|
|
Try General DataBase Forum..!
|
|
|
|
|
don't ask such question?
if u don't know anything just put your question(code if needed) and leave it to other?
by the way let me know your question.
Regards
Keyur Satyadev
|
|
|
|
|
|
Andy,
You should give the reference of your message while post the fast one. Other wise it is very difficult to understand 
|
|
|
|
|
Are you still havign trouble with your transaction log ?
I understand you want a permanent fix to your transaction log file growing, but there is no "fix" to your problem. This is normal operation of a database, each time a record is inserted/updated/deleted, there is a before and after image of the record written to the transaction log so that you can either rollback the transaction or apply re-do logs after a database crash. You can't prevent transaction logs from growing, you just need to know how to manage them.
For example, the most basic management of SQL db could be implemented as follows:
1) Set the recovery model to "simple"
2) Each night, perform a full backup of the database.
3) Truncate the transaction log file
Also, you may want to review the following TechNet article ...
How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235[^]
|
|
|
|
|
Thanks for your reply and a good article,
David Mujica wrote: You can't prevent transaction logs from growing
But if it increasing by certain amount then it's fine but it increased to 200 GB or more in few weeks time bringing it to 450GB or so which is just bizzar. We are using recovery model to full - could this be an issue ??
|
|
|
|
|
AndyInUK wrote: Any DBA here ??
Is this your question ? Please read forum guideline before asking any questions !
|
|
|
|
|
|
|
chandni patel wrote: jj
What does it mean ?
|
|
|
|
|
Hello guys,
I writing a data driven web application with .NET 3.5 using VB.NET Now I want to provide a quick option for users. I mean as soon as the user types in the search textbox, I want to filter records from my DB table where typed text LIKE or match the corresponding column in the table. Just as if one is performing search at Google.com but my own case is to get the filtered text from DB.
How do I go about this please?
Thanks for your usual support.
Tunsten
|
|
|
|
|
|
How can I remove the Request.QueryString without doing a Response.Redirect()
User click's on a link like:
http://localhost/__login.aspx?run=st
Now when the page is returned to the user I only whant the paht
http://localhost/__login.aspx
to show.
How can I do this without using a Response.Redirect("http://localhost/__login.aspx")
|
|
|
|
|
Hello
You can transfer the variable by other ways
For example,you can use a linkbutton and transfer the value by session.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 21:57pm.
|
|
|
|
|
Hi friends..
I have gridview and i fill data in gridview using ObjectDataSource.
I set properties EnablePaging and PageSize for displaying page numbers..
Now what i want to add is "First" and "Last" link on paging..So user can go to either first or last page of gridview by clicking on it..
So how to achieve that?
Thanks..
|
|
|
|
|
Ravi Mori wrote: Now what i want to add is "First" and "Last" link on paging..So user can go to either first or last page of gridview by clicking on it..
You can give here number, text or Image.
Try to Explore Pager Settings [ FirstPageText, LastPageText, NextPageText, FirstPageImageUrl etc.. ] for GridView.
|
|
|
|
|
Thanks a lot..
Pager Settings works for me..
|
|
|
|
|
Welcome !
|
|
|
|
|
Hi All
I am using Windows XP and want to upgrade IIS6 to IIS7 .
Is it possible to install IIS7 in windows Xp?
I need to use URL Rewrite Module 1.1 ...Please help me with this
Thanks in Advance
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
Seriously, is this[^] so difficult  
only two letters away from being an asset
|
|
|
|
|
hello,
is there anyway to simalate the work of the file upload without displaying the input file upload, while we got access to the client file.
in other word can we http post the client file and catch it from the server using httpfilecollection class.
regards,
Elie.
dghdfghdfghdfghdgh
|
|
|
|
|
You want to implement HTTPPost for file Upload ?
|
|
|
|
|
ellllllllie wrote: simalate the work of the file upload without displaying the input file upload,
if you just want to hide the control and do the functionality then its possible. Hide the control using CSS/Javascript , then use a button or image when this object is clicked you have to fire the click event of file control which will bring the Select file dialog. its simply File control customization
if you wish to similate the file selection through code(without user interaction) then this will not be possible due to security reasons. Better approach will be going for ActiveX
|
|
|
|
|
Hi,
I want to insert into the table using formview
for that here is my sample code
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
DeleteMethod="Delete" InsertMethod="Create" DataObjectTypeName=""
OldValuesParameterFormatString="{0}" SelectMethod="GetClients"
TypeName="ClientBLL" oninserting="ObjectDataSource2_Inserting">
</asp:ObjectDataSource>
and on oninserting event
protected void ObjectDataSource2_Inserting(object sender, ObjectDataSourceMethodEventArgs e)
{
IDictionary paramsFromPage = e.InputParameters;
Client_Info oClient_Info = new Client_Info();
oClient_Info.FirstName = e.InputParameters["F_Name"].ToString();
oClient_Info.Salutation = e.InputParameters["Salutation"].ToString();
oClient_Info.Address = e.InputParameters["Address"].ToString();
oClient_Info.City = e.InputParameters["City"].ToString();
oClient_Info.ClientInfo = e.InputParameters["Client_Info"].ToString();
oClient_Info.Company = e.InputParameters["Company"].ToString();
oClient_Info.Country = e.InputParameters["Country"].ToString();//e.InputParameters["Country"] is not returned, why i cannot understand
oClient_Info.Designation = e.InputParameters["Designation"].ToString();
oClient_Info.Fax = e.InputParameters["Fax"].ToString();
oClient_Info.MiddleName = e.InputParameters["M_Name"].ToString();
oClient_Info.LastName = e.InputParameters["L_Name"].ToString();
oClient_Info.Mobile = e.InputParameters["Mobile"].ToString();
oClient_Info.Phone = e.InputParameters["Phone"].ToString();
oClient_Info.Pincode = e.InputParameters["Pincode"].ToString();
oClient_Info.PrimaryEmail = e.InputParameters["Pri_Email"].ToString();
oClient_Info.SecondaryEmail = e.InputParameters["Sec_Email"].ToString();
oClient_Info.State = e.InputParameters["State"].ToString();
oClient_Info.IsDeloitteClient = Convert.ToByte(e.InputParameters["Deloitte_Client"]);//e.InputParameters["Deloitte_Client"] is not returned, why i cannot understand
oClient_Info.IsViewableByOthers = Convert.ToByte(e.InputParameters["Viewable_By_Others"]);// this one too left out
//paramsFromPage.Clear();
paramsFromPage.Add("oClient_Info", oClient_Info);
}
but e.InputParameters returns only 17 parameters but it should return 20 parameters. The parameter Country(varchar) ,Deloitte_Client(bit), Viewable_By_Others(bit) left out by objectdatasource why it is so ?
modified on Monday, October 12, 2009 6:35 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
