Adding rules,roles and administrators to my website

Hi ,

I am trying to add users,rules,roles and administrators to my website, of course on my local server everything was ok, but now I can't login with my users on the server.

Basicly I created users and rules on my comp, and copied the App_data DB file to the root\app_data that is on the server(Using godaddy).

I understand that if the data is on the server it is no longer uses the DB in the root\app_data , but only the asp tables which are on MSSQL database.

I need help in copying the data from the data base in the App_data folder to the hosting database. I couldn't find the answers in the godaddy website help nor how to use their stored procedures to insert all the above.

(if I need to use the stored procedures please explain how)

Thanks very much for your help

Hi yrcaesar,

From the description, I understand you want to copy the datas from an absolute database (mdf, ldf) to a SQL Server on the server. If I have misunderstood your concern, please feel free to let me know.

I think you can simply attach the database for this scenario. Copy the database files to the server. Attach the database by right click "Databases" node in SQL Server Management Studio and select "Attach…" in the content menu.

Adding data to columns

Hi

I'm am using SQL Server 2005 Express on my home PC.

To practice some of the SQL skills I learned on a course I was recently on, I am trying to build a mini database which I can run some queries from.

I have created some tables and added columns to these tables. However, I cannot find how to add data to these columns.

I'm sure it's pretty simple but I just can't find it! Can anyone help?

Cheers!

Hi,

use http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

to do this with an administrative console, otherwise, code you own gui to put in the appropiate statements.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

MarkAdams,

If you want to practice SQL "by hand", you can use an insert instruction. For example :

INSERT INTO Members (Id, FirstName)

VALUES (1, 'Mike');

In this example, we have a table Members which contains 2 columns : Id and FirstName). The values to insert must be appear in the exact same order as the columns names listed.

If Id is an identity column used as a primary key, you don't enter any value by hand. So the insert instruction will look like :

INSERT INTO Members (FirstName)

VALUES ('Mike');

The SQL Server 2005 Management Studio Express application is a good tool to learn SQL, because you can use both graphical and script method to execute instructions.

Best regards.