Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 database naming conventions

Author  Topic 

mary_itohan
Posting Yak Master

191 Posts

Posted - 2006-10-23 : 03:04:36
hello,
can i use a domain name to name a database ?

e.g.

"sqlteam.com"

as my database name ?

thanks

Mary

Yes O !

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-23 : 03:09:24
yes

just enclose it in [ ]

create database [sqlteam.com]



KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-23 : 03:43:46
Refer this also
http://vyaskn.tripod.com/object_naming.htm


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-10-23 : 14:43:10
I would recommend that you avoid using any names other than A-Z, 0-9 and '_' - and start with an Alpha.

You can work around this by using [MyDatabaseName] but then you must a) always do that and b) maybe not everything that you use will have been tested using bracketed names.

I would also recommend that you keep the database name under about 40 characters for the same reason.

Kristen
Go to Top of Page
   

- Advertisement -