What do you mean by "offline back"? Why do you want to do it?

John

You need to find out which operation is taking more than 600 seconds to complete, and look at improving its performance.

John

I think you have three options, then:

(1) Do as Brian suggested, but then explicitly deny EXECUTE on all system stored procedures.

(2) Move your user-defined stored procedures to a different schema...

Because there should be no expectation that the results of a SELECT query will be ordered, whether the query is against a table or a view, and whether or not...

If you've got corrupt data in your database then I would recommend that you deal with that before anything else. Have a read about DBCC CHECKDB if you haven't...

Ninja's_RGR'us (11/1/2011)

---

Did I miss something in the conversation?

Edit YUP.

There's no point in putting the columns in the correct order. You do that in the select statements.

SQL will order those...

Not as far as I know - there is no create_date column in sys.columns. I would advise against using the GUI to insert a new column between two existing...

You're ordering your results by the create date of the table. Since that will be the same for each column in the table, you can't guarantee that your results...

Have you tried logging a call with Quest support? I usually find them very helpful.

John

From the link I posted:

- Never run with more privileges than necessary. Users that log into an application with their own login should normally only have EXEC permissions on stored...

That's what I'd recommend, yes. See also this:

http://www.sommarskog.se/dynamic_sql.html

John

Bear in mind that we usually have shorter hours and longer holidays here in the UK than in the US, especially in public sector jobs. Comparing the salary only...

Frank

Please will you post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and show us the data you're trying to insert...

Murali

What column(s) do you want to match the two result sets on?

John

Something like this?

WITH MinVals AS (

SELECT

TransNo,

MIN(IsVoid) AS IsVoid

FROM

MyTable

)

SELECT

t.IncidentId

,v.IsVoid

,t.TransNo

FROM

MyTable t

JOIN

MinVals v ON m.TransNo = v.TransNo

Please post table DDL (CREATE TABLE), sample data (INSERT) and expected results next time. You'll get...