Yes, you can restore msdb without restoring master and that is exactly what I have done for DR purposes.  msdb contains all the jobs, dts packages and backup history among other...

...and this one

http://support.microsoft.com/default.aspx?scid=kb;en-us;280106

Actually, trying to insert a column in a specific order is indicative of a problem.  There should be no meaningful ordering of either columns or rows in a relational table.

I have generally found that for DR purposes it isn't necessary to restore the master db to the target server, in fact it usually just causes problems.  The only thing...

The WITH REPLACE option merely tells SQL to overwrite any existing files of the same name with what is in the backup.  The DBCC SHRINKFILE allows you to "resize" the...

check out http://support.microsoft.com/default.aspx?scid=kb;en-us;306843&sd=tech

"...flawed practice of using special values"?  And NULL isn't a special value?  OK, by definition, NULL isn't a value at all, it is more accurate to say that it is...

It sounds like you need to call ONYX for support. 

To answer your question about SELECT vs. PRINT.  SELECT returns a record set to the client (unless it is being...

Tyler, I had a chance to check this out and you are absolutely correct.  I'll let Steve Jones know.

I fully agree with the cursors are bad mentality, but in this case you don't have much of a choice.  About the only other option is to create dynamic sql...

But I thought Oracle was UNBREAKABLE?!>!#@(*&$!

I'm not sure why the shrink is hanging, 20GB isn't that big and shouldn't take that long.  However if you want to shrink the database to a size smaller than...

You will not be able to restore the database without all of its data files.  A log file can be rebuilt assuming that the database was shut down or detached...

That's an interesting one, but I think I have a theory about what's going on.

The shrink operation would have to place locks and latches on the pages that it is re-arranging, and...

Yes, backups can run from UNC paths. 

Your issue is almost certainly due to a permissions issue.  If you can see that directory from the server in question that doesn't...