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.
| Author |
Topic |
|
shzkhan28
Starting Member
15 Posts |
 Posted - 2009-10-29 : 23:15:37
|
| Hi All,I have a db name with '&' sign In use cmd it is giving me following errorUSE S&Kltderror:Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'S'. No entry found with that name. Make sure that the name is entered correctly.In Oracle,i remember there is set define off cmd to aviod '&'Ur help will be appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-30 : 01:14:07
|
wrap it in square bracketsUSE [S&Kltd]; |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-30 : 02:37:09
|
| It is bad practice to have such a name. Avoid using non alphabets as part of the object name. You can use underscorwe instead (S_Kltd)MadhivananFailing to plan is Planning to fail |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-10-30 : 02:54:02
|
create database [ ]
elsasoft.org |
|
|
|
shzkhan28
Starting Member
15 Posts |
Posted - 2009-10-30 : 03:15:20
|
| Its workingThanks... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-30 : 04:16:06
|
quote:
Originally posted by shzkhan28
Its workingThanks...
But keep in mind about my first replyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
& sign