I'm using sql server2005. One of my database's log file size has reached more than 3GB. Because of this it is creating problems while displaying the site. It shows connection timeout error. How to shrink the database log file. I tried all the shrink File options in the management studio but still it is not shrinking. how to acheive this.
View 1 Replies
i dont have enough space?what should i do?and i although want to shrink other databases as well?i'm working with sql server,
View 5 RepliesI've been working through the ASP.NET Security Tutorial 12, seen here:
http://www.asp.net/%28S%28pdfrohu0ajmwt445fanvj2r3%29%29/learn/security/tutorial-12-cs.aspx
Part of this tutorial entails setting up a GridView which is bound to the collection of UserAccounts, and then enabling paging on the GridView. There are the usual four links for First, Prev, Next, and Last pages, which should work because I have twelve users defined, and the pagesize of my GridView set to 5. I've set up the code to enable or disable the paging links depending on what section of the entire UserGrid is currently visible.
So when I first run the website and go to the ManageUsers.aspx page, I would expect to see only the first five users in my collection. But it shows all twelve.
I must have overlooked something, but I can't find it in the text and examples.
When I do an exec sp_spaceused eventlog I get this returned.
Name Rows Reserved Data index_size Unused
EventLog 14400616
85897152 KB 84569400 KB
1307600 KB 20152 KB
I ran this sql
USE kearneyareajobs_com_dnn
I am developing a C#/ASP.NET web application in VS 2008. Currently this page is too tall. The buttons appear on top and then there is a large gap between these buttons and the resultLabel text. The following code is from my ASPX file. I have tried switching to the Design tab of this file and manually moving this label, but there is still a large gap. I'm sure this is simple. How do I correct this?
[Code].....
I have an image that I use many times. In several cases I want to shrink its size, but obviously it loses sharpness when I do this in HTML.
Is there a way to fix this? The image is located elsewhere and I can't save it locally.
I am having trouble with .rdlc field sizing. Regardless of the table/field size settings in my .rdlc report, the reportviewer always shrinks the fields and table. I have tested everything I can think of, and searched the web for a solution to this problem, but no luck yet.
I have also tried just about every size setting there is and even looked in the output html, but nothing seems to be decreasing the width. I have attached two images. in the first image, I have added a black border around my table, and a red border around one of the fields to demonstrate the auto-shrink issue. the second image shows my vs report settings.
ReportViewer settings:
[code]....
I have images at the head of the page in an iframe and in the main center page. The image at the head flows over the social icons and the images at the center page resizing drops below and pushes the other image down. I just want the images to resize when the browser is being resized. Go to [URL] .... and you'll see what I mean.
View 1 RepliesHow do I create a schema.ini file from a tab delimited file?
I have this so far:
[myFile.txt]
ColNameHeader=True
Format=TabDelimited
CharacterSet=ANSI
I think I need something like this after my last line from above:
Col1=first TEXT width 150
My text file has 7 columns, the first row is the header row. The data comes from a Micosoft SQL Server Database where the fields are of the following types:
int
nvarchar(MAX)
nvarchar(50)
I have an ASP.NET website. This site is fairly complex in the sense that it has all sorts of blurs, gradients and rounded corners. The content of the website is always going to be in the same area, an area within some rounded corners. The content is going to be of a dynamic height. And, I can't show any scrollbars, other than those displayed by the browser window.
The banner is a Flash movie. I want to prevent the page from flickering. Because of this, I want to only update the url of the content portion. My question is, is there a way to do this without significant re-working? I thought an iframe would be suitable, but I can't figure out:
How to make the iframe's height dynamically grow/shrink based on the size of the content Get rid of the borders / scrollbars across the major browsers.
Is what I'm trying possible? Is there a better way to do it?
I have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 RepliesIs it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 RepliesI am trying to print a report containing the single record using print option available in Report Viewer control. But print is coming in more than one page.
How can we shrink the report to a single page?
I have a problem, I have created a website that is run on local host database is make in 2005 sql server
now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working
problem gives "NT NETWORK SERVICE FAILED "
how we can convert the sql 2005 mdf file to sql 2008 file.
On Page_Load I create dynamically table as following:
//compose the SQL statement
string strSQL = "SELECT images.location, products.description, products.price, products.isNew ";
strSQL += "FROM images INNER JOIN products ON images.idImages = products.idImage ";
strSQL += "WHERE products.idCategory=" + str_idButtons;
strSQL += " AND products.doShow=1 ORDER BY products.isNew DESC"; //new first
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["????????"].ToString());
MySqlCommand command = new MySqlCommand(strSQL, con);
con.Open();
[code]...
i have a sdf file. when i tried to open that file in sql server 2008, it is prompting me for a password. unfortunately, i dont have the password, what do i do ? any password reset options or password recovery options or password breaking options ?
View 9 RepliesI just want to ask how to import a .dat file to sql table in ASP.net. The .dat file is the report comes from our Biometrics Device (fingerscan)
View 6 RepliesI set up a daily backup for our database, however I noticed that rather than creating a new file for each restore point, SQL server just appends to one back up file. This is an issue, IMO because what if that one back up file gets corrupted? Is there a way to back up to multiple files (one new file per day?)
View 2 RepliesI've wasted two hours of sleep on a stupid problem. I have an excel 2003 file (xls) that I'd like to import into a table in Sql Server 2008 Express edition. I've done this before, but I can't remember how it's done really. Here's the problem: When I start DTS, I set the excel file as the "data source" and click Next. Now I'm supposed to name/point to the mdf file, but how do I do that? The only thing that appears in the "Server name" text field is the computer's nameSQLEXPRESS, but the mdf file is of course residing in the web site's folder. Also, what should I choose in the "Destination" drop down menu: SQL Server Native Client 10, Micorsoft OLE DB Provider for SqlServer, or what? Regardless of what I choose, I don't find my mdf file in the "Database" drop down menu below . What am I doing wrong? I imagine it's really easy!
View 6 Repliesi would like to move all membership tables from aspnetdb.mdf to another mdf file. I don't have connection string in web.config that points to aspnetdb.mdf. I found links like [URL], but aspnet_regsql.exe allows to move all security data to sql server, not mdf file.
View 5 RepliesI am still in the same project. Its been so hard to complete it. Always one or other problem.
I am using sqlserver 2005 and vb.net and vs2008- not that any of this matter for this question.
My problem is that I couldnt' check if the record exisist in the db. How do I do it.
I have fileupload control but I want to check my db if the filename already exisit.
Thi sis my code.
[Code]....
I am saving different file formats as varbinary in a SQL Server 2005. The web application is VS 2005 using VB.
How can I put a link in a page to the file saved in the database?
if we overwrite the db backup(using restore database) then is it posible to recover data of previous backups?
View 2 Repliese provide me the sample code file... on my mail id:- rahulbhute1987@gmail.com
View 3 RepliesWhat data type in SQL should i use to store an XML file? And how do i do it?
View 5 Replies
