Thanx Mohan, I know, BUT - I need that list generated to be importable as a registered server list.

I dont want to build a manual registered server list.

Are you using SQL authentication?

then enable the password policy for that account,(but remove the tick from "user must change password..... and password expiration....")

and also see if its locked under status.

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....