This isn't really pretty - and I had to carve it out of a cursor that I use as part of my nightly processing - but it seems to be pretty...

Check BOL for fn_trace_gettable.  This doesn't "decode" the trace file, but you can import the data from a trace file to a temp table and query it there.  I'm not aware...

Although this is a tangent, I thought I'd share this.  Microsoft lists the maximum number of databases per instance as 32,767 (BOL: "Maximum Capacity Specifications") but I did a little...

If memory serves me right, SQL Standard -used- to work as a [target] for log shipping out of the box.  I believe it stopped working after Service Pack 2.  I guess MS...

Here's a tool that may help also.  It's free (always a nice price).

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

Cheers,

Ken

Good suggestion, assuming the database was created small and grew to the current size.  Otherwise, shrinking the files won't buy you much... (you can only shrink down to the original...

Here's a few items that you'll probably see: User maintenance (be SURE your HR department includes you on employee terminations), new development, patch management, security and auditing, tuning, scheduled database...

I agree with Frank on this one.  You'd be better off doing it at the front end.  You [could] potentially split the columns between several tables and use a key...

I can't say for certain that your sql.log file is unrelated to SQL Server, but I believe there's a default name of sql.log for ODBC trace files.  Check any ODBC...

Do yourself a favor: be sure to shrink the files before you dump/detach.  I've had good luck with WinRAR.  WinZIP has problems (or at least it did when I needed to...

Jeff

Be careful with this.  I don't know what environment you're in but here's a few things to think about.

1. Transaction logs are your avenue for database recovery.  If you can...

Shamelessly stolen from a particular Gary Larson 'The Far Side' cartoon.

Likeness is close but I have a beard...

How embarassing...

I was so focused on answering the question that I didn't even -notice- Jonathan's reply (sorry about that, J...)

Not -enough- coffee, rarely serious and...

Call me Mr. Obvious here but I'll say it anyway: after you do your full backup on your production system, copy the backup file to your log shipping target server. ...

Lauren

I guess it's worth mentioning that these diagramming tools rely on existing relationships between the tables in the database.  I've reverse-engineered legacy databases and all I had when the dust...