we have a common user id and pwd (Windows NT service control) to access the NT server and seperate user id & pwd to open sqlserver.
i am using sqlserver authendication to connect the server by giving userid and pwd. i have many jobs which are all running without any problem, even...
Hi This is not SSIS. This job contains my stored procedure (USP_CalculateDataCapture) which is running in management studio without any problem...
thanks arun.
I have a mirroring setup in our production servers. I have a question, will the mirrored server start collection jobs when a fail-over occurs from...
Hi all I was trying to configure database mail in sqlserver 2005. After configure everything, i am getting the below err. I wanted to configure...
Hi all I am getting lot of deadlocks in my jobs while processing. The below one which i am getting error msg in my jobs :- Executed as user: NT...
I ran the alter database command, i,e -- To Avoid Deadlock ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON After run this, i am getting...
Hi sorry for not sending you reply immediately. After i changed the max worker thereads in syssubsystem table i dont get any status message like...
sure saurabh. I will let you know if i get worker threads. As for now, it is going smooth and not found any worker threads. Thanks for your assits....
chris thanks for your link. Let me try those steps and will let you know. --kmr
thanks for your link mohammed I checked my Virtual Memory in my server which shows 30000 paging file size. My server configuration is, win server...
As you said, i have changed the value into 572 in syssubsystems . Earlier it was 160. Will let you know after some time how it is performing. --...
thanks saurabh I got below configuration after i reconfigure the sp_configure. Ad Hoc Distributed Queries0100 affinity I/O...
Yes. i have restarted sqlserver and agent too.
hi satya It is good, as you suggested for the previous guy's problem against the 'waiting for a worker thread'. I am facing this problem very long...
hi mani usually tempdb will be installed in the default folder where master, msdb and model database installed. If TEMPDB located in c: drive, you...
Actually i have configured my company id as well as my personal email id in both email and reply email options respectively in SMTP configuration....
Hi I have configured Database Mail in my local server. But i am not able to get any email when i try to send test message from database mail. I got...
Separate names with a comma.
