I have installed SQL Server Express, the configuration tools as well as the SQL Server Management Express --- However, I need the SQL Profiler. Where or how does this get installed with SQL Server Express?
I tried all the INFORMATION_SCHEMA on SQL 2000 andI see that the system tables hold pretty much everything I aminterested in: Objects names (columns, functions, stored procedures, ...)stored procedure statements in syscomments table.My questions are:If you script your whole database everything you end up havingin the text sql scripts, are those also located in the system tables?That means i could simply read those system tables to get any informationI would normally look in the sql script files?Can i quickly generate a SQL statement of all the indexes on my database?I read many places that Microsoftsays not to modify anything in those tables and not query them since theirstructure might change in future SQL versions.Is it safe to use and rely the system tables?I basically want to do at least fetching of information i want from thesystem tables rather than the SQL script files.I also want to know if it's pretty safe for me to make changes in thesetables.Can i rename an object name for example an Index name, a Stored Procedurename?Can i add a new column in the syscolumns table for a user table?Thank you
I need to setup a script to read all the table names in the database above and then query the database to find the list of Stored Procedure using each table.(SQL Server)
Can only member in the System Administrators role use the SQL Profiler’s? Is there any other role or way to allow user to use this tool other then adding them to this role? Thanks you
Does anybody have any idea if there is a bug in SQL 7.0 where running multiple traces causes the SQL 7.0 to crash ?? This is running in a clustered environment.
I've looked high and low for information regarding this problem to no avail. Profiler works fine from the local server where SQL7 is running, (using NT security). But even though my client is multiprotocol, I cannot connect from my desktop using SQL security (ODBC error) or NT authentication. NT security gives me ConnectionOpenRcpBindingSetAuthInfo(). I do have a valid id on the NT machine as well and am not getting any errors in the security events log.
Can/How do you connect remotely to the profiler using TCP/IP or Mulitprotocol client?
Can anyone tell me what is a profiler in SQL server 7.0? What I exactly want to know is, in which practical situation u will find the profiler useful. Explaination with example will be appreciated.
Hi I need to track the connections hitting to my server through application???
I m doing some work in Profiler but i m not sure from where to start it..I m using SQL SERVER 2005...I m accesing few pages on application and that i want to track that activity involving at server side
I have a small doubt. where is the ideal place to run a profiler . can we run a profiler on production server or we have to run profiler on a seperate instance and connect to production server
1/When I create a new trace, it gives me sevral events including the SQL server s own functions and provcedures. How do I tell profiler to display only the requests we send SQL server from a VB program or other company made programs instead of including sql server own events as well. That will help me filter the requests and locate the problem easily. 2/ also ,. sometimes, my text data column description gets truncated and as a result I can't see the whole text of a request. What causes that and how can I fox it pls? Thank you, i am not familiar with profiler.
Hi hi, We had a sql express version running fine untill recently. Now it seems cause high processor use, high memory load, etc. So the websites being dependant on SQL start performing slower.
Is there some way to monitor what is causing this. I can't seem to read any log files, there is no profiler in express, etc. So what options do I have?
im trying to use the profiler to find out which tables are still being accesses as there seems to be alot of suspected tables lying around and stored objects (sps, functions etc) can the trace profiler be used in this situation?
When running a profiler trace for long running queries during peak usage what is a typically expected additional load the process of running it will create on that Database?
Dear All, where can i found sql profiler in sql server 2005?
i'm using Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Vinod Even you learn 1%, Learn it with 100% confidence.
I want to know if user defined functions like fn_example can be traced in profiler and what event to choose to trace functions executed. will it displays the function being executed or just the body of the fucntion? Thnxxxxxxxx
HiI am just started at a new position. This organization has a number ofdatabase servers with mission critical databases. However, I have twodatabase server, 1 a test server and the other a catch all db server thatcontain a hodge podge of databases. On the test server, there are 54databases while the other has 40. I am pretty confindent that not all ofthese databases are being used. My goal is to find out which ones are nolonger needed.In an attempt to find out who/what is using these databases, I have set upSQL Profiler.My SQL profile setup is as suchObjects - Objects openedSecurity Audit - Audit Login, Login Failed, LogoutSession - Existing ConnectionStored Proc - RPC Completed, SP:StmtCompleted, SP:StmtStartingTSQL - SQL Batch completed, SQL:StmtCompletedMy data columns are the standard except I added DatabaseName.And there lies my problem that I hope someone can help. As I run the trace,all other fields seems to be working except Database Name. I see everythingbut the only way to tell what database is being accessed is looking at theSPID number and comparing it with Process Info in EM or sp_who.Does anyone have any idea why this field is not working? Am I missingsomething? Or am I just giving myself a headache for nothing because thereis an easier way to find the information I want: What the heck is going onwith these database and who is doing what on them?Thanks in advance for any and all help:)Akinja
Hi,We have a requirement to run profiler continuously to find out themisbehaving applications/SQL in the dataserver. And we are notinterested in running it from an individuals local machine. Also wewant the profiler to start automatically whenever there are SQL Server/Machine restarts.Is there a way to invoke the profiler instance from cmd prompt or isthere a way to script the profiler?Thanks in advance,Thyagu.
I am using SQL7. On the client network utility, I am using name pipe and have 4 entries and they are in the same format (ie. server name, named pipes and ip address). I have problem to connect to some of them and getting [microsoft][ODBC SQL Server Driver]Client unable to establish connection and [microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(CreateFile()) Any idea?
I get the following error when I try to run Profiler from my client to any of our SQL Servers: [Microsoft][ODBC SQL Server driver][SQL Server] The operation could not be completed because your security context could not be impersonated.
Use the SQL Server client configuation application to ensure that you are connecting using either the Named Pipes or Multiprotocol network library.
We'd like to be able to use TCP/IP for this but I've tried it with Multiprotocol also and still get the same error message.
I would appreciate any suggestions for resolving this.