actually it's the syscomments table in the database in which the sps are kept.

Thanx for the correction Antares.

yes the locking file is in the same directory and same filename.

You'll have to kill the process manually this time but for the next times make sure that everytime you...

I've already had a similiar problem but not in dts. This may sound simplistic but is it possible that the database has been opened by your dts but not...

On another note I've seen scripts that do defragmentation on this board. Maybe you could use that too.

then you may have a look at this

exec SP_MSFOREACHDB 'print ''?'' --Script that does your stuff here'

then you can try my first solution which would work.. but be aware that dynamic sql is pretty much considered an evil amongts dbas and advanced coders. Make sure...

let's say this is your sp :

create proc MySP @DbName as varchar(100)

as

use @DbName

Select * from dbo.SysObjects

GO

You'd have to do something like this :

create proc MySP @DbName as varchar(100)

as

exec...

just code the function to remove it (just check to see if it's 1 or 2 characters that need to be removed.. this removes the last 2 chars of each...

you're already all set, just paste it in excel and change cell and the text will be presented as it should.

hmm, you can try this software.. But I don't expect it to be able to find and connect to turned off servers...

SQL STRIPES

Select case

when DoneDate is null and GetDate() > DueDate then 1

when DoneDate is null and DateDiff(d, DueDate, GetDate()) 14 then 4

when Not DoneDate is null then 5

else 99 --in case...

what Antares meant to say is :

Update MyTable set MyColumn = replace (MyColumn, 'x', '')

where charindex ('x', MyColumn) > 0

that way only the columns that actually need modifying would...

Too many good solutions to this questions... just as long as you keep the conversions down it's gonna be fine... I've seen 2-3 solutions here that do it in only...

I don't think it would make that much of a difference.

Unless sql server is on another machine than the web server, then you could see where it is best to...