• Alternatives to cursors in SQL Server

    What are the alternatives to cursors? I can’t find any other method to move through record sets one at a time.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Issues with multiple DBs on one SQL Server instance?

    We have multiple SQL Server instances running on different servers in our organization, each requiring maintenance and backup. We have a vendor backing up these instances that charges on a per instance basis. I am doing a review to see if I can bring all those SQL Server DBs onto just one instance...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to compare fingerprint images in VB.NET

    i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.

    Dlfshweta5 pointsBadges:
  • DR/HA questions with SQL Server design

    Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DB mirroring with SQL Server 2005: Standard vs. Enterprise

    On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Substring Query SQL

    Hi All, I'm trying to build a query to join names in one table to abbreviated names in another table. So for example I have - Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the amount of Har names with the total...

    Smillsie20 pointsBadges:
  • Problems installing BCM for Outlook 2007

    I have purchased 9 seats though volume liscensing for Outlook 2007 with BCM.  The first 7 installs with out a problem.  The last 2 have thrown this error: Setup failed to install the required component Microsoft SQL Server 2005 Express (MSSMLBIZ). Business Contact Manager for Outlook 2007 cannot...

    Flame14,925 pointsBadges:
  • Sudden SQL errors keep Business Contact Manager from loadingHELP – Sudden SQL errors keep Business Contact Manager from loading

    Dessteele5 pointsBadges:
  • HOW TO CONNECT VS2005 TO SQL2005

    Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005    

    Sql2055 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:
  • SQL SERVER 2005 XML LOAD

    Hi EVeryone, Having a text file (in which resides the xml data and the xml schema definition),i have to create the afilliate tables to that XML(+XSD).The problem is the XSD is variable , and can not be hardcoded, i mean that XSD could vary from file to file... Is there a way to create automatically...

    Adysann5 pointsBadges:
  • Microsoft SQL Server certification – Exams 70-433

    Anyone can help me to get microsoft dumps for 70-433 exam? I am looking for this for a long time. If you guys found out, please mail to the below email : raj_pandianin@yahoo.com Thanks in ADVANCE

    RajPandian5 pointsBadges:
  • Date calculation incorrect in sql when +1 month entered

    Date calculation incorrect in sql when 1 month entered. If we add 1 month to 28-Feb then it shows 28-Mar instead of 31-Mar. Similarly if I add 1 month to 30-Nov it should show 31-Dec instead of 30-Dec. SQL command run is SELECT CCDATE + 1 MONTHS FROM COGNOSMIS/xyzPF WHERE CCDATE = '2010-02-28'

    JohnsonMumbai1,160 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • attach a new mdf and ldf files in sql server 2005 enterprise

    i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

    Itdonsavi30 pointsBadges:
  • User defined function for an expression

    I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008?  If so, how?  Thanks.

    TheRicker5 pointsBadges:
  • Problems with SQL communications over ISDN

    We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a...

    McRick5 pointsBadges:
  • How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • Local clients loose connection to local SQL Server when system network drops connection to HQ.

    When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought...

    TomHelm5 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