Hello,

This is possibly caused by high levels of blocking on your SQL Server.

May be take a look at these articles:-

http://www.sql-server-performance.com/tips/blocking_p1.aspx

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=27354&highlight_key=y&keyword1=error+1222

Regards,

John Marsh

Hello Doug,

(As you mentioned it is not a production DB) Have you tried an sp_repldone?

Regards,

John Marsh

Hello,

A right-click and then "Run As" of SSMS will indeed let you test as the Windows Account (assuming you have access to the password), but what specific issues are you...

Hello,

You might also find this thread of interest:-

http://www.sqlservercentral.com/Forums/Topic749688-146-1.aspx

Regards,

John Marsh

Hello,

Can you post the Error that you get? In particular the Error Number, Level and State.

Regards,

John Marsh

Hello again,

As mentioned in my first reply. You can add the Unique Constraint to the combination of "real" columns in the Table that the Computed Column is built on. I...

Hello Nag,

If you want to consider using sp_msforeachdb, then I have tested the code below under SQL 2005. It should work Okay for 2000.

Regards,

John Marsh

PS: During my (limited) testing, I...

Hello Marco,

I had a quick look through the following article and couldn’t spot any reason why 2008 to (MSDE) 2000 would not work, but you might want to read the...

Hello,

You may find these two threads of interest:-

http://www.windows-tech.info/15/6c7783c53516a698.php

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/62f058c1-d0d6-4420-90e0-555794b889a4/

Regards,

John Marsh

Hmm, that does seem odd.

What results do you get if you execute the following script on the DB that is to be replicated:-

Select

ss.name As SchemaName,

sdp.name As SchemaOwner

From...

Hello again,

Unless you persist the Computed Column, it is not physically stored, so it will not impact system efficiency (including Inserts).

Please see the Books Online Topic “Computed Columns“.

Regards,

John Marsh

Hello Wayne,

You can find a definition of irony here: http://www.askoxford.com/concise_oed/irony?view=uk

You may like to spend your time writing code to duplicate logic already provided elsewhere but that does not...

Hello,

Could you use sp_msforeachdb instead of the cursor and Use statement?

Regards,

John Marsh

I can only guess that either the original installation of the Replication Components didn’t complete totally, or the SP was somehow since deleted.

Anyway, glad to hear that it is...

Hello Andrew,

I don’t believe you can as SQL Server Linked Servers are (sort of) one way.

You could link to SQL Server tables from within Access (but I guess you know...