To add to what Allen said...

Have you turned on Profiler to catch the offending code??  the error tells you which process caused the crash and you should be able to...

Why can't you try

ALTER PROCEDURE vs.  CREATE PROCEDURE ???

If you are 100% sure that the proc is there and you can't see it try this and see what it gives...

pravins,

I agree with Frank about the guessing. Also, when you mean "hangs" how long does the process run before (I assume) you kill it?

Have you attempted to see...

What about creating "staging" tables that you grant Windows groups to and then have jobs run that actually perform the requests..

This way you can manage the security and the job...

Why can't you create a group and place the agents using your application(s) into the group(s) and then create the groups in SQL and grant/deny permissions based on the groups...

Another issue along with hfranz is that the application might not be constructed in a way to be able to handle the SET FORCEPLAN. I have run into problems...

I know I am going to get crucified on this one but...

If the covered index that you worked on is what you wanted is it possible to place that in...

Eric,

I have tried collation of Hebrew_Bin and Latin_General_Bin (both are windows collation) on a column and inserted the data directly from Access 2K to SQL 2K using an Append...

Hate to ask this but you are using SQL 2K??

Have you tried setting the collation for the column(s) that are going to store the hebrew data using hebrew collation???

SELECT *

FROM...

Can you post some of the data that you are having problems with? And possibly the offending code? I'll look at this when I get home tonight for...

Have you checked the SQL database and ensured the NVARCHAR is set? I think that you have to use the N data-types to store this kind of data.

Good Luck....

xujohn,

I have had similar problems before setting up mail with SQL. There are some really good support papers at support.microsoft.com if you use SQL 2000 and mail.

Also, you...

If you know which dates you won't receive a file why don't you make your error trap smarter by stating:

IF error = no file AND NOT IN (SELECT Dates FROM...

How come I got this question wrong when I answered based off the following:

Space is allocated to tables and indexes in increments of one extent (eight 8-kilobyte pages) at a...

Are you sure that the data in the loop is refreshing properly?

If after the 1st insert you get a violation it sounds like the data is the same..

Good luck

AJ Ahrens

webmaster@kritter.net