Thank you, I'll give both a try tomorrow and get back to you.

I would second the Inside SQL Server books, excellent reference books, but a word of warning the first 2 / 3 chapters in the T-SQL programming and T-SQL Querying books...

Thanks I managed to get it working using a similar solution:

DECLARE @results table (result xml)

--Build the Dynamic SQL Statement to get the data from the xml file

SET @sqlstmt= 'SELECT *...

Thanks I managed to get it all working successfully.

Also I modified the functions so I could provide 2 dates so I can calculate the time passed between them instead of...

Hi, could you give me a little guidance on removing the lunch break as we have a rolling support team who work from 8am till 6PM.

I have managed to update...

The database was upgraded over the weekend by a member of our support staff, which caused the log to grow by 5GB while all the database changes occured.

Usually the log...

Hi,

If you buy the self paced training kit books you get a free set of tests on a CD which are by measureup. To be honest this is cheaper...

Thats the one, thank you!

Hi, I have written some SQL in the past that might just give you what you are looking for this will outout to a file in C:\temp called Security_Report.txt.

File is...

Steve, sorry I should have mentioned that I'm a DBA.

And it's looking forward.

Hi,

I have done all 3.

70-431 has simulations and multiple choice.

70-443 is a case study based exam, mine was 6 case studies with between 7 and 13 multiple choice...

Thanks for the reply, I have been toying with the idea of the BI stuff as I agree there definitely seems to be a growing market for this.

I...

Other than the WMI error, could it be that the SQL Server Service (MSSQLSERVER if its a deafult instance) is configured to use a windows account to run the service....

Just relaised its a problem with the text displayed in Google Chrome so when copied to Query Analyser it has html tags in it, copied it again in IE7 and...

Steve's answer was definetly more complete, I should have done the same, hope you get it working.