Books Online works, otherwise use the books/training resources for the exams which it replaces. Upgrade exams don't tend to get books.

Sure, toss them my way

You'll need to query every single table and search on every single column.

The clustered index is the table, so deleting it won't help you.

If the data isn't important, how about archiving or deleting old data?

Won't help, Administrator is not a default SQL login, not...

It's not, unless when you set the replication up, you configured it to use the sa account (which is not default iirc)

Jeff Moden (5/30/2015)

---

1. Do you want to capture the fact that the items after the @ symbol change?

2. In the case of things like "hicks2001" "conference:06", what do you want...

That's not going to work at all.

declare @moneyid int

select @moneyid = moneyid from inserted

You're assuming there's only ever one row updated at a time. When more than one row is...

With the trigger code there, that's not possible. That trigger will write into the audit table the rows which were affected by the delete with the host name and user...

Unless you had some monitoring in place at the time of those events, you probably can't figure out the cause.

Probably not, the error log would be a far more likely place to have that info.

But it is.

Warm winter at the moment, but it's definitely winter (dry as anything)

Lynn Pettis (5/29/2015)

---

Eirikur Eiriksson (5/29/2015)

---

A currently active thread: "I don't use any clustered indexes actually... all of mine are non-clustered..."

Sometimes I do wonder where things went wrong with MS and...

Errr.. wha?

That's a really odd decision seeing as the SQL storage engine is designed with the idea...

No feature, just a rather large pile of manual work.

You'll need to take the table create statements and change the data types to match Oracle, you'll need to check every...