what about with the /f switch which should just start the MASTER database to which you should then be able to execute the alter database statements

http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.100%29.aspx

I would also look at your drive configuration after it and see if your current config / RAID levels are sufficient enough to support failure of hardware to hopefully mitigate...

I think you would have to start SQL in single_user or minimal config mode and then issue a number of alter database commands to alter where it thinks TempDB lives...

Again, personal preference.

In the example you have given below, within BIDS (business intelligence development studio/visual studio) you have the option to right click a task and run it on its...

Yeah you can still use DTS in 2008, but I would recommend against it and re-write your DTS into SSIS as DTS has been depreciated since the release of SQL2005...

Sorry Wendy do you mean the deploy option within BIDS?

Personally I group tasks in order of acheving the overall goal. So for example, if one goal is to copy 100 tables from ServerA to ServerB, I would class...

There is the execution log view which is in the reportserver database which stores the marjority of this information. The only thing it doesnt do is if they logged...

Following on from Jared's script, this is the script that I use as it shows me the parameter values as well as the parts of the subscription I need to...

The solution is the root element of the overall SSIS file structure which is determined by the .SLN file extension, which is usually in the root of the directory. ...

Is this in one particular DB or is it multiple DB's and server level rights?

The four main tables for DB permissions would be a join on these from within the...

reidres (5/15/2012)

---

And I am unclear as to why the three temp tables response would be offered, first because there are three and not one, and second because I thought that...

Sorry I finish work at 4 UK time and dont have time on the forums due to family committments.

Yes you will create them in computer manager

Unsure on the passwords part,...

Thanks for the heads up Gail, much appreciated as always.

Thanks Gail, I'm sitting the ITP for administration in 2 weeks. I was going to go for the MCSE Data Platform so will need to get up to speed...