![]() ![]() The AdventureWorks database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). This reply was modified 4 years, 9 months ago by michael.leach2015. This is a sample Dataedo documentation - AdventureWorks - Microsoft SQL Server sample database.Under the list of 'Matching objects' I didn't see my current computer name listed (but I still saw the previous computer name listed).Īt this point, I need to know how can I get SQL to recognize my current computer name (current db owner)? I clicked the ellipsis next to the "owner" field then I clicked the 'Browse' button. So I typed in the new computer name (db owner) into that field and the object was not recognized. Lightweight (LT): with a smaller set of data (7 MB) Extended data warehouse (DWExt): with a lot more data (883 MB) The file size is small, but there are many tables inside this database. So after changing my computer name, apparently SQL doesn't automatically update the new computer name in the db owner field. For more information about samples, see the Samples GitHub repository. The name of the db owner that was returned was my previous computer name. This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server, Azure SQL Database, and Azure SQL Managed Instance. Recently I changed the name of my computer to a name that is easier to read, but here is what I discovered.Īpparently SQL uses your computer name as the db owner. This article provides direct links to download AdventureWorks sample databases, and instructions for restoring them to SQL Server, Azure SQL Database, and Azure SQL Managed Instance. ![]() Ok, I ran a query against "sys.databases" using suser_sname ( ) and got the name of the db owner. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |