The workaround suggested by the most experienced person in my group was to use sqlcmd and parse the results.. You could name the output file by server name, then take...

Did you set the time out for one at 500 seconds to see if it made it worse?

Don Urquhart (9/4/2014)

---

Does anyone know the proper way to shorten the login timeout when using the sp_testlinkedserver?

Currently my timeouts seem to take between 20-27 seconds to timeout which is...

This is very handy in my environment. Would you like me to message you for permission to post the script on my company's internal wiki?

Thanks!

That was a fun read. Thanks.

I'm not sure the best way to address this, other than to ask if you have a formula for how often you put a press release in the editorial slot?

I'm not sure why we don't check our data as many ways as possible. I have an environment that assumes everything is installed as expected, and a help desk busy...

The other side of this is that the people handling the big picture are often reluctant to spend too much time with people in the field, and their ideas.

The best...

I'd like to be able to turn it off without turning it on again when I do a restore into test.

Steve Jones - SSC Editor (8/14/2014)

---

Robert.Sterbal (8/14/2014)

---

We have hundreds of thousands of you in the SQL Server community. ...

There are 1,742,404 logins on the site

is the ratio of logins...

We have hundreds of thousands of you in the SQL Server community. ...

There are 1,742,404 logins on the site

is the ratio of logins to people closer to 10-1 or...

Is there any way to update the author or the text of the article to reflect the wonderful work Joe Celko did on this series?

This is the URL I'm referencing:...

Brandon,

The posts in this forum suggest otherwise.

We use replication at hundreds of sites, yet fail to use it to get a near real time archive of our in house CRM...

I'm always surprised when people don't use replication, especially with reporting problems. Real time data is very often over rated outside of financial markets.

More data might not get you the specific price on a house, but it will often help get you the reasonable estimate of whether a house should sell for more...