Attempt To Fetch Logical Page 605
Aug 1, 2005
Hi all,
I'm not too sure if this should be in this forum or in the admin one, but since DBCC is required to fix this error, so I might as well put it here. What I'm having is this error msg:
Attempt to fetch logical page in database 'DBName' belongs to object 'TableName', not to object 'TableName'.
Error: 605, Severity: 21, Stat: 1
I've checked BOL and it said that DBCC CheckTable on the 2nd table will fix this issue (or by using CheckDB), that is fine but what I want to know is why is this happening, and how to prevent it, I have a cluster server holding this DB, we have disabled write cache and we have tried to fail over to another node, but this issue does happen again (more often now), its running on SQL 2000 with sp4. Anyone got any ideas of why this is happening? and how to prevent it?
Thanks
View 20 Replies
ADVERTISEMENT
Aug 27, 2001
Any idea what this error is??
Thanks.
Attempt to fetch logical page (3:8360) in database 'XYZ' belongs to object '1934538212', not to object 'product'. [SQLSTATE HY000] (Error 605). The step failed.
View 1 Replies
View Related
May 16, 2008
I have SQL 2005 with sp1 (can't get sp2 to install yet), with a failover cluster (that works, but hasn't needed to be used in awhile), and the data resides on a, new, 1TB SAN array.
We were not aware one of our tables were corrupt until the last rotation of our backup included the corrupt table. So restoring isn't an option. rebuilding the table is a last resort. I would like to understand how this happened, and how to prevent it.
The error when trying to do anything to the table, read, edit, drop, etc:
Attempt to fetch logical page (1:27232) in database 23 failed. It belongs to allocation unit 72057594049069056 not to 281474980642816.
the first allocation unit # is sysobjvalues, and the second is g2_pluginparametermap
the table that the error happens on is g2_Item.
CHECKDB returns this error:
Msg 605, Level 12, State 3, Line 1
Attempt to fetch logical page (1:27232) in database 22 failed. It belongs to allocation unit 72057594049069056 not to 281474980642816.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
(tempdb is only 14megs, the drive has almost 30 gigs of free space. the db in question is only 300 megs)
dbcc page(db,1,27232,1)
returns nothing
I thought for sure I had manually made a backup quite awhile ago when I knew this table was fine. I restored the backup to a new database and am having the same exact problem.
View 19 Replies
View Related
Jul 4, 2007
Hi all,
I ecountered this error serveral times.
"Attempt to fetch logical page (3:25921) in database 'DOCUMENT' belongs to object '6357108', not to object 'SYS_Documents'."
also, I captured this error and I'm not sure if this had caused the error above.
"Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
Thanks in advace,
Larry
View 1 Replies
View Related
Jan 18, 2007
Hi,
we consistently have logical page errors on one of our SQL Servers.
The output from CHECKDB is shown below. Any ideas why this keeps happening. We recently replaced the disk thinking this would solve the problem.
DBCC results for 'TMP_tbl_Pay_Totals'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:391469) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
AND later on
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398376) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398377) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398378) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398379) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398448) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398449) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398450) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398451) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:398452) allocated to object ID 1412968160, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Final bit
CHECKDB found 0 allocation errors and 11 consistency errors in database 'ISS'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ISS ).
Any help or ideas much appreciated.
View 4 Replies
View Related
Jun 24, 1999
We tried to restore an empty database from a backup and got:
'Load database encountered an invalid logical page number' error.
This then set the database as 'loading'
Anyone got any ideas?
We aren't exactly sure how big the first database was when the backup was done but if the new database isn't big enough to contain the backed up data, wouldn't we get a more meaningful error?
Janet
View 2 Replies
View Related
May 29, 2008
I have a problem with a database in SQL Server 2000 8.00.194. I have read similar cases in the forum, but in all the cases the expert paulrandal requests sent it a detail of dbcc page ().
By mistake the user try to restore a backup on this database, the user realized the error and press the "stop" button of the SQL Server, the process stopped but the database is not recognized from SQL Server 2000.
I have opened the file. mdf and the previous data are inside.
I attach the database in "DBO Use Only" state using the tool "REBUILD_LOG"
when I execute DBCC CHECKDB ('<db_name>') I have the same symptoms that in the post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271
Attemp to fecth logical page (1:8945) in data base belong to object 'sysindexes', not to object 'syscolumns'
But I don't understand like it has been solved finally.
Does is it possible to recover these data?.
It is not obligatory it recovered all the database, only some tables to complete manually on to backup of this database.
I try BCP, but I have the same error
Thank you very much for your collaboration.
View 4 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Nov 28, 2006
Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.
When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.
I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)
I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.
Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter€¦
View 2 Replies
View Related
Nov 13, 2007
I am hosting my website with a web hosting company on the web. My web application readsdata from a SQL server 2005 database. So far I have been able to establish a connection to the database, but when I attempt to query data from a table, I a get an error message.I can't figure out what I am doing wrong here.basically I just want to read data from acolumn in the database and to store it into a multi-line textbox control. I am using someinline sql for the call. Can someone help me out here?
public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { mySqlConnection = new SqlConnection(ConnectionStringConst); mySqlConnection.Open(); try { // Database is named "Torsion", Table I am querying is named "Content" SqlCommand cmd = new SqlCommand("SELECT * FROM [Torsion].[dbo].[Content] ORDER BY [Section] DESC", mySqlConnection); rdr = cmd.ExecuteReader(); ListBox1.DataSource = rdr[0]; ListBox1.DataTextField = "HLContent"; // HLContent is the first column in my database ListBox1.DataBind(); // I want to store HLContent into ListBox1 control } catch { throw;} finally { mySqlConnection.Close(); mySqlConnection.Dispose(); } }}-----------------------------------------ERROR_MESSAGE_BELOW----------------------------
Server Error in '/' Application.
Invalid attempt to read when no data is present.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[InvalidOperationException: Invalid attempt to read when no data is present.]
System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) +137
System.Data.SqlClient.SqlDataReader.get_Item(Int32 i) +7
_Default.Button1_Click(Object sender, EventArgs e) +167
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
View 3 Replies
View Related
Mar 7, 2006
Hello,The code below is my first attempt at sql server 2005 and asp.net v2.0. Can anyone let me know what they think of it, ie things that are bad and should be changed?thanks.csusing System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Web.Configuration;using System.Net.Mail;public partial class register : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (Session["ID"] == null) { //notlogged in uxRegisterPanel.Visible = true; uxSuccessPanel.Visible = false; uxExistPanel.Visible = false; } else { //logged in uxRegisterPanel.Visible = false; uxSuccessPanel.Visible = false; uxExistPanel.Visible = true; } } protected void submit_Click(object sender, EventArgs e) { int anyerror = 0; int receiveUpdate = 0; if (uxNameText.Text.Length < 3) { uxNameLabel.Text = "*Must be 3 or more characters long"; anyerror = 1; } else { uxNameLabel.Text = ""; } if (uxPassText.Text.Length < 6) { uxPasswordLabel.Text = "*Must be at least 6 characters"; anyerror = 1; } else { uxPasswordLabel.Text = ""; } if (uxUpdateCheck.Checked) { receiveUpdate = 1; } if (anyerror == 0) //all fine submit to db to check that username/email does not exist { //new connection string connectionString = WebConfigurationManager.ConnectionStrings["Pubs"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionString); try { myConnection.Open(); SqlCommand memberCheck = new SqlCommand("memberCheck", myConnection); memberCheck.CommandType = CommandType.StoredProcedure; memberCheck.Parameters.Add("@name", SqlDbType.VarChar); memberCheck.Parameters["@name"].Value = uxNameText.Text; SqlDataReader memberCheckReader; memberCheckReader = memberCheck.ExecuteReader(); if (memberCheckReader.HasRows) { //if username exists uxNameLabel.Text = "<br />" + uxNameText.Text + " already exists, choose another or if this is you <a href='/sendPassword.aspx'>send your password</a>."; anyerror = 1; } else { uxNameLabel.Text = ""; } memberCheckReader.Close(); SqlCommand memberECheck = new SqlCommand("memberECheck", myConnection); memberECheck.CommandType = CommandType.StoredProcedure; memberECheck.Parameters.Add("@email", SqlDbType.VarChar); memberECheck.Parameters["@email"].Value = uxEmailText.Text; SqlDataReader memberECheckReader; memberECheckReader = memberECheck.ExecuteReader(); if (memberECheckReader.HasRows) { //if email exists uxEmailLabel.Text = "<br />" + uxEmailText.Text + " already exists, have you <a href='/sendPassword.aspx'>forgoten your password</a>?"; anyerror = 1; } else { uxEmailLabel.Text = ""; } memberECheckReader.Close(); if (anyerror == 0) { //insert member details SqlCommand memberInsert = new SqlCommand("memberInsert", myConnection); memberInsert.CommandType = CommandType.StoredProcedure; memberInsert.Parameters.Add("@name", SqlDbType.VarChar); memberInsert.Parameters["@name"].Value = uxNameText.Text; memberInsert.Parameters.Add("@email", SqlDbType.VarChar); memberInsert.Parameters["@email"].Value = uxEmailText.Text; memberInsert.Parameters.Add("@password", SqlDbType.VarChar); memberInsert.Parameters["@password"].Value = uxPassText.Text; memberInsert.Parameters.Add("@receiveUpdate", SqlDbType.SmallInt); memberInsert.Parameters["@receiveUpdate"].Value = receiveUpdate; SqlDataReader memberInsertReader; memberInsertReader = memberInsert.ExecuteReader(); memberInsertReader.Read(); //store session stuff Session["Name"] = uxNameText.Text; Session["ID"] = memberInsertReader["ident"].ToString(); Session["Access"] = 0; //send activation email MailMessage email = new MailMessage("noreply@name.com", uxEmailText.Text); email.Subject = "Action needed to activate your account at cookbuzz.com"; email.Body = "Please follow the link below to activate your account" + memberInsertReader["ident"].ToString(); SmtpClient mailClient = new SmtpClient(); mailClient.Host="smtp.ntlworld.com"; mailClient.Send(email); memberInsertReader.Close(); uxRegisterPanel.Visible = false; uxSuccessPanel.Visible = true; uxSentTo.Text = uxEmailText.Text; } } catch (Exception err) { Response.Write("Error:" + err); } finally { myConnection.Close(); } } }}.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeFile="register.aspx.cs" Inherits="register" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <link href="StyleSheet.css" rel="stylesheet" type="text/css" /> <title>Cook Buzz ::</title></head><body> <form id="form1" runat="server"> <h1>Register</h1> <asp:Panel ID="uxRegisterPanel" runat="server"> <table> <tr> <td>User name: </td> <td><asp:TextBox ID="uxNameText" runat="server" MaxLength="50"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="uxNameText" CssClass="error" Display="Dynamic" ErrorMessage="*Input a username"></asp:RequiredFieldValidator> <asp:Label ID="uxNameLabel" runat="server" CssClass="error"></asp:Label></td> </tr> <tr><td colspan="2"><div class="small">An activation code will be sent to the address below</div></td></tr> <tr> <td>Email address: </td> <td><asp:TextBox ID="uxEmailText" runat="server" MaxLength="100"></asp:TextBox> <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="uxEmailText" ErrorMessage="*Invalid email" ValidationExpression="w+([-+.']w+)*@w+([-.]w+)*.w+([-.]w+)*" CssClass="error" Display="Dynamic"></asp:RegularExpressionValidator><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="uxEmailText" CssClass="error" Display="Dynamic" ErrorMessage="*Input an email"></asp:RequiredFieldValidator> <asp:Label ID="uxEmailLabel" runat="server" CssClass="error"></asp:Label></td> </tr> <tr> <td>Confirm Email: </td> <td><asp:TextBox ID="uxCEmailText" runat="server" MaxLength="100"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="uxCEmailText" CssClass="error" Display="Dynamic" ErrorMessage="*Input an email"></asp:RequiredFieldValidator> <asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="uxEmailText" ControlToValidate="uxCEmailText" ErrorMessage="*Emails dont match" CssClass="error"></asp:CompareValidator></td> </tr> <tr><td colspan="2"><div class="small">Passwords must be 6 or more characters in length</div></td></tr> <tr> <td>Password:</td> <td><asp:TextBox ID="uxPassText" runat="server" TextMode="Password" MaxLength="50"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="uxPassText" CssClass="error" Display="Dynamic" ErrorMessage="*Input a password"></asp:RequiredFieldValidator> <asp:Label ID="uxPasswordLabel" runat="server" CssClass="error"></asp:Label></td> </tr> <tr> <td>Confirm Password: </td> <td><asp:TextBox ID="uxCPassText" runat="server" TextMode="Password" MaxLength="50"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="uxCPassText" CssClass="error" Display="Dynamic" ErrorMessage="*Input a password"></asp:RequiredFieldValidator> <asp:CompareValidator ID="CompareValidator2" runat="server" ControlToCompare="uxPassText" ControlToValidate="uxCPassText" CssClass="error" ErrorMessage="*Passwords dont match" Type="String" ValueToCompare="Text"></asp:CompareValidator></td> </tr> <tr><td></td><td> <asp:CheckBox ID="uxUpdateCheck" runat="server" Checked="True" Text="Receive email updates" /></td></tr> <tr> <td></td> <td> <br /> <asp:Button ID="submit" runat="server" Text="Register" OnClick="submit_Click" /><br /> <div class="small">By clicking register you argree to the <a href="terms.aspx">Terms & Conditions</a>.<br /> We take privacy seriously, please read our <a href="privacy.aspx">Privacy Policy</a>.</div></td> </tr> </table> </asp:Panel> <asp:Panel ID="uxExistPanel" runat="server"> You are already registered and logged in.<br /> <br /> If you are waiting for an email to activate your account then you can <a href="resendactivation.aspx"> resend activation email</a>.</asp:Panel> <br /> <asp:Panel ID="uxSuccessPanel" runat="server"> You are now registered and logged in.<br /> <br /> Before you can begin to use your account you need to click the activation link sent to <asp:Label ID="uxSentTo" runat="server"></asp:Label>. Please be aware that it may be delivered to junk mail folders.<br /> <br /> If you do not receive an activation email you can <a href="#">resend the activation email</a> or <a href="#">change your email address</a>.</asp:Panel> </form></body></html>stored procsset ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[memberInsert] @name varchar(50), @password varchar(50), @email varchar(100), @receiveUpdate smallintAS BEGIN SET NOCOUNT ON; Insert into Member(Name,Password,Email,JoinDate,LastActivity,groupID,receiveUpdate) Values(@name,@password,@email,getdate(),getdate(),0,@receiveUpdate) DECLARE @code varchar(4) SET @code = round(rand()*8999,0)+1000 select @@identity as ident, @code as code INSERT into activation(memberID,code) values(@@identity,@code)set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[memberCheck] ( @name varchar(50) )ASBEGIN /* SET NOCOUNT ON */ --check to see if username is in use--SELECT name from Member where Name = @nameENDRETURN
View 4 Replies
View Related
Dec 3, 2006
I have a standard Login ASP.NET 2.0 control on a login Page, a LoginName and LoginStatus controls on the member's page.
once the user login successfully I am redirecting the user to Member.aspx page. The following is my machine configuration
Windows XP Pro Service Pack2
IIS 5.1
SQL Server 2000
visual Studio 2005
DISABLE ANONMYOUS ACCESS IN IIS
ENABLE WINDOWS AUTHENTICATION
I am Using form authentication, and I am getting following error "Your login attempt was not successful. Please try again".
To debug,I am displaying the follwoing properties
Membership.ValidateUser(Login1.UserName, Login1.Password) : - True
HttpContext.Current.User.Identity.Name : - // is blank
FormsAuthentication.FormsCookieName : - SqlAuthCookie
FormsAuthentication.CookieDomain :- // is blank
FormsAuthentication.CookieMode :- UseCookies
FormsAuthentication.CookiesSupported :- True
FormsAuthentication.DefaultUrl :- /webIT/default.aspx
FormsAuthentication.EnableCrossAppRedirects :- False
FormsAuthentication.FormsCookieName :- SqlAuthCookie
FormsAuthentication.FormsCookiePath :- /
FormsAuthentication.LoginUrl :- /webIT/ASPX/Security/Login.aspx
FormsAuthentication.RequireSSL :- False
FormsAuthentication.SlidingExpiration :- True
User.Identity.IsAuthenticated :- False
User.Identity.Name :- // is blank
User.Identity.AuthenticationType :- // is blank
Is it something to do with the security of Windows XP Pro ? or a IIS 5.1? Any help will be highly appreciated.
Login.aspx file is
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:Login ID="Login1" runat="server" DestinationPageUrl="~/Member.aspx" RememberMeSet="True">
</asp:Login>
</form>
</body>
</html>
Member.aspx is
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Member.aspx.cs" Inherits="Member" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
You are back ........
<asp:LoginName ID="LoginName1" runat="server" />
<asp:LoginStatus ID="LoginStatus1" runat="server" LogoutAction="Redirect" LogoutPageUrl="~/Login.aspx" />
</div>
</form>
</body>
</html>
Member.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Member : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("<br/>Page.User.Identity.Name: " + Page.User.Identity.Name);
Response.Write("<br/>Page.User.Identity.IsAuthenticated: " + Page.User.Identity.IsAuthenticated);
Response.Write("<br/>Page.User.Identity.AuthenticationType: " + Page.User.Identity.AuthenticationType);
}//end
}
Web.config file is
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<clear />
<add name="SQL_CONNECTION_STRING"
connectionString="server=Sample;database=sample;user id=sa;password=temp;"
providerName="System.Data.SqlClient"
/>
</connectionStrings>
<system.web>
<authentication mode="Forms">
<forms name="SqlAuthCookie"
loginUrl="~/ASPX/Security/Login.aspx"
timeout="60"
domain=""
path="/"
protection="All"
requireSSL="false"
slidingExpiration="true"
defaultUrl="default.aspx"
cookieless="UseCookies"
enableCrossAppRedirects="false"
/>
</authentication>
<!-- Deny Access to anonymous user -->
<authorization>
<deny users="?" />
<allow users="*"/>
</authorization>
<!-- SQL Server Memebership Provider's-->
<membership defaultProvider="SqlProvider"
userIsOnlineTimeWindow="30">
<providers>
<clear />
<add connectionStringName="SQL_CONNECTION_STRING"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
passwordFormat="Hashed"
applicationName="webIT"
name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
<!-- SQL Server RoleManager Provider's-->
<roleManager enabled="true"
cacheRolesInCookie="true"
cookieName=".ASPXROLES"
defaultProvider="SqlRoleProvider">
<providers>
<clear />
<add connectionStringName="SQL_CONNECTION_STRING"
applicationName="webIT"
name="SqlRoleProvider"
type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>
</configuration>
NOTE : The applicationName is same in web.config as well as in the aspnet_Applications table in SQL Server 2000 membership database.
View 22 Replies
View Related
Apr 29, 2007
What if I attempt to creat a (merge) publication while the production sql server is online and active?
From another point of view, is there any drawback if I try to create (merge) publication while the tables are being used by users?
Thanks
Ekrem Önsoy
View 5 Replies
View Related
May 11, 2007
I have a C# application that connects to a SQL Server Express 2005 instance. One of the testers here shuts his machine down every night and first thing in the morning when he fires up the application it fails to connect. If he tries to open it again right after that it connects. What would the failed attempt do that would fix the instance?
View 6 Replies
View Related
Feb 13, 2008
Hi all
We generally modify the logical name of a data file or log file from the vendor defined to our standard name. Is there any impact that you know about this? If you have 2 seperate database and accidently you have 2 same logical name .. I dont' think that will be an issue ... correct?
ALTER DATABASE XXX_UAT
MODIFY FILE (NAME = 'mdd_Data', NEWNAME = 'XXX_UAT_Data')
GO
ALTER DATABASE XXX_UAT
MODIFY FILE (NAME = 'mdd_Log', NEWNAME = 'XXX_UAT_Log')
GO
View 1 Replies
View Related
Jul 17, 2007
Hi,I want to change the logical name of the database. My database name and.MDF has the same name, but the logical name is different. Willchanging it impact anything?--sharif
View 1 Replies
View Related
Mar 24, 2005
New project and this one going with stored procedures.
Should have done it on my first project, but learn as you go...
I have the following code to insert info into the database....
SqlCommand myCommand = new SqlCommand("sp_AddOnlineUser", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@IP_Address", Request.ServerVariables["REMOTE_ADDR"]);
myCommand.Parameters.Add("@Session_ID", Session.SessionID.ToString());
myCommand.Parameters.Add("@user_Agent", Request.ServerVariables["HTTP_USER_AGENT"]);
myCommand.Parameters.Add("@Referer", Request.ServerVariables["HTTP_REFERER"]);
Now, I just want to be sure this stored procedure is correct and if not, suggestions....
create proc dbo.sp_AddOnlineUser
@IP_Address char(4),
@Session_ID nvarchar(100),
@user_Agent nvarchar(255),
@Referer nvarchar(255)
Thanks all,
Zath
View 4 Replies
View Related
Jan 23, 2001
Hello
This is my 1st attempt at designing a database, and I have not finished
it completely, but I would like somebody to review and critique for me.
I really don't want to make any mistakes with this and I would appreciate any expertise out there to direct, recommend, suggest improvements and/or changes, PLEASE.
Thank you for considering this,,,if you provide me with your e-mail, I can send you a script.
take care,
~Iris~
:)
View 1 Replies
View Related
Mar 10, 1999
I have a Local DTS Package which will execute fine...no problems. When I try to schedule it from my NT 4.0 Workstation to the NT 4.0 Server, I get the job scheduling dialog box...fill it out...click OK...and NOTHING.
No error message, nothing in the SQL error log, nothing in the NT logs, no job in the schedule! When I perform the same task at the server logged in as Administrator it schedules successfully.
Any feedback would be greatly appreciated.
Eric
View 2 Replies
View Related
Oct 16, 2006
The following objects are placed on the Report body of the Report pane of SQL Server 2005 Reporting Services :
<textbox: expression1>
<textbox: expression2>
<table:table1 with at least 30 columns and 30 expressions>
<textbox: string1> - considered as the Title in the Footer section of the report
<texbox:string2> <textbox:expression3>
<textbox:string3> <textbox:expression4>
<textbox:string4> <textbox:expression5>
<textbox:expression6>
I can't find any explanation why is it string1 and string 2 of the footer section of my report displayed separately from the expression3 which is aligned on it and the rest of the object on the second page.
The expected design is that all Footer items should be displayed together of whether it is placed on the first page or on the last page.
As a workaround of this, I converted string 1 into an expression (Added = and enclosed the string with double quote).. As a result, all of the items in the Footer section are now placed together on the last page of the report.
I also remember one of the issue I encountered before where the Footer items where placed together on the first page and still have space at the bottom of the page, but then expression 6 is forced to display (alone) on the last page of my report.
I can't find any discussion related to this, I wish somebody could give me an idea why RS behaved like this.
Thanks in advance
View 1 Replies
View Related
Feb 14, 2008
Fit an intere table in same page without page break for save the excel export.
My table has a Group for order my dates.
I need to have the intere table in the same page, i don't care about blank space at the end of the page.
I can't use the page break beacuse i need an excel export in a unique sheet..
I have tested.. every page break..you'll have a different sheet in your excel export
I need something like this
page 1
Zone
1
2
3
4
5
6
7
7
8
9
..
page 2
Zone
1
2
3
4
5
6
7
7
8
9
..
but an unique sheet in the excel export
View 4 Replies
View Related
Jul 17, 2007
Hello,
If I have a report that includes a page header, the report viewer will render the report at the full width, but if I hide the page header and show only the body it will use the absolute width of the report.
I have a 7" wide report, with .75" borders set on each side.
Interactive & Print size are set to 8.5x11
Changing these sizes has no effect on the behavior of the viewer, which appears to ignore them.
When I view this report in the local viewer the contents fill the window if there is no page header.
If I enable the page header then the report is drawn at 8.5" wide, leaving a _big_ white border on the right side.
Any comments or workarounds that anyone knows? I know the local viewer is not a standard configuration (at least it seems) but it is what we need to use.Thanks,//Andrew
View 1 Replies
View Related
Sep 21, 2006
Hi, I wanted to know that can we access a webpagefrom a store procedure in sql server 2000 like we run a exe file from sql server. Bye.
View 1 Replies
View Related
Jul 20, 2007
Hi,
I issued this command on Tempdb but it doesnot shrink the file.
dbcc shrinkfile (tempdev_3,1)
go
Messages:
-----------------------------------------------------------------------------------------------------------
DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.
-----------------------------------------------------------------------------------------------------------------------------------------------
I have checked that there are no tables associated with any user in tempdb. Any help is appreciated.
Regards,
Razi
View 15 Replies
View Related
Apr 16, 2007
How can I print a field that is in the dataset on each page? I added a textbox in the Page Header and use =Fields!ProjectName.value in the value property. I got an error "Fields cannot used in page header and footer."
How can I have the table header shows on each page? Currently if the data goes to the second page, there is no table header.
Thanks.
DanYeung
View 8 Replies
View Related
May 26, 2008
Hi Team,
When i view the Report from SSRS Report preview Tab it's working fine, But when i deploy that and try to view in the IE
I am seeing the Body background color in between the image and page border of the page footer how to solve that?
View 1 Replies
View Related
May 16, 2008
Hi All,
In my SSRS report. I have a report which has only one page. In preview it is showing as only 1 page but when I am printing the report. I am getting two printouts with the second page as a blank.. Please help me in printing the page that contains report. Intially I used a Page header, at that it used to print the blank page with a header only. Now as I removed the header it is printing the page without header i.e Blank Page.. So please help me in prinitng a single page that has the report. It is urgent,..
Thanks
dotnetdev1
View 5 Replies
View Related
May 7, 2015
I have a report with multiple tables. I need to show each tables in different pages. When there is no data for tables/tables , it is coming with the next table which has data. I have given "Add a page break after" option in the tablix but still the tables are coming together when no data available. How can I show it in different page?
View 2 Replies
View Related
Mar 12, 2015
I have a report with tablix. when tablix returns no rows Footer is coming all the way up . How to display the footer at the bottom of the page all time.
View 0 Replies
View Related
Nov 11, 2015
How do I add a hard page break in the middle of a two page report? I use Microsoft reports for windows.
View 5 Replies
View Related
Apr 15, 2008
In SRSS 2005 (SP2) my page header seems to take up the same amount of space on the
1st page it would take if it were to print; I have PRINT ON FIRST PAGE set to
false - the header doesn't print - it just leaves the same amount of space.
How do you get the report to ignore that. I do have a report header built
into the body of my report. I have tested this by increasing the size of my
page header and it does move the report up or down on the 1st page by that
amount.
View 8 Replies
View Related
Jan 23, 2008
I'm hoping that someone can shed some light on this for me... I'm using SSRS SP2 and I have a basic report using a single list object which, at the moment, should print only two pages based on the results of the underlying query. When previewing the report, it shows the two pages. But when the report is printed or exported, there is a blank page before each report page.
What I've done so far:
1) Verified the properties of the list object and made sure that 'Insert a page break before this list' is not checked
2) Ensured that there are no hidden objects that could be causing this behavior
3) Ensured that the report size + margins are within the boudaries of an standard 8.5x11 paper size
Any suggestions on something that would solve this issue?
Sam
View 6 Replies
View Related
May 21, 2008
I have a query. on my search page i have a number of textboxes e.g. title, subtitle, ISBN where users can enter a search string and when they click on a button the data is displayed in the gridview below.
my query seems to be bringing up the right records but with some additional records into the gridview. I have tried the same query within the SQL server management studio and it brings back two records like indicated but within my aspx page it brings back 6 additional records that have no relevance to the query. Im quite baffled as to why this is happening and i have debugged but nothing comes to light.
my code in my aspx page is as follows:
public void BindData(){String _BookID = TxtBookID.Text;String _Title = TxtTitle.Text;String _Subtitle = TxtSubtitle.Text;String _ISBN = TxtISBN.Text;String AuthorFName = TxtForename.Text;String AuthorLName = TxtSurname.Text;
SqlDataAdapter ad = new SqlDataAdapter("SELECT Book_ID, Book_ID_Internal AS [Book Internal ID], Title, Subtitle, ISBN, Edition, Publication_Date AS [Published Date] FROM Book WHERE Book_ID_Internal = '" + _BookID + "' OR Title = '" + _Title + "' OR Subtitle = '" + _Subtitle + "'", conn);DataSet ds = new DataSet();ad.Fill(ds, "Book");if (ds.Tables[0].Rows.Count == 0){//if there are no rows returned-state in the gridds.Tables[0].Rows.Add(ds.Tables[0].NewRow());GridView1.DataSource = ds;GridView1.DataBind();int columncount = GridView1.Rows[0].Cells.Count;GridView1.Rows[0].Cells.Clear();GridView1.Rows[0].Cells.Add(new TableCell());GridView1.Rows[0].Cells[0].ColumnSpan = columncount;GridView1.Rows[0].Cells[0].Font.Italic = true;GridView1.Rows[0].Cells[0].Text = "No Records Found";}else{GridView1.DataSource = ds;GridView1.DataBind();}}
if i input the same query into SQL management studio:
SELECT * FROM Book WHERE Book_ID_Internal = 'ITD 450' OR Title = 'HTML 4.0'
it returns two records which is correct.
Can anyone see where i am going wrong?
View 4 Replies
View Related
