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

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

Version Check SP and Location Log Files

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server

My SQL Server 2008 Standard is showing Verson 10.0.2531.0.   Is ths SQL 2008 SP 1?  What is the latest SP for SQL 2008 Standard?  

I want to check that my log files are truncating properly during my Full backup.   How can I find the path for where the log files are stored? 

Thanks - NC Beach Bum

NC Beach Bum

View Complete Post

More Related Resource Links

Initialize snapshot fro alternate location - multiple .bcp files for an article

I have to replicate over 50GB of data over a slow network.  I did not use the option to initialize snapshot from database backup because the replication articles contain row filters.  If I do that, I'll have to run a lot of scripts to remove the data and other unnecessary database objects on the subscriber. Instead, I created a workaround.  On the publisher, I first create the actual push subscription to the target subscriber on the publication.  This subscription is set not to initialize from snapshot.  I then created a second push subscription on the same publication, but the subscriber is a random database on the publisher server.  This second subscription is a dummy subscription set to initialize from snapshot - the purpose is to generate the necessary snapshot files.  I then reinitialized all subscriptions and generate the new snapshot files. On the subscriber, an empty database is created with the same tables as the publisher database.  I created an identical publication on this empty database, and a dummy push subscription on the target subscriber.  The subscription is reinitialized, and the snapshot files on the empty database is created.  These dummy snapshot files are then overwritten with the actual snapshot files created on the publisher, and then I synchronize the the dummy subscriptions with the actual sn

Check for valid version number

Hi,I want to check whether given string is a valid version or not. If any string is in form of then it should return true, else if it contains any text or which is not any version format, it should return false.Any idea on this. Thanks for your help.

Specify CLR Version When Using Al.exe to Generate Publisher Policy Files

I'm trying to generate a publisher policy for for .NET 4.0 assemblies. However, I noticed that the version of mscorlib that the generated policy file references is always 2.0.0. Is there a way to specify .NET 4.0 as the CLR? Otherwise, when you install this assembly, it gets installed into the C:\Windows\assembly folder instead of the new .NET 4.0 assembly GAC location. 

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

Question about Workflow in Document Library with version control and check-in/out enabled



I use Sharepoint Foundation 2010 and have a workflow to set some metadata in a document with version control and check-in/check-out enabled (approval content is not enabled because anyone in the team can be a possible editor of the document).

My metadata is:

- a generated doc id with text+id (example P&D_1)

- a calculated status based in version: minor version = "on development" and major-version="published/approved"

I defined two workflows:

1) is called when item is created to define id and status.

2) is called when item is updated and status is re-calculated if version is major. (It is called in every item change, not only when user wants to publish a major version, because this option doesn't appear in SPD)

I noticed that sharepoint workflow must do a check-out to be able to update metadata, and because of this the version number is incremented. When version is minor, I don't care, but when version is major I have a problem, because just after publishing the version 1.0, the workflow changes metadata and the version to 1.1. and 1.1 means that the document is not approved anymore...


a) Isn't it possible to do the workflow to check-in and override the last/current version to not generate a new version??

b) Or is it possible to stop versi

sql 2008 installation question, windows installer version check?


sql 2008 installed, but didn't get pop up for windows installer 4.5, though intallation complete, but still wants to confirm the windows installer version, however, the windows 2008 seems not like w2k3 to show all windows components you installed, I only see .net 3.5sp1 on the appwiz.cpl

Check trial and registration version software and his activation



My question is

     When the user opens the application for the first time after installing it they should be prompted to either enter a registration code or activate the     30-day trial.  The user should not be able to use the application before first activating a trial period or registering the software.

 - algorithim  is needed that generate key which match the installed software code.

Please let me know if any one have any soluation for this problem.






Moving directories/files from the server to another network location


In my asp.net wep application i would like to move the folders from the server to a network location so that the server doesnt get filled up...................

i was able to move the files within the same drive but not to other network locations ..........

So please help me in finding a reliable solution

Client browser using cached files instead of updated version after deployment



