Query 2 output for spotlight process(Session_id 118 is Spot light monitoring tool user connected to QuestWorkDatabase) as per internal_objects_alloac_page_count is 606664 pages i.e. 4.63gb.

I agree with Jason. I noticed it when you posted five queries with their output earlier.

Try to run following code when it grows to find the offending query, if there...

Don't think so.

http://msdn.microsoft.com/en-us/library/ms188712.aspx

The principal and mirror server instances must be running the same edition of SQL Server—either Standard or Enterprise.

Primary filegroup needs to be restored/available then only you can proceed with the rest ones.

http://msdn.microsoft.com/en-us/library/aa196613(SQL.80).aspx

Partial restore operations work with database filegroups. The primary filegroup is always restored, along...

As per http://www.bigresource.com/Tracker/Track-ms_sql-GXEo9RFV/

Not found a way post-installation. Since sql2k5 no longer track licensing per code, this kind of information isn't that important anymore.

Anyway, the "only" way...

Paste the output of following

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),

SERVERPROPERTY ('edition')

http://www.mssqltips.com/tip.asp?tip=1046

Sys.dm_exec_requests DMVs to find the currently active requests, their associated TSQL statement, and the corresponding query plan that is allocating most space resources in tempdb.

SELECT t1.session_id, t1.request_id, t1.task_alloc,

...

As per

http://www.winserverkb.com/Uwe/Forum.aspx/windows-server-sbs/35736/6-SetServiceStatus

Generally speaking, the event 4101 should be related with third party

software or hardware. In order to solve such issue, we may need further get

more...

BEGIN

DECLARE @path NVARCHAR(4000)

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

...

Could you please post the script that you are using for creating the snapshot database.

Example stated at-->http://technet.microsoft.com/en-us/library/ms175511.aspx

MJ

Already answered with workaround.

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=254140

Renuka,

As per http://msdn.microsoft.com/en-us/library/ms179344(SQL.90).aspx

The loss of a partner has the following effect:

3. If the only mirror server becomes unavailable, the principal and witness continue.

Hope this answer...

Normally, it should run based on the filter. Try running the trace under gui to see if it actually filters and then script it out.

Even after updating statistics with fullscan results are different.

Also, script posted at http://vyaskn.tripod.com/code/sp_show_huge_tables.txt doesn't give the sales.individual tables in output list.