Hope everyone has had a great New Year, and a safe one.

CirquedeSQLeil (12/31/2009)

---

The jobs I have held followed this idea of "do the job" 24x7x365. Most had no compensation for on-call nor for holidays - the job had to be...

If you use BULK INSERT, you could check the table afterwards. I guess with bcp you could do the same. run a query and determine if the data was inserted.

Microsoft has changed the names of the certs a bit, and made them more specialized. The main information is here: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

There's a SQL Server TS, or Tech Specialist, which is...

I'll vote for "just wrong"

Enjoy the holiday tonight, everyone, and be safe.

That seems pretty fair. Good that they're recognizing holidays with extra pay for those working.

Thanks a lot for the kudos and praise. I appreciate it, but all of you add a lot to the site as well.

You can try dropping indexes and adding them back after the insert. That sometimes helps.

If you are adding a lot of records, it's possible that you're overloading the I/O system,...

Do you mean make a corrupt mdf on purpose?

Use a hex editor to scribble on some random part of the file.

The grammar has been corrected. Apologies for any issues.

I will also award back points for this question.

Try this: http://www.sqlservercentral.com/scripts/T-SQL/67368/

I think Jeffrey has some good advice. don't disrupt things if you don't have to.

Third vote here.

Note that moving those databases to the secondary server, either with detach/attach or just a copy over of the mdf/ldf (note that you need to stop the SQL services), does...

Typically patches will say if they are patching SSMS or EM and if they should be applied there.