Thanx a lot guys

for help

thanx

getting this error

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string 'C:\20071106.txt with (FIRSTROW = 2)'.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near...

still getting the same error

its 2.8

thanx a lot friends

it worked

Hii Leo

thanx for the efforts.

Even i don't knw the full flow of application, there's a lot of dependencies we r trying to consolidate the same,

as soon as i will get...

Leo.Miller (5/23/2010)

---

sanketahir1985 (5/21/2010)

---

but let me tell u my scenario

actually SP_ClientBPS runs after every 5 sec. thru console program

while Sp_IEActiveScreen gets fired randomly by users avg freq is 5-10 hits...

how can it be sql job? it runs after every 5 sec

sql job min freq. is 1 min.

GilaMonster (5/20/2010)

---

1204 is not the best traceflag to use on SQL 2005 or higher.

Switch traceflag 1222 on. That will result in a more detailed deadlock graph been written to the...

it depends on amount of data

but developers have taken care of that thing ,they have used some threading concept in which it checks for thread if it is busy...

hiii all

i m not getting this work around, since i m not a T-sql developer,i will talk to development team ,

but let me tell u my scenario

actually SP_ClientBPS runs after...

hiii Gail,

tomorrow i will post the O\P for 1222 trace flag ,since application is closed for the day.

till that time i will give the def. of sps SP_ClientBPS & ID...

is it ur production DB?

fire following command

select spid from sysprocesses where dbid=db_id('DBNAME')

identify query of this spids using "Sp_who4 "

get the attached script from http://www.sqlservercentral.com/Forums/Topic865824-146-1.aspx

if it is dead process...

hey frnds i got the ans

i have changed the script as

print ' ******************************************** Database Table Growth Report *********************************** '

Declare @dbname varchar(100)

declare @MyCommand nvarchar(1000)

----- Run This command at every database...