Posted by gelangov on 08/24/07 12:25

On Aug 23, 5:42 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (gelan...@hotmail.com) writes:
> > I certainly will appreciate your input if you don't mind...I was
> > heistating since it looked very ugly:
>
> It could have been a little easier if you had made it as attachment.
> Maybe then it would be possible to open it in BIDS? I first tried IE,
> and it appears that there line breaks in the wrong place etc.
>
> In any case, the only query I found was this one:
>
> Exec ('select dbo.fntrim(column_name) as
> col from information_schema.columns&#xA;where table_name =''' +?+'''
> and Column_name &lt;&gt;''Clientlocid'''&#xA;
>
> which is different from the one you posted.
>
> Reviewing the thread I see that you never posted the error message you get.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I wanted to send it as an attachment. I do not see that there is an
option to attach files through this group. This is the error message
I get:

"Syntax error, permission violation, or other nonspecific error".

Thanks.

• Next in forum: Re: Convert CHAR YYYYMMDD to mm/dd/yyyy
• Prev in forum: Re: how can i send mail by using sql server
• Thread view: Re: ssis EXEC command

[Reply to this message]