Easiest way, create a load of AD groups, assign the people you want to them groups, then assign the groups the access they need in SSRS. That way you...

Well if you know you have 30GB free, then specify a size of 63GB as SQL will try to get it down to 0 or as close to it as...

Your trying to shrink 98GB down to 0GB and SQL has to compact the files in the background and as it moves pages around it is going to take time.

First...

You will be lucky to get anything specific for the exam as they have only just been officially released.

Just do a search for T-SQL 101, should bring up the basics...

Ah that old chestnut, struggled with that a number of times in the past myself, what I usually do is dump it into a primary holding table as all varchars,...

Obivoulsy the usuals BOL, Google etc

This will give a overview as well http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ chapter 6

Use a data conversion task on the data flow pane of your DFT to convert the data types.

Thats because the lock isnt tied to an object as I said in the above post, as the lock is at the DB level the DB is not an object,...

Take a look at the output from sys.dm_tran_locks and then you can modify the query to bring back what you want. Not all locks will be placed on...

My advise would be to lookup the skills measured, from the MS Learning website for the exam and then devel into them by going searches in a search engine of...

This should get you what you want.

SELECT

C.Path,

U.UserName

FROM

Catalog C

INNER JOIN

PolicyUserRole PUR

ON

C.PolicyID = PUR.PolicyID

INNER JOIN

Users U

ON

PUR.UserID = U.UserID

Actually you need this

select OBJECT_NAME(resource_associated_entity_id, resource_database_id) 'ObjectName'

from sys.dm_tran_locks

where resource_type = 'OBJECT'

Otherwise the OBJECT_NAME call will look in the current database for the connection, not the database where the object is...

Nothing, 2007 and 2010 work on an xml file format basis therefore they work together.

If you want to import a 2010 workbook, use a 2007 file type as they are...

Password encryption is one way, once its encrypted it cant be unencrypted. When you log in, it takes the password, encrypts it then matches the stored encryption against the...

They are the same, there is no difference in 2008 or 2008R2 exams, its 70-432 MCTS and 70-450 MCITP for both.