Yes, but the point is that with UPDATE...FROM, you'll never know about it. If you use the ANSI syntax, you'll get an error message.

John

Here's where Joe explained it to me before. I now try to avoid UPDATE...FROM unless there is no possibility of cardinality errors - and then I document it in...

If you can't find it in SSMS, it's probably because you don't have enough permissions on SQL Server. If you log on to the server and run SQL Server...

You need MSSQL$APP1.

John

It might have something to do with...

Debbie

Instead of using an Execute SQL task to get the result set into an Object variable, why not use a Data Flow task to get it into a staging table?...

An index enforcing a primary key constraint will indeed be created clustered by default, but if there is already a clustered index on the table, the new index will be...

Almost.... since a function was required, and you can't use temp tables in a function:

CREATE TABLE testitem (itm_item varchar(43) NOT NULL,itm_desc varchar(100) NOT NULL,wsd_quantity int NOT NULL)

INSERT INTO testitem

SELECT 'CHCWPSU10DMX','Chroma-Q...

It sounds as if the file was in the wrong place and the registry entry was correct, since you said that everything was 64-bit.

John

OS error 5 means access denied, while OS error 2 means the file could not be found. Looks like permissions have been changed in one place and elsewhere, one...

Bhimraj

Then you won't be able to release any space from your log file. You have two options:

(1) Implement your new backup strategy as a matter of priority

(2) Switch to...

Bhimraj

So you're not doing any transaction log backups at all at the moment?

John

Have you read about computed columns? I think this would be a better solution than a trigger.

John

Please will you provide table DDL (in the form of a CREATE TABLE statement) and sample data (in the form of INSERT statements) to help us to help you.

Thanks

John

Jay

Are you specifying the server name correctly, complete with instance name if appropriate and port number if necessary? You could try either looking in the errorlog of the server...