February 15, 2006 at 7:52 am
Q1. Are there characters that cannot be used for database names
Q2. I have created a database called M1_0 which was created ok but when I try to run a sproc using M1_0.dbo.<SprocName> it fails saying it can't find a table used in the sproc.
This sproc works fine in other databases which have larger names.
February 15, 2006 at 9:05 am
use [M1_0].dbo.<SprocName>
February 15, 2006 at 10:45 am
identifiers that fail to comply with these rules must be delimited by double quotation marks or brackets..
If you get the object doesn't exist error for the table used in the sp while executing the sp then verify the table exists and use fully qualified name..(dbname.ownername.objectname)
-Krishnan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply