Nice to know! one more question: is your sa account enabled and what is the password? 😛

No matter what the answers, testing on production servers is never a good idea.

When posting questions, be sure to post more and detailed information in order for us to assist you faster and better.

Do you have an ID column? or any column with...

If you can drop down the DB's, Tables etc, its obviously online.

Some times remote servers take a while to display the color status.

confused....

What was the question?

Noted, and thank you for the feedback.

SELECTt.name as [DB Name],

t.user_access_desc as [Access State],

t.state_desc as [Online/Offline],

((SELECT (CASE t.is_in_standby WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Other' END))) as...

try it like this on both:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SELECT LEN('TEST')

Have a look at these:

http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx

and

http://blogs.technet.com/andrew/archive/2007/11/26/sql-server-2008-spatial-data-types.aspx

and if you run:

Select Datalength('Ather') ?

Port 90 as you used is fine.

It's a port specific to the website hosted on IIS, and is only used to point and identify the different websites running on...

Yes, and no.

run this to rename the server name:

sp_dropserver 'old_name'

go

sp_addserver 'new_name', 'local'

go

right here on SSC 😀

or

http://www.microsoft.com/sqlserver/

nevermind......misread your question....

select name, state_desc from sysdatabases

not a very descriptive post, but...

try using "." as your server name, just a dot.

and make sure SQL Services are running....