Indeed it looked slick and I wish I'd set it up and tested it.

Few issues, basically makes 3 copies (4 total) of the database, so space can be an issue....

Probably need Client Access or some other driver on the server. We use it from app as well as DTS at J.D. Edwards/Peoplesoft with few issues. Tends to either work...

Someone else did a test install here. No issues.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Haven't installed it yet due to potential issues here. Under test, but I'm not sure if it causes problems.

Hit the district up for a test box

Steve...

I've found that this process can be problematic. Usually there is some rights issue. If you double click the line wiht the error, is the error mentioned above the one...

What doesn't work here?

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

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,...