sys.databases sd where name = N 'AdventureWorksLT' and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() )ĮXEC. ( FILENAME = N 'C:\ YourPathHere\MSSQL\Data\AdventureWorksLT_Log.ldf' ) ( FILENAME = N 'C:\ YourPathHere\MSSQL\Data\AdventureWorksLT_Data.mdf' ), But where is the database? You will have to attach the DB, you can use the wizard or this script below (make sure that you change the path and username, both are in bold font) Okay so you have downloaded the file and installed the database. ![]() If you want to read more on the download page go here: Itanium (IA64) AdventureWorksLT_IA64.msi - 2,251 KB You can download the installers for the AdventureWorksLT sample databases here The name of this database is AdventureWorksLT, this database is a stripped down version of AdventureWorks. There is a new sample database available for SQL Server 2005.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |