SQL Server Tag Directory

Browse Alphabetically:

Featured SQL Server Questions

  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Forms application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Running a disk check on Windows 2000 Pro

    When running a disk check on a Windows 2000 professional computer it creates files in the root of the C: drive. What are these files and can they be used to restore data?

    NewnanIT1,110 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • SQL Server Disk Alignment

    What size should I set the Starting Partition Offset on the disks when running SQL Server 2005 32-bit enterprise edition, should it be 1024KB or 64KB?

    Rick Martinez585 pointsBadges:
  • Limit SQL Admin Access to a single DB

    I need to set up admin access on a MS SQL server but limit the access to a particular DB.

    Cybx10 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...

    ITKE352,415 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in Microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • Field data in Footer SSRS 2005

    I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.

    Rob122810 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:
  • What is SQL Azure?

    Sorry for this dummy question, what is SQL Azure?

    ITKE352,415 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL 2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when I enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Send a email with attachment?

    How do I send a email with attachment in a SQL script using SQL 2000?

    Mistp00120 pointsBadges:
  • Failure to register an SPN in SQL Server

    Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098,...

    Tiz5 pointsBadges:
  • Advantages and disadvantages of certain SQL commands

    Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    I want to make the SQL connection with VB 6. How do I open the connection in SQL?

    Vishalngp15 pointsBadges:
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 pointsBadges:
  • How to install SQL 2005

    Hey what was minimum hardware required for SQL 2005?

    Roony5 pointsBadges:

Browse Alphabetically:

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