Login Failed for Linked Server

In EM I am trying to create a link between two SQL SQL2K servers using NT
domain logins. It works using SQL Server logins, but not with NT logins.
The error message is "Error 18456: Login failed for user 'NT
AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
servers. I have checked the 'be made using the logins current security
context' box in the security tab. I can run querys against the second
server, but I need to run a linked query. We are trying to keep to NT logins
for everything, so I prefer not to use SQL logins.DaveK wrote:
> In EM I am trying to create a link between two SQL SQL2K servers using NT
> domain logins. It works using SQL Server logins, but not with NT logins.
> The error message is "Error 18456: Login failed for user 'NT
> AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
> servers. I have checked the 'be made using the logins current security
> context' box in the security tab. I can run querys against the second
> server, but I need to run a linked query. We are trying to keep to NT logins
> for everything, so I prefer not to use SQL logins.
Hi
Try to look up "delegation" in Books On Line. There are a few settings
in your domain that has to be in place in order to use NT login for
Linked servers.
Regards
Steen

Login Failed for Linked Server

In EM I am trying to create a link between two SQL SQL2K servers using NT
domain logins. It works using SQL Server logins, but not with NT logins.
The error message is "Error 18456: Login failed for user 'NT
AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
servers. I have checked the 'be made using the logins current security
context' box in the security tab. I can run querys against the second
server, but I need to run a linked query. We are trying to keep to NT login
s
for everything, so I prefer not to use SQL logins.DaveK wrote:
> In EM I am trying to create a link between two SQL SQL2K servers using NT
> domain logins. It works using SQL Server logins, but not with NT logins.
> The error message is "Error 18456: Login failed for user 'NT
> AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
> servers. I have checked the 'be made using the logins current security
> context' box in the security tab. I can run querys against the second
> server, but I need to run a linked query. We are trying to keep to NT log
ins
> for everything, so I prefer not to use SQL logins.
Hi
Try to look up "delegation" in Books On Line. There are a few settings
in your domain that has to be in place in order to use NT login for
Linked servers.
Regards
Steen

Login Failed for Linked Server

In EM I am trying to create a link between two SQL SQL2K servers using NT
domain logins. It works using SQL Server logins, but not with NT logins.
The error message is "Error 18456: Login failed for user 'NT
AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
servers. I have checked the 'be made using the logins current security
context' box in the security tab. I can run querys against the second
server, but I need to run a linked query. We are trying to keep to NT logins
for everything, so I prefer not to use SQL logins.
DaveK wrote:
> In EM I am trying to create a link between two SQL SQL2K servers using NT
> domain logins. It works using SQL Server logins, but not with NT logins.
> The error message is "Error 18456: Login failed for user 'NT
> AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
> servers. I have checked the 'be made using the logins current security
> context' box in the security tab. I can run querys against the second
> server, but I need to run a linked query. We are trying to keep to NT logins
> for everything, so I prefer not to use SQL logins.
Hi
Try to look up "delegation" in Books On Line. There are a few settings
in your domain that has to be in place in order to use NT login for
Linked servers.
Regards
Steen

login auditing not writing to log

Hello,
I have turned on the login auditing in the server properties to log
both failed and successfull logins. I logged out and logged back in to
test the feature. However, the system did not write the login details
to the sql server log. Do I have to bounce the sqlserver?
Are DDL triggers the only way to turn on database auditing in SQL
Server 2005?
Regards
JaideepYes, you need to bounce the SQL2000/2005 instance.
Linchi
"jai" wrote:

