May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
DECLARE @DataPath nvarchar(255), @LogPath nvarchar(255) SET @DataPath = '$(DataPath)' --'E:\Databases\' SET @LogPath = '$(LogPath)' --'F:\Logs\' CREATE DATABASE [PASTIS] ON PRIMARY ( NAME = N'PASTIS', FILENAME = N'D:\SQL_Data\MSSQL10.MSSQLSERVER\MSSQL\DATA\HASTATI.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'PASTIS_log', FILENAME = N'D:\SQL_Data\MSSQL10.MSSQLSERVER\MSSQL\DATA\HASTATI_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL State HYT00. Timeout expired proplem||8||46|
|SQL Server replace between tags||6||31|
|SQL Server Pivot||5||44|
|Odbc to Sql Server from client can connect to sql server but can only choose system databases, windows authentication||4||15|
Join the community of 500,000 technology professionals and ask your questions.