Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sohan
Starting Member
4 Posts |
 Posted - 2008-01-08 : 14:00:21
|
| Hi,Is it true that I need Analysis Server to simply log the queries being sent to my databases? I am not familiar with SQL server. In MySQL it is a simple checkbox setting; when I check it, all queries reaching the database(s) are written to a file. But accomplishing this in SQL Server is not so easy, so it seems. I read that I need Analysis Server to do this. I only bought the database, so I will have to purchase it. But I am not sure that this is, in fact, what I am looking for. I need a file that contains something like this:01/08/2008 14:19:21 UserName\DbName: SELECT name, telno FROM Customer WHERE country = 'Netherlands' AND name LIKE '%bicycle%'I need the queries exactly as they are sent to the database, from any (type of) client. Can Analysis Server provide this?Thx,/sohan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:39:45
|
| You can trace those in profiler but not with Analysis Sercive which is for olap cube and data mining. |
 |
|
|
sohan
Starting Member
4 Posts |
Posted - 2008-01-09 : 11:00:38
|
| Thanks for your reply. What is profiler? Or should I ask this question in the "New to SQL Server" forum?/sohan |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-09 : 11:10:16
|
| SQL Server Profiler comes with sql server (not express) and with it you can trace events that happen on your server.google it up._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
sohan
Starting Member
4 Posts |
Posted - 2008-01-09 : 11:24:16
|
| OK. Many thanks. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
sohan
Starting Member
4 Posts |
Posted - 2008-01-09 : 14:01:32
|
| You rock!!After reading a bit about MSSQL Profiler, it turned out that I have a workgroup license, so profiler is not available. I was already thinking about an upgrade to Standard Edition, but the tool you posted works like a charm. Not only with Express, but also with a Workgroup license.Thanks a bunch! The queries are displayed exactly as I need them. |
|
|
|
|
|
|
|
|
Analysis Server needed for query logging?