Attached is the output of Select * from sys.transmission_queue.

Thanks,

MJ

Try this:

-- Declare local variables

CREATE TABLE #DB_Space (

DBname varchar(25),Name varchar(100), FileName varchar(100),

Size_in_MB varchar(20),

Space_Used varchar(20),Available_Space varchar(20),RunDate Datetime

)

EXEC master..sp_MSForeachdb '

USE [?]IF DB_ID(''?'')>4

BEGIN

INSERT INTO #DB_Space

SELECT db_name(dbid),sf.name AS [File], sf.filename as...

I am getting the below mentioned message in under transmission_status column in Select * from sys.transmission_queue output:

Could not find the target broker in the local SQL Server instance.

Please help me...

I think the previous DBA scheduled it on business request. I am trying to find the same with business owner too.

Thanks for asking,

MJ

Thanks for your replies guys. I checked and found that server is scheduled to be rebooted at same time when job starts so I think due to it job is...

Have you gone thru the below mentioned link:-

http://technet.microsoft.com/en-us/library/aa274527(SQL.80).aspx

If yes, then please ignore.

MJ

Madhu,

Just go under surface area configuration for services and connections for this sql server instance and click on Database Engine-->Remote Connections and then on right hand side you would be...

Jack,

It was enabled during this time frame as job modified date says it was last modified on 29th May.

Since then it was never changed.

Thanks for the reply,

MJ

Adding to what Steve said analyze the execution plan and look for the costliest operator and try to tune the query part which is consuming the most of the cost...

Please check the SQLSetup0027_SQL1_SQL.log file as mentioned under error information message and also check the cluster installation log file which will help you to reach to a conclusion.

MJ

Is there any dump file created under log folder in sql server installation directory? Can you schedule a job to just track the sp_who2 output so that you can see...

Try this:

Create TABLE #db_file_information(

fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300))

-- Get the size of the datafiles

insert into #db_file_information

( fileid

, theFileGroup...

Verify the same from attachment. There are two rows for IndexId=3.

MJ

Adam,

I added one included column under one index in person.addresstype table in adventureworks table thn ut SP returned two rows for that index. Is that right?

Shldn't it report only one?

Just...

Have you checked event viewer logs or sqlstp.log files under C:\Windows\ or search for recent sqlstp file if you are unable to locate it in system root?

MJ