Sorry, duplicate post, try this thread instead.

Lynn Pettis (7/9/2009)

---

Unless you have a field that tracks the order that records are inserted )and is used to help order) and the columns you are sorting on are duplicates,...

Not that I know how to do it, but I would bet that you could do it with Powershell and this would be a good opportunity to learn some Powershell...

Unless you have some kind of incrementing column like an Identity column or an Inserted Date then there is no way to know when a row was inserted or to...

Your problem is that you are referencing the updated table which does not exist. In SQL Server triggers you need to reference the Inserted and Deleted virtual tables. ...

Yup, Steve and RedGate know about the problems as evidenced by the fact that we aren't getting the whole error displayed anymore. Yup, it appears to be with the...

Duplicate post, please answer here, http://www.sqlservercentral.com/Forums/Topic750186-146-1.aspx

You can query sys.databases to see if a database in online or not and then use sp_senddbmail to sendo ut a message or you can write an error out and...

I think either of these will queries will work. Had you posted some sample data as outlined in the first link in my signature I would have tested the...

I agree with GSquared in that I would put them in a Common/Utilities database and make them available via the public role. I never considered putting synonyms to them...

I'd be interested to know what DBCC OPENTRAN returns when run in the database the stored procedure is in returns. It sounds like you might have a transaction that...

Duplicate post, please post answers here, http://www.sqlservercentral.com/Forums/Topic749767-338-1.aspx

Duplicate post. Post answers here, http://www.sqlservercentral.com/Forums/Topic749752-169-1.aspx

Duplicate post. Post answers here, http://www.sqlservercentral.com/Forums/Topic749752-169-1.aspx

Just got approval from the boss to go to the PASS SUMMIT! You'll know it's me when you hear someone loud, but can't see them because they are too...