.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Drive setup

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
I recently purchased two additional drives after doing with some testing, with some help from many people on this forum ... <a href="http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/066b423b-62bf-471c-97b2-629d7b5ccbceurl">Prev Post</a> What would be the optimal setup of mdf, ldf, and  tempdb ? should I leave the tempdb and give the ldf, mdf dedicated drives ? should I put the tempdb on the drive with the mdf on a logical partition ? Thanks in advance for the help   right now everything is on one drive ahhh !!!

View Complete Post

More Related Resource Links

How to setup a Mobile Browser Emulator in Windows Mobile 6:

In the following tutorial, I cover the process of Setting up Windows Mobile 6 for Mobile Browser Emulation using the Microsoft Device Emulator. This enables a user to experience Windows Mobile 6 on a PC via Emulation without even owning a Windows Mobile 6 product. It can be a great way to test drive Windows Mobile 6 before purchasing a product with it installed. In our case, it allowed us to Emulate Windows Mobile Browsing so that we could optimize our sites for the Mobile viewing audience. Installation and Emulation is simple and fairly straight forward.

Can this code be setup to run against the whole database instead of just 1 record at a time?


We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..

We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.


            strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"        
            'get the new transaction_id out for just inserted alarm   
            strSqual = "select max(transaction_id) as transaction_id from trans"  
            set rst = getStaticRecordSet(strSqual)

Best Way to Upgrade Using Web Setup Project


Hi there,

I am using VS2005.

I don't have much experience with web setup projects, but I now need to create a decent windows installer in order to allow customers to install one of our web applications. I have created a simple web setup project and it works fine, but not when it comes to upgrades of the application.

If for instance I install version 1.0 on a machine, and then later I try to install version 2.0, I don't seem to have the control that I would like... I can specify in the web setup project that the installer must enforce an uninstall of previous version, but then all application files and logs are uninstalled as well. If I let the application just install itself over the older version, it seems to leave some old DLL's there - it then causes issues in the application because DLL version conflicts.

My basic requirement is that I would like th installer to upgrade the old version with all the files required, but leave any application and log files in tact - this way the customer won't have to reconfigure the application after install.

What is the best way to handle this?

Web Deployment - Setup failing - aspnetca.exe


I have created websetup in windows 7 environment, asp.net 3.5, IIS 7.

Client System is windows 7 and IIS 7

Our client configuration is Windows 7, IIS7 dotNet Framework 3.5.
Following error raising below...
Faulting application name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Faulting module name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Exception code: 0xc0000005
Fault offset: 0x0001d912
Faulting process id: 0xe80
Faulting application start time: 0x01cb3604624975cd
Faulting application path: C:\Windows\system32\inetsrv\aspnetca.exe
Faulting module path: C:\Windows\system32\inetsrv\aspnetca.exe
Report Id: a05d368d-a1f7-11df-8336-4487fc612414
PFA Here I"m attaching custom action script. 

Creating a Web Setup Project


Hi all,

I have a sample Web Application Project and using Web Deployment Project i'm generating the precompiled version of that.

Now i want to create a WebSetup project in my solution using the Output generated by the WebDeployment project.

Please let me know how to achieve this.



Data Deployment: Streamline Your Database Setup Process with a Custom Installer


Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004

Proper setup using Infopath and Custom Workflow using VS 2008



I have been struggling for a couple of days, trying to set up a decent
structure for an Infopath project using a custom workflow using Visual Studio 2008.

I had a solution with two projects:

1) Sharepoint 2007 Workflow

2) Infopath 2007 form w/code-behind.

I included the xsn, in the VS solution, but after a day or two,
something went wrong, and I lost some work. I still do not know what
happened, but I could not get my changes to persist afterthat  Doing research I have read that this
stucture, using Infopath xsn, within VS does not work correctly with Source
Control. I am using VSS.

So I since made a change to the set-up so that the .xsn (form template) is separate from
Visual Studio. However, I need to leave the code-behind in VS, since I need to debug

This is my latest problem. I have been unable to attach to the correct
process, as VS generates cachse files, and who knows what else.

My question is simple. What is the supported method for debugging InfoPath
code/behind, which uses a Sharepiont Workflow?

I just also want to say that one should not have
to spend a few days just trying to setup a working development environment.

This should be trouble-free, but it is far from being so. I

WSS 3.0 Search Setup Help


To Anyone that is willing to help me out, I would appreciate any guidance that is given to me.  We are currently running WSS 3.0 and have the search server started in the central administration area for our web application.

maxserver = The web application

sqlserver = sql database

content db = WSS_Content_3dbbdcc81761405cb6e9d983a88d59bd


When I go to Central Administration > Application Management > Content Databases > Manage Content Database Settings and choose the content DB above to setup the search the following settings are set:

Database server 
SQL Server database name 

Search Server 
You can choose to associate a content database with a specific server that is running the Windows SharePoint Services search service.  
Select Windows SharePoint Services search server 
Select one... maxserver

My question is, should the SharePoint Service search server be the Maxserver or the sqlserver.


The reason i ask this is it is set to maxserver currently and no results show up. I know for a fact that the timer jobs are running!  Shouldn't the server be the database server, sqlserver?  or does it spider maxserver?



I cannot get any se

Word save file on SharePoint via mapped drive


