Ha! I've missed the obviousl like that too many times and spent an hour to find the problem 🙂

If you run DBCC SQLPERF(LOGSPACE) you should see that the used percentage is low.

run sp_helpdb database name

Then run the following

DBCC SHRINKFILE paste in the log file logical name

that should shrink...

What error do you get when the service fails to start?

Have you checked the state of the indexes and stats on the tables that are being inserted to? What is the fill factor?

If you have high levels of fragmentation...

Your missing a + sign after the first reference to the @column variable

exec('if exists (select 1 from ##my_table where [' + @column + '] = ''jim'') insert into ##field_name(field) values('''...

You've tested the sa login manually right? I mean you can connect to from Query Analyser?

A bit off topic, but I strongly recommend that you DO NOT have a...

Musician? Ummmm no.

I do have an acoustic which I am trying to learn...but its just a whole load of noise at present. I'm thinking electric just to be...

I was about to ask where you get your train fair prices!

£17.80 for a daily travelcard. I just get the return from Waterloo though and walk to Piccadilly. ...

That's pretty awesome. Speaks volumes about the quality of the site!

I would think by around March/April next year the site should hit the 1,000,000 mark! That's some community...

Lynn Pettis (7/9/2008)

---

Clive Strong (7/9/2008)

---

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use the car...

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use the car these days, but I...

Quite simply, log shipping is the process of moving transaction logs from one instance to another and restoring them onto the 2nd instance.

The logs are backed up on the 1st...

I used to drive 40 miles each way in my last job. Used to drive me nuts when there was a crash on the M3. That sucked.

However, considering...

When I think about DR, I think worst scenario. What if there was a fire at the hosting center and all of the servers are wiped out. What...

Alternatively...

1. Run a profiler trace against your database and then run through looking for any calls to this table. The downside to this is that the call to a...