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

duplicate post.

no need to post the same question in multiple forums, the "Recent Posts>>Posts Added Today" makes sure your question will be seen.

follow the thread and answers posted so far...

I know if you had done it the opposite way, where you granted the user or role minimum rights like db_datareader and db_datawriter, then you had to do GRANT VIEW...

something like this should get you started; you have to join the table against itself to get the date differences.

SELECT game_id,DATEDIFF(day,MinSet.date,MaxSet.date)

From (select home as x, min(date) as date from YourTable...

i currently have to support both SQL and Oracle at the shop that I work.

because even little things like naming conventions for parameters(SQL requires parameters to start with @, Oracle...

encrypted fields have to be nvarchar or sometimes varbinary data types for any encryption to work, depending on the encryption method. they also have to typically be much larger than...

not an expert on SSIS, but as you identified,the row_number function can do what you want, for sure...maybe stick everything in a table and do the row_number in a Script...