Edwin Frydendall (3/20/2009)

---

I can't use a job with multiple steps. We want to run multiple DB Maint tasks in sequence (e.g. IntegrityChecks then Optimizations then DbBackups) and if one...

Hey ... instead of install outlook on the server check out ..

http://sqldev.net/xp/xpsmtp.htm

This will let you talk directly to SMTP server without having to expose your SQL Server to security issues...

pedro.ribeiro (3/20/2009)

---

Why is truncate better than delete?

Is it faster? why?

This table is just for temporary use.

I delete de data first and then insert the data trought the bulk insert. Then...

The lock will be acquired before your insert operation starts and will be held for the duration of the insert. It will be automatically released after opeartions are completed.

The...

Please look at ...

http://support.microsoft.com/kb/929151

And see if this helps you resolve your issues?

Mohit.

As I said it was just an idea I was throwing to the table...

The reason I am taking a guess AD communication issue is happening because of error message; that...

Hmm I guess we should have asked how far was the remote office; in this case Replication...

I agree with Mike there ... You can't use a solution to overcome bad design; it might work but it will come back to bite you later. In my...

kmauser (3/19/2009)

---

I'm running SQL 2005 on Win2k3 and we are getting really high avg. disk queue length that can spike up over 1000 (I set the scale to be 1)....

"When the snapshot is applied at the Subscriber, the Distribution Agent first applies the snapshot files (schema and .bcp files). It then reconciles each captured transaction to see if it...

I am not...

Hmm I am not sure .. just an idea.

Since you are having I/O Subsystem issues, SQL Server loses its communication to AD. So locks it down because it cannot...

When I create a FK with NOCHECK option then is_not_trusted is set to 1, in the sys.foreign_keys.

Thanks.

Mohit.

It is an error with WMI database that is on each computer; not error from SQL Server.

I would search on Google for WMI errors ... that Might help you out.

Thanks.

I think he might referring to the PDFs and the Practice test that come with the Self-Study books.

But I would like to say that you should buy the book it...