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 |
|
jbow
Starting Member
3 Posts |
 Posted - 2008-07-23 : 23:53:56
|
| This sounds like a stupid question but I need to be pointed in the right direction.So Ive been working with Oracle databases for 15 years so I know my way around a SQL query but SQL server is new to me.I am helping a client with an application that goes through SQL Server. The application is in some old code and they lost the source and only have some encrypted version that they run. Well its not properly updating their tables so they have asked me to figure out what is wrong. In Oracle I can easily query v$ tables to see what is going on but I cant seem to figure out how to monitor what is running on SQL Server.I want to run the application and then go back to SQL server and see what is being run by using some type of tool or view.How can I do that? Someone suggested query analyzer but I guess that is gone with 2005. Can someone point a poor girl in the right direction? |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
|
|
jbow
Starting Member
3 Posts |
Posted - 2008-07-24 : 01:25:15
|
| Thank you so much, this is exactly what I needed.Thank you, thank you, thank you! |
 |
|
|
jbow
Starting Member
3 Posts |
Posted - 2008-07-25 : 12:21:22
|
| Does anyone know if there is a SQL Server book specifically written for Oracle developers or experienced programmers in general? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 14:06:28
|
quote:
Originally posted by jbow
Does anyone know if there is a SQL Server book specifically written for Oracle developers or experienced programmers in general?
 didnt understand that?? how can sql server details be wriiten for oracle? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-25 : 23:34:07
|
I think OP mean books written for developer with with Oracle background / knowledge and not familiar with T-SQL aka newbie to SQL Server.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 21:45:22
|
| >> In Oracle I can easily query v$ tables to see what is going on but I cant seem to figure out how to monitor what is running on SQL Server.You can use Dynamic Management Views and Functions, books online has list of them. |
|
|
|
|
|
|
How to I see what is being run