The Rockies are doing something. They were down 1-0 for a lot of the game Sat night (I went with my son) and then they scored 2 to win,...

Is there perhaps a task in the package using this connection?

I don't have a 2005 instance to check this on right now, but can you save/store this in the file...

Under Management, there should be a "Maintenance plans" folder. Click it, then double click your plan. It should open in an editor.

This one is good: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1284393802&sr=8-3

Note that with physical access, a Windows admin could find a way in. If this is just to prevent issues from Windows admins making changes, go the administrative route, and...

You can't get this from T-SQL. You would have to call some Windows functions to get this, and you can shell out somehow to get those from T-SQL, but it's...

SanjayAttray (9/13/2010)

Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written...

Mike,

good points, although often we have the plans cached, so I'd expect that if I run a query regularly, I'm getting the same plan every time.

Perhaps this isn't a great...

Ultimately you need to test and get an idea of when it's quicker which way. It often does depend on how much data, and your disk I/O.

Please start a new thread and explain your issue better.

If you are doing a bare metal restore with some software, where are the MDF/LDF files? The bare metal restores I've seen (and they rarely work, in my experience), include...

My apologies for the plagiarism. I have removed the article, and reported the author to OSI Consulting[/url], the employer whose email server was used to send the article in.

Restore syntax: http://msdn.microsoft.com/en-us/library/ms186858%28v=SQL.100%29.aspx

There isn't a good example there, but basically

restore database xxxx from disk = 'yyyyy' with norecovery

restore log xxxxx from disk = 'zzzzz' with norecovery

restore log xxxxx from disk...

John is correct. you need to restore/move, all the files that are returned from the RESTORE FILELISTONLY command.

Added my vote. That's a good suggestion, though I wonder how well people would know how to use it.