I was traveling yesterday so could not reply.

Here is the create statement

CREATE TABLE [dbo].[mjtest](

[InvoiceId] [int] IDENTITY(1,1) NOT NULL,

[ProjectId] [int] NOT NULL,

[CompanyCode] [varchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[VendorNumber] [varchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CheckNumber] [varchar](2000)...

Thanks for the quick reply. I am using like statements because they are not equal but similar. Will a modified version of your statement with like instead of equal work...

Thanks but this seems like it will execute the first query to get the column values and then execute the main query again which will take much longer than executing...

Thank you very much. This was very helpful and informational.

It works if I remove the -E but I am not sure what it was for. This format works but please confirm if I am doing something wrong

for /F "delims=/"...

Thanks again guys!

Now I am getting "Sqlcmd: The -E and the -U/-P options are mutually exclusive." for all queries.

Thanks for the reply but now I get no errors even for files without spaces.

I think I found the problem but not a easy fix. Some of my sql files have space in the name and those ones are not throwing any error even...

Thanks for the reply. It looks good but the files do not report the error always. I got one when the object existed. But I tested creating a sp using...

Just want to confirm that the job I have setup is done the right way for error logging because you had something in your document about this and I am...

Thanks, I checked and all indexes with high fragmentation had less than 100 pages and the big ones were all fixed.

Sry about the double post. I did not see my first was not sure if it actually go added.

I had ran this query "SELECT a.index_id, name, avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (NULL, NULL,...

I am using standard edition of sql server which cannot run reindexing in online mode. Will your sp handle that or do I need to modify it?

Thanks, everything works fine now without any errors. I have SQL Server 2005 standard edition which does not support online reindexing. Will your sp check that or should I modify...

Thanks for the quick reply. I thought SQL service packs are part of windows update when you select custom but this does not seem to be the case for sp2....