This: http://support.microsoft.com/kb/325335 is the official way... funny it says the review happened in 2007 but it dos not mentions 2005 😉

For Every Restore operation you will get those 3 entries recorded in the log...

Great Article! I am doing this kind of auditing on all my servers.

I would *not* filter by database Id though. cross-database queries can come from the "unexpected" master,tempdb,etc... system databases....

Well I would re-write that quote this way:

"If it was written by M$ it is NOT necessarily...

When you do COLLATE it DOES *NOT* change the data that is *already* there. Keneth is right, BCP-OUT->Rebuild->BCP-IN is the way to go!

Cheers,

20,000 SP ?????.... that is BAD!!! I believe whoever created such thing did a lousy job.

By the way after database 99 many stats are not gathered by SQL Server.

select ...

join tableA a join tableB b on ltrim(a.CustomerID) = ltrim(b.CustomerID)

Now, I would advice to cleanup the data instead of following this route

Markus (1/10/2008)

---

Question: I thought that Microsofts stance on Service packs and CU was that you apply the latest SP but ONLY apply a CU if you are experiencing a...

By the way the "free" "Instances" are only for Enterprise Edition...

If you licence SQL Server per processor it does not matter how many instances you run.

Just my $0.02

And that behaviour has changed with the 2005 release. Even though you...

Database Snapshots are just sparse files that mimic...

SriSun (12/11/2007)

---

Thanks Grant Fritchey, its helpful.

Not all times I get primary key voilation or deadlock, but I am sure that I get any of these errors when I ran...

I too set them up at those values and *always* specify the max memory BTW.

You should create an ALIAS for the subscriber to eliminate the need for the hardcoded IP. That way if the subscriber changes IP you just need to update the alias.