Is the drive maybe full? Or maybe there is some corruption on the drive, run checkdsk against it by right clicking the drive, goto tools and pressing the Check Now...

Check the NIC input/output packets. May be high and thus packets are blocking or being lost so they have to retransmit. ALso, try pinging from that server and see what...

Check your transformation and the size and datatype associated with those fields. May have a wrong datatype or the length isn't long enough to pick up those pieces.

Unfortunately, no. The reason is there is not precise but approximate with Real and Float as stated in BOL so recovering the exact original number is impossible.

My only concern is that they could potentially have the same name and department.

Ex.

John A Smith IS

John D Smith IS

but you are only handling First and Last name. So you...

Drop and create are the only way without messing with the system tables. But then you have to redo permissions. Most folks just create a header in the SP and...

My suggestion is make sure like was said you have good indexes and have a good maintainence of the DB going on. However, wether or not you should archive is...

Still not uncommon but the only issue I ever saw was readability.

Consider

SET this = this + 1, @that = this + 1

as opposed to

SET @that = this = this...

Nope, didn't say you could blame for ID10T errors (). No offense to those who made this type of mistake.

quote:

---

we have a SQL 2000 Server installed on a win2k pc(dual p3 1.5GHz +1GB RAM ,RAID 5).we have s/w developed in VB6/Crystal...

McAffee and Norton Antivirus Corporate Edition (we use on some) both have been just fine. Usually we set them for a full scan once a week on Sunday nights where...

quote:

---

It's on both sides. There will always be bugs in code, so blaming MS for writing bad code isn't really right. Everyone...

Probably found a buffer overrun condition in the app and had to pull.

Bug must have been found or it wasn't supported yet. Saw this happen in...

On your laptop have you maybe setup a Name to IP address entry in the LMHOST file, HOST file, Client Network Utility, or maybe a WINSServer entry for the network...

First off in a trigger why are you referencing PMR instead of inserted? When you do an INSERT or UPDATE it will pass thru the inserted internal table that the...