Re: I wonder at the difference in the name patterns
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 1 Sep 2009 10:40:55 +0000 (UTC)
AAaron123 (aaaron123@xxxxxxxxxxxxxx) writes:
I look at the DB names in a User Instance and I see the system names and
Two DBs are named like:
I:\MY DOCUMENTS\VISUAL STUDIO
2008\WEBSITES\TEST\APP_DATA\NEWSANDEVENTSDB.MDF
One is named simply:
PhotosDB
Everything is working but I wonder at the difference in the name patterns.
Can you explain why the names might by as they are?
In two cases that's a file path, the latter looks like a database name.
Then again, I don't know what you use to look. Do you run "SELECT name
FROM sys.databases" or something else?
If these are names from sys.databases, I guess you simply named them
differently.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: I wonder at the difference in the name patterns
- From: AAaron123
- Re: I wonder at the difference in the name patterns
- References:
- I wonder at the difference in the name patterns
- From: AAaron123
- I wonder at the difference in the name patterns
- Prev by Date: Re: Scripts -> Create Database
- Next by Date: Re: I wonder at the difference in the name patterns
- Previous by thread: I wonder at the difference in the name patterns
- Next by thread: Re: I wonder at the difference in the name patterns
- Index(es):
Relevant Pages
|
