Does anyone know the minimum space required on the install partition so that the analyzer does not throw any warnings?
We are strapped for space and the recommended 80 GBs is not a option for us.
Thanks in advance.
View Complete Post
Edited by Nancy Michell
MSDN Magazine March 2004
I would be able to determine how much hard disk space is available on the Server with a SQL Query, and from an other computer on the LAN.
How can I do something?
Thanks for your help.
I am working on a web application where I want to keep all the user specific data at client side.
My user will select a location at client side through settings page where he/she wants to save the data.
Is there a way I can do this?
(Not sure if the DB Engine forum is a better place for this q, but thought I'd start here first :)
SQL Server 2008, 64bit. 3 File groups (plus a log), each with one physicial file in the group. Each physcial file is on it's own drive. File group X has a file "X1" and is growing and dangerously close to running out of space on the drive. I added a second
file ("X2") to the X filegroup on a different drive with plenty of space as follows:
ALTER DATABASE MyDB ADD FILE (NAME = X2, FILENAME = 'V:\X2.ndf', SIZE=100MB, FILEGROWTH=1000MB) TO FILEGROUP X
I was under the impression that the files would grow equally in parallel... the 2nd file is still 100MB, but probably because X1 has not experienced growth yet. My question is... Am I in any danger since the X1 file may run out of space, or will the data
automatically redirect over to the X2 file as needed?
the people called me in their firm because server Won't boot-up (SQL 2000).
I checked it and it was hard drive failure. Manage to get DB data from HD, i wanted to put it on SQL 2005 on new machine.
I successfully attached 5 databases, they are working now, but have problem with 6th. When i trying to attach it get the error;
Server Name: PROMET
Error Number: 9004
Line Number: 1
.mdf file has 1.3 gigs and .ldf 6.1 gig
I searching trough the forums all day, and i cannot find working answer...
Please help me, i can provide additional information if needed.
I've got a virtual Server 2008 R2 server that keeps running out of disk space on the system drive. Oringianlly there were several dozen sql database on the drive so i moved them (several gigs worth), however, after moving them all to another drive
(ussing sp_dettach/attach and physcially moving the file) the system drive is still showing 0 bytes free! The recycle bin is empty and i've verified that all of the files are physically gone from the system drive. Also when I do a search for
Huge files I don't see anything new, but i didn't actually note every single file before and after.
Anyone know why moving sql databases would not free any space?
If i hard coded role=Manager on the specific SiteMap/Folder/Page/etc. I will have problem when the manager need to remove from access a specific page. I need to change the code ont eh page/SiteMap/Folder more move the file into another folder.
What i have in mind is to change the role to taks oriented. such as role=AddStock, Edit Stock, Delete Stock, Print DO, Add Sales, Edit Sales, Deleted Sales..... (but it will be many role for 1 user compare to just 1 as Manager)
Will this cause performance issues later when each user have 60 roles and if i have 20,000 user will it affect the application performance?
Otherwise any other option? to make it flexible.
How to manage user messages to avoid hardcoding messages accross the web application.
I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval. This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.
We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.
I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.
Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.
Can anyone help with providing sample or that I can use to move this one on.
I am still in disbelief on this one. the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.
I am using aspose.slides to create PPTx's. Some of the process involves loading jpg's from another server and including them in the presentation. This works fine in my development environment. When I upload the site to its server, the jpg loading fails.
I am trying to access jpg's on the other server by:
oFS = New FileStream(sFile, FileMode.Open, FileAccess.Read)
This causes an access violation error when run from the server.
I also boiled the code down to reading the file directly:
oImg = System.Drawing.Bitmap.FromFile(sFilePath)
This causes a file not found error.
We have narrowed the problem down to the fact that the File Path has a space in it. How does one solve this problem (while still keeping the space, there is a lot of legacy data)? I have tried replacing the space with %20 or +. I have tried using Server.UrlEncode. The error message always comes back with the encoding in place (like no decoding
Custom field types provide a powerful way to define a reusable SharePoint column definitions.
MSDN Magazine May 2009
Learn how to enable an auditing solution for Windows SharePoint Services (WSS) 3.0 with customized control pages in Microsoft Office SharePoint Server (MOSS) 2007.
MSDN Magazine September 2008
Here's a custom branding solution for SharePoint sites that integrates Master Pages and CSS files at the level of the site collection.
MSDN Magazine July 2008
See how to use Word to capture a VBA macro and use Visual Studio Tools for Office to wrap it up into a deployable Word add-in.
MSDN Magazine May 2008