Search Results | SQL Server Performance Forums

automation job

Thread by: srimkumarp, Mar 29, 2011, 3 replies, in forum: SQL Server 2008 General DBA Questions

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...

db role

Thread by: srimkumarp, Apr 13, 2010, 1 replies, in forum: SQL Server 2005 General DBA Questions

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...

problem with sql server login

Thread by: srimkumarp, Oct 7, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

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...

dump error in sql server 2005

Thread by: srimkumarp, Jun 30, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

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...

replication prb

Thread by: srimkumarp, May 8, 2009, 2 replies, in forum: SQL Server 2005 Replication

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...

performance query.....

Thread by: srimkumarp, Mar 17, 2009, 3 replies, in forum: SQL Server 2008 T-SQL Performance Tuning

Hi All, can any one please explain me if user stored procedures and user defined funtions is having prefix sp_userprocedures; and fn_userfuntions....

analysis the isse

Thread by: srimkumarp, Mar 16, 2009, 7 replies, in forum: SQL Server 2005 General DBA Questions

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...

query pls help

Thread by: srimkumarp, Mar 13, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

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...

profiler output

Thread by: srimkumarp, Mar 12, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

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...

configurations on iis server

Thread by: srimkumarp, Mar 2, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

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...

initial size for mdf and ldf

Thread by: srimkumarp, Feb 17, 2009, 6 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, we have a databases for some reasons the initial size of Log and datafile size appears to be changing on its own. previously it was 2 mb...

perfmon counter

Thread by: srimkumarp, Feb 11, 2009, 13 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, In system monitor tool,when i try to add counters in performance object it is showing numbers. i am unable to track how many users are...

dll error

Thread by: srimkumarp, Feb 3, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I traced one error from sql server 2005 -application event logs.please suggest the description of the error.it'll be create any problem in the...

index out of range

Thread by: srimkumarp, Feb 3, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All,from last 20 days i'm tracking the errors from sql server 2005 -application event logs;for five databases i am getting the below error Error:...

Script timed out errors

Thread by: srimkumarp, Jan 11, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, In your company who are all uploading file from application to database they are getting error continuously.i have changed the script...

net sqlclient data provider error

Thread by: srimkumarp, Dec 30, 2008, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, One user is getting error while working the windows application. He is end user .he is not using SQL Server , any other tools.Developers are...

login issues

Thread by: srimkumarp, Dec 11, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, we have one database which is recently created in new server.For that database i need to give permissions for 2000 logins as db_owner. I...

RUN TIME ERROR

Thread by: srimkumarp, Nov 21, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

HI ALL, our developers developed one application in .net 2008,and the we conifgured the application IIS. system configuration is win 2003 standard...

sql to excel openrowset error

Thread by: srimkumarp, Aug 25, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

hi all, while executing the below insert openrowset INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=d:pendingdet.xls;' ,...