Thanks for the replies, I find it very odd that the error is thrown even when there is no data in the table. Thanks!

Hmm, interesting. The object is a table (non-heap). There is a clustered index and 4 non-clustered indexes. Do you know of a more in-depth explanation of the...

Thanks for the information Craig, I really appreciate it. I'll read those articles you've included.

Thanks for the reply Craig!

I meant that if one of the...

Hi Gail,

Thanks for the response, I didn't think of traceflags. I ran DBCC TRACESTATUS and got the following two results:

TraceFlag Status Global Session

1204 ...

My sincere apologies for jumping the gun, the problem is that this table is not a part of the dbo schema and I had overlooked that.

Derrick,

Thank you! The ALTER AUTHORIZATION is what I was missing. Now I am able to have ProcB a member of dbo schema, but owned by LoginA as...

Hey thanks for the info Lowell. I would have guessed the opposite - that the optimizer first checks the current db/schema and then if not found there, keep checking...

Thank you both for the replies. I will try to flush out the various parameters being used on these queries. My apologies for the delay on thanking you!

Thanks again for the replies. I've attached sample data now. Also, I made a typo in the original post. The PK of Table A is Col1. ...

Thanks for the replies guys. Sorry if the use of ColX has confused us. Table A does not contain Col3 and Table B does not contain Col2. ...

Thanks for the replies guys. I haven't had any luck instantiating the snap-ins into the PowerShell. I also had trouble finding the actual profile to use. I...

Hey guys, thanks for the quick replies. The SQL Server 2005 instance is Standard Edition 64-bit. I do see the SQLPS utility in the C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist...

Hey There,

The following worked for me:

declare @a nvarchar(20)

set @a = N'CDDÉE'

update testcols set col1 = @a

HTH

Turns out that this was a typo on my part in the connection string. This is why I got the error. To see this, I simply opened the...