Profiler "settings" are greyed out

Ive run a trace and Im trying to access the Settings option on the Replay
button but its greyed out. Any ideas why?
sql2k sp3
TIA, ChrisR
ChrisR wrote:
> Ive run a trace and Im trying to access the Settings option on the
> Replay button but its greyed out. Any ideas why?
Start the replay first against the server in question. When you start,
those are the settings. You can access them again from the menu once the
replay is started.
David Gugick
Imceda Software
www.imceda.com

Profiler "settings" are greyed out

Ive run a trace and Im trying to access the Settings option on the Replay
button but its greyed out. Any ideas why?
--
sql2k sp3
TIA, ChrisRChrisR wrote:
> Ive run a trace and Im trying to access the Settings option on the
> Replay button but its greyed out. Any ideas why?
Start the replay first against the server in question. When you start,
those are the settings. You can access them again from the menu once the
replay is started.
--
David Gugick
Imceda Software
www.imceda.com

Profiler "settings" are greyed out

Ive run a trace and Im trying to access the Settings option on the Replay
button but its greyed out. Any ideas why?
sql2k sp3
TIA, ChrisRChrisR wrote:
> Ive run a trace and Im trying to access the Settings option on the
> Replay button but its greyed out. Any ideas why?
Start the replay first against the server in question. When you start,
those are the settings. You can access them again from the menu once the
replay is started.
David Gugick
Imceda Software
www.imceda.comsql

Profiler

Is there any way I can give user permission to run SQL profiler witout giving
them sysadmin access
thxstoney wrote:
> Is there any way I can give user permission to run SQL profiler
> witout giving them sysadmin access
> thx
No. It is a sysadmin function. SQL 2005 will have other options.
--
David Gugick
Imceda Software
www.imceda.com

Producing Text File

Hello all,
My sql skills are pretty poor, so please bear with me!

I need to take info from two tables (in Access db) and produce two txt files.

The data in the first table is listed as follows: OrderID, OrderDate, CustomerID, Total
The data in the second table is listed as follows: OrderID, Quantity, Discount, UnitPrice

The user has to be able to specify a time frame (start date and end date).

The major problem I'm having is with setting up the txt files. The header has to have the OrderID listed as "!!OrderID" (this is the way the fake company has their db set up apparently) Also, in the actual data in the txt files the OrderDate has to start w/ "#" and the CustomerID has to start w/ "&".

here's what I mean:

!!OrderID OrderDate CustomerID Total
--- --- ---- --
123456 #456789 &abcdef 987654

If you can help me at all, I'd much appreciate it!!! Thank you!Well, in MS Access you can't use "!" in column name, so you'll have to handle this using VBA coding and replace column name when writing into the text file. You didn't describe tables relationship.

SELECT
[OrderID],
"#" + [OrderDate] AS [OrderDate],
"&" + [CustomerID] AS [CustomerID],
[Total]
from
your_table;

store the result into some VBA object (I don't remember which one to use, it's long time since I used Access for last time). Open text file and read row by row from VBA object and write it into the file. Replace column name OrderID with !!OrderID|||Thanks for the help. The tables are linked through OrderID. Also, I found out that I don't have to use Access to do the project. MySQL is allowed as well. If that makes a difference w/ the !! problem, let me know.

Thanks again!

Processing priority based on client connection?

Is there a way to set a process priority in SQL Server 2000 based upon the
client or connection type being used to access the data? For example, on a
particular database, I want to give the client application for which the
database was designed priority over other connections such as Microsoft
Access or Seagate Crystal Reports.
Can this be done?As far as I know, it is not possible to set priority based on the client =or the connection.
-- Keith
"Glen Appleton" <buglen@.hotmail.com> wrote in message =news:O432%23p2uDHA.1788@.tk2msftngp13.phx.gbl...
> Is there a way to set a process priority in SQL Server 2000 based upon =the
> client or connection type being used to access the data? For example, =on a
> particular database, I want to give the client application for which =the
> database was designed priority over other connections such as =Microsoft
> Access or Seagate Crystal Reports.
> > Can this be done?
> >

Process Info

I want to check who access the database in the sql server. When i go to current activity then process info. I found not all the users who access the database are displayed. Even though i refresh it. It didn't show up. But i am sure some user was accessing the database. Anybody know why, how can i avoid it. Thanks.Perhaps the user disconnected prior the current activity was shown? Or the user connected using a different username/password?|||I'd use SQL Profiler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_2xiq.asp).

-PatP