I just archived and deleted a bunch of records and there was a very important piece of my code commented out that caused me to delete too many records. Fortunately I archived them, but I'm trying to insert them back into the table, but I get this message:
Violation of PRIMARY KEY constraint...
On one of my SQL Server installations I have a linked server defined. I have created a stored proc that queries the linked server. If I log into the server as me (I'm an administrator) and use Query Analyzer to run the SP, it runs fine. If I am using QA from my own PC, I get: Login failed for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.