Database Discussion Boards

Using MS SQL Profiler in SQL 2000

ToughGuy931-Jan-07 3:39

31-Jan-07 3:39

Hi Friends,
I want to know is there any way i can use SQL profiler to MONITOR all queries RUN on a PARTICULAR table. I see that there is a way to tracks all queries run a particular DATABASE, but i couldn't find a way to trace queries run on a PARTICULAR table in a database.

Even though there is no direct way a Work around suggestion would be great.

Thanks a lot for ur help..

Regards,
Leela Krishna

Re: Using MS SQL Profiler in SQL 2000

Pete O'Hanlon31-Jan-07 3:51

Pete O'Hanlon

31-Jan-07 3:51

Set a filter on the TextData to be Like %table%.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Re: Using MS SQL Profiler in SQL 2000

ToughGuy931-Jan-07 6:36

ToughGuy9

31-Jan-07 6:36

Hi Pete,
Thanks a lot.. Will try that..

Regards,
Leela Krishna

Query help

indian14331-Jan-07 2:31

indian143

31-Jan-07 2:31

Hi all,
What is the query to get the details of an employee whose sal is the second highest salary among all the epmloyees from Employee table by using SQL Server and Oracle. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Re: Query help

Pete O'Hanlon31-Jan-07 3:03

Pete O'Hanlon

31-Jan-07 3:03

This is the type of query that you should be looking at.

SELECT TOP 1 * FROM Employee a WHERE a.Salary IN (
SELECT TOP 2 b.Salary FROM Employee b
ORDER By b.Salary DESC )
ORDER BY a.Salary ASC

Re: Query help

Sylvester george31-Jan-07 23:48

Sylvester george

31-Jan-07 23:48

Hey man this will work for both sql server and oracle
This is 100% pure SQL

select max(salary) from employee
where salary<(select max(salary) from employee)

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions

SQl Server 2005 Vs. SQl Server 2000

mrkeivan31-Jan-07 0:18

mrkeivan

31-Jan-07 0:18

Hi guys, I just installed SQL Server 2005, I was wondering whats the diffrence between this and SQL Server 2000.
By the way I've created a database and i want to creat a DataBase Diagram but I can't seem to find the option, I mean its not available !
can you help me out PLZ.

Mr.K

Re: SQl Server 2005 Vs. SQl Server 2000

Pete O'Hanlon31-Jan-07 1:41

Pete O'Hanlon

31-Jan-07 1:41

There are so many differences that it's hard to know where to start. Integrated Reporting Services. BI built into from the start. New T-SQL commands. Common Table Expressions. CLR integrated into Sql Server to allow you to have .NET stored procedures. VARCHAR(MAX). These are all areas that you should take a look at.

Did you install a new instance of the SQL Server engine or did the install perform an upgrade of a 2000 database? If it was the upgrade, then you cannot do anything with database diagrams and the new features will not be available.

Re: SQl Server 2005 Vs. SQl Server 2000

mrkeivan31-Jan-07 9:29

mrkeivan

31-Jan-07 9:29

Well I downloaded Microsoft Sql server 2005 express edition from Microsoft website ! maybe thats why ! Is there anywhere I can download the full version for free Big Grin | :-D

!!!

Mr.K

Re: SQl Server 2005 Vs. SQl Server 2000

leckey31-Jan-07 6:13

leckey

31-Jan-07 6:13

You can find LOTS of articles online that explain the differences.

_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.

SSIS Package

NK731-Jan-07 0:13

NK7

31-Jan-07 0:13

Hi
I am trying to create a package programmatically. Transfering 100 or 1000 data no problem if i try to transfer millions of records it is taking more time. If i try the same through intergration project it takes only few minutes.

Any one can help me to speed up the transformation please......

kesavan

Query Help Its Urgent

amjad ali shah30-Jan-07 21:00

amjad ali shah

30-Jan-07 21:00

I have this query which I used to populated a dropdown list when a department is assigned to a employee.now I want to populated those department which are not assigned to employee.this query not work.

"select Dep.Department_Name,emp.dept_id from contact_dept
Dep,Contact_Employee_Depts Emp where dep.active=-1 and dep.Dept_id <>
Emp.Dept_Id and Emp.Emp_id=" & CLng(ViewState("Emp_id")) & ";""

Plz Its Urgant

Re: Query Help Its Urgent

andyharman30-Jan-07 21:26

andyharman

30-Jan-07 21:26

I think that this is what you want:

select Dep.Department_Name
from contact_dept Dep
where Dep.Dept_id not in (select Emp.Dept_Id from Contact_Employee_Depts Emp where Emp.Emp_id = 123)
and Dep.active = -1
order by Dep.Department_Name

Regards
Andy

Re: Query Help Its Urgent

amjad ali shah30-Jan-07 23:13

amjad ali shah

30-Jan-07 23:13

thanks it work fine Poke tongue | ;-P

how to find a trigger is enabled or disabled for a particular table

smjp30-Jan-07 18:08

smjp

30-Jan-07 18:08

In sql server 2000 how to find wheather a trigger is enabled or disabled for a particular table...
I found that there is stored procedure sp_helptrigger tablename for getting the details of how many triggers present in a particular table...

But i want to find out find wheather a trigger is enabled or disabled for a particular table...

plz help me out

this is smjp

Re: how to find a trigger is enabled or disabled for a particular table

Ware@Work5-Feb-07 10:58

Ware@Work

5-Feb-07 10:58

