When a programmer tells you somthing is good always dig deeper to see WHY.

If it's faster for him to program in chances are good that something is generating code with...

GilaMonster (8/19/2011)

---

Class finished yesterday. This is a 4-day one,...

You're <all> welcomed. But I think it would have been a real travestie, and unthinkable to not have gone through with this.

It's not like this is giving out a...

Sorry but I just had to do this :

This is a message I sent to Kimberly Tripp (Paul Randal's wife)

Subject : When Paul's not enough

You call in the best!

Seriously,...

Thanks.

WayneS (8/19/2011)

---

Ninja's_RGR'us (8/19/2011)

---

For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take...

WayneS (8/19/2011)

---

Ninja's_RGR'us (8/19/2011)

---

For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take...

Thanks again, that was the last big elephant in the room. ;-).

So latest...

Thanks a Million @Skrilla99

For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to take a rather...

Issue posted on connect

https://connect.microsoft.com/SQLServer/feedback/details/684806/rollback-causes-db-to-go-suspect-only-repairable-with-repair-allow-data-loss

ChrisM@Work (8/19/2011)

---

Just as easy without....

Check the sql err logs for the exact error and post it here.

As Gail says, it's often because the log file is gone. Best thing is to put it...

You can also use a similar technic. This inserts the results in a temp table so the "empty" datasets are ignored.

SET STATISTICS IO, TIME OFF

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS ON

GO

USE...

So basically search all tables / columns for @x.

You can search this site in the script section. This has been done many times over. I just don't have...