Depends what you want to do, DATEDIFF gets the difference between 2 dates, in this case you simply want to subtract 5 weeks from the current value which DATEADD is...

you could build it into a xml auto format pass it into an exec statement if you wanted to do it set based, but it will eventually only come out...

you will need to set the authentication to mixed mode (sql & windows) restart SQL, then create a SQL account under the security folder in SSMS on the actual server,...

There are a lot of things on google for that error message my google search which seem to imply its something to do the rsreportserver.config file.

DELETE FROM test1 WHERE col1 <= DATEADD(WEEK,-5,GETDATE())

Will delete anything where col1 is 2012-04-26 (based on today) or less

first link i found when googling

http://jahaines.blogspot.co.uk/2010/04/t-sql-tuesday-005-creating-emailing.html

sp_who2 or sys.dm_exec_requests/sys.dm_exec_sessions will get you the information you need.

if the query window was closed and didnt commit it will be rolling back the transaction. if the query window...

If the data needs to be accessable to users on the other server, then you will want a combination of backups and either logshipping, mirroring, replication.

If the data doesnt need...

are you talking backups as in BAK and TRN files or copying the db's so that they can be used on the other server?

this link should help you out

http://msdn.microsoft.com/en-us/library/cc645954%28v=sql.105%29.aspx

are you in a domain environment or a workgroup environment?

if workgroup you will need to use SQL authentication to connect, otherwise if your in a domain environment ensure that your...

Well you will need to find the level of rights which securityadmin gives the user then use the DENY keywords to manually deny the permissions you dont want them to...

You dont have access to the SSRS DB or Local System doesnt? Is the report db on your local machine or is it on a remote server?

I will second that John, last selection I had was at the local beer festival http://www.beer-festival.co.uk/, had a very good range of cask, other than that not really much good...

running as local system which is a highly priviledge account, should really be running your services with a less priviledge account, that aside, check that local system has access to...