I'm sure that is what happened but...

GilaMonster (1/26/2012)

---

Are you absolutely sure that the differential you have is based off the full backup that you restored? There were no other full backups taken between the time that...

wolfkillj (1/25/2012)

---

Oh, and by the way, I tested the function you posted earlier. It definitely works properly...

ok, thanks but I get the same error.

The function is wrong.

Do you have a tested solution with that function?:w00t:

gweiho4xd2 (1/25/2012)

---

Hi,

I don't have any client machines (all Win XP) which are able to see the list of tables/views on the SQL 2000 server over an ODBC connection.

I can see...

wolfkillj (1/24/2012)

---

Your splitter function returns the expected results, but the code in the stored proc should select the column Item from the function in the subselect in the WHERE clause,...

Not really..

This is the code for the function:

CREATE FUNCTION dbo.Split_Multi_Value_Parameters

/* This function is used to split up multi-value parameters */

(

@ItemList NVARCHAR(max),

@delimiter CHAR(1)

)

RETURNS @IDTable TABLE (Item NVARCHAR(100) collate database_default )

AS

BEGIN

DECLARE @tempItemList NVARCHAR(max)

SET...

The delimiter is not working.:w00t:

I have the following in my Stored Procedure:

AND State IN (SELECT State FROM dbo.Split_Multi_Value_Parameters (@State, ','))

I perform a DBCC INPUTBUFFER (SPID) and it parses as follows....

wolfkillj (1/13/2012)

---

I tried that but I still get...

You want to configure the DSN on the machine that you are having trouble with to use the same Login as the machine that is working.

I tried this once with Yahoo and could not get it to work.

GilaMonster (1/23/2012)

---

You can restore the full backup WITH STANDBY, that makes the DB read only (as opposed to completely inaccessible as with WITH NORECOVERY), you can then query and investigate...

Simon,

ok,...