I am always cautious to delete anything from the top. You delete the first line, the second line becomes the first line etc.

Addionally, why did the question say "remove

I have a laptop where I installed MDAC 2.8 last week. ADO folder contains files from Feb. 2003, C:\WINDOWS\dasetup.log (MDAC Setup Log File) says:

Ini Section: General

 : ProductName = Microsoft Data...

Charles,

Look under C:\Program Files\Common Files\System\ado

Mine DLL for Connection object is:

C:\Program Files\Common Files\System\ado\msado15.dll  

This is for MDAC 2.82.1830.0. I would test connecting using VBscript. Not from ASP, but just vbs...

EXAMPLE TO MY PREVOUS POST:

I added a field Total_qty as integer to Pubs.dbo.Sales and then run the following code:

Declare @run_total int

SELECT @run_total = 0

UPDATE sales

SET @run_total =total_qty=@run_total+qty

From sales

It updated...

There was a highly unusual solution in Chapter 12 "Transact-SQL Examples and Brainteasers" of Ron Soukup and Kalen Delaney book "Inside Microsoft SQL Server 7". There is an edition for...

What is your Edition: Standard will use 2 GB max anyway. Enterprise can use more.

Go to Management ->Current Activity window in Enterprise Manager and see in the Process Info what...

What are the error messages? Where: what statements, what objects?

Hi,

I am concerned a little bit with 2 things:

1. Higher level knowlege requirement is replaced by several more dedicated areas like Steve says "all the other SS acronyms...".  Managers and...

Hi

The article mentioned denying somethings like syscomments access to PUBLIC. Everyone is a member of Public, will SPs work after that?

Otherwise the article is very good. Chris even did...

Good Question!

Found an excellent article on the subject by Ken Henderson

Inside the SQL Server 2000 User Mode Scheduler

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/Sqldev_02252004.asp

Ken says: "When a client connects to SQL...

Hi,

I assume you are asking about adding Named Pipes to the list of the protocols available for SQL Server when installing SQL Server or using Server Network Utility and not...

We just had the article here on 10/31/2005 on the topic with good examples:

http://www.sqlservercentral.com/columnists/dasanka/callingcomfromtsql.asp

Calling COM From T-SQL

by Dinesh Asanka

I added it to my virtual briefcase

Graham,

The problem may be not with the image but what was installed on the image after. The server I mentioned was built (installed) not from the Image SW. I will...

Hi,

I did it using a temp table that contained the original fields plus a field that had a range as a string named AgeGroup. Then I just grouped by AgeGroup...

Hi,

I found a WSH (Windows Scripting Host) script that does import from csv file to Excel. You can modify the script if your text file is not csv (comma-separated). This...