My mistake. I was thinking of linked servers.

No, registered servers isn't something that's stored in the database. It's local application data.

You can export your registered server data into...

You could set something up that will send an e-mail when the service stops. You'd have to write a program to send the alert, and then go to the...

At the very least, I would expect that to slow down metadata queries, which just about everything needs. Plus, you're going to have the execution plan cache absolutely jammed...

Are you asking about creating a view to select from master.sys.servers?

TheSQLGuru (11/16/2009)

---

GSquared: did you try hard-coded space-strings instead of the pile of replicates? I would HOPE the optimizer would expand those on compile, but if it doesn't that...

It's...

No. I'm pretty sure only a limited subset of people can help with that.

Michael Meierruth (11/16/2009)

---

Nadrek (11/16/2009)

---

I didn't see it later on, but my solution in the past has been very simple; nest REPLACE() two spaces with one space as deep as required...

Didn't say it, but sure as heck implied it! 🙂

Take a look at "ANSI_PADDING" in Books Online.

I can't think of a way to do that directly, but you could certainly query that table and compare it to a calendar of when backups are supposed to be...

Thanks.

I view things from an evolutionary viewpoint, and that includes tools and ideas.

It's nice, but in this test, it loses by a large margin (on my desktop machine):

if object_id(N'tempdb..#T') is null

create table #T (

ID int identity primary key,

Col1 varchar(100));

if object_id(N'tempdb..#T2') is not...

Yes. Depends on what you want.

For example, if it's been 1 hour and 30 minutes, are you looking for 1.30 or for 1.5?

Per the Microsoft license, you can have a copy of Windows Server and SQL Server that's the same edition or lower than your production server, for a failover backup, so...