this will be data related....

on db1, the recordset frm.AdodcTemp.Recordset was loaded with a select statement...

but on db2, the same select statment returned no data, so the recordset is at the...

you've got almost all the pieces...i've done the same thing as well:

To check Syntax:

SET PARSEONLY ON

-- Execute your query

GO

SET PARSEONLY OFF

To Actual Compile and check for objects existance:

SET NOEXEC ON

GO

--...

isn't it @@proc_id? so object_name(@@proc_id), rather than the @@spid?

i have this handy query stored in my snippets collection.

select name as DBNAME,STATUS,

CASE WHEN (STATUS &         1) = 0 THEN 'FALSE' ELSE 'TRUE' END AS [AUTOCLOSE_(ALTER_DATABASE)],

CASE WHEN (STATUS...

i don't think that error refers to free storage card/disk memory, but rather the amount of RAM that is available to perform the query;

my CE machine has 128M of ram,...

i think this can be fixed simply by adding some code to either the button that submits the data, or the Sub Page_Load event; the page will have all the values that...

No problem Steve; just wanted you to know; i bet it has something to do with the high traffic your site gets; i love this site and spend a lot...

I found it; it's two pieces of the puzzle...it must be a system function, and it ALSO must be owned by 'system_function_schema' ... NOT dbo:

http://msdn2.microsoft.com/en-us/library/aa224829(SQL.80).aspx

SELECT UID FROM master.dbo.sysusers WHERE...

like above, I've never hit a limit on the number of values in the IN() statement, and read it gets converted to a temp table by SQL Server;

I've gotten an error...

definitely not a best practice, i admit...I was just showing by example that just because something is a marked as a system function, does not make it available to ::fn_...

i have been bitten by this bug 6 times this week; some of my posts couldn't have taken me over 3 minutes to type, others were huge detailed answers....I'm a damn decent...

oh and the 41 second thing? try it yourself....paste my query and run it...it will be slow the first time...SQL Server will save a plan for that query in case...

what a meant was i would do this:

CREATE VIEW VW_EQPMAS AS

SELECT EQPNUM,

LEFT(TXTEXT,

      CHARINDEX(CHAR(13) + CHAR(10),TXTEXT,--6th vbCrLf

        CHARINDEX(CHAR(13) + CHAR(10),TXTEXT,--5th vbCrLf

          CHARINDEX(CHAR(13) + CHAR(10),TXTEXT,--4th vbCrLf

            CHARINDEX(CHAR(13) + CHAR(10),TXTEXT,--3rd...

the charindex(... 6 levels deep is incredibly slow with no execution plan...on my test table with 2 rows, it took 41 seconds...41!!! on the first pass as an execution plan...

Antares686 raised a lot of good points. Here's an idea: it looks like the first 6 lines are a header, adn have the same format....so for example, does line 6...