• Bundling SQL Express Edition

    Is it free to Bundle the SQL Express Edition within our Product or along with our Product CD/DVD?

    Rajeshbs45 pointsBadges:
  • How to check browser activity?

    Hi, I'm working a project, in that I'm storing login, logout time. What if i don't click logout button and close my browser, or somehow my system shutdown.I cannot store the logout time, so that my program will be in error state. Tell me how to get the logout time when my programmer didn't click...

    Karthij5 pointsBadges:
  • Inbound and outbound interfaces in SAP

    I have been asked to find out the list of Inbound and Outbound interfaces in SAP and their structures. Basically we will try to write a module which can send data in the SAP required format and also receive the data from the SAP in their format and load it in our SQL Server table. Is there a way I...

    rajivk5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • How to upload data from Excel into SQL Server 2005

    Hi, Please tell me, how can I upload data from excel into SQL 2005 Thanks & regards, Ambrish Srivastav

    Ambrish 82310 pointsBadges:
  • How can we reindex a SQL Server 2000 database?

    We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Clustering in SQL Server 2005/Windows Server 2003

    Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server 2005 ensure columns sum within a table

    How can I ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

    Timmytong5 pointsBadges:
  • How to implement an Entity Relationship Diagram into a working database?

    I need to implement a ER diagram into a working database. I'm hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement "Is a" relationhips, how to implement...

    Obhasha0795 pointsBadges:
  • External Table / SQL Loader

    Hi, We are using this new SQL loader for a month now and it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge...

    External10 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 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:
  • How to create date in SQL Server 2000

    I created a table with attribute date and i want to store date as "Date-Month-year". What procedure to create a date and how we able to insert the required format by using SQL Server 2000?

    Malikjavediqbal30 pointsBadges:
  • Implementing a test system with SQL Server log files

    We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 pointsBadges:
  • Column extention in SQL

    Hi I want to expand the number of columns that SQL would permit me to create. How do I start? any suggestions? example: 1032 maximum column limit I want in the area of upper 5000 range for a table. Someone help. Thanks!

    Ctc12320 pointsBadges:
  • SQL Server 7 database restore

    I'm working with SQL Server 7 and I made a backup from a Database and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do?

    Claudiofuentes15 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 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:
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on SQL Server.

    Wandasoozq5 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