Thanks.

I got it. Even though the second query gives no error, it will wait for the first to wait to complete.

Mean while, the second query shows executing .

Thanks

Manoj

Can't believe this thread gave me a feeling of loosing 7 points for QoD (humour) this morning.

Yes. I lost the QoD about DBCC TIMEWARP. I couldnt find this thread in...

Querying the msdb tables looks something like below:

SELECT TOP 1 bmf.physical_device_name [Backup File]

FROM msdb.dbo.backupmediafamily bmf

INNER JOIN msdb.dbo.backupset bs

ON bmf.media_set_id = bs.media_set_id

WHERE bs.database_name ='AdventureWorks'

ORDER BY bs.backup_finish_date DESC

You can also...

I could uninstall the Integration Services without changing the data value from 0 to 1.

I'm still confused.

Thanks for the replies guys.

So,If there has been no modification in the source database, then no pages will be copied to SS and hence the data is read from...

Shrinking the log file and moving the files to the new location is the feasible option.

But the other options are:

1. Detach the DB, move the data file (only) to the...

Please could you explain how it works.

The data for the 'Uninstallable' is always 0 in the REGISTRY.

What was your previous (default) value for it and what was the value give...

I'm not looking for locking pages for sql server. Because other process requesting memory would be SQL related only (.ie., analysis services, SSIS etc..). I dont want to hamper them.

I...

Hi,

Its a 64 bit server.

MAX memory in OS = 16 GB. MAX mem value for SQL Server is 6 GB. Mem is divided among SQL server, SSIS, SSAS.

No AWE used.

Do...

I got it from here:

http://www.hotcoding.com/dbs/sql/34936.html

Correct me if I'm wrong

Thanks in advance

I want to know about sp_services.

Because SQL server central gave wrong for sp_services in its question of the day contest. But I still believe that this SP can be used...

Is this undocumented SP still present in the SP3 of SQL 2005/?

If so, which DB?

Hi Vinu,

Please could you explain how you sorted it?.

M John