Please find details.

schema (.sch); data (.bcp); constraints and indexes (.dri); constraints (.idx); triggers (.trg):for updating Subscribers only; compressed snapshot files (.cab).

Attached is the link.

http://64.4.11.252/en-us/library/ms151795(SQL.90).aspx

Good question to test our basics 🙂

Is there a way to validate the SMTP settings?

My suggestion is to delete and recreate the database mail profile from scratch. Just let us know if this works.

Steve, thanks for the question again.

There is one thing I noticed in your questions-mostly the answer to your question is usually the first choice in the option list 🙂

Did you happen to check the event viewer log. You might get what you are looking.

I have faced some problems with this approach-combining all db's in one backup job, especially on servers where there is disk space shortage on the backup drives. During backup job...

takayama123 (5/18/2011)

---

When i try to point the database server (sql 2008), username+password i get this error:

The password specefied for the username account is invalid.

Im 100% sure that the username/password i...

Thanks for the question 🙂

I found this link

http://www.sql-server-performance.com/articles/per/sys_dm_os_performance_counters_p1.aspx

but were you able to query sys.os_exec_performance_counters DMV?

I have encountered this problem in SQL Server 2000 itself, but we could recycle the instace as there was a acceptable downtime for that application.

Is it possible to put the...

Thank you for easy question 🙂

Thank you Tom

hlewis (5/17/2011)

---

What a thought provoking topic! This explains a difference between my network admin coworker and myself that has been bothering me. I'm a hard work person. I...

ModestyBlaise84 (5/17/2011)

---

Hi Gail,

Any thoughts about pro et contra for both solutions?

Detach/attach seemed more ‘natural’ to me, but would like to understand why you advised different?

Believe that there was a reason.

Respect...