richardmgreen1 (6/1/2012)

---

Anthony - thanks for that, I'll give it a try and see what happens.

Just one quick question, why have you ignored master, model, msdb and tempdb in your code?

John...

I thought it would be blocked here to as its alcohol related, but must...

Koen Verbeeck (6/1/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

I would give my...

Koen Verbeeck (6/1/2012)

---

I would give my left kidney to...

me neither, thought 20% was bad

It's not a bad social network in all fairness, just be carefull with recruitment agencies. When I got made redundant last year I ended up with around 100 recruitment...

all in one go.

you cant combine full backups, what you could do is restore to 4 databases, then use some thing like Red-Gate's SQL Data Compare tool (other tools available) to see the...

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

'DBCC SHRINKFILE ('+name+'_log);'+ CHAR(13) + CHAR(10)

FROM sys.databases WHERE name NOT IN ('master','model','msdb','tempdb')

FOR XML PATH('')

)

AS...

Koen Verbeeck (6/1/2012)

---

Wait untill you see our taxes. The reason we have such great...

Thanks Andy.

Was searching the web for a few of the answers to which I had a sort of clue about but wanted to double check, and from reading BOL I...

NVPL (none visible panty line)

it would require some coding and can be done, all depends how you want to do it.

what you will need is to call the reportviewer.aspx control from your dmz web...

+1 to the stairway, also dont underestimate the power of your favourite search engine, lots of good and not so good sites out on the interweb.

Thanks Perry, learnt something new on that one.