October 25, 2004 at 7:36 am
When I created filenames for the servers running SQL Server 2000, I used dashes in the name of the server. It would not be easy to rename the servers at this point.
Now when I try to run a script remotely through the SQL Server Agent, the script will error out on the dashes in computer name:
exec server-name.master.dbo.scriptname
If I run the same command in SQL Query Analyzer I can put "" around computer name and it will run, but that fix does not work for Server Agent:
exec "server-name".master.dbo.scriptname
Any help would be appreciated.
Chris Nichter
October 25, 2004 at 10:44 am
Not certain but have you tried
exec [server-name].master.dbo.scriptname ?
Francis
October 25, 2004 at 10:52 am
We have server names with dashes (-) in them, and I have used the following syntax successfully:
exec [Server-Name].[master].[dbo].[script-name]
That should work for you.
October 25, 2004 at 11:27 am
That worked. Thanks A Lot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply