How do I get started talking to my webmatrix sql server

get a prompt up (in a program like telnet / msdos window) so that I can run sql commands on my webmatrix accounts sql server. I've been trying to connect using telnet but i think maybe I've got the wrong end of the stick or I'm doing something wrong.

here's a link where you click through "how to connect" on the "myserver page" I searched the page for "connect" and found 0 occurances.

http://europe.webmatrixhosting.net/text.aspx?tmpl=qa#3.7anyone please help,

the only way I know of to create table is through an sql prompt,

is there another way or can somebody give me some pointers cos i'm well stuck.|||Will webmatrixhosting let you use Enterprise Manager and Query Analyzer?|||i have windows XP pro, it doesn't come with it does it?

this isn't my main priority at the moment though,

trying to get an msde installed however is :

http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=447274

http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx?id=181961&Page=1#183199

then I might actually be able to start coding the ASP.NET I'm required to produced (pretty much by the end of the week)|||Enterprise Manager and Query Analyzer are "free" tools provided with SQL Server 2k.
Even when demo period is over, you can still use 'em.

Install MSDE.
Download SQL Server 2k.
Then just choose "SQL Server Tools only" during install.|||wicked!

I was looking for a trial on the ms site but couldn't find one b4 - didn't think they had one, downloading it now :)

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)
|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.
|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)
|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.
|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

how do i do this using Crystal Reports IX?

Hi all,

Please help me with my CR IX problems...I am new to crystal reports.

I have a table that consist of:
[City, Program, Type of Payment, Total # of participants]
example:
[LA, Aerobics, Cash, 100
LA, Aerobics, Credit, 120
LA, Dance, Cash, 50
LA, Dance, Credit, 20]

I wanted to do a report so that it will show the folowing datas:
[City, $Aerobics, $Dance, CR Aerobics, CR Dance, Total]
example:
[LA, # of participants in Aerobics that pay by cash, # of participants in Dance that pay by cash, # of participants in Aerobics that pay by credit card, # of participants in Dance that pay by credit card, Total # of participants in LA]

Thank you very much in advance for your answer and time.
Have a wonderful day!Do a group by 'City' field. Create running total for #of participants and
select 'Use a formula' option. Use the following formula :

if Program="Aerobics" and Type of Payment="Cash" then
true
else
false;

This will give you the total # of participants with Cash payment for Aerobics. Similar running totals for Credit card payment etc.

Hope this helps!
Rashmi

How Do I distribute an existing DataBase - Please Help

I have a Systema that uses a DataBase an I Want to Install y other machines, I need to Install a Visual Studio Program that uses a Database, How do I Install The Visual Studio Program, the Sql Server Express, and the existing DataBase.

Thanks in Advance, Santiago

Visual Studio can be installed using the appropiate installer from the VS disks, SQL Server comes with the Visual Studio, so you either use the shipped version with Visual Studio and update it laterone with the SP2 Service Pack or leave the SQL Server Express edition out and install it seperately by using the most recent download from Microsoft. The database can be distributed by using SQL Backup and Restore (Backup the databases on the source server and restore them on the other clients)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Perhaps these resources will help:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

How Do I distribute an existing DataBase - Please Help

I have a Systema that uses a DataBase an I Want to Install y other machines, I need to Install a Visual Studio Program that uses a Database, How do I Install The Visual Studio Program, the Sql Server Express, and the existing DataBase.

Thanks in Advance, Santiago

Visual Studio can be installed using the appropiate installer from the VS disks, SQL Server comes with the Visual Studio, so you either use the shipped version with Visual Studio and update it laterone with the SP2 Service Pack or leave the SQL Server Express edition out and install it seperately by using the most recent download from Microsoft. The database can be distributed by using SQL Backup and Restore (Backup the databases on the source server and restore them on the other clients)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Perhaps these resources will help:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648