are you using sql mail (2000) or database mail?

For both, make sure they are enabled in the surface area configuration options. If your using database mail (sql 2005 option)...

Not read all the responses but one thing that i have seen in SQL 2005 that was causing one of our queries to take 1hr 30 mins (it used to...

Jason Shadonix (1/24/2008)

---

E-mailing a distribution list is definatly a solution if you can convince your mail administrators to set it up for you.

Can you have an operator with...

Jason Shadonix (1/24/2008)

---

I've used the built in alert / database mail in SQL2005 for quite awhile and it has always worked fine for me. I've never used anything but...

I would generally use the not for replication option on foreign keys in a replication scenario.

Its not that there is any problem with your application logic, the primary database will be fine, its the replicated database. Even if the 2 tables (parent and child)...

I did my 70-431 last March, the only one of the 2005 certs that ive done. I used the MS Training kit, Exam cram, and transcenders for that, as...

Steve Jones - Editor (12/17/2007)

---

It's all multiple choice, so you don't have to write syntax from memory, but you do need to be able to recognize what a statement is...

Doh, you are right!

The compatability was 80 when it should have been 90!

Do your foreign keys have the "not for replication" element? It could be that the child table entry is being made before the parent table and hence the FK...

Sorry, just read your earlier post about not having any admin rights, so ignore my last post. Hmmm

I think whats happened is when you restored the database you have orphaned users in the database and the logins dont exist on the server. You CAN (with minimal...

Hmm, i cant give you lots of information but one thing you could look at doing is downloading a tool called NGSSQLCrack. It will connect to the database and...

Fantastic - cheers! Easy when you know how. Funny that it lets you add multiple items (even when dtsx file format) yet add existing package wont let you...

Does it fail when you run it as yourself or when it runs as the agent? If its when the agent runs it as a job make sure that...