How would I transfer a database from Microsoft Access to SQL Server 2000?
Hi friends, I am using d2k as front end and for back end. I want to use my SQL Server 2000 data. How can I connect it? Thanks!
Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?
Well I'm working in MNC as a network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to separate database server & application if any body has a plan or he/she know how move...
Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter. 2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ (head quarter) - HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server 03 +...
I am sure this is simple, I just need to know what the expressions is if you have fields in lets say a report that are : some empty and some with information...such as Telephone Field. I want to show only those "telephone" that are actually in the field. Example John Doe 555-555-5555 430 Cow Street...
Hi, Right now my database server running on SQL Server 2000 & my application is also running from the same server for heavy load on server. I'm going to separate my database server & application server. I need help because my database size is all most 3 GB. Also I need to upgrade my...
We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?
First off thanks for reading, I am new to SQL (SQL Server 2000). Unfortunately I just had the array my Data was on and my tape backup get toasted, I was able to do some data recovery on the remaining drives and pull off about 15 different .bak files for the database I need to restore....
Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run? The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used. I know I could do my own thing and stuff, but I'd...
Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.
Hello all, I have developed a small application in VB.NET 2005 with SQL Server 2000. The application is running in a machine is okay. But when I'm going to access the application through another machine in the network is not running. How can I solve this problem please help? Thanks!
Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.
How can I restore a SQL database with an .mdf file?
We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?
We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?
I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it
My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.
How can I add a system tray icon for SQL 2008 just like SQL 2000?
How do I find out the row_number in SQL 2000 like using row_number() function in SQL 2005?