Just because they were entered first doesn't mean they will be returned from the SQL server in that order.  Since there is no clustered index, you can not guarantee that...

How can you tell the difference between the first 14 million records and the last 1.5 million records?  Is there some field on the record you can check that could possibly...

The solution I gave will update 14 million records since it is in the while loop (140 iterations of 100,000 records).  However, the "first" 14 million records can not be guaranteed...

As long as your where clause restricts your result set to the first 14 million records, that will work.  Otherwise it will update all records in the table in...

Here are a couple of ways you can do this:

1.  In the data tab, use the following type of syntax as your command.

Example:  EXEC stored_proc_name @param1, @param2

Click the 'Generic Query Designer' button...

Can you just use the print button on your browser window?

It seems that when you answer the question, it is still requiring the initial "correct" answer.

I just answered it with the correct answer (every table, every view, every stored procedure...

That worked perfectly.

Thanks ozy!!!

If you don't have to worry about the time when the statement is ran (if this is run at 11:20am, it will delete everything older than 60 days ago at 11:20am)...

I had the same problem.  I clicked the link to answer the question and it said I had already gotten it wrong.  What's up with that???

That's one way I was thinking about doing it.  Setting up a job that checks for procs without the permissions on it and assigning them appropriately, but the time between...

Thanks for the quick response.

I was looking for an alternate way of handling this (if possible).  I didn't want to have to worry about granting permissions every time I rollout...

USKiwi,

I believe the identity property will evaluate a new ID before the constraints are checked.

Here's a quick example of what I did:

CREATE TABLE DebugMe

(RecordNumber int NOT NULL IDENTITY (1,1),...

In the report designer, on the data tab, select the 'Generic Query Designer' (it should be the 4th button to the right of the dataset drop down box).  Then, to...

I do this on a few tables every night to get rid of old and useless data.  Here's how I do it:

delete from tableX

where datefield < convert(varchar, getdate() - 21,...