By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

Curser in SQL(for coonectiong to deifferent servers)

P: 57
Hi all,,

Can someone please give me an idea about writing a stored procedure script which will do the following--

1. Connect to remote server(if allready coonected delete the current server object and create a new server object).

2. login to the database on the remote server.

3. check if a specif stored procedure is there or not(if stored procedure exist delete it and create new... with all the new functionality of that stored procedure)

4. there is a table name(user log) get all the data from the userlog..

Can you please help me with that , i need to connect to 4 servers and do that same for all of them.

if some one can give me an example that will be great other wise please tell me -

1. how can i detect a server object and if it exist how can i delete it(through sql)

2. how can i detect ant delete, create stored procedure on remote server through this stored procedure

Regards,

Vineet Bindal
Feb 26 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.