Need Details On Query Profiler

Jul 23, 2005

Where is the information coming from that is displayed in query
profiler.
Is it the command that is retrieved before it is processed, or is it
what is actually processed.

View 3 Replies


ADVERTISEMENT

Sql Query To Details About Database

Sep 11, 2007



Is there any query to list all tables,column name,datatype,size,total record in each tables for particular database
ex
Database:Northwind
Tables:categories,(categoryid varchar(50),Category name varchar(50)...............),1023kb ,25 records like this
i think there is no such a simple query...
Atleast tell How to get all column names and datatype of particular table and size of table

View 5 Replies View Related

T-SQL (SS2K8) :: Job Details In Query Output

May 1, 2015

I have a T-SQL query that outputs exactly as I wish when run via Management Studio. I now want to automate this query to run monthly via a SQL Agent Job.

I have got this to run but the resulting file is left with a header row which shows "Job 'MyJobName' : Step 1, 'My QUERY' : Began Executing 2015-05-01 10:52:01" and an extra blank row before my data (and column headers).

Is there any way of stopping these extra rows from being created using T-SQL in my query?

View 2 Replies View Related

Query Table And Its Column Details

Apr 23, 2008

How to query Table and its column details

View 2 Replies View Related

Help With Query ,should I Belive Profiler ?

Mar 22, 2006

Hi ,
I have query executed 1000 times a day by application with diffrent values in where ... but profiler shows different duration each time
duration might be 100 milisecond ,but might be 140000 miliseconds !!!

what is a reason ? should I belive profiler ?

SELECT cust_calls.call_date , cust_calls.work_order_sap , cust_calls.call_type_code , cust_calls.call_status , cust_calls.ind_max_expense , cust_calls.chng_date , cust_calls.user_id , cust_calls.call_seq_no , cust_calls.loc_equip_seq_no , cust_calls.initial FROM cust_calls WHERE (
cust_calls.loc_equip_seq_no = 3780 ) --changes with each query
ORDER BY cust_calls.call_date DESC

execution plan

|--Index Seek(OBJECT ([price].[dbo].[cust_calls].[cust_calls2]), SEEK ([cust_calls].[loc_equip_seq_no]=Convert([@1])) ORDERED FORWARD)
--space used--
name rows reserved data index_size unused
cust_calls 205019 201544 KB 74776 KB 38256 KB 88512 KB

