Jack,

Sorry... I only see it on the MultiServer connection, and it is False and grayed out. I tried creating a new MultiServer connection, but it defaults to False and grayed...

Jack,

Since you are familiar with Rodney's DBA...

Thanks for the tip. I found some...

I never found an easy way to do it. I started working on some code to do it, but I got sidetracked on other tasks and never finished it.

I tried the manual checkpoints before posting this thread. They did not work for our site. The gaps consistently occurred anyway.

You won't have any argument on this from me. LOL However, this is an old,...

Gail,

Another concern is that we have two scheduled instance failovers a week so that our clusters can be patched during established time frames, which means that around 2,000 identity values...

>>Why is having no gaps in what is probably an artificial primary key (column without meaning) important?

To DBAs, this isn't important, because *we* know that identity columns are arbitrarily assigned....

I'm still looking for an answer. Any ideas?

Thanks in advance.

I tried using SQL Server Configuration Manager to define an alias with the same name as the SQL Server Network Name, pointing to the clustered instance's IP address, but that...

Oliiii (5/30/2013)

---

If you know powershell you can use a simple powershell script to do that for you, no need for the sqlps.exe.

You can use this to get you started for...

Lowell,

I just noticed that I didn't answer your question.

Yes, I have reviewed the logs. Nothing shows up in them.

A while back, I wrote some code that tracks the number of...

By the way, http://www.memfix.com/ looked promising, but it requires a "complementary" license. When I sent an email for the license, my email bounced because the vendor's mailbox is full. Hmmm......

Lowell (5/30/2013)

---

i could provide you with the source code, and you could compile it yourself, if that would get you rolling;

exe's from strangers are too creepy to accept, no...

Lowell (5/30/2013)

---

it's a pain in the ***, but you can pull all the SMO dll's from the GAC(Windows Global Assembly Cache) so you can include them in any .net app...