This will give you the name of the login or schedule who invoked the job. I hope this will help

DECLARE @Schedule_Name_ID nVARCHAR(1000)

DECLARE @Job_ID nVARCHAR(100)

DECLARE @StateINT

DECLARE @Job_Name nVARCHAR(1000)

SET@Job_Name = 'Your...

Got the solution which might work for you as well.

In my case there were few job categories (specified in the jobs ) but missing in msdb..syscategories tables.

Either you can...

use "forfiles" with xp_cmdshell and it will serve your purpose

forfiles [/p <Path>] [/m <SearchMask>] [/s] [/c "<Command>"] [/d [{+|-}][{<Date>|<Days>}]]

http://technet.microsoft.com/en-us/library/cc753551(v=ws.10)

Hi

First of all file shrinking is something else and database shrinking is something else.

Kindly let me know if you have the db as production or just testing.

and the space...

what is your Isolation level ?

try reading Snapshot isolation level and try it.

it will might help you out.

try getting only Pk in selection

like

SELECT ID

FROM TABLES and JOINS and WHERE Clause

put the result set in a Temp table and then select the orignal data like

SELECT...

did u change the max worker to 0 ?

kindly let me know the details about the behaviour of the db server when its performing slow ? i mean the counters...

kindly state more details about what is ur current avg response time and what do u mean by badly affected ? is it performing poorly or it has stopped responding...

it would be much better if you could just upload the actual execution plan so i can have a look at it and then i can give you an advice...

I suggest you to use this solution as its much better when comparing text values if you need an exact math

1. Add an (e.g. CSV_Inv) INTEGER COLUMN to the table...

Dear Fritchey thankyou very much for your time,

I have tried the left joins and its not that much beneficial as main issue is of timestamp you can and about...

Thankyou very much its really nice to hear from you.

First Execute this

Use [YourDBName]

GO

EXEC sp_updatestats

It will update the Stats for all the tables

Then try to rebuild or at least defrag the tables which are used mostly

then you...

dear Thankyou very much for your valuable suggestion but it will be a worst case when i will do it as it requires a column to be added and data...

I have defragged all the indexes and maintenance is done regularly and no index has a scan density less than 90% so what else is missing ? what would be...