connection to right dB in server SQL server 7.0

I have the following SP.
the problem is when the execute is performed it gets another DB with a
similar name.
physicianlaboratories_Interface.
I am leaning towards the name is to long. if so what is max length for a
unique name.
Alter Procedure ADP_CompleteXMLOrderImport
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE physicianlaboratories_com..ADP_CompleteXMLOrderImport
RETURN 0
END
returnHi,
The max length for Database name is 128 characters.
Just try the "[ ]"
Alter Procedure [ADP_CompleteXMLOrderImport]
@.Storename varchar(50)
As
set nocount on
IF @.SToreName = 'physlabs'
BEGIN
EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport]
RETURN 0
END
return
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||thanks, tried the [] did not do anything.
I believe there is also a maximum length for Unique DB names.
it also may be constraint of the ODBC driver.
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:52j#sy8OEHA.3800@.cpmsftngxa10.phx.gbl...
> Hi,
> The max length for Database name is 128 characters.
> Just try the "[ ]"
> Alter Procedure [ADP_CompleteXMLOrderImport]
> @.Storename varchar(50)
> As
> set nocount on
> IF @.SToreName = 'physlabs'
> BEGIN
> EXECUTE [physicianlaboratories_com]..[ADP_CompleteXMLOrderImport
]
> RETURN 0
> END
> return
>
> HTH
> Ashish
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>