-- table structure
CREATE TABLE [cust_calls] (
[call_seq_no] [numeric](7, 0) NOT NULL ,
[manufacturer_code] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[in_charge_code] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[work_order_sap] [char] (7) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[loc_equip_seq_no] [numeric](7, 0) NOT NULL ,
[call_type_code] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL ,
[syst_lang_code] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[maint_emp_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[expense_code] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[ind_max_expense] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[call_date] [datetime] NULL ,
[call_status] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[call_description] [text] COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[chng_date] [datetime] NOT NULL ,
[user_id] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL ,
[Invoice_number] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[invoice_date] [datetime] NULL ,
[invoice_amount] [numeric](9, 2) NULL ,
[invoice_note] [text] COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[initial] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[call_date_update] [datetime] NULL ,
[call_logon_id_update] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[gl_code] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[ind_follow_up] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
CONSTRAINT [PK__cust_calls__4EF38B7F] PRIMARY KEY CLUSTERED
(
[call_seq_no]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [FK__cust_calls__call___601E1781] FOREIGN KEY
(
[call_type_code]
) REFERENCES [cust_call_type] (
[call_type_code]
),
CONSTRAINT [FK__cust_calls__expen__267B85D1] FOREIGN KEY
(
[expense_code]
) REFERENCES [cust_expense] (
[expense_code]
),
CONSTRAINT [FK__cust_calls__in_ch__73BAFBDA] FOREIGN KEY
(
[in_charge_code]
) REFERENCES [cust_in_charge_warranty] (
[in_charge_code]
),
CONSTRAINT [FK__cust_calls__maint__40FA71E3] FOREIGN KEY
(
[maint_emp_code]
) REFERENCES [cust_maintenance_employees] (
[maint_emp_code]
),
CONSTRAINT [FK__cust_calls__manuf__41EE961C] FOREIGN KEY
(
[manufacturer_code]
) REFERENCES [cust_manufacturer] (
[manufacturer_code]
),
CONSTRAINT [FK__cust_calls__syst___1B29CEB6] FOREIGN KEY
(
[syst_lang_code]
) REFERENCES [cust_system_lang] (
[syst_lang_code]
),
CONSTRAINT [FK_cust_calls_cust_GL_Code_Type] FOREIGN KEY
(
[gl_code]
) REFERENCES [cust_GL_Code_Type] (
[gl_code]
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

View 10 Replies View Related

Query Profiler Event Log Software

Feb 16, 2004

I am looking for a way to log all events that occur on the server. I have used quary profier and that gets me the info i need but is there a way to truncate the file, say only log the last 30 minutes of activity and having it rolling so that it is always the last 30 minutes. Or is there some other software that will do this. The database times out at random times and I am trying to fix the problem but dont want to keep houndreds of log files that query profiler will create by leaving a trace running 24/7. Any suggestions.
Thanks
Mark

View 5 Replies View Related

Timing Difference Between Query Analyzer And Profiler

Aug 1, 2014

We are trying to troubleshoot some website performance issues and found some queries taking 2 to 3 seconds when the request comes from the web, and captured by the Profiler.

The same queries, when run in the Query Analyzer take 0 seconds.

What could be the reasons for this difference, I mean why it takes 2 - 3 seconds shown by the Profiler, when it's 0 second in Analyzer?

View 3 Replies View Related

Item Master And Office Stock Details (was Query Problem)

Sep 15, 2006

Hi,

I am having problem in getting result out of two table, one table is Item Mater which stores global items for all offices and other is stock file which stores office wise stock items as follows:

ITEM MASTER
--------------
NCODE ITEMNAME
1 A
2 B
3 C
4 D
5 E

STOCKDETAILS
-----------------------------------
NCODE ITEMCODE OFFICEID
1 1 1
2 2 1
3 3 1
4 1 2
5 2 2
6 4 2
7 5 3

I want office wise stock details which inludes items found in stock file and remaining itmes from item master. example for office 1

--------------------------------------------
FOR OFFICE - 1
--------------------------------------------
ITEMCODE ITEMNAME OFFICEID
--------------------------------------------
1 A 1
2 B 1
3 C 1
4 D NULL
5 E NULL

i want a single view from which i can select data like i shown above, any kind of help is highly appriciated, what i tried is , i created union of both tables and tried to get data out of union view but result is not up to desire.

Thanks in advance

View 8 Replies View Related

Created View With Join Query - Unable To Fetch Details

Feb 12, 2014

I created a view with a simple join query

there are 2 rows with orderid as null, i am unable to fetch the details when i give WHERE Condition as

"select orderid from joins where orderid=NULL"

Query :

create view joins as
select A.customerid,A.Companyname,A.Contactname,A.City,B.OrderId from Customers A
left join orders B
on A.Customerid=B.Customerid

View 1 Replies View Related

T-SQL (SS2K8) :: Can Value Of Parameters Passed To A Query Be Determined In Profiler

Mar 27, 2014

In Profiler a StmtCompleted Event Class has identified a query to be:

SELECT TOP 1 * FROM [WINSVR2008R2].[001].DBO.[OECTLFIL_SQL] WHERE ( ( OE_CTL_KEY_1 = @P1 ) ) order by OE_CTL_KEY_1 asc

Is there any way to determine the value of @P1? If so which Event class and Column should I examine?

View 5 Replies View Related

SQL Server 2012 :: Query To Select Parent Details From Child Table

Mar 3, 2015

I have a scenario,

We have equipment table which stores Equipment_ID,Code,Parent_Id etc..for each Equipment_ID there is a Parent_Id. The PK is Equipment_ID Now i want to select the Code for the Parent_Id which also sits in the same table. All the Parent_Id's also are Equipment_ID's.

Equipment table looks like :

Equipment_ID Code DescriptionTreeLevelParent_Id
6132 S2611aaa 4 6130
11165 V2546bbb 3 1022
15211 PF_EUccc 5 15192
39539 VP266ddd 4 35200
5696 KA273eee 3 3215
39307 VM2611fff 4 35163
39398 IK264ggg 4 35177

There is another table for Equipment_Tree which has got Equipment_Tree_ID,Parent_Id and Equipment_ID does not has the Code here.

Select query where i need to select the Code for all Parent_Id's.

View 8 Replies View Related

Integration Services :: Query SSIS Packages Details From File System

May 1, 2015

I have around 500 packages (SQL 2005) deployed in file system & all this packages are running on daily basis via SQL agent. Now I need to migrated all 500 packages into SQL server 2008 R2.

There is no inventory to track which package belogs to which team and any other information.

Now, I need a method to query the pakages connection string details with database respective. Is there any method?

View 2 Replies View Related

SQL Server 2012 :: Query Execution Not Showing Up In Profiler Trace

Aug 22, 2014

Set up a trace with the events RPC:Completed, SQL:BatchCompleted, SQL:BatchStarting, and SQL:StmtCompleted.

When I issue the statement: SELECT * FROM XyzView there is nothing captured in Profiler. If I script out the view and then execute the select statement that defines the view, it does show up in Profiler.

I've tried adding a lot of the other events, i.e. SP:StmtCompleted and the various other StmtStarting events and the trace still does not capture anything.

Am I capturing the wrong events or is this known behavior? My goal is to see what the overhead is for using a view versus persisting the results of the view as a table and referencing that instead. The view in question is against static data, joins 9 tables, and is referenced a lot.

I can use the stats generated when I execute the select that defines the view but I still find this to be curious behavior so I assume I'm doing something wrong.

View 9 Replies View Related

SQL 2012 :: How To Find Query Which Have Sort Warning Alert In Profiler

Jan 30, 2015

which have a lot of impact to database performace since it do not fit onto memory and spill over to disks.

The question is when i ran a profiler and tried to catch a sort warning i cannot find the query which cause the alert.

View 1 Replies View Related

Analysis :: Profiler Trace Doesn't Capture Full MDX Query

Sep 16, 2015

I am trying to load all the MDX queries that run on a Analysis Server instance into a database for further analysis. A SQL Profiler is setup which captures the MDX queries, and when I am loading the Profiler info to database, some of the queries are not coming up in full length.The TextData field doestn't show full MDX query. When loading to the database, the field is next data type. Is there any workaround to get the complete MDX query? 

View 2 Replies View Related

SQL Server 2012 :: Query To Get CPU Usage / Memory Usage Details Of Server?

Jan 30, 2014

providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...

I want to create a job which will run on a Node every 15 min and store data in a table for each instance...

DMV is not giving more stuff and xtended events not sure if i can store that data into a table?

View 7 Replies View Related

Log Details

Nov 30, 2007

Hi,
Is there any way to capture the log details such as row count of the data flow,number of success rows and failed rows in a separate table?

View 3 Replies View Related

Attention To Details

Aug 15, 2004

Well I made a bussiness object for registering users as well as logging them in. I dont know if my bussiness obect is screwed up or if its the database, or the SQL syntax or what. Please take a look at this. I am not getting any error messages, but nothing is being added to the server. I am using MSDE for the SQL Server.

Here's my bussiness object:


Imports System
Imports System.Data
imports System.Data.oledb

NameSpace LoveShare

Public Class UserDetails
public UserID AS Integer
public FirstName AS String
public LastName AS String
public UserName AS string
public Password AS String
public Address AS String
public City AS String
public State AS String
public Zip As Integer
public Email AS String
End Class

Public Class User

Private objConn As New oledbConnection("Provider=sqloledb;Data Source=GARAGESALELOVESHARE;Initial Catalog=LoveShare1;User Id=sa;Password=notonthispost;")



Public function Login(strUsername AS String, strPassword As String) As Integer
dim intID as integer
dim objparam AS new oledbparameter
dim objcmd AS oledbCommand

objCmd = new oledbCommand("dbo.SPLoginUser", objconn)
objcmd.commandtype = commandtype.Storedprocedure

objparam = New oledbparameter("@UserName", oledbtype.Char)
objParam.Value = strUserName
objCmd.Parameters.Add(objParam)

objParam = New oledbParameter("@Password", OleDbType.Char)
objParam.Value = strPassword
objCmd.Parameters.Add(ObjParam)

Try
objConn.Open
intID = CType(objCmd.ExecuteScalar, Integer)
objConn.Close
Catch e As Exception
Throw e
End Try

If intID.toString = "" Then
return 0
End if
Return intID
end function

Public Sub AddUser(objUser As UserDetails)
Dim intId as integer
Dim objReader As oledbdataReader
Dim objCmdID As New oledbCommand("SELECT MAX(userID) FROM tblUsers", objconn)
Dim objcmd AS New oleDBCommand("spAddUser", objConn)
Dim objparam AS OleDbParameter
objCmd.CommandType = CommandType.StoredProcedure


objParam = New oleDbParameter("@FirstName", oledbtype.Char)
objParam.value = objuser.FirstName
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@LastName", oledbtype.Char)
objParam.value = objuser.LastName
objCmd.Parameters.add(objParam)


objParam = new oleDbParameter("@UserName", oledbtype.Char)
objParam.Value = objUser.UserName
objCmd.Parameters.Add(objParam)

objParam = New oleDbParameter("@Password", oledbtype.Char)
objParam.value = objuser.Password
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@Email", oledbtype.Char)
objParam.value = objuser.Email
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@Address", oledbtype.Char)
objParam.value = objuser.Address
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@City", oledbtype.Char)
objParam.value = objuser.City
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@State", oledbtype.Char)
objParam.value = objuser.State
objCmd.Parameters.add(objParam)

objParam = New oleDbParameter("@Zip", oledbtype.Integer)
objParam.value = objuser.Zip
objCmd.Parameters.add(objParam)

Try
objConn.Open
ObjCmd.ExecuteNonQuery
objUser.UserID = CType(objCmdID.ExecuteScalar, Integer)
objConn.Close
Catch e AS Exception
Throw e
End try

If objUser.UserID.ToString = "" then
objuser.UserID = 25
End if
End Sub
End Class
End NameSpace






Here's is my stored procedure for the registration:



CREATE PROCEDURE [dbo].[SPAddUser]
@FirstName VarChar(255),
@LastName VarChar(255),
@UserName VarChar(255),
@Password VarChar(255),
@Email VarChar(255),
@Address VarChar(255) ,
@City VarChar(255),
@State VarChar(255) ,
@Zip [INT]

AS
INSERT INTO tblUsers (FirstName, LastName, UserName, Password, Email, Address, City, State, Zip)
VALUES (@FirstName, @LAstName, @UserName, @Password, @Email, @Address, @City, @State, @Zip)
GO




And here is the actual registration page

<%@ Page Language="VB" %>
<%@ Register tagPrefix="LoveShare" TagName="Header" src="head.ascx" %>
<%@ Register tagPrefix="LoveShare" TagName="Menu" src="Men.ascx" %>
<%@ Register tagPrefix="LoveShare" TagName="Stats" src="Stats.ascx" %>
<%@ Register tagPrefix="LoveShare" TagName="Footer" src="foot.ascx" %>
<%@ Import Namespace="system" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="LoveShare" %>



<script runat="server">
Public sub Submit(sender as object, e as eventargs)
If Page.IsValid then


dim objuserdetails as New LoveShare.UserDetails
dim objuser As New LoveShare.User

objuserDetails.FirstName=tbFirstName.Text
objuserDetails.LastName=tbLastName.Text
objUserDetails.Username=tbUserName.Text
objuserDetails.Password=tbPassword.Text
objUserDetails.Email=tbEmail.Text
objUserDetails.Address=tbAddress.Text
objUserDetails.City=tbCity.Text
objUserDetails.State=tbState.Text
objuserDetails.Zip=tbState.Text

ObjUser.AddUser(objUserDetails)

Session("UserID") = objUserDetails.UserID
FormsAuthentication.SetAuthCookie(objUserDetails.UserID, false)
Response.Redirect("index.aspx")
else
lblMessage.text="Information entered incorrectly"
End If
End Sub

</Script>

<html>
<body BGCOLOR="00ccFF">
<Table Width="800">
<tr>
<td>
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<LoveShare:Header runat="server" />
</td>
</tr>
<tr>

<td>
<Table cellpadding="0" cellspacing="15" Width="800">
<tr>
<td>
&nbsp;
</td>
<td>
<td>
<form runat="server">
<table cellpadding="3" cellspacing="0" width="100%">
<tr>
<td colspan="2" Align="center">
<Font size="6">Sign Up Today!<BR><BR></Font>
</td>
</tr>
<tr>
<td Align="Center">
<Font color="red">
<asp:label id="lblMessage" runat="server" />
</font>
</td>
</tr>

<tr>
<td Align="right">First Name:</td>
<td Align="Left"><asp:textbox id="tbFirstName" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbFirstName" ErrorMessage="First Name Required" Text="Forgot First Name" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Last Name:</Td>
<td Align="Left"><asp:textbox id="tbLastName" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbLastName" ErrorMessage="Last Name Required" Text="Forgot Last Name" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Desired UserName:</td>
<td Align="Left"><asp:textbox id="tbUserName" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbUserName" ErrorMessage="UserName required" Text="Forgot UserName" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Password:</td>
<td Align="Left"><asp:textbox id="tbPassword" Textmode="Password" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbPassword" ErrorMessage="Password Required" Text="Forgot Password" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Verify Password:</td>
<td Align="Left"><asp:textbox id="tbVPassword" Textmode="password" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbVPassword" ErrorMessage="Verify Password" Text="Forgot to verify Password" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Email Address:</td>
<td Align="Left"><asp:textbox id="tbEmail" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbEmail" ErrorMessage="Email address required" Text="Forgot Email address" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Verify Email Address:</td>
<td Align="Left"><asp:textbox id="tbVEmail" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbVEmail" ErrorMessage="Must verify Email address" Text="Verify Email address" Display="Dynamic"/>
</td>
</tr>
<td Align="right">Street Address</td>
<td Align="Left"><asp:textbox id="tbAddress" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbAddress" ErrorMessage="Street Address Required" Text="Forgot Address" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">City:</td>
<td Align="Left"><asp:textbox id="tbCity" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbCity" ErrorMessage="City Required" Text="Forgot City" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">State:</td>
<td Align="Left"><asp:textbox id="tbState" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbState" ErrorMessage="State Required" Text="Forgot State" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">Zip:</td>
<td Align="Left"><asp:textbox id="tbZip" runat="server" />
<asp:requiredfieldValidator runat="server" Controltovalidate="tbZip" ErrorMessage="Zip Code Required" Text="Forgot Zip" Display="Dynamic"/>
</td>
</tr>
<tr>
<td Align="right">&nbsp;</td>
<td Align="Left"><asp:button id="btsignup" text="Sign Up" onclink="submit" runat="server" />
</tr>
</table>
</form>

</td>
<td>
&nbsp;
</td>
</tr>
</table>
</td>


</tr>
</tr>
<td>

</td>
</tr>

<tr>
<td>
<LoveShare:Footer runat="server" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>



Please help, I cannot figure out what is wrong

View 1 Replies View Related

Index Details

Mar 10, 2005

Hi,
I need to get the index_name,colum_name and table_name in entire database.
Coule you let me know how I can get that details.
Thanks,

View 7 Replies View Related

Replication Details

Sep 28, 2006

Hi,

I used my DB and some tables for replication earlier, now i removed my all replication subscription and publication and my DB is out of replication.

Now i am altering my table for PK then its giving err as follows:

Cannot alter the table 'mstparty' because it is being published for replication.

From where i can find details, i mean in which sys table all replication obj are stored.

There is no Replication now on DB then why still table 'mstparty' has a replication err when i alter table.

Please advice as i am not able to alter my table or tables which earlier i used in replication and now i removed replication.

View 5 Replies View Related

Contact Details

Apr 5, 2007

I have a database which has contact column eg. Mr Peter Smith

I am writing a new database which is to have three seperate columns.. saluation, first name and surname. What would be the best way to split the column up?? I was thinking on concentrating on the spaces??

Note: some conacts may not have saluation inc in the contact column, and in this case the saluation column should be blank...

Thanks

View 1 Replies View Related

Getting Object Details In The DB

Apr 30, 2007

Hello

Is there any script or procedure which can give the object name , type ,status and owner in a database.

Thanks

View 2 Replies View Related

OLAP Details Please

Aug 28, 2007

Can somebody please go in depth detail what exactly is done in OLAP? i know it deals with the data warehouse end. but what does the SQL DBA do in the OLAP end? please elaborate. thanks.

View 5 Replies View Related

How Can I Get The Details Of The Error

Jul 23, 2005

How can i get the details of the error in sql server 2000 such where itoccurs in which line. I need something like i get in sql query analyzer.--Message posted via http://www.sqlmonster.com

View 4 Replies View Related

Trigger Details

Apr 28, 2008

I Have so many user create trigger's in my database
like create trigger trig_name

Now i want to see what does what and delete the unnecessary ones.


How can i See the logic in the trigger.

I can get the trigger name but not the logic using this query .


SELECT S2.[name] TableName, S1.[name] TriggerName,

CASE

WHEN S2.deltrig = s1.id THEN 'Delete'

WHEN S2.instrig = s1.id THEN 'Insert'

WHEN S2.updtrig = s1.id THEN 'Update'

END 'TriggerType' , 'S1',s1.*,'S2',s2.*

FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id]

How to see the logic.

View 6 Replies View Related

Failure Details?

Dec 12, 2006

Where is, (or even does it exists) the best place to look for some details on when package execution fails if running as a scheduled job. Obviously when you run from the command line or in VS, there is plenty of output detail on progress and on the source of errors, but when you run it as a scheduled job, it just says step 1 failed in the sql server log, and package foo failed in the NT application log . Is there anywhere to find this info or do we need to build error traps into the package to write stuff out somewhere?

THX

Dave

View 2 Replies View Related

Comprehensive Details For Setting Up SSE?

Nov 23, 2006

First, soapbox questions for someone who might have more direct pull with Microsoft (or at least knowledge of how I should work with what they've given us), then a more specific question:
Scenario: You install SQL Server Express (or any other version, it doesn't matter) and the feedback with all the little green checkmarks tells you it has installed successfully. "Oh goody," say people (like me) who are not super experienced with SQL Server, "it installed successfully; now I can jump in and start using it!" But it aint so--there are so many other hoops to jump through before it really becomes operational.
 After successful installation, why can't some link become visible indicating what you have to do after that? I mean, it's fine to wade through all the questions in this forum and get answers from all you nice and informed guys, AFTER the problems start coming; but I would rather not have to associate with you, to be honest, in terms of time spent that could be going into my projects.
Why isn't there a comprehensive guide right off the bat? That is, something referenced immediately that tells you such things as: how to register a database with emphasis on the fact that just creating a database won't do the trick for your application; how to set permissions and rights; that (what was I reading in the advice of one post?) you have to register both the database and the user, blah blah; all about instances, the web.config file, etc. etc. I mean, doesn't it seem logical that by virtue of a person installing the database, come on, that this is a pretty good indication that he/she in all likelihood is new at it? As it is now, all they tell you on the SSE site is that you have to have the .NET Framework installed; and the green checkmarks indicating that you've installed it correctly (sorry for mentioning that twice).
"OK, self," I say, "I have the Framework installed and SSE installed correctly, so let's get to work." Then the trouble begins. Unless Microsoft's purpose is to keep you tech guys and book writers in business, I don't understand why they don't give more up-front guidance. Any thoughts on why they work it this way? Bueller, Bueller? Anyone, anyone?
Now, to the question that's pressing me at the moment: I've installed SSE and I'm going through a tutorial ("How Do I: Create Data-Driven Web Sites?" on http://www.asp.net/getstarted/default.aspx?tabid=61). Yeah, the guy makes it look really easy. He creates a database then shuts down the connection. I try to do the same things and I'm informed that I don't even have a valid connection! How SQL-Server-Express fun and easy is that? It's a real AdventureWorks, if you ask me.
OK, that's my rant; and since MS didn't think in advance and implement my idea of a link to jump off from the installation menu, I have to face the reality of learning this by putting all the pieces together myself. So, my question is, before I try to go through the video and get more frustrated, WHERE DO I GO FOR THE MOST BASIC OF ALL THE STEPS I NEED TO DO, ONE BY ONE? This is like the second "beginner" video I've tried to go through but even these don't start at the very beginning with information on how to register a new database, making the user a part of aspnetWHATEVER, what permissions to dole out, etc.
Guidance is solicited and will be most appreciated. Thanks, Bryan

View 1 Replies View Related

Master-Details Insert

Jan 21, 2007

Master table (tlbProduct) having productID as Primary key and which acts as reference key for table (tlbCategory).Fields for tlbProduct are productID,productNameFields for tlbCategort are productID,CategoryID(primary key),CategoryName,Prizeboth productID,CategoryID are autoincrementing.but when i write two inserts simultaneously as follows insert into tlbProduct(productName)values(@productName)insert into tlbCategory(CategoryName,Prize) using sqldatasourceI get the error that ProductID value is null which is not providedBut (productId in both is autoincremented) and relationship is there in both tables How to resolve this problem without adding ProductID in second Insert?SWati 

View 1 Replies View Related

Master - Details In Reverse

Mar 20, 2006

HI, I'm using Visual Web Developer and SQL Server 2005 Express Editions. I have a database with two tables, say AccountsTable and PersonsTable, with a one to many relationship respectively.
Given a particular selected record in PersonsTable, I need to look up the corresponding master record in AccountsTable. Here's what I've done:
SqlDataSource1 has a "SELECT * FROM PersonsTable" and a GridView1 which uses this as its datasource and the 'enable Selection' checkbox is On. This works fine.
Then, I create a second SqlDataSource2. When I click on the WHERE button in the Configure Data Source page, I have chosen the following parameters:
Column:PrimaryKeyField; Operator:=; Source=Control; ControlID=GridView1; Default Value='I left this blank' but the Value field shows GridView1.SelectedValue when I click the ADD button.
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:bizConnectionString %>"
SelectCommand="SELECT * FROM [AccountsTable] WHERE ([AccountNumber] = @AccountNumber)">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="AccountNumber" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

I have bound DetailsView1 to SqlDataSource2. When I run the page, the GridView1 is shown with Persons records OK. Then I click the 'Select' next to a record in the Gridview expecting the corresponding lookup to the master record (Account) to be shown in the DetailsView, but it does not show anything.
What am I doing wrong? Is there a better way of doing this?
Your help is much appreciated. Thank you.
PS. I could find Tutorials showing Master/Details retrieving records in a top down fashion (1:n), but I could not find the reverse (n:1)
 

View 6 Replies View Related

Backward Compatibility Details

Jul 14, 1999

Does anyone know if the enhanced data types (character length up to 8,000 bytes for some types) and the increase in the number of tables used in joins are available when using the 65 backward compatibility mode?

Many thanks in advance...

View 1 Replies View Related

View Transaction Log Details

Aug 31, 2004

Please may I have your assistance with the following
I’m struggling to view the transaction log for a database.
I’m using the following command structure

DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.

type - is the type of output:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length)

2 - very detailed information (plus object name, index name,
page id, slot id)

3 - full information about each operation

4 - full information about each operation plus hexadecimal dump
of the current transaction log's row.

-1 - full information about each operation plus hexadecimal dump
of the current transaction log's row, plus Checkpoint Begin,
DB Version, Max XACTID

Which I got from a web site, however the output does not make sense to me

Ideally I would like to analyse which SQL insert commands are predominantly using the log file

Any ideas how to do this or a tool that u recommend

Thanks in advance for your help
:confused:

View 4 Replies View Related

SET IDENTITY_INSERT: Devil In The Details...

Feb 13, 2006

Need to ask this, 'cause as ya'all know I'm a GUID sort of guy with a sever IDENTITY crisis.

Got a client that erroneously deleted some records from a table with an IDENTITY key. We have a backup that we can restore to a new db to isolate the records that need to be reloaded. Question is, when we set IDENTITY INSERT to ON temporarily to reload the affected records, does the db need to be in single-user mode, or will it go merrily on creating IDENTITY values for new records if the db is in use during our fix? It is a 24/7 production db with web users around the country/world.

View 4 Replies View Related

SELECT TOP 2 From Each Details Record

Apr 24, 2007

Hi everyone,

I am having a header table and details table and I want to display first 2 records against each header from details, whatever number of records are there in details against each header.


Example :
=======
Details table is as follows
HeaderID DetailsID
1 1
1 2
1 3
2 4
3 5
3 6
3 7
3 8


output should be:
TransDate SupplierName HeaderID DetailsID
1/1/2000 abc 1 1
1/1/2000 dsds 1 2
2/3/2003 fgd 2 4
2/4/2005 sdsd 3 5
1/1/2006 fgfdg 3 6


I am using the following query

SELECT H.TransDate, H.SupplierName, D.DetailsID FROM
Header H, Details D
WHERE H.HeaderID = D.DetailsID
AND D.DetailsID IN (SELECT TOP 2 DetailsID FROM Details WHERE HeaderID = H.HeaderID)


As I am dealing with very huge data it is taking very long time to execute.

Is there any better way to accomplish the task?

Thanks.

Riyaz

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved