you can use xslt to transform your file into xml if you have fixed width columns. I use a front end app to do this. you can then import the file into sql

or...

http://msdn2.microsoft.com/En-US/library/aa337169.aspx

no, you will have to develop one for your self

RDO!  I forgot to add that your system is due for an upgrade.

RDO uses ODBC underneath so it should be possible to connect to sql 2005 with out changing much. create a system dsn that points to your sql 2005 server and use...

Matt,

it was someone spamming the forums with stuff totally unrelated to sql. maybe i should have quoted it

what happens if you don't include the double qoutes on your send thingy i.e.

SET  @proc = 'Send(' + @post + ')'

with an encoded @post as per my earlier example

mmm.. but we still have a lot of boxes on sql 2000

parse you @post and replace the double quotes with "

e.g.

DECLARE @var VARCHAR(50)

SET

@var

yes you can use table variables

DECLARE

@totalCount INT

DECLARE @tracker INT

DECLARE @Dkey AS datatype

SET

@tracker

the request came from high up, then tell them that this is a NO NO.

replicate the live on to Test and have the developers doing their thing there.

on which platform are we talking abt

i.e. development, test, production

my matrix for dev security would be

dev - full access

test - partial access

production - no access

cheers mate, the more knowledge u have the better for us

i am assuming that you created the datareader user for use in an application, if that is the case then in sql why do you want to view the stored...

i second Jeff's idea of using bcp or osql.

or if you want you can just develop a .net app