Data Management Interview Questions 

I 'm using MS SQL 2000 for a management software. I want to export data so that I can set up the software on the custom's computer. But I 'm stuck with a problem: "how to export ALL data from MS SQL server ?". (ALL means : tables, foreignkey, data, store procedure)
Anyone knows about this problem, please help. Thanks thousand times.

Is there option to export data from CSV file to
Microsoft SQL Server Management Studio Express(SQL Server.2005).
Plz Help me.

I have a SQL database created in my Visual Web Developer Express website. The website is currently being developed on my local machine so I have a file based website.

I would like to copy an Access table and its data into this SQL database.

I believe that this may be done by using the MS SQL Server Management Studio. My problem is that I cannont attach to my websites SQL database. (yes I have detached the Database from VWD first) When I try to browse to the SQL database file The directory tree doesn't open up all folders.

In otherwords many folders are hidden from view from within the attach dialog browser. I tried copying the website files from the myDoc's subfolders to another location but after copying to the root directory the websites subfolders are still hidden from view. I can view these files in Explorer and checked the attributes in the folders properties. They are not hidden nor read only.
I am signing on to the managment studio using windows authorization.

I have a web site, in that web site the client fills the form to add a note to the List of him/her Agenda which is based on Sql database 2005.

I will tell my problem with the followinge example

For Example;

Gökkusagi is filled in textBox and saved to the database.
On the second page, which lists the notes, the word Gökkusagi appears like this: GökkuÅ?aÄ?

On the Other hand if I edit the word Gökkusagi manually in th SQL Management System, everything goes well, at this time it appears correctly.

I think there is a problem while sending the data to the SQL 2005. But what?


Best Regards

BK

I created a relational database using ms access, based on exsting excel data. I also created queries, forms, macros and event precedures etc.

- Is it possible to split my tables and the rest, put tables onto a small business server mahcine as a back-end, and then copy queries, forms etc to individual front-end user's pcs - let users to manipulate data through forms and queries? Or am i just daydreaming?
- If it is doable, is there any tutorials out there regarding this topic?

- If we decided to migrate access tables to ms sql server, how can users manipulate the data? As there isnt an interface (ie, forms in access that allow users to use as a tool for updating data). Does sql server management studio provide this kinda interface?

Thank you.

what is normalisation. what does it mean to 'normalise to the third form??' How do I create an SQL query? Thanks in advance for the help, x

Hi

I have Old Database "A" in SQL2005.

I already created Database "B" and Tables using SQL 2005 Server Management Studio Scripts of Database "A".

I have to Move existing rows of several tables from "A" to "B". I need a tool to generate insert scripts for this.

hi. what's th easiest way to transfer data from an sql server to another?
I'm using sql server management express.

I have problem in writing the query in SQL.please,anyone suggest me to study better,which books and websites are useful.

I have just started using Microsoft SQL Server Management Studio Express and want to populate the contents of a text file into a new table. Can Microsoft SQL Server Management Studio Express create a linked table like MS Access?