Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Need to find a server in SQL 2005

Author  Topic 

gjbedi
Starting Member

1 Post

Posted - 2010-05-11 : 09:08:21
Hi All,

I don't know anything in SQL 2005.

I need to find a server in SQL2005 and I don't know in which table it resides.

Please help me.

I need to find this server and need to change its ownership.


Thanks and Regards,
Gaurav Bedi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-11 : 09:10:16
Did you mean current server name?

select @@servername


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -