Something like this would probably work

create a table to store a record (unique index so only one allowed) to prevent two people inserting records via sp.

i.e if exists(select * from...

I have a slightly different issue of a demo lap top running windows 2003 server & rs service pack 2 where the image streams are lost (unless run via the...

Possibly you could copy and paste the data across in the data directory? Havent tried this myself...

My guess would be that the report service needs access to the internet to resolve the url.

I seem to remember that varchar sizes are set as the default size which may cause truncated strings, try using create table. Anyhow as far as SSIS goes try turning...

I usually parse the script before running as well, as an error in a view can trigger errors in all views looking at that view, 1 errors easy to find, >1...

As far as I know in 2k theres no way of doing this?? It can be backed up and restored I think but as far as I remember you typically...

copy & paste cube in same database giving cube new name, delete old cube and reprocess in 2000 is the only way I've found to do it..

Pretty sure that ado (not sure about oledb) can't open two recordsets simultaneously you have to wait until data is returned, try waiting until query is complete before continuing, asynch queries are...

Pretty sure that ado (not sure about oledb) can't open two recordsets simultaneously you have to wait until data is returned, try waiting until query is complete before continuing, asynch queries are...

Whats the state of the connection when a recordsets created? If its busy does the class library your using attempt to create a new connection if the state doesnt equal open,...

When I experienced this (in vb6 ado 2.5) the approle couldnt be reapplied but the connection was still usable if the user had privileges to access the data which does...

Is it possible your problem is to do with connection pooling, application roles mess up connections so they can't be reused. Try turning this off in the odbc settings for the...

only one i've come across is the one by dundas which seems pretty expensive for what you get, I'm sure someone will do a cheap replacement soon.. Office 12's got a whole...

Its just a formating thing - char(10) = newline , char(9) = tab, the article mentions using char(10)'s for formatting