View Complete Post
I have a encrypted store procedure in my production server .Right now I do not have the script now I want do some modification.
Please any one can help me to decrypt the store procedure it will be a great help for me.
For any suggestion thanks
We are calling store procedure from vb.net client following are the observation.
1) sqlserver 2005 takes huge amount of time (more than 1 hour) to execute procedure. The procedure has select statement using join statement. (Generally this procedure executes and populate data in 5 seconds when it is called from .net client.)
2) If same procedure is executed from sql server management studio, procedure executes and populate data in 5 seconds (works as per expectation)
3) If we recompile procedure (i.e. open procedure in alter mode in management studio and click on execute button) , the procedure executes and populate data as per expectation.
4) This is intermittent issue on production machine. Most of the time procedure is executed and populate data as per expectation when called from vb.net client. But it does not give expected outout in some scenario. The frequency for occurring the issue
is once in 15 days and there is no pattern in which the issue is occurring.
Can any one help to resolve the issue.
Thanks in advance!!!
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.
I have scenario where i need to run my store procedure on specific time frame ? For instance i have a field in my table1 called count.
i think for this some job should continous run in background, I have store procedure and i want to run that store procedure as background job in MSSQL continous. How can we do that or any other approch? please suggest me.
This is the sproc I am calling from my Asp.Net application:
ALTER PROCEDURE [Uds].[Dashboard_GetJobs2]
@date as datetime = null
Select * From Uds.RealtimeLogging
Where (@date is null or [timeStamp] > @date)
If I ran from query analyzer I get the correct results:
exec Uds.Dashboard_GetJobs2 '9/20/2010 11:01:23 PM'
However, if I ran the Asp.Net page, ALL records are showed. Looking at the SQL Profiler I see the following call:
exec sp_executesql N'exec Uds.Dashboard_GetJobs2',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'
And if I ran the statement above in query analyzer it WILL return ALL records. Why????
[UserID] = @UserID
I am about to rename a column in one of the table. How can I check the dependency for the column specially in store procedure? I am using SQL server 2008.
Thanks in advance