It sounds like a permission problem with the user account that you are using to run the Upgrade Wizard .

Macca:

In Management Studio:  If you right-click on the table you want to modify, and choose "Modify":

* You should be able to select more than one field for a primary key...

If you are starting to have doubts about hiring a person after you interviewed them you can always try:

(1) calling references to get a feel for the candidate's personality (you would be surprised...

In SQL 2005 EM,

to find the maintenance plans:  (DB_SERVER) -> Management -> Maintenance Plans

to find the scheduled jobs: (DB_SERVER) -> SQL Server Agent -> Jobs

** replace (DB_SERVER) with the...

Not sure if this is what you are asking ... in FULL recovery mode when you perform a transactional log backup, your transacation log file will be reduced in size...

What a great idea!  I can't wait to see your course offerings.  I only hope that I can persuade my boss to send me to a class in Orlando, Fl...

I use the "Remove Files Older Than" option in my maintenance plans.  For example, my maintenance plan #1 writes all backups to C:\Backups and runs every Sunday. ...

Found the following at http://msdn2.microsoft.com/en-US/library/ms186865(SQL.90).aspx.  It seems to be that the difference is that "EXPIREDATE" gives you the option of specifiying the ACTUAL DATE the backup can be overwritten while...

We do not use screen shots.  Having them in the documentation just causes more work when upgrades are made to the software.  If you have a minor upgrade where there...

Glad that helped.  Sorry though, I don't know the answer to:

Just tried this out.  In the SQL Export Wiz, on the "Select Source Table and Views", click the "Edit" button next to the table that contains a varchar.  Change the...

I am glad that I am not the only one who had that question ... I was so curious about it that I saved the icon (from my browser) to...

Top 10 differences between SQL Server and Access:

10)  Memory management

9)  SQL can handle bigger size databases

8) Extra server side components for SQL Server (i.e.like Analysis services, DTS, etc)

7) You can...

As SQLBill mentioned, make sure that SQL Server Agent is running:

On the server, open up Control Panel -> Administrative Tools -> Services.  Make sure that "SQLSERVERAGENT" is listed as "Running". ...