Thursday, March 29, 2012

database name issue

Any known problem or in future a problem in using database name with a space
in it.
Example "North Wind" or "MY DB"If you use a space in the name you must enclose all references to it in
square braces... ie [my db]... I prefer NOT to name dbs this way.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ilovesql" <ilovesql@.hotmail.com> wrote in message
news:O$kMq1zlDHA.1672@.TK2MSFTNGP09.phx.gbl...
> Any known problem or in future a problem in using database name with a
space
> in it.
> Example "North Wind" or "MY DB"
>|||By the way... If you include spaces, you may run into software that does NOT
use square braces, which means the software would not work against your db.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ilovesql" <ilovesql@.hotmail.com> wrote in message
news:O$kMq1zlDHA.1672@.TK2MSFTNGP09.phx.gbl...
> Any known problem or in future a problem in using database name with a
space
> in it.
> Example "North Wind" or "MY DB"
>sql

No comments:

Post a Comment