SQL Server Tag Directory

Featured SQL Server Questions

  • Member relationship in DB2

    I would like to know the relationship of member in DB2 interms of  MSSQL table. I need the query to fetch member in SQL Server

    sbesuedbknk5 pointsBadges:
  • install a second instance of sql server 2005

    how do i install a second instance of sql server 2005 on the same server?

    Twkennis5 pointsBadges:
  • SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE344,715 pointsBadges:
  • How to Display Japanese character in Crystal Report 8.5

    Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character....

    Kaushalp50 pointsBadges:
  • Which config file does MySQL use?

    Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message:...

    jailall101735 pointsBadges:
  • SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases

    If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases' MDF and LDF files.

    MSSQLDBA5 pointsBadges:
  • how do I cause a field to be null, using DFU?

    how do I cause a field to be null, using DFU to update/insert a record?

    tegarvey35 pointsBadges:
  • Trigger Perormance Issues when Journalling Started

    I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files,...

    FrankWM110 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 pointsBadges:
  • ASP.net SQL Server Need Experienced Webdeveloper

    I have a website I need an experienced webdeveloper to help me get my website running again. Fired my Webmaster. Does anyone have this experience to help me? Pat

    CharlestonRealtor5 pointsBadges:
  • MSSQL 2008 sudden and drastical slow down – IT telephony

    Hi, I'm a newbie, greeting everybody from Hungary, and thanks for your time :) Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same...

    Sandy6015 pointsBadges:
  • Ageing Report T-SQL

    Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...

    Sanisto45 pointsBadges:
  • Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8

    I have Oracle 10g running on Solaris 8. I would like to do direct queries from this server to a table on a MySql 5.0 database residing on a Microsoft Server 2003. Are there step-by-step instructions around? ie. Drivers for both ends; admin/config on both ends, etc. Thanks.

    Jlowe5 pointsBadges:
  • conversion of oracle trigger to MS SQL

    how can i convert an oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • What wiki software do you recommend?

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

    Eric Hansen1,775 pointsBadges:
  • Advantages and disadvantages of MySQL 5.0

    Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

    Espada0075 pointsBadges:
  • SBS monitoring

    Hello We have a customer running SBS 2003 sp2. We can't access the monitoring and reporting through server manager. When Monitoring and Reporting is clicked it just displays a - The Webpage cannot be found HTTP 400 page and when Setup Monitoring and Reports is clicked an error box comes up reading:...

    Swandigital5 pointsBadges:
  • null v/s ” “(empty string) in Java

    what is the difference between null string and emty string(" " ) in java? String name; if(name == null || name == "") { } wat is the meaning of the abouve if statement?

    Prcvjr220 pointsBadges:
  • Get data from one MySQL datebase server to another in real time

    hi     I am useing mysql database, I want to create one more database which I want to get updated in real time from the remote mysql database server. kindly help me in this. Thanks    

    Chetanm145 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