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.

Certain things are stored in the default trace if its enabled, but by default only 5 20MB files are created and are rolled over once full, so you might have...

sure as long as you have a connection method that uses the correct credentials you can do what you want to the db.

First off I'm going to say, that I hope you understand that shrinking a database is not recommended or best practise and ensure that you perform index maintenance after your...

the config tool is good for looking at it in a GUI, but always check the XML config file as it can differ as the config file contains all the...