Looks like the User you have selected for your service account has the password expiration policy set. Contact your system admin to correct that

There is one bit of information still missing in this post. What type of linked server are we dealing with here? is it an SQL linked server? if yes then it...

For these cases is a lot better to use OPENROWSET or OPENDATABASE. Linked servers are supposed to be used as permanent resources. IF you still insist in using that method...

You should really look at the data because you are supposed to get the matches and the missmatches too

BTW : your select has...

The fact that tableA  does not exists when the delete statement is parsed is what generates the error.

Either

 1. Use a normal Table and truncate it when needed 

2. Use dynamic...

Text data type manipulations are very cumbersome and should be avoided. Can you change it to let the client read the text and pass it back to the sever?  

If you still have no...

Yep ORDER of operations matter in this case if you create the DB before the UDT are in model then you are...

Comunities like this would be impossible with such regulations!

Lets hope there is a balance in management decisions out there

Another thing that helps is to set the DBs that are less used in read-only mode and you will, at least, have no problems with those

Ok, Where is the beer!!

Now, I am the one who is curious. Where do you live?

OK I got the link

Transaction Isolation level is a property of the Connection not of the Server or the Database. You can not...

Great ! where is sushila sending the check?  

Best solution will probably be to buy the speakers!!

I am congratulating myself here because nobody will bother over here

Cheers!

>>I have a computed column ColA :- formula = (ColB+ColC+ColD)/3.<<

change the formula to:

= (ColB+Isnull(ColC,0)+ColD)/(3 - (case when Col3 is null then 1 else 0 end))