Using this system function (::fn_dblog(null,null)) you find out how many transactions are been confirmed in your .LDF. Although by means of another system function you can see further information, i mean statistical ones.
Any help would be very appreciated.
I have know this error but have completely forgotten how to take care of it. How do I pass the integer values to the SQL statement?
ERROR: Syntax error converting the nvarchar value 'Label' to a column of data type int.
WHERE (LinkInfo.L_State = @State) AND (LinkInfo.CG_ID > @CatIDLow) AND (LinkInfo.CG_ID > @CatIDHigh)
<SelectParameters> <asp:ControlParameter ControlID="TextBox1" Name="State" PropertyName="Text" /> <asp:ControlParameter ControlID="Label2" DefaultValue="0" Name="CatIDLow" PropertyName="Text" /> <asp:ControlParameter ControlID="Label3" DefaultValue="1899" Name="CatIDHigh" PropertyName="Text" /></SelectParameters>
CODE BEHIND
public partial class TopandBottomSelect : System.Web.UI.Page{ int CG_IDlower; int CG_IDupper; protected void Page_Load(object sender, EventArgs e) { } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { if (RadioButtonList1.SelectedIndex == 0) { CG_IDlower = 0; CG_IDupper = 1900; Label1.Text = Convert.ToString(CG_IDlower); Label2.Text = Convert.ToString(CG_IDupper); } else { CG_IDlower = 1899; CG_IDupper = 3000; Label1.Text = Convert.ToString(CG_IDlower); Label2.Text = Convert.ToString(CG_IDupper); } GridView1.DataBind(); }}
Thank you
Hi,Can you guys see if there's a solution to this problem?I have a database from which I have to read each record and processthat record. New records are being added all the time, so I need to goback and check for new records and process them.However:-- there is no 'identity' column in the database design (so I cannotkeep track of the last record read by use of a numeric variable)-- I am not allowed to update the database (so I cannot flag therecords I have read).My problem is: how can I know which records I have already read andwhich ones I haven't read yet? I don't want to process records twiceand don't want to miss any records.Is there a known solution to this problem? Any ideas?Thanks.
View 12 Replies View RelatedHello,
A while ago I installed SQL CE on my decive. Unfortunately, it crapped out at one point so I'm reinstalling what needs to be put back on. I'm pretty sure I just used the CAB files to do this (but I might be mistaken). In any case, I remember there being an application that allowed me to do queries, browse data, etc. on my device's databases... I'm pretty sure it was just something included with SQL CE.
I already have the CF installed. I have all of the SQL CE CABs installed as well (I think)... but for some reason I simply cannot remember what CAB or other installation that would contain the browser, query creation thing, and so on...
Anyone have any idea what I'm rambling on about? Thanks!
What is the simple way to remember Primary and foreign key?
Why is the ID column in a table declared as a integer datatype?
I have written a script to GENERATE Random Password. But I want to modify that to a some kind of password which is little easy to remember!
I have seen some of the online sites where they generate passwords which are easy to remember and having some way to remember them,
my script:-
declare @db_pswd nvarchar(4000);
declare @len1 int = 16,
@min tinyint = 40,
@range tinyint = 74,
@exclude varchar(50) = '11cdtyuXR#0:;<=>?@O[]`^/abfty#$%^&1234567890*',
@output varchar(500)
[Code] .....
Hi all,
I have a report in which the user can drill down on data. However when the user changes a parameter and reruns the report, all nodes are collapsed again. Is it possible to let the report keep the expansion state of nodes after pressing the 'view report' button again?
Regards,
Henk
I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.
View 3 Replies View RelatedWhat is the easiest way to remember the definitions of clustered and non clustered indexes.
View 9 Replies View RelatedBoth the OLE DB Connection and ADO.Net Connection in SSIS Package does not remember password.
Im connecting to a SQL Server 2000 box using its sa password as test.
The SSIS package runs fine when you first set up the connection in bids
The bottom line is that SSIS keeps forgetting the password I feed into
the two Connections that I'm using. I double-click a connection,
type the password in, check "Save my password" and hit "OK" but the
password disappears from there whenever I run the package or
double-click the connection again.
is there any known workaround for this issue as I would like to schedule my SSIS package using a SSIS Step in a SQL Server 2005 Agent job.
the only thing I found when googling this error was link below but the workaround described here is a little harsh
http://www.developersdex.com/sql/message.asp?p=1921&ID=%3C1146409399.447345.7470@j73g2000cwa.googlegroups.com%3E
thanks in advance
Dave
the box SSIS is running on is Windows 2003 Server Standard Edition latest service pack
SQL Server 2005 (no service packs )
On the login prompt for Report Server, there is a checkbox option to "Remember my Password." I check this, login successfully... but when returning to the Report Server, I am again prompted for the password, although the user name is saved. No matter how many times I do this, the password will not save in IE7. I have tried this on 3 different computers with IE7. In IE 6, I do not even get the checkbox as an option, just the user name/password prompt. In Firefox, the password saves fine. Any ideas what would be causing this?
Thanks,
Brian