Monday, March 19, 2012

How to get server name and databases name from a server using SQL Command...

can anyone tell me
How to get server name and databases name from a server using SQL Command...

i m using sql server 2000(T-SQL)

Use @.@.SERVERNAME to find the server name -
select @.@.SERVERNAME

& this to find the current database name -
select db_name()

|||

thanks....

No comments:

Post a Comment