I have actually run through the process of rolling the SP 4 back and it worked fine.  It does seem overly complex, but I think due to the number of...

I think what you are looking for is what is called "Steaming".  I have done this in the past with word documents, excel spreadsheets and images, but I am nto...

The way I got around this was by using a case by statement in the order by clause.  Here is an example:

CREATE PROCEDURE Return_EmpInfo ( @OrderColumn varchar(100) ) AS

SELECT EmpID, FName, LName,...

I ran into something similar to this before.  One thing to check is that the tempdb files are located in the same location as your previous server.  If they are...

I would suggest using an MSDE installation, it is a free version though it has some limitations.  Information can be found at the following link:

http://www.microsoft.com/sql/msde/default.mspx

Good Luck

For this kind of thing I have been using a tool from Microsoft called SQLH2.  This is integrated with SQL Server Reporting Services and provides all kinds of statistics.  Other...

I agree, the problem is most likly that the master database is looking for other system databases in specific locations which it cannot find.  Usually the most common one is...

I used this product briefly when it was in Beta Testing and it was not too bad.  Very basic though.  It did not really give a lot more information other...

Thanks Phil, and thanks everyone else as well.  Everyone had some good points and suggestions and it is definitly going to give some stuff to think about over the next...

One more thing to add here is that many of these custom scripts accomplish their amazing feats by directly accessing and querying system tables.  In terms of support, Microsoft has been...

Thanks for the input Phil. First off, I am not a "wizard" dba, I have 5 years experience doing this job and am more than capable of running command line...

Thanks dc,

I was starting to think that I was going crazy. The reinventing the wheel thing is what comes to mind right away. An analogy someone once gave me was...

When I need to shrink a large file like that I set up a maintenance plan to do it and then let it run over a weekend or another time...

Probably the easiest way to do this is to open the package, click the menu item package and the select save as.  Give it another name and then delete the...

Here are some links that I have used in the past. They give some good information on what the counters represent and the threshold they should adhere to.

<