Also I would check your local computer keyboard and language vs the servers keyboard and language.

E.g English British and English American the keys are in different locations eg Shift+2 in...

If you want to control SSRS in SSMS then you will need to downgrade to SSRS2005.

As for why, unsure, I would see if there is a connect article on it...

You cant do what you want to do in SSMS you need to do it via the web page.

Do any of the other windows accounts have sysadmin access? If so simply change the SA password.

What has changed recently on the server?

Migrated to a different server, moved databases around etc etc.

Yes you can start the server in single user mode.

Impact well only 1 person at a time can connect

As your not incrementing @root your inserting the same value every time.

You would want to row_number the table then add the max ID value to it so that it is...

You need to backup the solution files not to backup the databases, so that you have the solution in a 2005 format as once you have upgraded them you cannot...

Do you have the solution files to hand?

If so make a backup of them in their 2005 state, then open the originals in BIDS 2008, it should run you through...

One method would be a string splitter.

Take a look in my signature for Jeff's string splitter and call it in your query

declare @temp table(Userid int, forename varchar(200), surname varchar(200), locationid...

This work for you?

DECLARE @Temp TABLE (ServerName VARCHAR(10), ServerFunction VARCHAR(3), BackupReqCode TINYINT)

INSERT INTO @Temp VALUES

('Server1','IS',0),

('Server2','Ops',0),

('Server3','Ops',2),

('Server4','Ops',4),

('Server5','IS',1),

('Server6','IS',5),

('Server7','Ops',0),

('Server8','IS',2),

('Server9','Ops',3),

('Server10','Ops',3)

SELECT

BackupReqCode,

ISNULL(SUM(CASE WHEN ServerFunction = 'IS' THEN 1 END),0) AS 'IS',

ISNULL(SUM(CASE WHEN ServerFunction = 'OPS' THEN 1...

Whats your RTO and RPO for the database? If its mission critical and DBCC CHECKDB only takes 1 - 2.5 minutes to run, I would run it every day...

select name, case value when 0 then 'Disabled' when 1 then 'Enabled' END AS Status, CASE value_in_use WHEN 0 THEN 'Disabled' WHEN 1 THEN 'Enabled' END AS RunningStatus from sys.configurations...

So you have new SAN drives presented on your existing servers and you want to move files say from drive D to drive Z on the same server?

If so, ALTER...

http://msdn.microsoft.com/en-gb/library/bb510680.aspx