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...

Change or disable the alert. It makes no sense to have an alert for a condition that is already exceeded.

Bhuvnesh (5/4/2012)

---

It means that there should not be any connection (some process is using) with those files but why this case doesnt get applied on...

Great advice from Gus, but one thing I'd also add to my list to circle back on is to make sure that you round robin to all groups before too...

There are scripts here on this site to help you automate this. Ideally you restore all backups every day. If not, pick a few test workstations, set up restores on...

Are you using roles here for security to be sure the two users have the same access?

Is there perhaps some other trigger on the table that is causing issues?

Can you...

I think you're both off track slightly here. Apple doesn't do well because of sales. They do well because they've made very intuitive products that work great in some ways,...