• Earning badges pays off – TODAY!

    We recently announced that the IT Knowledge Exchange Badge Program is beginning its reward phase, meaning that you can earn great prizes just for doing what you've already been doing in the community! Initially we planned to send out a first-time prize for everyone who has been active in the past...

    MelanieYarbrough6,345 pointsBadges:
  • Create linked server from sql 2000 to sql 2005

    Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000   Thanks in Advance

    ManosZim30 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • SQL Server 2008 Insert Into vs Insert Statement Recompile

    I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using "INSERT INTO" but when I use "INSERT" only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from...

    Rick Martinez585 pointsBadges:
  • Declaring the same file twice with two OPENID and reading the same file twice in CL Program

     Is it posssible read a db file while declaring twice with openID     and reading the same file twice

    Chraghuveer25 pointsBadges:
  • Trigger or Stored for lock and unlock database for 15 minute

    Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password  on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive='false'. So can u please help me to give code...

    Programmer0075 pointsBadges:
  • Can two separate cursors update the same SQL table when executed together?

    I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I'll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following the...

    MrRussellWebb5 pointsBadges:
  • How to Edit SQL 2008 RDLs to run on a SQL 2005 SSRS Server?

    Has anyone figured out how to edit a SQL 2008 RDL to run on SQL 2005 SSRS server?  Mr. Denny (see link below) believes it can be done. http://itknowledgeexchange.techtarget.com/sql-server/you-cant-deploy-a-sql-2008-ssrs-report-to-a-sql-2005-ssrs-server/

    Myrmidon105 pointsBadges:
  • What is Broker EventHandler Wait Event?

    I keep seeing this wait stat "Broker_EventHandler" in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?

    Rick Martinez585 pointsBadges:
  • Should I enable service broker on SQL Server 2008?

    I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

    Rick Martinez585 pointsBadges:
  • Updating a SQL Server record in a large table

    We are using SQL Server 2005 and I have an SQL DB on it with 270,876 records in it. There is a PRIMARY KEY defined on the first field called RecordID (Identity field). The index name is PK_ListOfFiles_as_of_3-7-2011. If I execute the following command from the Query Window on the server it takes a...

    BDW65 pointsBadges:
  • I want to delete records from a PF outside a PGM

    I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I'm not sure how to pass variable to either idea.

    TIB5 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • Microsoft Sequel Server 2005 VSS backup

    What's seems to have happened is that the SQLVDI.dll files in the 2 directories: C:\Program Files (x86)\Microsoft SQL Server\80\COM C:\Program Files\Microsoft SQL Server\80\COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The...

    LeonT140 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,025 pointsBadges:
  • Native SQL

    I want to insert picture into oracle database from sap usinf native sql.I use string field but ı take conversion error?How can I insert ?

    61711985 pointsBadges:
  • How to install a named instance in SQL Server 2005 without affecting the existing instance

    I have SQL Server 2005 installed and the default instance running. I want to install an additional named instance. How should I go about creating the new instance, without affecting the existing one?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to determine proper max memory setting

    How do I determine the proper max memory setting for our system? We have Windows server 2003 R2 entreprise ed, sp2. It is 32 bit. There is 8.00 Gb of ram. We have just upgraded to SQL Server 2008 sp1, enterprise ed. Now we're having some memory problems. Thanks very much for any help with this.

    denise7525 pointsBadges:
  • Multi Location Software in VB.Net

    I want to create multi location software in VB.net .Basically, my scenario is like ………..software should work for 9 branches. One main branch where SQL server is located and rest all sites are remote site where software installed and directly connected to central SQL server. Please give me...

    Servernetwrkdbase60 pointsBadges:
  • Get your free IT book: The Rails 3 Way

    Here's your chance to win "The Bible for Ruby on Rails Application Development"! There are two ways to get your copy of the book that "strips complexity from the development process," answer one of four questions and post the link to your answer in the discussion section below. Another way to enter...

    MelanieYarbrough6,345 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