Was this restored? The user is in the database and the login is in master. They are linked in the database "sysusers" table. If it is blank, sp_change_users_login will help...

Log Explorer from Lumigent could read back the log and you could see the transactions, but there could be a lot to go through.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Ditto with what Andy said. sjones@sqlservercentral.com or awarren@sqlservercentral.com. We very, very rarely censor, but it does happen. Mostly we'll remove offensive material, but leave the post.

Disagreements are fine, personal attacks...

Maybe we'll get something in Aus one day. I know I'd like to go down there.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Be sure you register with the SSC code and we'll have a shirt waiting for you. Looking forward to meeting you as well.

Steve

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

If they just create tables, then you can easily get the new tables from sysobjects. However, alters will be missed unless you are tracking the version of the current tables.

Steve...

While it might seem conventient, same as threaded discussions, I much prefer this "conversation" format. I know if I don't have time to read all the posts, then I tend...

Haven't seen this, but will forward to our SMS guys to see if they have.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Krispy Kreme is amazing, especially when hot! They melt in your mouth.

AFA the books, The Guru's Guide by Ken Henderon is agood read as is Ben-Gan's Advanced TSQL.

For admins,...

Thanks for the complements and notes. We couldn't have built this site without all of you!

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

35, about to add to that. Married with 3 kids (11,4,2) and enjoying life as much as I can. (http://www.dkranch.net/about/default.asp#members)

Of course, if I don't get something done quickly, it's probably...

I'd build a table and have them insert a value in there. You can then check this table with some job that will run backups.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

I'll look at the search.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Will be there permanently.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Very interesting. Haven't seen this, but I'll take a look.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net