It's easier to create a new publication and subscription.

But of course you are limited if it is referenced by a foreign key constraint.

ScottPletcher (10/22/2014)

---

You should be able to use the session_id to do the lookup. But since session_ids are reused, and sysjobactivity keeps history, if your proc is not currently running...

The code below will give a list of jobs that have been running over ten minutes (can be anything you want).

Remember to exclude jobs you expect to run long (e.g....

Lynn Pettis (2/10/2010)

---

I take it that the 8060 byte limit has its roots with Sybase. Not all database systems have such a limitation. I had the opportunity to...

scantoria (10/8/2014)

---

So what is the approach? Keep working with the 8 servers and just add more memory (RAM and HDD) when needed?

We have over 100 databases across these servers. I...

If you choose mirroring, you need to understand something about the read requirements, as to how up to date the data needs to be.

If latency is an issue and there...

Thanks for the article. Look forward to future installments.

Also more importantly why were schema created with the user's name.

i know there are some third party tools that do this, but usually there is no need for it.

I suggest...

Another option is mirroring with rolling snapshots.

Still that has its own set of issues and admin challenges.

Found an earlier thread: http://www.sqlservercentral.com/Forums/Topic1374671-1281-1.aspx

And this on MSDN:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5c4414a6-213b-4a69-8dcd-f162bc979b3b/service-broker-filling-tempdb?forum=sqlservicebroker

When you stopped all processing, were there still any open transactions?

What non-application connections were still there?

Did you look in sys.objects in tempdb?

I think logging to a central repository in a meaningful way or having a central process that scans log is a good thing.

I have had very bad experience with Microsoft...

This is a nice script.

Couple of comments.

1. I would separate out the size of the log file and the (total) size of the datafiles.

2. I would avoid using IP...

One more question.

If you do not have access to server B beyond db_owner in the database,

how do you ensure that the logins (server principals) are synced?

I like Arial in general, stopped using it because of how my name looks (Arni).

I don't like it when people call me Ami.

🙂