Recent content by nirmalsp

Hi I need to delete a system Index in syssubscriptions table i used sp_fixindex i could'nt repair it. help me !! Thanks Nirmal

Hi i am running application writen in MS Access & Tables are Linked to SQL server as Linked Tables. users are unable to login to sql server even proper access rigts are granted. Error is: sql state:08004 Server Error :4060 server rejected the...

Hi i have a problem with blocking sql tables the same table is block by one user for long time while other wait for min & min to continue. how can i handle blocking Thanks

Hi how can i read sent itmes folder using xp_read mail Thanka

hi when ever i run a sql sp , my server utilize 100% CPU usage for execution. what could be the cause ? Thanks

Hi i have deleted guest account in my sql server. even from sysusers table from all databases. including from master,msdb etc.. once it was deleted my user couldn't login in. then when i serch in the microsoft knowledge base they ask me to grant permission all users to master db. now i need...

Hi There are lots of Stored procedures running using cursors in my sql server db's now when ever a sp executes server allocates up to 100% CPU usage at that time. due to this other users who use to view reports & run queries fails giving a time out. what could be the cause. all are welcome...

hi i am having a server performance problem , i have been recomended to setup the memory settings in sql server properties. is there a standard ? what is recomended for most severs need help

Hi there is are some message login to sql server log file as "Date Source Message ------------------------------------------------------------------------------- -------------------------------------------------------------------------------... .... 0 x00000000...

hi i need to disable sp re-compilation when executing is it possible. since i have a problem with my sql server performance. how could i do it. need help Thanks

Hi i have a application which uses database as sql sever 7 logins with same SQLUSERID(SA) TO application & validates user accounts from a tables. there are about 50 users using the same application can this cause to sql server performance pls. help me on this thanks

Hi There is a message loging to my sql server log file as "2002-02-05 21:02:02.68 spid9 Closing file e:\MSSQL7\data\Efficiency_Data.MDF. 2002-02-05 21:02:02.82 spid9 Closing file e:\MSSQL7\data\Efficiency_Log.LDF. 2002-02-05 21:23:59.70 spid9 Opening file...

Hi i need to stop writing Login details to sql error log how could i do it thanka

Hi I have installed SQL server desktop edition on win98 OS & i am using ghostsvr.exe to copy the configuration to multiple pc's. after all completing the ghost i tried to register sql server with that m/c name i couldn't start the service. Error is "General Network Error,See...

Hi I need to write a single script to Grant select,insert,update,delete rights to multiple Views & i don't want to Execute the same script agin & agin by changing the view name " Grant select on vCustoemers to Management" "Grant select on vproducts to Management" can u...