Viewing 8 posts - 1 through 8 (of 8 total)
The solution can be found here:
I found this by selecting the results of the NAME column from sys.servers into a variable and parsed out the two characters after...
June 24, 2011 at 12:58 pm
Yeah, definately doesn't hurt being a DEV server. But I like to keep my servers clean of debris so to speak.
I will definately keep you posted on this thread....
June 23, 2011 at 9:59 am
Produces the same error:
Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42
The server ''ServerA; UID=DEVAccount;PWD=DEVPwd'' does not exist. Use sp_helpserver to show available servers.
There are no quotes. ...
June 23, 2011 at 9:49 am
Thank you for your input. At least now I know it wasn't something simple I overlooked. I suspect there isn't a way to remove it. I may...
June 23, 2011 at 9:39 am
Yes, I tried using QUOTENAME already which is equivalent and it produced the same error. I did just try it again to confirm using both QUOTENAME and hardcoded like...
June 23, 2011 at 9:18 am
That's the issue. The name of the server includes the user name and pwd.
It is not a valid server and it cannot connect to anything since it is not...
June 23, 2011 at 9:00 am
You may want to increase the number of files in each of your filegroups to match the number of physical CPUs on the server as well as insure the size...
September 20, 2010 at 9:13 am
Viewing 8 posts - 1 through 8 (of 8 total)