Hi, I have a Document Library mapped to a drive letter. I am able to browse the drive through Windows Explorer. However when I try to save a document to the drive Word returns, 'Unable to connect to the Web server.' .  I have been unable to find any information regarding this error message. If I try to create a document in the Document Library through Windows Explorer and the mapped drive, I get a different error message: 'Unable to create the file 'New Microsoft Office Word Document.docx' There is no user session key for the specified logon session.' After I click OKand refresh the directory, a 0 KB New Microsoft Word Document.docx file has been created. When that file is opened, it is in Read-Only mode.


Windows Server 2003 R2
Webclient service started
Signed into the Microsoft Online Services Sign in Application
IE configured through the sign in application
site added to the trusted sites in IE

Thank you again for your input.

Specify [TARGETDIR] in Setup project (msi) runtime


I am not sure if here is a proper place to ask this question. I look for other forums, and don't feel this question can fit in any. If this is not a correct place to post, I appologize. Please let me know where I can get answer for this question. Thanks.

Here is my question.

I wrote a website, and not I am trying package it with a setup program (msi), so I created a "Web Setup Project" and specify outputs as the standard tutorial on this. And then I'd add custom action to msi which modify Web.config file during msi installation. Output looks ok, but msi install the website under "C:\Inetpub\wwwroot" folder, and I don't have control on it. I followed an example (http://www.codeproject.com/KB/install/ChangeVDirWebSetupProject.aspx) use orca.exe to remove WEBCA_EvaluateURLsMB, WEBCA_EvaluateURLs and WEBCA_EvaluateURLsNoFail from corresponding tables in msi and provides TARGETDIR value while calling the msi file. And then I fall in a problem, either the custom action is not called any more or I get a error "Configuration file cannot be created".

setup/deployment issues


I have built an installation (MSI) for a project I'm designing. I'm using Visual Studio 2008.  Mostly it works fine; however, I have two issues:

1) for some reason, it insists on installing .NET 3.5, even though all the projects within the install use .NET 2.0. Is this because the installer requires 3.5? If so, I guess I can live with it.

2) I want one of the programs to run on startup, and actually, it does. I assigned the Primary Output of the program to the User's startup folder. HOwever, the install also copies the .config file to startup; so it launches it notepad, leaving the user looking at a config file they obviously shouldn't be seeing.


Any thoughts? Thanks in advance... 

How to setup db diagram to automatically insert username into table?

 I have a table setup in the database for users who are basically going to create a classified listing.  How can I setup a diagram that would easily create a table relationship with the Users table, so that it automatically inserts the users username when they submit a new ad?  If so, how?  I've tried adding a UserName row to my table and creating a relationship with the Users table "UserName" row, but it wasn't accepting the relationship when I tried to save the diagram...apparently because the UserName row in the Users table isn't a primary key?Also, one this is setup, what's the best way to provide the user a way to see a list of their ads and have the ability to edit them?

Great you've had a .NET Framework Setup Issue and now want some help getting to the bottom of it

This should be the first stop in determining what is happening to your machine. When posting please follow the steps at the following blog post: http://blogs.msdn.com/aaronru/archive/2007/12/10/what-to-do-when-you-go-to-post-a-setup-and-deployment-issue-on-the-msdn-forums.aspx

Very slow regasm.exe and aspnet_regiis.exe make a setup timeout.

Hello, I originally posted my problem in the Exchange forum, but I think that it is an ASP.NET issue. The Exchange setup launch "aspnet_regiis -config+" command with maximum timeout of 120 seconds. If I manually launch the command, it take 240 seconds for a successful résult. I found that this command use regasm.exe, witch take 3.5 Minutes just for help (regasm.exe /?) All details are on : http://social.technet.microsoft.com/Forums/en/exchange2010/thread/70d8cbfa-6e9e-47be-87b8-969ad1a581aa Can you help me ? Syncerely Yours, David.MCSE, MCITP Exchange 2K7 & 2K10

Why does .NET Framework require 841 MB hard drive space on C:

Just downloaded .NET Framework 4 from Microsoft website. Installation says it requires 841 MB space on my C: drive. Why so much? I am presuming that this is in addition to the space for the other versions of .net installed. This is not going to be installed without a very good reason for this much space required. Can anybody enlighten me on this? Any way to lighten the space requirement load?  

How to overcome .net download error during setup

Hello All,We have a .NET 3.5 SP1 WPF application that we deploy to our costumers using a setup and deployment project in Visual Studio.In order to make things easier to our costumers, we provide in a specifc URL path for the setup.exe file and the .msi file.As the .net 3.5 is a prerequisite for the app to run, the setup.exe properly detects when it is missing form the costumer PC and ask to start the instalation.This works fine for most of our costumer, but, for some of them, the download fails with the following message:An error occurred downloading the following resource:http://go.microsoft.com/fwlink/?LinkId=37283 (something similar to this path).I suspect that some costumer have firewalls or anti-virus programs that block file download trought a non autorized program.Most of our costumer have dificulties to install the application and they actually don´t know anything about internet security or deployment process, so they expect the installtion to be an easy process.I would like top hear from you could be really causing this and how do you suggest to workaround this issue, so the user don't have to bother about prerequisites instalation.Kindly Regards,Igor.Project Manager at INOVATIVA Tecnologia www.inovativatec.com
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend