quote:

---

Jonathan - Why is it that the insert of zero rows would take less time than the exists? SQL has to...

http://www.sql-server-performance.com/sql_server_log_shipping.asp

--Jonathan

You don't have to write the stored procedures, as they already exist. Check out sp_adduser and sp_password.

--Jonathan

Just a guess, but try listing the actual columns rather than using the * expression. Perhaps OLE DB will not expand the select list in this circumstance.

--Jonathan

quote:

---

It is running under the system account. What is the minimum level of privileges that the domain account can be run under?...

The insertion of zero rows probably takes less processing time than would any test to determine if the insert will have zero rows.

--Jonathan

That has a problem if your list contains just one entry. How about something like this:

CREATE FUNCTION dbo.f_SplitInts(@List varchar(8000), @Sep char)

RETURNS @t TABLE(Piece int) BEGIN

DECLARE...

From your use of ampersands I infer that this is Visual Basic. Create a function in your project to replace the single quotes with double quotes when using values...

quote:

---

Hi Bill,

Yes I looked there and have done backups.. both full and log backup.. But the actual data file stays the same...

quote:

---

I've done some more testing and discovered that the problem is definitely with SMP. I added option maxdop 1 after the...

quote:

---

Thanks.

I've read about User or Device CALS, but am still not 100% clear on if they are reserved/assigened to specific users or...

quote:

---

If you are using smalldatetime you could only use 20790606. What are the chances that they will be using...

Sounds like you got sold something...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16577&FORUM_ID=5&CAT_ID=1

--Jonathan

(Assuming the answer to Mark's execllent question is negative.)

As you have determined that the problem is with the server and not any particular database, it's either a hardware problem or...

quote:

---

uff, and I thought while reading Patricks' post, the programmers of our human resources system ?!? are completely wrong using a termination...