We have an ASP.NET web application and it's hosted using IIS 6.0, in the app we have these several javascript and css files located in a folder, and for performance sake (according to YSlow) we set the folder content expiration header to 1 year. Everything worked just fine until recently when we deployed the latest build to the server, in which we had made some changes to those javascript and css files. For some reason after the deployment some of our end users don't see the latest changes when they connected to the app, even after they cleared the cache in IE. We have also restarted the IIS on the server and the problem still remained. When I went into the IE Temporary Internet Files folder on one of these machines I saw the files were still the older version and not the latest one, I had to manually delete the files from the Temporary Internet Files folder then they were able to see the latest changes. I'm baffled by this, how come only some users who couldn't see the changes but some others do (without having to do anything by the way), and how do I make sure that for future releases we won't have to do anything like what did (manually deleting the cached files)? For now I disabled the Content Expiration option in IIS for these files but I would like to know if there is a way that I can enable the content expiration (to help performance) but

copy a folder and subfolders + files from remote location to local drive



i am making a windows application( C#.Net) in which there is a folder placed at remote location( on other computer). this folder contains files + subfolders inside it. i need to copy all the files and subfolders present inside this main folder to my local drive. How can i do this. 

Thanks in advance

Install a wcf as a windows service and copy files from a network location



I need to intall a WCF as a windows service. In side this WCF , I need to copy files from a network location to the local machine and run them.

I tried to give a specific user account ( which has access to the shared location)for the windows service processinstaller and install the service. but this account cant host the WCF since it does not have admin rights.

Is there a way to host the WCF using local account.. and then to access network location in side the wcf using a specific account. ( impersenation??/ )

Thanks in advance.





How to Programmatically Upload the files based on the current location in the document library?


how can programmatically to upload a file to document library based on the current location for example when i was inside the subfolders and click on the custom button in ribbon it should upload file to current location entered to document library not hardcoding the subfolders name 

Thanks in advance

SharePoint/IIS referencing a Temporary Files version of an assembly


I'm having a very weird and frustrating problem.  I have a SharePoint Feature that I am deploying, however at some point it references the AjaxControlToolKit dll that is in the GAC.  What happens is the following error:

CS0433: The type 'AjaxControlToolkit.ModalPopupExtender' exists in both 'c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\root\30ff2330\b662b5c4\assembly\dl3\2724a5e5\b1736a7f_6c53cb01\AjaxControlToolkit.DLL' and 'c:\Windows\assembly\GAC_MSIL\AjaxControlToolkit\3.0.30930.20127__28f01b0e84b6d53e\AjaxControlToolkit.dll'

What happens is that each time I access the SharePoint site where this Feature is deployed and Activated, a set of temporary files is created in the 'c:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\' path.  I have tried to stop IIS, delete these temp files, then restart, but each time I begin to use this SP site, the temp files are created again, and then I get this conflict error. 

About the AjaxControlToolkit.dll:  It is not set to CopyLocal and this is not being run in debug, I've tried it being added to SafeControls on the web.config file.

Any ideas why this is happening and how to fix?  It has basically halted

Default location of data files


I had changed the default location setting for database in the "Database Options" tab of SQL server setting and it has taken effect when I create new database using Management Studio.

But when using CREATE DATABASE DBName the file still gets created in the old location. I dont see any option to change the setting any further. Its an SQL 2005 cluster. Is this a bug or am I missing a setting somewhere?

Arun Jebakumar B

Get files from different location using SSIS


Hello All,


We have  process which gets files from different location and saves on our drive and unzips it. but its old process and requires to be rebuild.

I am thinking to use SSIS for it.

I have list of all file ftp location, username, password. and Desination location.

what steps do i need to achieve this?


Thanks in Advance

version control for .xamlx files in vs2010


Hi ,

This is my scenario:

I have a solution having multiple projects in it. There are several workflow files(Template1.xamlx,Template2.xamlx)files in my Business Logic Project. User Interface is a web application project that uses the service references of each of the workflows(Template1Reference, Template2Reference).

I have some threads which are running live . I need to update Template1.xamlx by adding another activity in the workflow.

I wanted that existing Template1 threads should continue to run in the old version (v1) and new threads to run in V2 of Tenplate1.

Template2 has no change.

My queries are:

How can i update Template1.xamlx and deploy ?

Do i need to create Template1_V2.xamlx file and update the Template1V2Reference in Template1.aspx page? or can i use the same Template1Reference in .aspx page.

If Template1.xamlx needs to be updated to version 2 , do i require Template2.xamlx to be upgraded to version 2 also ?

will the endpoint configuration of both workflows needs to be changed?

Kindly share your suggestions.

Thanking in advance


web browser control can not play swf files with the 64-bit version of Vista

Why web browser control can not play swf files with the 64-bit version of Vista, but it work well in the web page? Does anyone know this reason?
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