If you've managed to open SSMS and connect to your database server you should see a list of all the databases in the left hand tree view - to drop...

Tempdb?  Where is that sitting?

Joe

Likely culprit in this scenario would be the firewall - since it "never" fails while both servers are behind the firewall, but fails when the server is put in the...

How did you go about your upgrade?  What compatability level is the db current set at?  Have you rebuilt indexes/reorganized the database since the upgrade?

Also where is your tempdb/how is...

Check out SQLRecon, it will "crawl"/scan for SQL Server instances and report any that it can find including version, etc.  Be sure to talk to your network folks before turning...

Ken -

The growth of your Tlog is normal/correct behavior as you load/manipulate data within the database - the Tlog will grow to accommodate the largest single transaction.  If you are...

Scott -

Make sure that the stored procedure exists in your default database/initial catalog - in your connection string you are probably specifying the "initial catalog=", that's where your stored procedure...

Scott -

Stick with localhost\SQLEXPRESS and rebuild your project once you've made the change. 

Joe

Neener -

I'm still not sure why you're running set up to delete a databases - why not just delete the database via SSMS?

Joe

Given that you are working with an IIS server (Microsoft Internet Information Services 6.0) what are the chances that you can save yourself some pain and configure IIS to log...

Scott -

Try changing your connection string from .SQLEXPRESS to .\SQLEXPRESS and let us know the results.  SQL Express is typically installed as a named instance for which the naming convention...

I must be missing something here, how/why are you dealing with msiinv.exe, etc. just to drop a database?  Is this a visual studio setup (or other installer) package?

Joe

I'm not clear on what you're trying to accomplish...

Full text index on SQL 2000 are not backed up as part of the database backup, SQL 2005 they are.

Are you taking...

Delete the databases on your SQL 2005 instance, backup from the 2000 server and then restore on the 2005 instance and all will be good - watch out for file paths...

You are both right, I stand corrected, as part of our regular hardening of servers we revoke VIEW ANY DATABASE as a matter of course.

Take a look at VIEW ANY...