> Hello,
> I have turned on the login auditing in the server properties to log
> both failed and successfull logins. I logged out and logged back in to
> test the feature. However, the system did not write the login details
> to the sql server log. Do I have to bounce the sqlserver?
> Are DDL triggers the only way to turn on database auditing in SQL
> Server 2005?
> Regards
> Jaideep
>|||Hello Jai,
For SQL 2000 or SQL 2005 after doing the change you need to stop and start
SQL Server service.
DDL trigger can be used to audit the schema changes. Say you can audit
alter, drop or create statements
into a table or fire an action you could use DDL triggers.
Thanks
Hari
"jai" <dbasybase@.gmail.com> wrote in message
news:1169496539.784616.88210@.m58g2000cwm.googlegroups.com...
> Hello,
> I have turned on the login auditing in the server properties to log
> both failed and successfull logins. I logged out and logged back in to
> test the feature. However, the system did not write the login details
> to the sql server log. Do I have to bounce the sqlserver?
> Are DDL triggers the only way to turn on database auditing in SQL
> Server 2005?
> Regards
> Jaideep
>

login auditing not writing to log

Hello,
I have turned on the login auditing in the server properties to log
both failed and successfull logins. I logged out and logged back in to
test the feature. However, the system did not write the login details
to the sql server log. Do I have to bounce the sqlserver?
Are DDL triggers the only way to turn on database auditing in SQL
Server 2005?
Regards
JaideepHello Jai,
For SQL 2000 or SQL 2005 after doing the change you need to stop and start
SQL Server service.
DDL trigger can be used to audit the schema changes. Say you can audit
alter, drop or create statements
into a table or fire an action you could use DDL triggers.
Thanks
Hari
"jai" <dbasybase@.gmail.com> wrote in message
news:1169496539.784616.88210@.m58g2000cwm.googlegroups.com...
> Hello,
> I have turned on the login auditing in the server properties to log
> both failed and successfull logins. I logged out and logged back in to
> test the feature. However, the system did not write the login details
> to the sql server log. Do I have to bounce the sqlserver?
> Are DDL triggers the only way to turn on database auditing in SQL
> Server 2005?
> Regards
> Jaideep
>

login auditing not writing to log

Hello,
I have turned on the login auditing in the server properties to log
both failed and successfull logins. I logged out and logged back in to
test the feature. However, the system did not write the login details
to the sql server log. Do I have to bounce the sqlserver?
Are DDL triggers the only way to turn on database auditing in SQL
Server 2005?
Regards
Jaideep
Yes, you need to bounce the SQL2000/2005 instance.
Linchi
"jai" wrote:

> Hello,
> I have turned on the login auditing in the server properties to log
> both failed and successfull logins. I logged out and logged back in to
> test the feature. However, the system did not write the login details
> to the sql server log. Do I have to bounce the sqlserver?
> Are DDL triggers the only way to turn on database auditing in SQL
> Server 2005?
> Regards
> Jaideep
>
|||Hello Jai,
For SQL 2000 or SQL 2005 after doing the change you need to stop and start
SQL Server service.
DDL trigger can be used to audit the schema changes. Say you can audit
alter, drop or create statements
into a table or fire an action you could use DDL triggers.
Thanks
Hari
"jai" <dbasybase@.gmail.com> wrote in message
news:1169496539.784616.88210@.m58g2000cwm.googlegro ups.com...
> Hello,
> I have turned on the login auditing in the server properties to log
> both failed and successfull logins. I logged out and logged back in to
> test the feature. However, the system did not write the login details
> to the sql server log. Do I have to bounce the sqlserver?
> Are DDL triggers the only way to turn on database auditing in SQL
> Server 2005?
> Regards
> Jaideep
>

Login Audit

I'd like to keep track of the number of logins to a SQL server over a
day which are then logged in a simple text file, for licensing
reasons. What do you think is the best way to do this? I was thinking
of using a trace but fear this may generate too much info. Could I
schedule a stored procedure to run every hour which records the number
and exports to a text file?
Thanks for your help in advance!
JohnTurn of the Login success and failure auditing functionality of SQL Server.
This will create an entry for each event in the NT Application Eventlog,
then you use WMI to filter them out and send them to a file for example.
This will be the lowest overhead solution, using SQL Trace/Profiler has much
more impact on your server performance.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"John McGinty" <jpmcginty@.talk21.com> wrote in message
news:87642ea9.0401280404.40536dde@.posting.google.com...

