• Importing large sets of Excel 2000 data to SQL database

    I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

    ITKE56,475 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • ASP Web page database?

    I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it's good still with access. (I Know basically  "everything" is SQL but please give me a good...

    Eddy20 pointsBadges:
  • Error when translating execute immediate from Oracle to SQL

    SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement,...

    Ariel5 pointsBadges:
  • Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Keck5 pointsBadges:
  • Exclude Login from SQL Audit Trace

    I'm working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I'm using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login...

    VelameLaCosa110 pointsBadges:
  • dblookupcombobox has a null row

    Hello I'm Arnika. I have a question with dblookupcombobox. I have a program that hase a database I wrote.all things that I want it has,except when I open dblookupcombobox it must be have a row whit null value that when user wants to click nothing he can, but here there is'nt.

    Arnika5 pointsBadges:
  • Crystal Report Not Coming on Screen

    I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.

    ManishPatelRaymond5 pointsBadges:
  • Network documentation/Diagram

    I am curious as to how others are documenting their network; both visually and configurations. I am familiar with MS Visio for drawing the network. Are there better options? What about documenting all equiptment? IP addresses? Settings? Changes? I am just using MS Excel/word to create all sorts of...

    Skepticals0 pointsBadges:
  • Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Crystal Reports – Rounding Nearest 1/8 Mile

    I'm trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?

    Sarahtaj5 pointsBadges:
  • How to roll back service pack in SQL server 2005

    HOW TO ROLL  BACK SERVICE PACK IN SQL SERVER  2005 

    Venkatdbait35 pointsBadges:
  • Looking for Backup solution for VMWare environment

    We've started adding VMWare servers to our data center, and we need a backup solution that works. We'll have a mix of ESX4.0 and ESX3.5 hosts along with vCenter 4.0. Host will have Windows 2003, Windows 2008, RedHat 4.x and 5.x. Some hosts will have MS SQL 2005 and Oracle DB. We have TSM deployed...

    ITKE56,475 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 pointsBadges:
  • Automatic backups for production databases without taking SQL server offline

    I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

    ITKE56,475 pointsBadges:
  • How to migrate a database from SQL Server 2000 to SQL Server 2005

    Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?

    SQL Server Ask the Experts2,585 pointsBadges:
  • File backups for Windows server 2003

    What files should we be backing up across all of our windows 2003 servers? Is there a list of what should be backed up to restore the entire system if a disaster occurs?

    ITKE56,475 pointsBadges:
  • SQL Server 2005 Performance

    1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?

    Rick Martinez585 pointsBadges:
  • Error when trying to restore SQL Server database backup file

    We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we have no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database Log File sql server 2005

    We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the application...

    Rick Martinez585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following