• Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET

    To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft's Senior Technical Product Manager, Brjann Brekkan, on July 20 from...

    ITKE346,360 pointsBadges:
  • Web based application not uploaded ON SERVER sometimes

    We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update...

    SJFIL5 pointsBadges:
  • Maximum memory on a 64-bit operating system?

    I need to install a new SQL server and we are buying a 64-bit OS. What's the maximum amount of memory that the operating system can hold/support/make use of?

    ITKE346,360 pointsBadges:
  • SQL server SP3

    Security Update for SQL Server 2005 Service Pack 3 (KB970892) .. i cant get this update to work on my comp..soemthing about hotfix.exe error

    Jimk5 pointsBadges:
  • How do I use DateDiff in cobol using SELECT statement?

    how to use DateDiff in cobol using SELECT satement.

    Ije35 pointsBadges:
  • Join for merging records

    I'm trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep those records that were matched...

    Eabouzeid175 pointsBadges:
  • Sponsor Post: Secure End Point Live Expert Chat – Tomorrow @ 11am ET

    Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the...

    ITKE346,360 pointsBadges:
  • How to create date in SQL Server 2000

    i create 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:
  • Sponsor Post: Cloud Migration Pros and Cons Live Chat Today

    Today's live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data...

    EmNichs3,250 pointsBadges:
  • Mounting Tape on Tape Drive using BRMS

    Hi, We have BRMS installed on AS400 V5R4.The Backup and Restore are done manually.Once the tapes are ordered the operator puts it in the tape library.Can anyone please let me know how I mount the tape on the tape drive remotely. As an example,I am pasting below the 'Work with media Library Media '...

    Hugheswilliams345 pointsBadges:
  • Sponsor Post: Join Us for Endpoint Security and Identity Access Management Live Chats with Microsoft

    Today’s workforce faces a constantly evolving landscape of threats to information and infrastructure—even regulatory compliance. Endpoints are exposed to attacks both inside and outside the corporate firewall, resulting in lost productivity and real financial losses worldwide.  Join us this...

    EmNichs3,250 pointsBadges:
  • How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • I’m interested in creating a web form that will deposit information into a SQL Server database.

    I'm interested in creating a web form that will deposit information into a SQL Server database. What's the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

    Eabouzeid175 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • ORACLE-TRIGGERS

    Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time)...

    RizwanSharief30 pointsBadges:
  • clarification of the terms FRS vs SRS

    I'm often confuse with the term FRS and SRS - are there the same or if there's a diiference, can u please highlight what are the diffrences? Do we have to have both for software development projects or either one is good enough?

    Rohaz5 pointsBadges:
  • Lotus Notes to SQL Server 2005 via linked server

    I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB...

    Awaller5 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • Trimming Values with SQL Server Express 2005

    I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn't work for me. I can't use LEFT or RIGHT before the column because the column length is variable. I...

    Eabouzeid175 pointsBadges:
  • Insert and update DB2 from SQL Server 2000 using OLEDB

    I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but...

    Sandy555 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