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

Actually, your article doesn't cover use of the REPLACE option. And the Microsoft page you link to is...

Does the message go on to say anything else? I think you can use the REPLACE option to overwrite the existing database. I would advise you to use...

Two other things you could consider: back up msdb on your test server, then restore over it, then restore the original one back once you've retrieved your package. Or...

I would set them both to 12GB, for example, and if there's a failover, let them fight for the available memory. The reason for this is that failovers should...