SQLGuru,
thanks for your response. we are going through other stuff and not looking at changing any settings. What I wanted to understand below number, Am I reaching my maxworker...

Yes, I am testing with different type of corruption to see how its behave.

I have change the code to use TRY...CATCH and it seems to be working.

SET NOCOUNT ON

DECLARE @dbid...

Yes, it populate the table if everything is fine but table is empty if failed with an error for one of the database.

This is what I am expecting as I created suspect database for my testing but my above script stop here even though I have one more database to change DBCC.

Error...

Did not work. Once script hit suspect database failed with error and doesn't check dbcc on rest of the database.

SET NOCOUNT ON

DECLARE @dbid INT

DECLARE @DBName SYSNAME

DECLARE @SQL NVARCHAR(4000)

CREATE TABLE ##temp_tbl

(

Error...

Thanks for quick reply. I created one suspect database and DBCC CHECKDB failed for suspect database and loop stops there. There are more databases in loop that I like to...

Drop table only allowed by db_owner and ddl_admin permission at the database and sysadmin at the server level. I am not sure if you can filter out who are the...

Try to use with port number and see if you can connect. If you can connect with port number than recycle your SQL browser service.

Incremental backup is your database backup and trasaction log backup is your log backup. Increamental backup can be done on your database irrelavant of database recovery model and take backup...

I use below T-SQL code to get mount point that are used by databases from sysaltfiles.

In below code, you need to change following lines as per your enviornment.

select distinct substring(filename,...

You can use OSQL or SQLCMD in your SQL job and through the query output into shared directory on your SQL server where your user has permission to read.

Do you do regular db reindex and update stats in DEV same as PROD? I also see huge difference in memory for your DEV (2GB) and PROD (8GB). Is that...

You can also get it from sysprocesses.

select hostname from sysprocesses where program_name like 'Microsoft® Windows® Operating System%'

Why do you have LocaleID as Ireland in package? Is this the regional settings you have on your server too?

English (Ireland)

ISO file should not be required by SQL server 2008. It seems like you have other program that show ISO as virtual drive and disk. If you do have that...