binnacles

Is there a way to view binnacles (or details of
transactions) in SQL Server 2000
Hi,
Did you meant reading the transaction log file;
There is an undocumented command (DBCC LOG) that lets you see the records in
transaction log.
Here is an sample:
DBCC LOG('DBNAME',2)
or there is good tool from Lumigent called Log explorer
www.lumigent.com
Thanks
Hari
MCDBA
"Juan" <anonymous@.discussions.microsoft.com> wrote in message
news:177e901c418ea$f19f4f60$a501280a@.phx.gbl...
> Is there a way to view binnacles (or details of
> transactions) in SQL Server 2000

Binding error

Hi all

I have a form view which uses a SQL data source control to retrieve it's data from the sql express database

the form view is used for view,edit,delete and insert data into the database

in the insert mode I have two dropdownlists, where the second one is depending on the first one to retrieve the correct data from the data baseBUT

when selecting a value in the first dropdownlist it give me the following erro:

Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.

Please How can do this

any help is appriciated

bye

You cannt do this using this method. There are many work arrounds out there, but the easiest I believe is the CascadingDropDown control which is part of the AJAX.NET Control Toolkit.

http://www.asp.net/ajax/ -- Install the AJAX.NET FRAMEWORK AND configure your site to use it.

You will need to:

1.) First Create a Web Service Class like as followed:

using System;using System.Web;using System.Collections;using System.Configuration;using System.Web.Services;using System.Web.Services.Protocols;using System.Collections.Generic;using AjaxControlToolkit;using System.Data;using System.Data.SqlClient;using System.Web.Script.Services;/// <summary>/// Cascading DropDownList AjaxControlToolkit Web Service/// </summary>[WebService(Namespace ="http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)][System.Web.Script.Services.ScriptService]public class DataService : System.Web.Services.WebService { private string connectionString =ConfigurationManager.ConnectionStrings["CarrierDBConnectionString"].ConnectionString; public DataService () {} [WebMethod] [System.Web.Script.Services.ScriptMethod()] public CascadingDropDownNameValue[] GetCarriers(string knownCategoryValues, string category) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("CARRIER_SELECT_ALL", conn)) { cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { values.Add(new CascadingDropDownNameValue((string)dr["NAME"], dr["ID"].ToString())); } } } return values.ToArray(); } [WebMethod] [System.Web.Script.Services.ScriptMethod()] public CascadingDropDownNameValue[] GetSubsidiariesByCarrierID(string knownCategoryValues, string category) { List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("CARRIER_SELECT_SUBSIDIARY_BYID", conn)) { string[] categoryValues = knownCategoryValues.Split(':', ';'); int id = Convert.ToInt32(categoryValues[1]); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@.id",id); conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.HasRows) { while (dr.Read()) { values.Add(new CascadingDropDownNameValue((string)dr["NAME"], dr["ID"].ToString())); } } } } }return values.ToArray(); }}

2.) Create the Actual Web Service

Click on the Project in the 'Solution Explorer' and 'Add New Item' and then select Web Service (for instance in this example: DataService.asmx)

3.) Hook up your ajax controls and dropdownlist

<asp:UpdatePanel ID="updatePnlInsert" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlCarrierInsert" runat="server" AutoPostBack="True" Width="100%" DataSourceID="sqldsCarriersInsert" DataTextField="NAME" DataValueField="ID" SelectedValue='<%# Eval("CARRIER_ID") %>' AppendDataBoundItems="true">
<asp:ListItem Value="" Text="<select carrier>" />
</asp:DropDownList>
<br />
<asp:SqlDataSource ID="sqldsCarriersInsert" runat="server" ConnectionString="<%$ ConnectionStrings:CarrierDBConnectionString %>"
SelectCommand="CARRIER_SELECT_ALL" SelectCommandType="StoredProcedure" />

<asp:DropDownList ID="ddlSubInsert" runat="server" Width="100%" /><br />
<cc1:CascadingDropDown ID="cddCarrierInsert" runat="server"
TargetControlID="ddlSubInsert"
ParentControlID="ddlCarrierInsert"
Category="CARRIER"
LoadingText="[Loading Subsidiaries...]"
PromptText="<select subsidary>"
ServiceMethod="GetSubsidiariesByCarrierID"
ServicePath="DataService.asmx"
SelectedValue='<%# Eval("SUBSIDIARY_ID") %>'>
</cc1:CascadingDropDown>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="ddlCarrierInsert" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>

