^^ I don't know about everyone else, but I never got the newsletter this morning. Had to go to the site to get my fix. As for auditing,...

Well, removing these user created INSTEAD OF INSERT triggers has solved the issue for anyone else that comes across this topic. Thank you for your help.

On the publishing table, the constraint on the ID is greater than 8055 and <= 10055. I've also been playing around with things and I noticed that if I...

Thank you for the quick reply. I just rebuilt the replication and it reset the identity IDs. I initialized the subscriber and checked the constraint on my table...

I do have it set to ON, but I had tried setting it to OFF after misreading an article. SQL Server is managing the identities automatically. For instance,...

From what I recall seeing, anyone sharp enough to be...

Would this be like what EDS and HP currently do? If so, it'd just mean one more competitor in the remote desktop/server management arena. At least Microsoft has...

I think a good part of the premium that is applied to a DBA's salary versus a developer is that the DBA is also an insurance policy againt data loss....

One of my friends once got one with the following subject line: "Celebrate the new year with a bigger p3n1s" or something to that effect. Since it was around...

Oh yeah, what on Earth was I thinking! The left outer join was definitely the way to go.

I would group by department having count(*) = 0.

Whenever I'm feeling poor, I compare what I have today to what people had in the past. Say 16th or 17th century England, ancient Rome, even the 1800s. ...

Since I'm almost 27 and haven't touched the stock market in 5 years, the maket fall hasn't hurt me in a retirement savings way. Most of my investments are...

Like Steve said, the people you have on the project is the thing that determines how successful it is. However, at my last job, we had 2 project managers...

I thought the whole reason for SQL Server's success was its superior Price/Performance over Oracle. Not just licensing but development costs as well. Does it need to be...