A couple of things here.

1) Open your DTS package and open each item and transformation in the package. They all have a description item in them that you can set...

Open EM and drill down thru Management/SQL Server Agent/Alerts should be there. If this is what you are doing then what version of SQL are you using?

"Don't roll your eyes...

Set up an alert

Type = SQL Server event alert

Error = 14151

Database = YourDbThsiHappensOn

On the response tab check Execute job, and pick the job related to the replication.

"Don't roll your...

I would try using one publication for both servers as it will direct the process better. Andy may be right thou, may not be the replication at all but if...

Using SMTP works fine however you still open yourself to security risks. Such as if not configured properly a person can use your machine to forward mail. Have them layout...

Meaning it is not fully recovered. Your error is as follows.

quote:

---

Database '%ls' is in warm-standby state (set by executing RESTORE WITH STANDBY)...

If the publications are the same in setup then you should be able to create one publication and send to both subscribers. If not then if this is not transactional...

After a bit of research on this, I don't believe the sort order applies to the unicode data but only the non-unicode stuff when the supported characters are based on...

A deadlock is when two or more items try to access resources the other needs to complete.

For instance if a process is access table 1 and needs table 2 which...

This should do the trick.

SELECT personid

FROM table

WHERE language IN ('German', 'French', 'English')

GROUP BY personid

HAVING COUNT(personid) = 3

Or if you only have those three languages then

SELECT personid...

The only problem with that last trick is you will lose constriant, indexes, permissions, etc. EM scripts out all that stuff for you in addition. However I agree on the...

Brendon, for set based solutions this way will usually work.

SELECT ColListHere

FROM tblTransactions oq

WHERE oq.TransID IN (

SELECT TOP 10 iq.TransID

FROM tblTransactions iq

WHERE iq.CustID = oq.CustID)

Hope this helps.

"Don't roll your eyes...

It normally restarts on it's own depending on the type of replication. If you will open EM and drill Management/Sql Server Agent/ Jobs you will find the actuall jobs that...

Brian gave much better detail. However let me add one point. If this server is SQL 2000 you can add the user databases back without issue as they can have...

I will say any major corporation with multiple large departments probably has a site license with MS for clients due to almost impossibility to keep up with them. Many will...