that is normal.

the first time a procedure gets run, an execution plan is created and saved. that takes longer.

after that plan is created, subsequent calls are much faster.

if the procedure...

ok i think i see the reason, but not the solution.

float, without the size defined , is defaulted to a float(53), which is an 8 byte double precision.

if i...

how about the free one from microsoft? one of my web hosts uses it, it's basically a web based SSMS/Enterprise manager:

Download details: Microsoft SQL Web Data Administrator

it looks like all you want to do is remove the extra zeros.

to do that, you need to decide on the precision of your @A5 variable.

here's your same code,...

something like this is pretty close; I don't know the sql to get the temp table, and I'm not sure of the table that the old function uses.

the sql...

your function is fine, it's the function call...

since it is returning a table, you need SELECT * FROM, not SELECT:

select * from dbo.testFunction(getdate(),getdate()+30);

--results:

2009-07-27 00:15:08.460

2009-07-28 00:15:08.460

2009-07-29 00:15:08.460

2009-07-30 00:15:08.460

2009-07-31 00:15:08.460

etc....

well you can't delete anything in anything belonging to sys...they are just views. they are just thre for information purposes...they are not updatable.

if a function was created that you want...

the trace shows everything that happens from the moment you created it; it can't show what happened in the past, but if anything deletes again, you now have the tools...

fastest way to fix it is to reseed the value with the next highest value...146 automatically:

dbcc checkident(identicheck,RESEED) --sets to max

i thought that could not happen, but sure enough, this example...

--confirm the view exists so you can select from it:

SELECT * FROM master.dbo.sysobjects where xtype='V' and name like 'sp_%'

--no results means it's not in master, is it somewhere else? check...

I know exactly what you mean.

I post here because it gives me personal satisfaction to help someone else out. It's a huge advantage to their learning curve for us to...

26 million records to scan whether to delete or not, and it requires a table scan because of the NOT IN;

instead of NOT in, can you join instead? is there...

yeah i saw that...IE spins forever. tried with firefox, and after a couple of "do you want to stop the runaway script" warnings, it would finally open. at...

just to clarify, if you run the script above, ti doesn't do anything except add a stored procedure...

if you call the procedure, ie EXEC sp_AddMyTrace, that creates/starts the trace and...

just once. run it just once.

sp_AddMyTrace creates a log for all statements in all databases.

it is limited to 100 meg of data before it starts rolling over to reuse the...