Q:
STORED PROCEDURE SYNTAX ERROR
Please help, I would appreciate it. Below I have a simple stored procedure to return the names of my databases.
I am getting a syntax error:
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark before the character string 'PASBA-DEV '.
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'SERVER1-DEV
Some of my server names contain hyphens, thus the reason for using [ ]'s in the procedure.
Code for procedure begins here:
ALTER PROCEDURE
[dbo].[usp_getdatabasenames]
@ServerName char(50)
AS
Declare @string2sql char(50)
Set @string2sql =
'Select name from ['+@ServerName+'].[master].dbo.sysdatabases order by name';
EXECUTE (@string2sql)
I am getting a syntax error:
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark before the character string 'PASBA-DEV '.
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'SERVER1-DEV
Some of my server names contain hyphens, thus the reason for using [ ]'s in the procedure.
Code for procedure begins here:
ALTER PROCEDURE
[dbo].[usp_getdatabasenames]
@ServerName char(50)
AS
Declare @string2sql char(50)
Set @string2sql =
'Select name from ['+@ServerName+'].[master].dbo.sysdatabases order by name';
EXECUTE (@string2sql)
ASKED:
Sep 29 2006 9:18 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
