If you installed the express version of management studio you must uninstall it first if you wish to install the full version. So I am guessing this could be an issue...

What version are you trying to install?

VS usuall installs express by default when its being installed?

As it sounds like its trying to upgrade a version you alreday hav einstalled

David

You could do something like

SELECT *

FROM Table

where datetime >= DATEADD(week, -4, GETDATE())

Obviously the use of getdate() may not be appropriate for you but hopefully you get the idea

hth

David

It's in BOL if you try typing url in the index it will miraculosuly find all the topics about accessing reporting services through a url.

David

To manually uninstall

http://support.microsoft.com/?kbid=909967

hth

David

I have always just dropped the table in the worksheet as the first step in the package and recreated it in the second and the after the do what you...

Are you getting this error often??

If so check the server you are backing up to and look for mrxSMB erors and LAN redirector errors in the event log if this is...

By the way using auto shrink is not recommneded you can find many articles on why e.g

http://www.sqlservercentral.com/columnists/mpearson/autocloseandautoshrinkjustdont.asp

To recreate tempdb you will need to restart sql server as it recreated each...

I think its just

SELECT department, sn + '', '' + givenname

Create

Procedure SPPS

@Year1

int, @Year2 int ,@Year3 int