How can I export a SQL 2000 database to SQL 2005 without the SQL Management studio?
536173
In order to manage a MS SQL 2005 DB you need SQL Management studio, that includes adding/importing data and/or DB objects to an 05 instance.\n\nOne quickie you can try is to detach/and attach the database.  To do this, go into Enterprise Manager, right click on the DB and select "All tasks > Detach ..."  this will disconnect the database from the server.  Now, go into the file system, create a copy of the MDF and LDF files.  Rename both of those files to the new database name (while maintaining the LDF/MDF extensions), and copy the new files to the 05 server's Mssql.x directory (where "x" is the instance number you are attaching to).  Go into the Enterprise Manager and right click on the database server and select the "All Tasks > Attach ..." option.  Browse to the file on the 05 system and select it.  \n\nIf that doesn't work, you're SOL.
898845
Just download and install 'konvertor'.then u can easyly change cobol database in to dbf file.
254436
write a script in sql*plus:\n\nSET echo OFF\nSET verify OFF\nSET feedback OFF\nSET pagesize 0\nSET linesize 180\n\nspool DROP.SQL\n\nSELECT 'drop table &&1' || '.' || table_name || 'CASCADE CONSTRAINTS;'\nFROM ALL_TABLES\nWHERE owner = '&&1';\nspool OFF;\n\nSave this as create_drop.sql, then run with\n\nSQL>@@create_drop USER\n\nwhere USER is the user you want to drop, then run drop.sql\n\nSQL>@@drop\n\nGOOD LUCK
135369
http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx
514769
You need to download MS SQL Server 2000 or 2005 JDBC driver first. This driver doesn't need ODBC at all.\n\nexcerpt from documentation:\n\nOnce the driver is installed, you can connect from your application to your database in two ways: with a connection URL through the JDBC driver manager, or with a JNDI data source. This quick start explains how to establish your database connection using a connection URL. See "Using the SQL Server 2000 Driver for JDBC" for details on using data sources. \n\nYou can connect through the JDBC driver manager with the method DriverManager.getConnection. This method uses a string containing a URL. Use the following steps to load the driver from your JDBC application. \n\n1. Setting the Classpath \nThe SQL Server 2000 Driver for JDBC needs to be defined in your CLASSPATH variable. The CLASSPATH is the search string that your Java Virtual Machine (JVM) uses to locate the JDBC drivers on your computer. If the drivers are not on your CLASSPATH, you receive the error "class not found" when trying to load the driver. Set your system CLASSPATH to include the following entries, where install_dir is the path to your SQL Server 2000 Driver for JDBC installation directory: \n\ninstall_dir/lib/msbase.jar  \ninstall_dir/lib/msutil.jar  \ninstall_dir/lib/mssqlserver.jar \n\nWindows Example \nCLASSPATH=.;c:&#92;Microsoft SQL Server 2000 Driver for JDBC&#92;lib&#92;msbase.jar;c:&#92;Microsoft SQL Server 2000 Driver for JDBC&#92;lib&#92;msutil.jar;c:&#92;Microsoft SQL Server 2000 Driver for JDBC \n&#92;lib&#92;mssqlserver.jar \n\nUNIX Example \nCLASSPATH=.;/home/user1/mssqlserver2000jdbc/lib/msbase.jar;/home/user1/mssqlserver2000jdbc/lib/msutil.jar;/home/user1/mssqlserver2000jdbc/lib/mssqlserver.jar \n\n2. Registering the Driver \nRegistering the driver tells the JDBC driver manager which driver to load. When loading a driver using class.forName(), you must specify the name of the driver: \n\ncom.microsoft.jdbc.sqlserver.SQLServerDriver \n\nFor example: \n\nClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  \n\n3. Passing the Connection URL \nAfter registering the driver, you must pass your database connection information in the form of a connection URL. The following is a template URL for the SQL Server 2000 Driver for JDBC. Substitute the values specific to your database. (For instructions on connecting to named instances, see "Connecting to Named Instances" in the SQL Server 2000 Driver for JDBC topic.) \n\njdbc:microsoft:sqlserver://server_name:1433  \n\nFor example, to specify a connection URL that includes the user ID "username" and the password "secret": \n\nConnection conn = DriverManager.getConnection \n  ("jdbc:microsoft:sqlserver://server1:1433","username","secret");  \n\nNOTES: \n\nThe server_name is an IP address or a host name, assuming that your network resolves host names to IP addresses. You can test this by using the ping command to access the host name and verifying that you receive a reply with the correct IP address. \n\nThe numeric value after the server name is the port number on which the database is listening. The values listed here are sample defaults. You should determine the port number that your database is using and substitute that value. \n\nYou can find the complete list of Connection URL parameters in "Connection String Properties" for the SQL Server 2000 Driver for JDBC.
62810
You can't normally do it as a database file can't be changed into an executable file. You could write macros or program some Visual Basic classes and forms to have the database file contain an independent interface and save that as an executable.
430792
As with upgrading any database - you need to be concerned about the applications that are tied to it.  If you have and customized applications, then there will likely be some development costs to update the applications (database connectivity).  If you use MS Access to perform any administration - it's not possible to create a Access project (.adp file) connected to SQL Server 2005 just yet.  Other compatibility issues would need to be evaluated such as reports (like Crystal reports).  These may also require redevelopment to change over to the new server settings.  As far as data conversion - there are no issues that I've seen yet - but that is influenced by database architecture.  With sufficient planning and identifying all the various affected applications - you shouldn't really experience too much of a problem.
264171
Go to ADD/Remove programs, then try to see if it's there. IT should be Microsoft SQL Server.
824619
You need Windows 2000 or XP
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
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.
1073394
You can migrate to SQL 2000 or 2005. You can even start using Oracle, as a vamp yahoo user told you to. But the question is, do you really need to migrate?\n\nThe locking/inability problems are solved in the Access Startup Menu, where you can set things like refresh time interval between a change in a record made by a user and the time need to the change to be seen across all access database users. Have you explored all the Access database features?\n\nSpeaking of my experience, I have a small  Access database with about 20 000 entries, and no such problems are happening with me.
954519
You will have to save those in a DataBase Management System like SQL Server 2000.
1164930
Go to enterprise, and click on the database in which you want and right click on stored procedures and create new...\nIs that what u want?
1081549
Hey try this you will find the answer yourself \n\nhttp://www.microsoft.com/technet/prodtechnol/sql/2005/UsingRSwithSAPNetWeaver.mspx
473727
sql> alter tablespace tbs1 add datafile '/../../datafile4.dbf' size 400m autoextend on next 10m maxsize 600m; \n\nhope it helps
842942
Here's a discussion that might interest you\nhttp://forums.techguy.org/business-applications/491904-convert-wdb-xls.html\n\n///