quote:

---

> I'd like to keep track of the number of logins to a SQL server over a
> day which are then logged in a simple text file, for licensing
> reasons. What do you think is the best way to do this? I was thinking
> of using a trace but fear this may generate too much info. Could I
> schedule a stored procedure to run every hour which records the number
> and exports to a text file?
> Thanks for your help in advance!
> John

---

|||The logins also get sent to the SQL Server errorlog as well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

login and password administration

Using SS2000. I have two questions. How do adminsremember passwords for
logins. We have several web sites each with its own login and password. I
thought about creating a table somewhere and storing the login, password and
purpose of the login but that doesn't seem so secure.
Second question - I have a login/user who I want to remove. The user owns a
table in a database. I tried changing the owner of the table to 'sa' using
"EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
Object 'tblSVM' does not exist or is not a valid object for this operation.
How do I get rid of the login/user?
Thanks,
--
Dan D.Hi,
Answer to your seconds question.
Make the owner of the object to DBO and drop the user and then remove the
login. While changing the object you have to give TABLE_OWNER.TABLE_NAME..
EXEC sp_changeobjectowner 'current_table_owner.tblSVM', 'dbo'
After that drop the user
sp_dropuser <user_name>
Drop the login
sp_droplogin <login_name>
Thanks
Hari
MCDBA
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:652F288B-24C3-4D9F-A616-8EA1A6840F46@.microsoft.com...
> Using SS2000. I have two questions. How do adminsremember passwords for
> logins. We have several web sites each with its own login and password. I
> thought about creating a table somewhere and storing the login, password
and
> purpose of the login but that doesn't seem so secure.
> Second question - I have a login/user who I want to remove. The user owns
a
> table in a database. I tried changing the owner of the table to 'sa' using
> "EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
> Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line
38
> Object 'tblSVM' does not exist or is not a valid object for this
operation.
> How do I get rid of the login/user?
> Thanks,
> --
> Dan D.|||After adding the current owner of the object, now I get this error message:
Server: Msg 15410, Level 11, State 1, Procedure sp_changeobjectowner, Line 55
User or role 'sa' does not exist in this database.
If I try to add 'sa' as a user in the database I get this message:
Cannot user the reserved user or role name 'sa'.
I was able to change the owner to another user but why did I have a problem
with changing it to 'sa'?
Thanks,
"Hari Prasad" wrote:
> Hi,
> Answer to your seconds question.
> Make the owner of the object to DBO and drop the user and then remove the
> login. While changing the object you have to give TABLE_OWNER.TABLE_NAME..
> EXEC sp_changeobjectowner 'current_table_owner.tblSVM', 'dbo'
> After that drop the user
> sp_dropuser <user_name>
> Drop the login
> sp_droplogin <login_name>
> Thanks
> Hari
> MCDBA
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:652F288B-24C3-4D9F-A616-8EA1A6840F46@.microsoft.com...
> > Using SS2000. I have two questions. How do adminsremember passwords for
> > logins. We have several web sites each with its own login and password. I
> > thought about creating a table somewhere and storing the login, password
> and
> > purpose of the login but that doesn't seem so secure.
> >
> > Second question - I have a login/user who I want to remove. The user owns
> a
> > table in a database. I tried changing the owner of the table to 'sa' using
> > "EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
> > Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line
> 38
> > Object 'tblSVM' does not exist or is not a valid object for this
> operation.
> >
> > How do I get rid of the login/user?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||You need to use the database user name, not the login name.
Mark.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Dan D. wrote:
> After adding the current owner of the object, now I get this error message:
> Server: Msg 15410, Level 11, State 1, Procedure sp_changeobjectowner, Line 55
> User or role 'sa' does not exist in this database.
> If I try to add 'sa' as a user in the database I get this message:
> Cannot user the reserved user or role name 'sa'.
> I was able to change the owner to another user but why did I have a problem
> with changing it to 'sa'?
> Thanks,
> "Hari Prasad" wrote:
>
>>Hi,
>>Answer to your seconds question.
>>Make the owner of the object to DBO and drop the user and then remove the
>>login. While changing the object you have to give TABLE_OWNER.TABLE_NAME..
>>EXEC sp_changeobjectowner 'current_table_owner.tblSVM', 'dbo'
>>After that drop the user
>>sp_dropuser <user_name>
>>Drop the login
>>sp_droplogin <login_name>
>>Thanks
>>Hari
>>MCDBA
>>
>>"Dan D." <DanD@.discussions.microsoft.com> wrote in message
>>news:652F288B-24C3-4D9F-A616-8EA1A6840F46@.microsoft.com...
>>Using SS2000. I have two questions. How do adminsremember passwords for
>>logins. We have several web sites each with its own login and password. I
>>thought about creating a table somewhere and storing the login, password
>>and
>>purpose of the login but that doesn't seem so secure.
>>Second question - I have a login/user who I want to remove. The user owns
>>a
>>table in a database. I tried changing the owner of the table to 'sa' using
>>"EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
>>Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line
>>38
>>Object 'tblSVM' does not exist or is not a valid object for this
>>operation.
>>How do I get rid of the login/user?
>>Thanks,
>>--
>>Dan D.
>>|||Dan,
Q1. Why not put them in a SQL Server database? You can restrict access
to the data in here easily. What are your security concerns?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Dan D. wrote:
> Using SS2000. I have two questions. How do adminsremember passwords for
> logins. We have several web sites each with its own login and password. I
> thought about creating a table somewhere and storing the login, password and
> purpose of the login but that doesn't seem so secure.
> Second question - I have a login/user who I want to remove. The user owns a
> table in a database. I tried changing the owner of the table to 'sa' using
> "EXEC sp_changeobjectowner 'tblSVM', 'sa'" but I received this error:
> Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 38
> Object 'tblSVM' does not exist or is not a valid object for this operation.
> How do I get rid of the login/user?
> Thanks,

