I haven't tried it, but I don't see a restriction on versions. The docs mention any compatibility mode.

The issue with doing this continuously is that if you fail over, you...

Sorry, didn't realize this was SQL 2000. (Doh!)

Query Analyzer has a menu item for this. You select it before you run the query.

Don't be sure your schema and data are...

In sync, are you sure? Have you actually done a sync recently or a restore? It's easy to assume this and be wrong.

To get the execution plan, you can easily...

Let us know what you find, and if you have specific questions, post back.

One thing I'd caution is not to assume anything here, especially with security. Use SETUSER and actually...

Nadrek (5/7/2012)

---

I assume that's at most...

Nadrek (5/7/2012)

---

Seriously: how many people are going to ask for, much less get, a wipe absolutely as soon as they realize the phone's missing? Instead of turning around...

And the XP registered correctly? You ran sp_addextendedproc? The DLL has to exactly match the function you register.

Is the DLL x64 if the server is x64?

Are you looking to return an error when this occurs?

I assume you are merely looking for a count for each employee for a year, correct? I would write a proc...

That is not a SQL Server function. It's an extended stored procedure that you have to register on the SQL Server.

http://msdn.microsoft.com/en-us/library/ms164653%28v=sql.100%29.aspx

Definitely not x86 v x64. The way the database works and disk structures are the same.

There has to be something with security, or perhaps some other issue. If you post...

Are you backing up the t-log? Are your subscribers all getting data?

Is this the publisher or distributor log?

Check data size

Check indexing in both

check the execution plans

calvo (5/4/2012)

---

Yeah, that's real tough for him. On the verge of retirement but still the best in the game then BAM, done. All in the blink of an eye.

Let's hope...

Mark-101232 (5/4/2012)

---

Now...

You may be right. I haven't done enough formal SCRUM to know. But I have seen things slip down the list. It's not that someone doesn't advocate, but that there...