Try this script from BOL:

/********************************************************/

/*Perform a 'USE ' to select the database in which to run the script.*/

-- Declare variables

SET NOCOUNT ON

DECLARE @tablename VARCHAR (128)

DECLARE @execstr VARCHAR (255)

DECLARE...

That requires DTS. The Wizard in SQL Server 2000 you are talking about is part of DTS. DTS (Or SQL Server Intergration Services, SSIS, as it is now called) is...

Well, I at least, by adding a column defined as an IDENTITY NOT NULL, expect the column to contain NO nulls. Both by the constraint NOT NULL and by the...

Fastest way to import data from SQL Server 2000 to 2k5 is a very generic question.

Are you wondering about the best way performance wise or development time?

Performance wise would very...

Hello,

I would not recommend using cursors for this. SQL is a set based language and the relational database engine inside SQL Server is optimized for handling SETs. I am not...

Also worthy of noting is the fact that I have SELECTed * INTO TestTable2 from myTable.

Adding my UNIQUE IDENTITY column failed also for this new table.

I guess one of...

Well, the database has NOT been upgraded from SQL Server 2000. Newly created and a new table has been BULK INSERTed into.

Coul you try again without your PK and...

Yes, here is the result:

And no,...

...and a test to see if it is just this data, this table structure and this hardware and software configuration that produces this effect.

Now I have tried that and it works. Thanks.

Still remains my interesting conundrum if this really is a bug.

No, nothing really to investigate. The duration of Audit Logout Event is actually the total duration of the connection...

So if you expect a connection from a certain source to be short lived I...

Yes, and I answered to that. Ex: LEFT( @Path , 1) on 'C:\Windows\System' gives 'C'.

And if you only have the name of the folder you have to search for it...

Get the LEFT( @Path , 1) maybe?

SQL Server will, with a fragmented index (clustered on nonclustered) , lock more records then it needs and therby create big blocking problems.

Ex: If you UPDATE a record in a...

Do you mean your INSTEAD OF UPDATE is not firing when you edit the data in the view though Enterprise Manager - Open Table / Query Analyzer Object Browser - Open?

Could...