Hope this helps.

BIDS Variable Window Disappeared

I am experiencing a weird problem with SSIS development in BIDS...
When I click "View --> Other Windows --> Variables", the window doesn't show
up.
Has anyone else had this issue? If so did you solve it, and how?
Thanks!Hello Dan,
The actual window itself or the ability to edit variables?
Are you sure the window isn't already open just tabbed with the toolbox or
something like that?
What build are you running?
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

> I am experiencing a weird problem with SSIS development in BIDS...
> When I click "View --> Other Windows --> Variables", the window
> doesn't show up.
> Has anyone else had this issue? If so did you solve it, and how?
> Thanks!
>|||Allan,
Thanks for the reply.
The window itself doesn't show up. I have the window in auto-hide on the
left (with the toolbox on the left). When I traverse the menu (as stated) a
blank box appears as if it is trying to show me what I've asked.
I can get to (and edit) the variables by using the package explorer tab -
just not from the variables window.
Here are the builds of the different products I'm using:
-Microsoft Visual Studio Team Edition for Database Professionals Version
2.0.50727.251
-Microsoft Visual Studio 2005 Team Explorer
Version 8.0.50727.762
-Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00
Thanks again for the help...
"Allan Mitchell" wrote:

> Hello Dan,
> The actual window itself or the ability to edit variables?
> Are you sure the window isn't already open just tabbed with the toolbox or
> something like that?
> What build are you running?
>
> --
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
>
>

BIDS Variable Window Disappeared

I am experiencing a weird problem with SSIS development in BIDS...
When I click "View --> Other Windows --> Variables", the window doesn't show
up.
Has anyone else had this issue? If so did you solve it, and how?
Thanks!
Hello Dan,
The actual window itself or the ability to edit variables?
Are you sure the window isn't already open just tabbed with the toolbox or
something like that?
What build are you running?

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

> I am experiencing a weird problem with SSIS development in BIDS...
> When I click "View --> Other Windows --> Variables", the window
> doesn't show up.
> Has anyone else had this issue? If so did you solve it, and how?
> Thanks!
>
|||Allan,
Thanks for the reply.
The window itself doesn't show up. I have the window in auto-hide on the
left (with the toolbox on the left). When I traverse the menu (as stated) a
blank box appears as if it is trying to show me what I've asked.
I can get to (and edit) the variables by using the package explorer tab -
just not from the variables window.
Here are the builds of the different products I'm using:
-Microsoft Visual Studio Team Edition for Database Professionals Version
2.0.50727.251
-Microsoft Visual Studio 2005 Team Explorer
Version 8.0.50727.762
-Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00
Thanks again for the help...
"Allan Mitchell" wrote:

> Hello Dan,
> The actual window itself or the ability to edit variables?
> Are you sure the window isn't already open just tabbed with the toolbox or
> something like that?
> What build are you running?
>
> --
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
>

BI- Collaboration and reports

