A user database was created with a name like data-base (ie - in the middle of the name). When I try and query the db or do anything referencing data-base.dbo.table, I receive an error because of the -. Is there anyway around this without having to rename the db?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Referencing database with '-' in the name
- Thread starter Luvsql
- Start date
the same problem can occur if table has '-' or space inside name. This syntax always works (if names does not contain any characters that are not allowed)
[data base name].[owner name].[table name]
alternatively you can change [ ... ] with ' ... ' notation
Chris
[data base name].[owner name].[table name]
alternatively you can change [ ... ] with ' ... ' notation
Chris
- Status
Similar threads
- Locked
- Question
- Locked
- Question