sudhakara (4/28/2010)
Grant Fritchey (4/26/2010)
Can you get the information running this query?
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));If not, you may have an issue with the server, it's configuration, your connections... not sure.
Yes. That select statement displaying the name of the server.But here name of the instance and name of the server is different.
Thanks.
OK. That's good. Then you can also call the SERVERPROPERTY function with 'InstanceName' to get the instance. If that's accurate, you might be OK.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning