You can also put the candidate values in a table and join to it if FTS is not an option.

I would definitely recommend upgrading your dev server to more current bits.  In general, your dev environment should mirror your production environment as closely as possible (hardware as well as...

Hello lucas..

It's unclear to me whether the data made it into SQL Server correctly; that ambiguity would certainly color my response here.

If you run a select statement on your SQL...

Actually, the DDL for both tables would be helpful.

Chances are, as jezemine suggests, one or more of your source columns is/are shorter than the destination.

Hope this helps..

Hi Ron..

How about copying the pertinent code out of sp_helplogins and writing your own procedure?

Hope this helps..

Hi Nelson..

What datatype is expected by the stored procedure?

The error message suggests that the stored procedure is coded with an nvarchar parameter.  Changing it to varbinary(max) should resolve this issue.

Hope...

Hi Sugesh..

It sounds as though you're making a linked server call in your trigger.  This is very dangerous, as the local DML action that fired the trigger (INSERT or UPDATE)...

Have you downloaded the July, 2006 BOL?

Hi Ninel..

Based on your error message, it seems as though you might have an impersonation issue.  Check out this link in the latest BOL (web-posted on 21 July 2006):

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/18a64236-0285-46ea-8929-6ee9bcc020b9.htm

Hope this...

About the only place I've seen dynamic SQL used to good effect in this type of scenario is for a search function with wildly variant parameters.  There's a series of...

Hi Deon..

If I understand your question correctly, this is not possible.  In order to do what you're trying to do, you'll need to employ either Dynamic SQL or sp_executesql.

There might...

I would suggest that your second sproc access the contents of the temp table rather than the results of a SELECT run against it.  These steps would likely render your...

I had a similar requirement and ended up going with what you're calling an odometer table.  Even then, locking and concurrency were issues.  Here's the code I ended up with...

Hi RGR..

According to this link (scroll down to the Manageability topic), Profiler is only shipped with the Standard and Enterprise Editions.

Hope this helps. 

Jules is correct.  This strikes me as a violation of first normal form.

Remember, the ability to do a particular thing doesn't necessarily make it a good idea..