Hi Satya, Thanks for reply, Before restore the DB from Prod to Test.We will take the login permission using thrid party tool and will place in one...
Hi All, I want to write a code for the below requirement:- If any (SQL Server 2008)database is restored in last 2 hours,then it can read permisison...
Hi All, I've created one database role for end users and i've added stored procedure and functions inside role.know my query is how to track...
Hi All, One of your developer having problem with sql server 2005, user is able access the stored procedures functions and other db objects using...
Hi All, Today morning in SQL Server Logs i found dump erros .Can any one please suggest why i am getting this error.This is the first time i am...
My doubt is from application point of view is there any difficulities are there. How we have to redirect to different server and in my application...
Hi All, My scenario is two locations are there and this two different location servers are going too replicated. We are going to use the db...
today i have observered the counters which you have provieded in that link. 1. page splits-some times it shows the graphs maximum value 98.16;but...
can anyone please advice
hi, i am pulling standard reports from server. when ever i've pull it shows for some user function,user procedure. for example fn_reports is taking...
Hi All, can any one please explain me if user stored procedures and user defined funtions is having prefix sp_userprocedures; and fn_userfuntions....
thanks for ur reply satya garu, First thing is we had almost 100 applications running in application server and their corresponding databases are...
Hi All, How can I analysis slowness from SQL Profiler.We are facing slowness issue for all application in between 10:45 am to 12 pm ;so i have...
thanks for ur reply,.....
Hi All, My question is how can i find the chat messages from which user to which user . I'm able to run the reports below format. ID , DATE...
HI All,. is there any way to find out SQL Profiler trace output in to graph. I want to find out db wise queries time taken to execute in graphical...
Hi All, system confg-win(SE) 2003;iis 6 we are having live projects which is developed in asp,asp.net and vb.net. All applications are configured in...
hi all, Now all applications are working fine in morning times but here issue is some applications are getting error in night times only....
hi satya garu, ur correct. yesterday(19-02-09) eve shift started by that time all application ran slowly.pls advice me where i've chk. is this db...
thanks for ur suggestions.. Normally end users are entering , updating , pulling reports and uploading batches. these are the taks are doing on...
Separate names with a comma.
