M$ would like for you to use SMO. Its the way they are going so you might as well have your foot into it already. Besides SMO works with both...

I would have liked to get my hands on it but my team size does not warrant giving M$ more $

Hi,

can you put up a column definition of the source and target columns. and sorry for my being thick but what is it really you want to do?

i replied in your other post

whoa dbase III,incredible

you can import the *.dbf file into excel or access and then use the drivers on sql 2005.i think that is the fastest way unfortunately.

yes its possible. sending mail to lotus notes is no different from sending mail to exchange/outlook

that's the same thing i used on 2000

no luck for me. you myt have to use a the printing functionality in vs with vb or c#

DECLARE @idoc int

DECLARE @doc varchar (1000)

SET @doc =''

--Create an internal representation of the XML document

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

-- Execute a SELECT statement that uses the OPENXML rowset provider

SELECT *

FROM...

i am a developer and i have been using ms since i laid my eyes on it. my dba has no problem with me using it.

the issue to do with...

using some of the code posted by william you can put the code in a table valued function and then use that in your stored proc

-------------

CREATE FUNCTION Split (@input varchar(1000))

RETURNS...

jules that i agree with you.

did you create the split function, that myt be the coz of the error

goto this url http://weblogs.asp.net/pleloup/archive/2003/04/14/5569.aspx

the solutions we have all given are with in the context of the little info that we know of the problem.as to the use of either method it probably boils...

ok, i will try it. hopefully i will be able to have something