One of the snapshot isolations?

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic919053-145-1.aspx

Index on (Entry_Sequence, Patient_Info_Field_ID)? Should have, the index looks covering, unless I missed...

SQL Server, yes, SQL Agent, no. The...

Apparently there are 20 or so rows in it. Index may help, I...

Considering the size, I'm hardly surprised. Looking at that thing last week I felt like...

Abrar Ahmad_ (5/10/2010)

---

My inquiry was, if employers think that the DB can be fully managed by Front End Developers, and specially i wrote bad controlled DB by the front end...

You need to apply a service pack. I can't recall which one, but applying SP3 is safe enough.

I'm probably not going to get a chance to look at this, got a lot of work this week. Maybe Grant feels like a challenge.

Attachment? <looks around>

Restore the database from a backup taken before the change. If you don't want to overwrite the entire database, restore the backup as a new database and copy the data...

Abrar Ahmad_ (5/10/2010)

---

Each and every front end developer just do put columns in tables, and at one stage, everybody sits and thinks... what to do with this huge uncontrolled giant...

Wow. How can you ask for a discussion when your bias...

You can check the default trace, if the server isn't too busy, the changes might still be in there. Otherwise you would have needed a trace or DDL trigger before...

No! No! No!

That is terrible advice, it is...