Dan Guzman (7/10/2009)

---

The post doesn't say which version of SQL Server this is for, but with my 2005 I got close to 30 errors, mostly syntax errors near ' ...

great work done...i din't know that ping accepts parameters....thanks dude 🙂

I tested the script against...

thanks william...

I have attached the updated script...once published it will be available for viewing....

u r getting the syntax errors...

well... I just scripted the function thru ssms copied them to the editor... I will try to remove the characters.....

do you mean that it is not working....

bingo...u just proved my point...

Richard M (5/28/2009)

---

Taken from BOL:

The local definition takes effect only after the server is shut down and restarted. Only one local server can be defined in

each server.

And, not sure...

tom.dewit (5/28/2009)

---

I also have a problem with My SQL server name.

In this case, the SQL server host name was renamed, without renaming the SQL instance. When retrieving information from...

Well...I have a solution....I hv to re install reporting services....

Jeffrey Williams (5/26/2009)

---

Not sure about reporting services - but, you can try changing the windows identity in SQL Server Configuration Manager.

When the system was renamed, you probably have the old...

Jeffrey Williams (5/26/2009)

---

You still need to add the new server in using sp_addserver 'new server name', 'local';

You should also take a look at fixing the Windows groups that SQL Server...

john (4/30/2009)

---

I was wondering if anyone has a script that can take a DB name as input and dump out all of the stored procedures to disk files for backup...