Unfortunately I don’t have any spare slots, I have total 4 of them out of which 2 are used for C Drive & 2 are used for...

This should help you.

SELECT rows FROM sysindexes WHERE id = OBJECT_ID('<TABLE_NAME>') AND indid < 2

Try killing it from EM.

sp_updatetask is provided for backward compatibility only, check BOL for more info.

Add the outputfile pramater in steps under webtask job .

sp_runwebtask [ [ @procname = ] 'procname' ]

    [ , [ @outputfile = ] 'outputfile'

You are asking the hole architecture may be you should as questions related to db issues, then you might get some good tips on that.

if you are the only one who is updating the other table then you can pull the records in tmp table check the condition then if needed update the...

If trace is enabled on the server then  you can find from that.

create procedure ds_truncatetable(@tablename varchar(60))

as

exec ('truncate table '+@tablename)

go

you can restore the backup on your current db itself or even drop & create db will also work in your case.

Try seting recovery model to simple in db properties under options tab.

Try replacing "STANDBY" with "RECOVERY"

OR

Try replacing "DBO_ONLY" with "RESTRICTED_USER" as "DBO_ONLY" is available only for backward compatibility.

If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service will fail to start, with an error message "Your installation was corrupted or...

If the numbers of columns are going to be constant at all the time then cross tab is the most effective way of getting the result set.

May 31, 2006 at 3:00 am