Dinesh Priyankara (7/24/2003)

Ok. What I want is : create a trace using sp_trace_create with option 2. That's what I have done. But I cannot read the tracefile untill I...

Thank you.

hi Paul,

I had a database that checkdb reported errors, I did a checktable for all the tables and few tables reported problems. See the output from each step. Interestingly, the...

Thanks...You answere my question.

Nice article...very simple and precise.

But, I did not understand the second report...what are P1, P2, P3 columns represent ?

Please let me know.

thanks,

Ranga

Kathi,

Very good article....

I saw on the microsoft site and it says "This version(2.027) of SQLH2 supports SQL Server 2005 RTM collection "

Is there a different version of SQLH2 for SQL...

Thanks for your responses...I changed my code to defrag indexes which have more than 1000 pages.

Individual Plans for each databases will be a efficient method. Also include the database name in the maintanence Plan name for better documentation.

why not a stored procedure with a output parameter ?

Thanks.., here is the exact commands

EXEC MASTER.DBO.XP_REGREAD

@rootkey='HKEY_LOCAL_MACHINE'

,@key='SYSTEM\ControlSet001\Services\MSSQLSERVER'

,@ValueName = 'ObjectName'

EXEC MASTER.DBO.XP_REGREAD

@rootkey='HKEY_LOCAL_MACHINE'

,@key='SYSTEM\ControlSet001\Services\SQLSERVERAGENT'

,@ValueName = 'ObjectName'

We are auditing our servers and want to see whether all our servers are using the right domain acct...

To create a good format file, use DTS. Just drop a sql connection object and a bulk insert task and go from there. After you choose the source and destination...

Thanks for your feedback...

The reason I wanted to drop all the nonclustered indexes is to speedup the bulk insert process..

I actually ran sp_helpindex, stored the results in a work table...

My requirement is to:

1.Drop all the indexes from the table

2.Load New Data

3.Delete Old Data

4.Recreate the indexes...

So, I am looking for any script that would script all the existing indexes so...

sushila, my point was that database is overloaded with stuff which could very well be done by the front end code or midlle tier!

Just beacuse you have got upto 140...