Não reconhece o NAME na criação do banco
CREATE DATABASE ApressFinancial ( NAME = N'ApressFinancial', FILENAME = N'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ApressFinancial.mdf', SIZE = 3072KB, MAXSIZE= UNLIMITED, FILEGROWTH = 1024KB) LOG ON (NAME = N'ApressFinacial_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ApressFinancial_log.ldf', SIZE = 1024KB, MAXSIZE=2048KB, FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CPI_CI_AS GO
Incorrect syntax near 'NAME'.
Marcos Oliveira
Curtidas 0
Respostas
Marcos Oliveira
08/06/2011
RESOLVIDO
ERRO: Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'NAME'.
CREATE DATABASE ApressFinancial ( NAME = N'ApressFinancial', FILENAME = N'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ApressFinancial.mdf', SIZE = 3072KB, MAXSIZE= UNLIMITED, FILEGROWTH = 1024KB) LOG ON (NAME = N'ApressFinacial_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ApressFinancial_log.ldf', SIZE = 1024KB, MAXSIZE=2048KB, FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CPI_CI_AS GO
Incorrect syntax near 'NAME'.
GOSTEI 0