So that's the difference between the two products. Thanks for clarifying. That is a significant difference and one worth taking into consideration when making a purchase.

I thought the same thing that others did when I read this editorial: Why is it that this capability to restore a virtual database from a backup is being treated...

To be fair, I have not read your article, but I did notice that it uses DMO which is being replaced by SMO. We have found that although DMO does...

To be fair, I have not read your article, but I did notice that it uses DMO which is being replaced by SMO. We have found that although DMO does...

One big advantage to using stored procs that I have not seen mentioned here is when it comes time for a SQL upgrade. Without having all your sql code in...

I just wrote this quick little stored procedure to reverse engineer grants for a specific object. Note that I placed it in the master database so I can run it...

I ran across this article through a Google search. I am already familiar with DCM, and I thought this would be the perfect tool to use to determine the rate...

I have no BI and data warehousing experience, but I know this is a huge topic that I need to become familiar with. Would studying for these certification exams be...

I'm confused. Are you saying a particular process could fail and in turn cause the transaction log to grow? Or are you talking about a process that fails and causes...

I never understood his reasonings either, and I know that continually shrinking the log is not something I want to do unless there's a very good reason for it.

I know...

Thanks for your help. I haven't had time to try out your changes yet, but I did find another article that I think will be helpful to me as well...

In addition to AdventureWorks, you can download other sample databases from http://www.codeplex.com/MSFTDBProdSamples

Here's what is there...

The following sample databases are currently available for Microsoft SQL Server 2005 and Microsoft SQL Server...

You don't see the AdventureWorks database because you can't connect to the instance or you don't see it because when you log in it's not there? Please be more descriptive.

So you must not have created a SQL 2005 instance at all, correct? If that's the case you should be able to run setup again and create an instance. Don't...

First, SQL 2000 and 2005 can be installed on the same server and both be running at the same time. I assume you're not running them at the same time...