Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Jay Dave,
I have 150 users using standalone application on there Windows XP destops. Each destops as .ini file for that application which points to Server abc. i want to do SMS push to those 150 users which will modify\update .ini file so that instead of pointing\connecting to Server abc it will then connect to Server xyz and not to Server abc.
How to use this script:-
you just have to change the name of the original server, the new Server and the path and name of the ini file and it should work. Just copy and paste this text into a notepad session and rename it to .vbs. Then push out the vbs script to the clients. Or put it into a script window within SMS.
SQL Server 2005 script
Script Server Roles in case of migration or documentation
Script to List Tables on Link Server
unattended script for SQL Server 2005 installation