here's an example i had handy: filename is build with a combination of variables and current time/date.

replace your query  where the query in red is below.

declare @outfile    varchar(250),

        @strCommand...

hehe... same example, but i beat your post by a whole minute!

great minds and all that.

in sql server , you can use a calculated column; (not available in oracle...you'd have to create a trigger to do the same thing); note i added logic to watch...

Eddie thanks; you pointed me on the right track; by using the sp_Oa procs, and  a bit of minor modifications to my test dll, i was able to read any...

could it be something as simple as statistics or something?

I had a situation where a developer turned off automatic statistics in his test database, and over time his machine...

check out this recent post:

there's no native way I know of to use TSQL to create the image...the image data is usually handled by an object that can handle a...

check out this recent thread on the same subject:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=333827

a few different examples were given on how to search syscomments, especially how to avoid the rare situation where a tablename...

search for the Split function in the scripts section of SSC; there are several that will do this.

searching for Split in the forums will get you loads of ewxamples as...

someone has posted something similar in the script submissions as well:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1584

Notification of schema changes - Advanced

Script Rating

somewhere in the report, it is referencing a column that does not exist in the SQL statement returned into the recordset. a valid  recordset was returned, and has rows, otherwise...

you typically use ORDER BY new_id() to randomize results:

SELECT top 5 CATEGORY_NAME ,ASSETS_NEEDED_FOR_ASSIGNMENT FROM MYTABLE ORDER BY NEW_ID()

run it multiple times, and you'll see the data is random.

you should be able to use the object_name function without translating to decimal:

select object_name(0x4319E038)

select object_name(0x60FC61CA)

ok how about this: can you do this to the linked server? using the SELECT ...INTO feature, but make sure the where statement returns no rows, so it creates the...

I think that's my next step.... I was looking for an easy sleazy way to get results from any old DLL, but I think I'll have to slap together an...

you didn't post any changes, so I'm assuming you are still not checking for nulls.

add this function to the page:

Private Function tnull(s) As String

    If IsNull(s) Or IsEmpty(s)...