You have to use Sql Server Profiler.

During creation new db, the model database is open. Check sp_who2, and if necessary kill proces using model database.

You don't need to keep "drop #temptable" in your sp.

This table exists only during executing this sp and is recreated every time you run sp.

It's not possible to kill extended stored procedures (xp) using kill statement. Am I right ?

What about isql/osql ?

I don't think that it is possible with sp_MSforeachtable, but why don't use systems table, eg.:

SELECT object_name(id), rows

FROM sysindexes

WHERE indid IN...

Hi Ryan,

it seems that works, I'm going to check this against my table which is  huge, so it might takes a lot of time.

Best regards,

dobrzak

Yes, exactly.

I've order by Item, StartDate.

Hi,

I dont have any gaps between data, startdate can be different than 1st of a month and EndDate can be different than 31st. I want show the entire price history for...

Sorry for confused you

This is only example, I write this myself and didint't notice that date was wrong, I'm really sory. But in...

Hi, I have column datatime, but I have problem in this case:

Item |StartDate |EndDate | Price

1 1/1/2004 ...

Exactly, great thanks !!