Certain things are stored in the default trace if its enabled, but by default only 5 20MB files are created and are rolled over once full, so you might have...

sure as long as you have a connection method that uses the correct credentials you can do what you want to the db.

First off I'm going to say, that I hope you understand that shrinking a database is not recommended or best practise and ensure that you perform index maintenance after your...

the config tool is good for looking at it in a GUI, but always check the XML config file as it can differ as the config file contains all the...

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...