extractor.exe -R Extract

[-?]

[

[-F sqllitespeed_backup_file]

[-E base_file_name]

[-N file_number]

[-K encryption_key]

[-L 0|1|2 ]

[-I]

]

this will convert your SLS backup to Bak backup

first of all there are 2 delete statements that are being executed which are taking lot of resources. do a DBCC inputbuffer on spid's 69 and 72. Also check SPID's...

If you are trying to use linked server to link 64 bit SQL server 2005 to 32 bit SQL server you will get this message.

this is a...

You can create a DNS alias for the new server, that way when you try to access the old server it will be automatically routed to the new server

thank you

Hi Tommy,

Thank you for your reply but i am working with SQL server 2000. To my knowledge only SQL server 2005 creates default *.trc files. Please correct me if...

Thank you Anita, Leifah and Ninja. You were of great help .

Below is the script that worked for me in the test environment..

Please comment if i have made any mistake..

CREATE PROCEDURE inde

AS

SET NOCOUNT ON

DECLARE @tablename VARCHAR (128)

DECLARE @execstr ...

Thank you both Leifah and Ninja for the suggestion. This does not work for indexdefrag. It work fine for DBCC DBREINDEX.

use test

go

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')" ---...

When trying to use the object id, i found a strange problem

the below query gives me a NULL result.

It only works for 'dbo' owner, it does not work for other...

Thank you for the reply but I didnot get what you were say..

below is the procedure that i am using to do the indexdefrag

CREATE PROCEDURE usp_sp_INDEXDEFRAG

AS

SET NOCOUNT ON

DECLARE @tablename...

hey Rudy,

Thank you very much for the answers.

Very nice..great work..I love the way it shows up..Thank you

Thank you for the suggestion and the article..i will try to do that

Hi Lucky,

Thank you for the reply. The mail profile is configured using the domail account. SQL server services and SQL server agent services are started using the same domain...

Thank you very much Greg. I also don't believe in developer having access to all of these but have to follow orders. I will try to implement this.