quote:

---

.Parameters.Append = .CreateParameter("@targetURL", adVarChar, adParamOutput, 200)

---

adParamOutput is your OUTPUT variable defined. I see nothing wrong...

If MS states it requires 2 license then you will not find anyone who got permission. They are very strict about their eula's and do not stray unless you perchase...

Have you tried running by hand from the server to see if the error appears there. If not may be permission, if does then you should be able to get...

25million is not a lot of records. Usually standard is enough unless you will need specific things only Enterprise does which in you case may be using 3GB of ram...

In Visual C++ when you create a new project you have an option call SQL Extended Stored Procedure or something to that effect that will create you a sample dll...

Make it an IDENTITY field and it should work.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure but you might want to see if Philips makes a comparable drive and try that driver. Cannot guarantee it will work nor have I tried but Philips makes...

We do this on a few servers, started out as a test and found it gives an improvement on reads more so than writes. You should with proper planning of...

Sorry try this, sometimes it is hard to logically think about something when other things are going on but this should be it.

UPDATE Clients

SET Clients.StartDate = Employees.StartDate

FROM

Employees

WHERE

Clients.IDVal = Employees.IDVal AND

Clients.StartDate...

You can mix varible setting with select output at the same time.

You can

SELECT @var = colx FROM tblx

Or

SELECT colx FROM tblx

but not

SELECT colx, @var = colx FROM tblx

nor can you...

I have also had this problem with 7 when restoring from tape. Had to read the tape for verifitcation of what backups were on it I believe.

"Don't roll your eyes...

Try

ALTER TABLE tblName ALTER COLUMN Employee_No int identity(1,2) NOT NULL

BUt it will only effect data entered after that point the way expected. Also if you set the seed value to...

1st, you should be able to truncate and empty the logs to shrink them. However if using 7 they may not shrink all the way and you should look to...

This is an odd situations. Have any other procedures been affected? And can you explain what it does?

"Don't roll your eyes at me. I will tape them in place." (Teacher...

I agree with Brian and would add that adding memory to SQL does not always give a large performance gain as it depends on what the bottleneck is. However the...