• Creating clustered index on exiting table

    I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database's logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when...

    Senyeart5 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell470 pointsBadges:
  • How to Upload Image into SQL Server 2005

    Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.

    BrownAsakpa20 pointsBadges:
  • unable to connect sql server 2000 on network

    We have sql server 2000 instance on a machine say "comp1".The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the "comp1" via run and give password then i am able to connect through SSMS Can someone give a solution so that...

    Psingh1630 pointsBadges:
  • Order by clause in SQL Server subqueries

    why the "order by" clause in sub queries must be associated with "top" clause in sql server..??

    Karthikharve5 pointsBadges:
  • How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?

    I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can't seem to get it right.  I want to retrieve the previous day's date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD.  When the current date is a Monday, I need to...

    Kathyb6245 pointsBadges:
  • AMD Sempron

    Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?

    Squibc40 pointsBadges:
  • Code Impact Analysis Tool

    Hi, Need a tool to do the impact analysis of .net/java/com code files and should produce the matched code/classes/objects/methods/references etc. for a particular database hit (stored-procedure or select/insert/update query)

    Kvrao5 pointsBadges:
  • Store and retrieve data in UTF-8 on SQL Server 2005

    (Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table...

    MrGeorge65 pointsBadges:
  • SQL Update not Working using two files

    I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT...

    dab77780 pointsBadges:
  • update the tables in to two server using a single ssis package

    i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error.  Executed as user: RICRDWDEVSYSTEM....

    Knowledgesharing5 pointsBadges:
  • New Contest: ASK, Answer and win some Amazon.com gift cards

    It's that time again -- a chance to win an Amazon.com gift certificate based on your activity in the IT Knowledge Exchange community! Remember: the more you ask, answer and discuss questions, the more Knowledge Points you will earn. (Only valid questions, answers and discussions will be counted...

    ITKE346,285 pointsBadges:
  • Community Announcement: Cash in your Knowledge Points for an Amazon gift card

    Members who have earned over 1,000 Knowledge Points in the community by December 15th have the opportunity to cash in their points for Amazon gift cards -- just e-mail us at contactus -AT- itknowledgeexchange.com with your handle when you choose to cash out. You can also post here in the discussion...

    ITKE346,285 pointsBadges:
  • Data base with Visual C++

    I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don't know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot

    Makee15 pointsBadges:
  • VPN Connectivity Issue with SQL Database

    My Issue is with a VPN Connection. I have an SQL Data Base set up on a Windows XP Pro machine. We are using a Clear Motorola WFIMAX Modem and an AirPort Extreme Router. I have port 1723 Forwarded and Out going and Incoming Connections created on both Server and Client.  The Server has a version of...

    greatjubee165 pointsBadges:
  • VPN Hollander Powerlink Server issues

    I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having trouble making the...

    greatjubee165 pointsBadges:
  • Free IT Book: Building Applications in the Cloud

    This week's free IT book is Christopher Moyer's Building Applications in the Cloud: Concepts, Patterns, and Projects. "Don't just migrate the cloud: Use cloud architectural patterns that deliver superior performance, scalability, and availability" with this great resource. Answer one of five...

    MelanieYarbrough6,345 pointsBadges:
  • Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan

    Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by.  The computed column is not persisted and there is a non-cluster index on it (the only index on the...

    Steve005 pointsBadges:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • VS 2005 SQL Reports – Need to convert 5 character string to datatime

    Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called 'Duration'. The datatype is char(5) e.g. "00:30" to represent a half hour. I suppose I need to change the datatype to sum it but can't figure out how to. What would my query...

    Haxatron15 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