Hi

Sorry if this sounds obvious, you can script the entire db using management studio, right click on the db go to all tasks and script db.

You can also expand the...

Hi AJ,

I don't think you can tell unless you have some form of auditing enabled or using ddl triggers.

Hope this helps

OK let me add a different scenario that if know to be true, BUT this is not about me I hasten to add… I pay huge amounts in gas and...

Are you getting any problems with performance letting the SAN "do its job".

We have many large databases with many millions of rows in certain tables, all with indexes...

Why don't you make all the node the same SP level, seems logical seeing as the existing nodes in the cluster are at SP4.

If the company can afford to pay someone for five years and not realise that they were out of pocket, that's their lookout and their problem.

Perhaps the person in question...

If you have got the Express edition then you will need to download and install the Management Studio for Express.

If you have Developer edition then you will have to specify...

When you intsall SQL Server 2005 you have to select the "client tools" as a component for installation in the wizard. Failure to do this will result in the...

Hi Brad, I suppose it depends on what type of training you’re after and where you are based... Learning Tree in London offer independent training courses...(not the Microsoft curriculum) on...

me - i'm a pretty good key note speaker, been best man a few times given some awesome addresses, went down well, my mother told me, if you wantme to...

Hi tracey 3042 is sp2 minus some security patches, visit the microsot site for some further info...

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

which training course would you recommend colin? any in particluar

The question is dated Jan 1 2008 - I don't see the 'trick'

You could try and use the online option when creating the index... taken from BOL

ONLINE = { ON | OFF }

Specifies whether underlying tables and associated indexes are...

Appologies if you have tried this but if you search for:

SQL Server Agent, service startup accounts

In BOL it should give you place to start...