Tuesday, September 17, 2013

[MS SQL Server] creating table on all sql servers in the environment

[MS SQL Server] creating table on all sql servers in the environment

creating table on all sql servers in the environment

Posted: 16 Sep 2013 07:33 AM PDT

Hi,I have a requirement to create a table in database on all sql server instances in our environment.We have a monitoring tool and it uses a sql instance.I can get the list of instances ( dev and prod ) from the monitoring tool. My concern is to connect to each and every instance and create a table. With SQL agent i dont think its possible but i guess we can acheive this through SSIS.. Please post your valuable suggestions and let me know if you have any questions....Thanks in advance...

Finding cluster nodes (powershell or sql)

Posted: 16 Sep 2013 08:23 PM PDT

Hi,I am looking to find cluster and it's nodes, actually we have bulk of servers and we don't know which server is running under which cluster. i want to find out all servers. basically we don't know when cluster server will change. please can any one help me out from this situation.??it would be greatful wheather script poershell or sql script.Thanks
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog