Query Analyzer and SQL Express

I actually have multiple questions. I am trying to use a CMS called Insite Creation 2008 for my site but am having some issues. With regards to the database, I am trying to find out a few things. The setup instructions for the CMS state that I need to create a blank database, which I have done. It then says that I need to run a file call storeproc.sql against the database using Query Analyzer:

1) How would I use Query Analyzer against my database on the DASP servers?

2) Isn't Query Analyzer for SQL 2000? My DASP database is SQL 2005.

3) I am running SQL 2005 Express on my local machine for development. If I create a database on my local machine with SQL 2005 Express, can I replace my DASP database with that one?

4)Is it possible to make a SQL Express database workwith SQL 2005.

Any help would be appreciated. I am just trying to figure out how to make this work so that I dont feel like I wasted the money on the license fee for the CMS.

If anyone wants to take a look at the setup instructions provided to see if maybe they can figure out a way to make this work for me, you can find the documentation at http://www.insitecreation.com/resources/1/insitecreation/InsiteCreation2008.pdf. The setup instructions are in the first few pages. They seem easy enough until I got to the Query Analyzer part.

Thanks in advance for any help!

 

Dear Lance

1) How would I use Query Analyzer against my database on the DASP servers?

For SQL 2005 clicking on New Query is equivalent to Query Analyzer.

2) Isn't Query Analyzer for SQL 2000? My DASP database is SQL 2005.

Yes you are right, technically Query Analyzer is a feature for Enterprise Manager/MS SQL 2000, however New Query provides the same function.

3) I am running SQL 2005 Express on my local machine for development. If I create a database on my local machine with SQL 2005 Express, can I replace my DASP database with that one?

Yes you should be able to. Read this kb article for information on our SQL Management Tool feature which will allow you to attach or restore databases to your discountasp db addon. http://kb.discountasp.net/article.aspx?id=10431

4) Is it possible to make a SQL Express database work with SQL 2005.

Not exactly sure what you mean by this question, but on our shared hosting environment to ensure stability and security, we do not support SQL Express on our servers.