Which user were you logged in with when creating the table?

Which user were you logged in with when running the insert statement?

Excellent QOD idea

If you are referring to Users then check out this link

http://msdn.microsoft.com/en-us/library/ms190387.aspx

if you are looking for a way to compare database structure (schema) between two different servers, then check out RedGate...

GilaMonster (3/4/2010)

---

Same. I invited him over to my desk and showed, in code, that it could be rolled back. No point or need to argue, it's easy to prove that...

If you run a report that retrieves massive amounts of data then you run the risk of contention and blocking. However, you should tune your queries and database such...

Not sure what you mean.

Could you clarify what it is you are trying to find out?

Nice article and well presented.

Chris Morris-439714 (3/4/2010)

---

Excellent article, Gabriel. I reckon it's time to start messing with those...

That was almost as good as the sound effects from Tron.

Another one of those movies (Star Wars all but Episode 3) that my kids are hooked on these...

Please don't be distributing braindumps, purchased software, or violate the NDA through the use...

GilaMonster (3/4/2010)

---

Not true.

Truncate is a logged operation, it can...

I like Jeff's idea. It is very useful to do it in this fashion and will save a lot of pain.

Another option is to script out the database that...

Do you have a good full backup?

Do you have transaction logs since the last full backup?

If yes to both, then you can restore your database up to the time of...

TPR -threadopulmonary resuscitation.

http://dijest.editthispage.com/tools/pm