Happy to help.

I think that would solve the problem (just make sure that the derived table dtOrderedSales has the order by you need and you should be fine) :

SELECT identity (int,...

Actually if you only want ONLY positive values you'd be better off doing something like this :

Select ABS(MyCol) from dbo.MyTable

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...