Logic problem - a challenge if you will

This is killing, me and I think that I'm failing to see something simple here:

If I have a table with logins and datetimes. I need to output any logins that have logged in more than 3 times in any 3 hour period of time, and how may times it was done. For example:

Login table:
user1 01:00
user2 01:13
user1 02:32
user2 01:17
user1 01:12
user2 07:00
user1 04:10

I would need:
user1 2 <-- (times user 1 logged in more than 3 times in 3 hours)

Because:
01:00, 02:32, 01:12 are all within 3 hours of each other
02:32, 01:12, 04:10 are all within 3 hours of each other

Obviously I have alot more data than this, but I'm failing to grasp the logic properly. Trying to do this in a Sybase stored proc.create table #tmp (
login char(5),
log_time smalldatetime
)

insert into #tmp
select 'user1', '01:00'
union all
select 'user2', '01:13'
union all
select 'user1', '02:32'
union all
select 'user2', '01:17'
union all
select 'user1', '01:12'
union all
select 'user2', '07:00'
union all
select 'user1', '04:10'

select rs1.login, count(*) as cnt
from (
select #tmp.Login
from #tmp inner join (
select login, log_time as mintime, dateadd(hh,3,log_time) as maxtime from #tmp) rs
on #tmp.login=rs.login
where #tmp.log_time between rs.mintime and rs.maxtime
group by #tmp.login, rs.mintime, rs.maxtime
having count(#tmp.log_time)>=3) rs1
group by rs1.login

drop table #tmp|||This would be assuming a limited data set, though, correct? Suppose I do not know how many logins and times there are?|||This would be assuming a limited data set, though, correct? Why are you thinking that? Did you try the query?

Logging Usage (logins)?

Hi everyone!

Can anyone tell me if it's possible to set up some kind of a trigger that will write out to a file or a table and log details of all database connections?
ie: user, datetime of connection, database connected to, etc.

Any help appreciated.

Cheers,
MeganHi Meagan ,

Use SQL Profiler and run a trace you will then see which user connected to which database and at which time they did so ...and more.

Regards
Burner

logging of activity on database

I want to make an investigation on the activity of the sql-server. This
means not only logins , but I want to know also the sql-commands which are
done. Is this already logged and captured in a database (in msdb for
example).
A second question: can i also see the CPU-activity of the computer where the
sql-server is put on. I have full connection to the sql-server, but i do not
have administration permission to that computer.
Thank you.
Johan
Use SQL Server Profiler for this purpose
http://www.sql-server-performance.co...filer_tips.asp
"johan Goris" <johangoris@.rewah.com> wrote in message
news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
> I want to make an investigation on the activity of the sql-server. This
> means not only logins , but I want to know also the sql-commands which are
> done. Is this already logged and captured in a database (in msdb for
> example).
> A second question: can i also see the CPU-activity of the computer where
the
> sql-server is put on. I have full connection to the sql-server, but i do
not
> have administration permission to that computer.
> Thank you.
>
|||Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
though I understand SQL 2005 would not need that. If you want to see the
CPU activity, the best you can do is SELECT @.@.CPU_BUSY. For SQL related
counters, you can use SELECT * FROM master..sysperfinfo
You could set up Performance Monitor on your server to log counters to a
table on your database, though I think it's only available on WinXP and
Win2003 (someone correct me here). Alternatively, I use a custom built tool
to collect and store local and remote performance counters from Win2000
servers to a SQL Server table.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uq3zLjEVEHA.3512@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Johan
> Use SQL Server Profiler for this purpose
> http://www.sql-server-performance.co...filer_tips.asp
>
>
>
> "johan Goris" <johangoris@.rewah.com> wrote in message
> news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
are
> the
> not
>
|||Peter Yeoh wrote:
> Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
> though I understand SQL 2005 would not need that.
i don't like that. i hope there's a way to prevent people that aren't
SAs from running profiler.
|||Perhaps I misphrased my statement regarding SQL2005. What I meant to say
was that to run Profiler in SQL2005, you still need to assign rights, but
not the sysadmin rights. It's actually an improvement then.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"ch" <ch@.dontemailme.com> wrote in message
news:40D19EF9.5B69D37E@.dontemailme.com...
> Peter Yeoh wrote:
> i don't like that. i hope there's a way to prevent people that aren't
> SAs from running profiler.

logging of activity on database

I want to make an investigation on the activity of the sql-server. This
means not only logins , but I want to know also the sql-commands which are
done. Is this already logged and captured in a database (in msdb for
example).
A second question: can i also see the CPU-activity of the computer where the
sql-server is put on. I have full connection to the sql-server, but i do not
have administration permission to that computer.
Thank you.Johan
Use SQL Server Profiler for this purpose
http://www.sql-server-performance.c...ofiler_tips.asp
"johan Goris" <johangoris@.rewah.com> wrote in message
news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
> I want to make an investigation on the activity of the sql-server. This
> means not only logins , but I want to know also the sql-commands which are
> done. Is this already logged and captured in a database (in msdb for
> example).
> A second question: can i also see the CPU-activity of the computer where
the
> sql-server is put on. I have full connection to the sql-server, but i do
not
> have administration permission to that computer.
> Thank you.
>|||Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
though I understand SQL 2005 would not need that. If you want to see the
CPU activity, the best you can do is SELECT @.@.CPU_BUSY. For SQL related
counters, you can use SELECT * FROM master..sysperfinfo
You could set up Performance Monitor on your server to log counters to a
table on your database, though I think it's only available on WinXP and
Win2003 (someone correct me here). Alternatively, I use a custom built tool
to collect and store local and remote performance counters from Win2000
servers to a SQL Server table.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uq3zLjEVEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Johan
> Use SQL Server Profiler for this purpose
> http://www.sql-server-performance.c...ofiler_tips.asp
>
>
>
> "johan Goris" <johangoris@.rewah.com> wrote in message
> news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
are[vbcol=seagreen]
> the
> not
>|||Peter Yeoh wrote:
> Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
> though I understand SQL 2005 would not need that.
i don't like that. i hope there's a way to prevent people that aren't
SAs from running profiler.|||Perhaps I misphrased my statement regarding SQL2005. What I meant to say
was that to run Profiler in SQL2005, you still need to assign rights, but
not the sysadmin rights. It's actually an improvement then.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"ch" <ch@.dontemailme.com> wrote in message
news:40D19EF9.5B69D37E@.dontemailme.com...
> Peter Yeoh wrote:
> i don't like that. i hope there's a way to prevent people that aren't
> SAs from running profiler.

logging of activity on database

I want to make an investigation on the activity of the sql-server. This
means not only logins , but I want to know also the sql-commands which are
done. Is this already logged and captured in a database (in msdb for
example).
A second question: can i also see the CPU-activity of the computer where the
sql-server is put on. I have full connection to the sql-server, but i do not
have administration permission to that computer.
Thank you.Johan
Use SQL Server Profiler for this purpose
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
"johan Goris" <johangoris@.rewah.com> wrote in message
news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
> I want to make an investigation on the activity of the sql-server. This
> means not only logins , but I want to know also the sql-commands which are
> done. Is this already logged and captured in a database (in msdb for
> example).
> A second question: can i also see the CPU-activity of the computer where
the
> sql-server is put on. I have full connection to the sql-server, but i do
not
> have administration permission to that computer.
> Thank you.
>|||Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
though I understand SQL 2005 would not need that. If you want to see the
CPU activity, the best you can do is SELECT @.@.CPU_BUSY. For SQL related
counters, you can use SELECT * FROM master..sysperfinfo
You could set up Performance Monitor on your server to log counters to a
table on your database, though I think it's only available on WinXP and
Win2003 (someone correct me here). Alternatively, I use a custom built tool
to collect and store local and remote performance counters from Win2000
servers to a SQL Server table.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uq3zLjEVEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Johan
> Use SQL Server Profiler for this purpose
> http://www.sql-server-performance.com/sql_server_profiler_tips.asp
>
>
>
> "johan Goris" <johangoris@.rewah.com> wrote in message
> news:40d155cc$0$26690$a0ced6e1@.news.skynet.be...
> > I want to make an investigation on the activity of the sql-server. This
> > means not only logins , but I want to know also the sql-commands which
are
> > done. Is this already logged and captured in a database (in msdb for
> > example).
> > A second question: can i also see the CPU-activity of the computer where
> the
> > sql-server is put on. I have full connection to the sql-server, but i do
> not
> > have administration permission to that computer.
> >
> > Thank you.
> >
> >
>|||Peter Yeoh wrote:
> Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
> though I understand SQL 2005 would not need that.
i don't like that. i hope there's a way to prevent people that aren't
SAs from running profiler.|||Perhaps I misphrased my statement regarding SQL2005. What I meant to say
was that to run Profiler in SQL2005, you still need to assign rights, but
not the sysadmin rights. It's actually an improvement then.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"ch" <ch@.dontemailme.com> wrote in message
news:40D19EF9.5B69D37E@.dontemailme.com...
> Peter Yeoh wrote:
> >
> > Unfortunately for SQL 2000, you need the sysadmin role to run Profiler,
> > though I understand SQL 2005 would not need that.
> i don't like that. i hope there's a way to prevent people that aren't
> SAs from running profiler.