To piggy-back on Troy, if you need each row to be completely custom with respect to security, then yes, there's going to be a lot of records. There's no way...

Take a look at the system stored procedure sp_update_jobschedule. We use it to reschedule a job every 15 minutes if a mainframe extract hasn't transferred yet.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

All the Perl books from O'Reilly except for the one on data structures (linked lists, trees, etc) are online at http://safari.informit.com/ which is basically a site where you pay a...

Since we're talking about applications which start up and then crash after a particular operation, take a look at the following Knowledge Base article. It's about a tool called AutoDump+...

Is PC Anywhere or the Cisco VPN client on the machine with .NET? I know we've had some issues with compatibility with PC Anywhere on a couple of other apps.

K....

If you're using Query Analyzer, it's because QA is only set to show the first 255 characters. Here's an article I wrote which will help:

http://www.sqlservercentral.com/columnists/bkelley/qa2k_3_1.asp

On the results tab, you...

The query in QA is faster? It may be a recompile issue on the stored procedure. Here are some of the more common reasons for a recompile:

• Stored procedure prefixed with...

If you use a single # sign, no. SQL Server will create a unique table name. To see what I'm talking about, create a # table in Query Analyzer and...

I'm thinking it's probably the SQL Client tools + MDAC + something else. Case in point: we use Altiris and it caused an issue with a particular client for an...

It'll probably be better to dump the values. Something to the effect of:

CREATE PROCEDURE usp_BuddyTest

DECLARE @List varchar(8000)

DECLARE @memID numeric(9, 0)

DECLARE @Username varchar(18)

DECLARE @tmp int

AS

SET @List =...

It's hard to read. Do you have spaces afteer UPDATE and before SET on the dynamic SQL statement?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

You could dump the SELECT into a temporary table and return the temporary table in one select statement. Alternately, you could dump the list into a temp table and then...

Can you post your Perl code masking the actual security info?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If you reinstall the client tools or re-apply the SQL Server service pack, still the same error?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

I'm not aware of MDAC 2.7 causing any issues like this, so that is odd. I have MDAC 2.7 on other systems in addition to my .NET system (had it...