how to create databases in sql server 7.0 in win 98?there is no such option in the console root .?
336563
The MSDE version of SQL doesn't come with an interface to create a database.  Without SQL Enterprise Manager you need to use MS Access and create a project (.adp extension in Access).  Using that process, Access runs through a setup where you specify the local instance of SQL Server ... and once it creates the SQL database, you can add tables and views through the MS Access interface.  Good luck!
724162
for a database system you can use something like windows 2003 or windows NT for distributed systems you can use windows NT or linux
1071667
I think u have to enter you host name, username password and the name of the database after the =>.\n\nyou can do this wich a text editor like notepad.
1115367
You can download SQL Server Express from Microsoft. It is a very good database server and works very well with the other .Net Express programs. There is a great wealth of information available on how to use it. Best of all, it is completely free to download, use and distribute.
161373
You can get a free version of SQL Server 2005 (the "Express" edition) at the link below.\n\nIt will run fine on Windows XP.
539787
You need to create a windows application or a command line application. then you can use the following\n\nImports System.SqlClient\n\nthen just use the library features to open a sql connection and specify a sql command and fill a dataset using that.
1132129
Read this short review:\nhttp://en.wikipedia.org/wiki/DBMS
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
1100890
you should use an sql connection object from the component toolbar n make a connected architecture.. and then drag n drop an sql command object . in that object's property set type = stored procedure and then proceed. it's as simple as that in visual studio..\nin query builder u'll get the type as : create procedure <> as.... GO.\nthen in ur code for d form write:\nSqlCommand cmd = new SqlCommand (<proc.name>, <connection name>);\ncmd.CommandType=CommandType.StoredProcedure;\ncmd.Parameters.Add( new SqlParameter("@<pname>",<type>,value,<col name>));\ncmd.ExecuteNonQuery();\nhope thiswill work for u?
144872
Create a new database, using the Database Wizard.  There, it will give you different samples.  There is probably several ready-to-run examples there to use...
1167306
The short answer is that you have to have an external (remote) database setup, then you can use odbc to connect to it.
112568
refer these urls..\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_5b1v.asp\n\njust surf through the bookmark on left hand side..\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_30s5.asp\n\n\nalso refer this one..simple n straight forward\nhttp://www.1keydata.com/sql/sql-create-index.html
725618
Hai Ritu,\n   Here you mentioned that you are connected to *.mdb, so it is not to a single database, like db1.mdb ?\n\nYou cannot  access lot of mdb's through a single dsn.\n\nIf this is not the  case, then you need to verify that the dsn you created is existing ? and it is the same as that you have mentioned in the programming.\n\nOne more thing is that you said you are working in an application, \nIs that a Web Application, later you said you are using JSP ?\n\nWhere did you receive these error messages ? \nIs it in the console(command prompt) or in the IE ?\n(This error may be also due to missing of library file also).\n\nIf you wish you can contact me\nfor more clarifications, send me a detailed description of what you need to know and if possible send me the code segment\nI will correct the necessary parts.\n\nemail: ananthasivanvk@gmail.com\ncell: +919995403653
937158
hi,\nthere is no default extension for backup files in SQL 2000. So we can choose ours, if u want as bak u can give backup file name with .bak.\notherwise if u want .bck u can give backup file name with .bck
169272
its not like MS Access database where you can simply copy the database and paste it somewhere.\n\nOracle : You can move the whole database to a different location using the oracle manager or you can export the entire database which will create a dump file. However this is done usually for backup purposes. \n\nNOTE: Unmount the database first before doing any of the above. Also what Oracle version you're using 9i or 10g?\n\nhope this helps
195744
SQL Enterprise Manager only comes with full version of SQL Server 2000 not MSDE.\n\nWeb based client - http://www.aspenterprisemanager.com/\n\nSQL Server Management Studio Express (SQL Server 2005) - http://www.microsoft.com/downloads/details.aspx?familyid=57856cdd-da9b-4ad0-9a8a-f193ae8410ad&displaylang=en
888756
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'