Bryant - the cost-of-living argument is a pretty valid and hefty one...I live in the D.C metro area and the real estate market alone has skyrocketed to criminally unaffordable prices.....

Ultimately...

Also - how many named instances do you have ? Since there is one SQL Server service for each instance of SQL Server running on the computer.....

BOL also has...

Do you have the "auto-start service when os starts" option checked ?!

I think there was definitely a misunderstanding - I was suggesting you run a script to loop through procedures using "with recompile" immediately after you do a restore...NOT sp_recompile which...

Oh yes - and that last bit about "Work in a smaller company, enjoy your job and your co-workers, and remember that life is short." - think that touched a...

Great article (as usual) Steve - a few things that caught my attention were:

1)"...those with certifications made 7-19% more on average.." - hmmm! It'd be good to get some real...

Glad that got sorted out...

Migrations CAN BE fun...when everything works...once in a bluemoon ?! 😉

In the "logins" under the "Security" folder in the server you want to access - do you see your name ?! If you right click on this and choose "properties"...

"In the end shortcutting the tech spec phase resulted in lost time later on so it really was a false economy".......

EVERYBODY (at least most people with common sense) knows this...

I swear by Wrox and OReilly publications..

Here're a few links you could look up:

http://www.w3schools.com/default.asp

http://www.mssqlserver.com/tsql/

http://vyaskn.tripod.com/sqlserverres.htm

Scott - I came across this while I was reading an article on dynamic sql - this may be completely irrelevant but it'd be interesting to see what happens if...

Using sp_recompile will mark the procedure for recompilation next time it is run...you may be better off creating a script to loop through all the procedures and executing them by...

Del - what you say reads funny but rings SO TRUE...

Going by the old adage - "If you want to see something well done, DO IT YOURSELF!" - it's tough...

Not sure what query you're running -

what service pack do you have ?! Apparently this was a known bug sometime back that was fixed with sp4 (I think!)...

Chen - not sure what you mean when you say "will delete the entire device"! You are going to be specifying name of device to be dropped....alternately, the easier way...