I would like to get ideas on how how to enable report users not only
just view reports but also take action after viewing a report by
collaborating with collegues. Here's a use case-
- A project mangager (PM) logs into a portal and view a projects
status report listing current status of all projects managed by him.
- He finds that one of the projects is falling behind due to a pending
task that Peter is working on.
******Collaboration piece******
- In the portal itself the PM enter in a comment for Peter to clarify
the task's status.
- Peter logs into the portal and sees the PMs' comments. In response
he adds a comment that his task completion is dependent on the the
CEO approving a pending PO.
- PM logs into the portal opens the same report and sees Peters
comments. He updates his weekly project issues report to highlight
this dependency.
I have seem Microsoft Performance Point demos that exibit similar
collaboration features. I am not sure if the collaboration piece
requires Performance Point or is it a Sharepoint feature. Any ideas on
how to implement, what technologies to use would be appreciated.
Regards,
KenIt is as you say a feature of PerformancePoint Server.
You could also check out Analyzer by StrategyCompanion.
"Ken" <raidken@.yahoo.com> wrote in message
news:3dfe603c-e258-40c4-939a-8405951dbcd7@.p73g2000hsd.googlegroups.com...
>I would like to get ideas on how how to enable report users not only
> just view reports but also take action after viewing a report by
> collaborating with collegues. Here's a use case-
> - A project mangager (PM) logs into a portal and view a projects
> status report listing current status of all projects managed by him.
> - He finds that one of the projects is falling behind due to a pending
> task that Peter is working on.
> ******Collaboration piece******
> - In the portal itself the PM enter in a comment for Peter to clarify
> the task's status.
> - Peter logs into the portal and sees the PMs' comments. In response
> he adds a comment that his task completion is dependent on the the
> CEO approving a pending PO.
> - PM logs into the portal opens the same report and sees Peters
> comments. He updates his weekly project issues report to highlight
> this dependency.
> I have seem Microsoft Performance Point demos that exibit similar
> collaboration features. I am not sure if the collaboration piece
> requires Performance Point or is it a Sharepoint feature. Any ideas on
> how to implement, what technologies to use would be appreciated.
> Regards,
> Ken|||Ken,
If this already exists in your portal you can add hyper links to you report.
AK Code Rat.
"Ken" wrote:
> I would like to get ideas on how how to enable report users not only
> just view reports but also take action after viewing a report by
> collaborating with collegues. Here's a use case-
> - A project mangager (PM) logs into a portal and view a projects
> status report listing current status of all projects managed by him.
> - He finds that one of the projects is falling behind due to a pending
> task that Peter is working on.
> ******Collaboration piece******
> - In the portal itself the PM enter in a comment for Peter to clarify
> the task's status.
> - Peter logs into the portal and sees the PMs' comments. In response
> he adds a comment that his task completion is dependent on the the
> CEO approving a pending PO.
> - PM logs into the portal opens the same report and sees Peters
> comments. He updates his weekly project issues report to highlight
> this dependency.
> I have seem Microsoft Performance Point demos that exibit similar
> collaboration features. I am not sure if the collaboration piece
> requires Performance Point or is it a Sharepoint feature. Any ideas on
> how to implement, what technologies to use would be appreciated.
> Regards,
> Ken
>

Beta 2 Management studio navigation

A couple of questions:
-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
-- Where do you go to set up a new DTS script if it is not done with the wizard?
Thanks.
If you have a question about SQL Server 2005 Beta 2, please ask it in
the newsgroups that have been established for it. You can find out how
to access those newsgroups where you got the beta version of SQL Server
2005.
Steve Kass
Drew University
bogus_boy wrote:

>A couple of questions:
>-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
>-- Where do you go to set up a new DTS script if it is not done with the wizard?
>Thanks.
>

Best way to view reports from a webpage

I can view a report created in SSRS by using a url or by using an Reportviewer control in asp.net 2.0 what is the best way to view reports from a webpage?

you can use the report viewer control in your web page and render the reports throught it for more info read this article

http://www.gotreportviewer.com/

best way to preserve all dependencies

I know ive asked this before and created seperate publications for tables
and views,etc in order to avoid conflicts such as view being created before
the table,etc..
What do u guys prefer as the best method to handle this, especially if
reinitialize a publication that has tables in it and it results in error as
the table properties has a drop to it and hence would not be able to drop as
a view is present..
There must be better ways to handle all of this . If only I could create one
publication for all objects belonging to one database ..if only all of the
dependencies were ordered.
Hassan,
like you, I have separate publications - one for tables, one for views and
one for UDFs.
AFAIK, dropping a table should be fine unless the view has been created
using schemabinding.
For those cases where dependency info of views is incorrect, sp_refreshview
is sometimes useful; sometimes use sp_addscriptexec; sometimes just add the
view manually on the subscriber when there is connectivity and there is only
one subscriber.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Best way is table/view

Hello guys,
Thanks for you kind help in advance.
Actually I want to know, which is the best way to develop a report is.
From a view or from table.
And how can I edit query (from show query)?
dipitI prefer to use views, mostly because if the database structure or table/column names are to change it is easy to modify the view so that the reports are unaffected.

I find it gives more flexibility, and selections/projections can be performed on the database side - I try to avoid using Crystal to perform joins where possible.

I haven't looked too much into the "show query" until now; however the Select [column names] probably comes from whatever has been dragged onto the report, while the Where [clauses] come from whatever you have entered into Report -> Selection Formulas -> Record.