If it works for you then you have diced onions.

best,

There are a thousand ways peal an onion, as long as in the end you have diced onion.

I would add an sp_recompile of the table after the reindex. This...

So you are getting way down into the heart of SQL Server internals here. I'd love to have a reference to where I can read about this. But,...

As per BOL...

"Clustered indexes sort and store the data rows in the table based on their key values. There can only be one clustered index per table, because the data...

I am going to relate this topic to a development and writing of a book as most people at one time or another have thought about writing a book.

When initially...

I am going to relate this topic to a development and writing of a book as most people at one time or another have thought about writing a book.

When initially...

This was an excellently written article. It makes a point to both technical and non-technical people. I have read the replies and have to say, as with cats...

Thanks,

Actually we have multiple servers some of which have 2000 and others with 2005.  I accidently tried running this from a 2000 site while the help I was using was...

In Server management Studio under the server you want to run your query from... open each tree until you find "Linked Servers."  Add the second server as a linked server. ...

I found it on my own.

Ctrl/0 assigns a null to a column but you must leave the record before the <NULL> shows up in the column.

Thanks anyway.

Mike:

I was out Thursday and Friday.  I just read your e-mail.  When I get a chance I will load the utility and try it.  As I have just done I...

Thanks!  I'd like that.  Mt e-mail address is below.

And if I find it useful so may hundreds of others.  There are sites where you can place a bit of code and...

C R:

I am using SQL Server 2000.  I have recreated the procedure and it works just fine with one exception.  The output is a structured storage file and in SQL...

C R:

I couldn't find a stored procedure call sp_SaveDTS or sp__SaveDTS.  Is this a stored procedure created from third party software.  Can you provide the script for creating the stored procedure......

I do not have any third party software.

msdb..sysdtspackages contain the actual dts package in the column packagedata.  Table Structure follows

 name        sysname             NOT NULL,

 id          uniqueidentifier    NOT NULL,

 versionid  ...