http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

And?

Another job I wouldn't qualify for. The T-SQL and basic Pl-SQL are fine, however I don't meet any of the front end coding requirements.

I'd second the 'restore from last good backup', but might be possible to hack-attach the database. Last resort though.

http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/

May or may not be sufficient, depending on the code (which we haven't seen), and not necessarily the best option.

There are many ways...

Why do you want to shrink the file? What...

On what aspect of it specifically?

Have you read Kalen's whitepaper on it? Have you read the many blog posts from the SQL dev team or people who have played with...

rodjkidd (4/24/2014)

---

Train goes straightish from Birmingham airport to Telford. Via Brum central, so you might have to change train, but I think they just sit at Birmingham for a few...

Steve Jones - SSC Editor (4/24/2014)

---

GilaMonster (4/24/2014)

---

Steve Jones - SSC Editor (4/24/2014)

---

On the shed-dyule for...

Why?

...

Or use...

Yay!

Make the column an identity? Or use a sequence?

Err.. Thanks.

I have no idea which post you're referring to, but you're welcome.

Finally making some progress on at article on premature optimisation. Anyone willing to be a proof-reader? Hopefully will be done this week or next.

I'd start by looking through other procedures to see if there's any which drop and recreate that table. Sounds like there might be another procedure which does a DROP TABLE......