• Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when i enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell465 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:
  • Query Manager Error

    Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG("MISC" "CODE"), 0008.00 &MISC LEN(4,0) COLHDG("SHARED CONTAINER" "CODE") NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL...

    a1maida150 pointsBadges:
  • Replicating a partitioned table to a secondary server

    I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • ADO not receiving errors raised in sub procedure

    Hi, I'v known for a while that ado has it's limits when it comes to dealing with errors... but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that if the sub...

    Palloquin95 pointsBadges:
  • Log of stored procedures run on my SQL 2005 box.

    How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

    Karl Gechlik9,860 pointsBadges:
  • SQL Express 2005 query times lagging

    I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same...

    Reza838325 pointsBadges:
  • SQL 2005 keeps rebooting

    My SQL 2005 server keeps rebooting. I can not figure out why. I get an NT SUbsystem message and then a 30 second countdown. This happens 20-40 times in a day. How can I fix it? I can not even run a virus scan to completion. Windows server 2008 SQL 2005. McAfee 8.7.1.

    Troubleshooter24755 pointsBadges:
  • SQL Server 2005 database design

    What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

    Shamu75 pointsBadges:
  • Getting password when we know Product Code and Serial in Pl/SQL Developer

    Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

    PSRDOTCOM5 pointsBadges:
  • When creating a web application in Sharepoint 2007, where is the data stored?

    hello guys :) when I create a web application on sharepoint 2007...where does t he data and documents that am uploading be saved?? in that path that I have set ?? or on SQL Server that I have installed on C: drive thank u in advance

    IT19875 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:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 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:
  • How do I use primary keys in SQL server?

    I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i...

    Shamu75 pointsBadges:
  • How many processors can SQL Server 2008 R2 support?

    How many processors can SQL Server 2008 R2 support?

    ITKE62,205 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:
  • Upgrading from SQL 2000 to SQL 2005

    Will you need to purchase a new server to upgrade SQL 2005?

    Noles15 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 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