i am trying to emulate the options that are available in 2000QA for 2005 ssms.

Tim was close - a search revealed this link:

http://www.internet.com/icom_cgi/print/print.cgi?url=http://www.15seconds.com/issue/050106.htm

i need to resolve permissions issues when i try doing this but it shows promise

good article but i think there is a typo in one example (it returns @sum , but should return @answer) i rarely use return except for maybe a 0 or...

The Northwind database should come with all versions of Access as well as sql server - although it might not install by default.

If you don’t have a nwind.mdb or...

i made a small correction to the DO loop:

Do While Not rs.EOF

For i = 0 To rs.fields.Count - 1

...

you can create an excel file and export to that from an ActiveX task, and it should overcome the field length issue you were having.

a few other things you...

'i am making a few assumptions about what you are doing here:

'here is what i would suggest (and should work with no problems when outputting to a text file):

'you can...

We use sps for ALL table inserts and updates (and deletes). We also use NT Auth and store the NT account and domain name in a 'Users' table along with...