There isn't a good way to do this. You could script grabbing 10% of rows in all tables, but the issue is that you'll have FKs and child rows that...

Is there a unique index on the table?

Haven't seen the error, but I'm amazed it would restart the server. Did the SQL Server instance restart or was it Windows? Or SQLAgent?

I'd probably call Microsoft on this one.

You have a syntax error there with the name of the column. What is the column name of the table?

I think you're kidding, and I hope so. Soft Skills are important. Even in the military, where it's a top-down, no-nonsense, do what I say attitude, soft skills are needed...

Thanks!

1. order in the WHERE clause does not matter.

2. What's the dat? This doesn't make sense in SQL Server.

3. Not sure, might depend on the isolation levels set on the...

Haven't tried it, but this might help you: http://www.sqlservercentral.com/scripts/Miscellaneous/31062/

I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/. They do a lot of work with large installations and you could get some data there.

As far...

You can capture the new database using a DDL trigger or an event notification. If you store that data off in some table, then you can track it. You can...

You could compress them, but you'd need to either Sp_OACREATE to grab an object handle to some zip utility or shell out (xp_cmdshell) to do the command line call.

You might...

You could always start one :w00t:

You have to try and collaborate, try and help, but at the same time you have to meet your responsibilities.

Management has to see this, perhaps by dividing responsibilities and letting...

I have friends who think that outtakes are the editorials!

You and my kids like those the best.:hehe:

I'd argue that having command line options is a part of usability. Just like every program I wrote years ago had to respond to "/?" from the command line, just...