ss1011 (8/28/2008)

---

Can I trouble someone to explain why? I don't need exact details - perhaps just an overview of what's in the tables that might cause problems if not backed...

Okay... we all get your co-worker is "fearless" and has not guts to say "no", the question here is... what did your coworker do before dropping the database? Please don't...

yes.

huh?

The single most important thing you have to have is a backup strategy aligned with business needs.

Once you have that in place the most important thing you have to remember...

You can do it resorting to Logon Triggers.

Logon Trigger would start a storedproc so you can do whatever you want there. 😉

Pure BS 😀

GermanDBA (8/28/2008)

---

...the easiest way would be to backup the database where this table is and restore it on the target system. You then have an exact copy of the...

Well... it sets 'YourDatabaseName' 'trunc. log on chkpt.' option to true then performs a checkpoint 😀

I'm not doing your job but here is a hint...

a = lenght of the email column.

b = position of the '@" in the email column.

If (a !< b + 4)...

Try this...

USE master

go

EXEC sp_dboption 'YourDatabaseName','trunc. log on chkpt.',true

go

USE YourDatabaseName

go

CHECKPOINT

go

Yes. You may want to start by reading about it, try this...

http://www.devarticles.com/c/a/SQL-Server/Migrating-from-Sybase-to-SQL-Server/

Assuming you are talking about properly defined referential integrity you just have to create a diagram on Enterprise Manager.

Help Desk would start getting angry calls from the user community because you forgot to broadcast the Emergency Maintenance Windows notification...

Problem is you want to do some non-default stuff in a default configured environment.

I...