Drop database on a different SQL Server.

Hi,

I am new to SQL Server 2005.Till now, I have been using a SP to execute DROP DATABASE command to drop databases on my existing database server.

but now i want to delete a database which is on a different SQL Server 2005 instance on a different machine. but i am not sure how to do this.

Can anyone please help me on this?

Any help would be appreciated.

Thanx in advance.

Kawal

If you have the remote server credential connect your SQL Mang. Studio with the target server & execute the same script.

|||

Thanks for the reply!

i can do that but my problem is different.

I am deleting database from my application which calls a VB component to delete the database. SP is called from this VB component and this SP resides on Admin DB which is on , say server1. database that has to be deleted is on a different server running a different SQL Server instance.

Is this thing possible in any way?

Waiting for your reply.

|||As far as I know, in this case, you have to recreate the sproc on target server.

|||and can you please tell how to do that? as i tols earlier, i am new to SQL Server