• Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN20008,500 pointsBadges:
  • SSIS, CLR, sp_OAMethod or another method to call web method

    I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a...

    ToddN20008,500 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN20008,500 pointsBadges:
  • Assign a serial number for each group

    I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems...

    Tharanya5 pointsBadges:
  • sql query of datediff between two columns

    i am having one table in sql 2000 that is called (personal), in that table i am having two columns name date of birth(dob) and date of enrollment(doe). i want to write a query to get the actual difference between two date i.e like 10 years 03 months 22 days. Can somebody help me out of this. An...

    vinayak44910 pointsBadges:
  • Updating SQL 2000 Data

    Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle to a...

    KH155 pointsBadges:
  • SQL Server Logins

    Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example    user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password. I...

    KH155 pointsBadges:
  • SQL Recovery from MDF and LDF – Missing Data

    Where to start ... On 6/2 we lost a major system that we found relies on a database that hasn't been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on the MDF and LDF files for this...

    SixCs5 pointsBadges:
  • SQL 2000 database recovery

    Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf...

    Charliev5 pointsBadges:
  • View in SQL 2000

    How to create view with parameter? Thanks and regards.

    Pkaur65 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    i want to make the sql connection with vb6,how to open the connection in sql

    Vishalngp15 pointsBadges:
  • SQL 2000 view debug help

    I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                      ...

    DavidHa!!110 pointsBadges:
  • SQL Server 2000 Log Shipping

    Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run ...

    KH155 pointsBadges:
  • Best tool for SQL Server 2000 – like golden is for oracle

    what db tools are there to query ms sqlserver 2000 database? i'm used to using benthic's golden for oracle databases - and would like a similar tool to use with sqlserver databases.

    Angeliamcdaniel5 pointsBadges:
  • How can I use SQL codes in delphy7?

    I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+'0 ' FROM        edit.text2

    Ramin5 pointsBadges:
  • How to write text into word doc using SQL 2000 query analyzer

    how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

    Pkaur65 pointsBadges:
  • How to write text into textfile using SQL 2000

    can I use exec sp_OAMethod 'c:osqloutput.txt', 'WriteLine', Null, 'hello' to write something on file using sql2000

    Pkaur65 pointsBadges:
  • Process ID 174:102 owns resources that are blocking processes on Scheduler 2.

    Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the...

    Meken1abe5 pointsBadges:
  • Trouble installing SQL Server 2005

    I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

    Pmister5 pointsBadges:
  • Can I restore a SQL 2000 backup to a new SQL Server 2005?

    Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

    TeachMeIT975 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