Try this in Query Analyzer......

SELECT SERVERPROPERTY('LicenseType'),

SERVERPROPERTY('NumLicenses')

-SQLBill

Check to see that they have permission to access the databases.

-SQLBill

WITH STOPAT and WITH STOPATMARK are two different things.

WITH STOPATMARK requires you to have set a mark in your transaction.

WITH STOPAT just requires that you be restoring a LOG...

Aha.......it's those little details that cause problems all the time.

Glad you figured it out.

-SQLBill

You might want to look at Microsoft's website for some of the other patches that came out after SP3. There were problems with that version, which is why they came...

Your development server has a RTM version of SQL Server. That needs to be upgraded to SP3a or 4 right away. SP3a was the first to correct the...

I agree with you, but that doesn't explain the results which was my point. There are three language classes with a total of 22 Males. The three language classes...

I don't get how you are coming up with your numbers......for example:

Languages, there are three language courses which have a total of 22 Males, but you are only counting two...

You might be able to make one stored procedure per table, but it's not going to work as a generic 'for all tables' script. All your tables don't have...

But the table names will begin with the owners name:

joesmith.#mytable

janedoe.#mytable

That's one reason it's always a good idea to use the 3-part naming convention (dbname.owner.table)

-SQLBill

Yep. And it requires its own license.

-SQLBill

I believe that when you run the install there is a window where it asks for the instance and has a checkbox for default. Check or uncheck the box as...

Everyone seems to be looking at this database as though it was created all at once. Maybe it was done a part at a time. Sometimes what works...

If the query and data are the exact same, then it's an issue between the Personal and Enterprise editions.

-SQLBill

I'll second BKelly's comment......I'll bet you have more than one instance and just keep updating the default instance. You MUST apply service packs to each instance even if they are...