As I understand it triggers are enabled if they exist. You disable it by removing it. It might not fire if there was an error in original command or prior triggers run (multiple can run for same sql statement).

Thanks,

Ware

SQL Query Help

Hulicat30-Jan-07 13:36

Hulicat

30-Jan-07 13:36

I am trying to join the two following select statements into a single result that would look like the following:

Ticket Number, Open Issues, Email

meeting this criteria from table "job_ticket" WHERE job_ticket.location_id = '5' and status_type_id like '[1-2]'

Both select statements run fine alone

SELECT job_ticket.job_ticket_id 'Ticket Number', job_ticket.subject 'Open Issues'
FROM job_ticket
WHERE job_ticket.location_id = '5' and status_type_id like '[1-2]'

Select email from client where client_id ='5'

Data from Table "Job_ticket"
ticket_id
subject
client_id
location_id
Status_type_id

Data from table "Client"
client_id
email

I am trying to pull the client.email via the job_ticket.client_id into the 1st sql statement:
SELECT job_ticket.job_ticket_id 'Ticket Number', job_ticket.subject 'Open Issues'
FROM job_ticket
WHERE job_ticket.location_id = '5' and status_type_id like '[1-2]'

I have tried various methods and read through "books online", however; I am not making much progress.

What is the best way to do this?

Any information would be greatly appreciated.

Thanks and Regards,
H

Regards,
Hulicat

Re: SQL Query Help

andyharman30-Jan-07 19:50

andyharman

30-Jan-07 19:50

SELECT job_ticket.job_ticket_id 'Ticket Number',
   job_ticket.subject 'Open Issues', Client.Email
FROM job_ticket
INNER JOIN Client
 ON Client.Client_Id = Job_Ticket.Client_Id
WHERE job_ticket.location_id = '5'
AND status_type_id like '[1-2]'
ORDER BY job_ticket.job_ticket_id

Regards
Andy

Re: SQL Query Help

Hulicat31-Jan-07 9:10

Hulicat

31-Jan-07 9:10

Thanks a ton....

This one was killing me.....

That was it.......

Thanks and Regards

Regards,
Hulicat

DataGrid and DataGridView

Blekk30-Jan-07 12:48

Blekk

30-Jan-07 12:48

Hi,

I have got the Apress book Beginning C# Databases: from Novice to Professional, and have been very pleased with it, But because it was written before Microsoft Visual C# 2005 came out, some things are a bit out of date. I have managed to get around most of them except this one:

It tells me to add a DataGrid to the designer view, but all I could find was DataGridView, and after some scripting, I have to "Bind the data grid at run time" using the script:

dataGrid1.SetDataBinding(dataset1, "employees");

I understand what the code is doing but the class DataGridView does not have a SetDataBinding function and so do not know how to bind the DataGridView1 object to the dataset.

Please help.

Thanks,

Any reply is appreciated.

I will also post this in the C# section

Re: DataGrid and DataGridView

smjp30-Jan-07 18:45

smjp

30-Jan-07 18:45

first create a dataset
then in page_load event type this
for windows application
adapter1.Fill(dataset1,"employees");
dataGridView1.DataSource = dataset1.Tables["employees"]

for web application
gridview1.datasource=dataset1.Tables["employees"]
gridview1.databind()

this is code maker

Re: DataGrid and DataGridView

Blekk31-Jan-07 7:48

Blekk

31-Jan-07 7:48

thanks for the help,

But I found out how to do it another way before your post:

dataGridView.DataBindings.Add("datasource",dataSet1,"customers");

Question about using PIVOT in SQL

leckey30-Jan-07 11:33

leckey

30-Jan-07 11:33

In Access I am doing a crosstab query which translated to SQL is:

TRANSFORM Sum(Adjust_Sold_Sold_Subtraction.Qty) AS SumOfQty<br />
SELECT Adjust_Sold_Sold_Subtraction.PartNumber, Adjust_Sold_Sold_Subtraction.Model, Sum(Adjust_Sold_Sold_Subtraction.Qty) AS [Total Of Qty]<br />
FROM Adjust_Sold_Sold_Subtraction<br />
GROUP BY Adjust_Sold_Sold_Subtraction.PartNumber, Adjust_Sold_Sold_Subtraction.Model<br />
PIVOT Adjust_Sold_Sold_Subtraction.Vendor;

The table is data entry table. The user can choose the Vendor from a drop down box.

problem: if in this session the user does not have a record for every vendor in the list it causes problems later on when I try to insert the records into a table (which has a field for each possible vendor).

Is there a way to force the code to recognize all the vendors, even if not all vendors have been entered in the source table?

Or is there a way (some type of if statement?) when trying to do the append that somehow I can program 'the vendor XYZ doesn't exist in the source table, but it exists in the destination table so just stick a 0 in there.'

_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.

can i return dataReader in ado.net method on web serviec ?

PavanPareta30-Jan-07 3:05

PavanPareta

30-Jan-07 3:05

Please help me i have a question?
Confused | :confused:

can i return dataReader in ado.net method on web serviec ?

Pavan Pareta

Re: can i return dataReader in ado.net method on web serviec ?

Pete O'Hanlon30-Jan-07 3:48

Pete O'Hanlon

30-Jan-07 3:48

Why would you want to? A DataReader is meant to be a forward-readonly reader that efficiently allows you to get data out of the database. A web-service, (when a method is marked as a [WebMethod], is typically meant to return a synchronous value.

Now, what you could do is have a collection that is populated by the DataReader and then returned from the WebMethod.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.