If I have to choose 2, I would go with Fast, Cheap, and *Mostly* adequate.

I am looking for a more "permanent" solution, but thanks for the quick reply.

I found sp_Help <tablename> that gives me some of the info needed, but I would like a...

I am not exactly doing a "BULK" insert.  It is just an "Insert Into" command.

From what I see in the documentation, I can't do a Bulk Insert because I am not...

Try searching for Char(10) <Line Feed> and/or Char(13) <Carriage Return>.

Use Left(Address, CharIndex(Address, Char(10))) for the first section.

Frank,

This works awesome for the Stored Procedures.  Thanks!

Is there a table for the User defined Functions like "INFORMATION_SCHEMA.ROUTINES"?

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

If you don't have Stored Procedures that exceed 4,000 characters, this will...

I had found that link by searching through the archives.  Thanks.

I think that this approach is going to be overkill for my stored procedure.

What I wanted to do was declare...

> Have a look at "Linked Servers" on BOL

What is BOL ?

> BTW the statement should use 4 part names like:

> <ServerName.DBName.dbo.table>

DOH!  I knew that!  It just slipped my mind. ...

I have been able to limit my decimal points to 2 places by using the following code:

LTRIM( STR ( MyNumber, 99, 2 ) )

I am mostly trying to determine a...