.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

SQL Server in Log Mode

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hello I'd like to know how to put the database in log mode, i mean, i'd like to freeze the writing and close all the transaction to the main the database. Any changes should be only written to the log. I have the database and the log in different devices. I need this so i can backup the database in a consistent state. I only need to freeze for a second, then i can release.    

View Complete Post

More Related Resource Links

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

My Sql server 2005 Database in recovery mode for 3 -4 hours every day

Hi , Some of our Sql Server 2005 databases remain in recovery mode after midnight for almost 3 to 4 hours. So when my application access them error "Databse in recovery" and for same database this happens again and again every night. Please suggest why and how this can be solved?

VS 2008 Design Mode Hangs on Windows 2008 Server

 I have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it. It was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go. Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking! Help please, I'm getting desparate.  

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

Does SQL Server in 32-bit mode installs and use 64-bit SLQNCLI on x64 Windows?

The answer to question "How to read a .dbf file on 64 bit sql server?"  states: "The basic issue is that 64 bit processes cannot load 32 bit dlls.  Many drivers only release in 32 bit mode.  I am not sure if there is an intent to add 64 bit drivers in the future.  There is a way to work around this issue, but it is sort of roundabout.  You can install SQL Express in 32 bit mode and double hop to the dbf file (or any other 32 bit only provider) through 64 bit SQLNCLI.  The 32 bit express instance can OPENROWSET using all the 32 bit drivers, and the 64 bit SQLNCLI provider can connect to the 32 bit express instance" Is it valid also for non-Express Editions of MS SQL Server? Can the same edition of MS SQL Server be installed both in 32-bit mode and in 64-bit mode - for the same services of different instances? - for different services of the same server setup?

Sharing the session variables between two .net applications using SQL Server Mode?

Hi, I have two different IIS applications within the same domain(let us say www.mydomain.com) , both of these applications use the same database instance(same connectionstring), now what I want is that both of applications can see each sessions variables , can SQL Server session state mode helps in this case? Did someone try that before? Is there any other way to share the session variables? Please help.  

How to run Scripts in Debug mode to run queries step by step in Sql Server 2008


Hi all

i am working on SQL Server 2008 i dont know to how to use the debuging mode to Run Scripts

so that to check Scripts step by Step  please help me out i am wasting my time for checking the error please provide me any link that provides article & Demonstration

thanks in Advance

Sunil Yoganna

Sql Server 2008 logs Authentication mode incorrectly avoids remote login


Im trying to connect SQL server 2008 Express R2 installed on XP sp3 pc through ODBC SQL Server driver with a Windows 7 PC. I managed to define static IP ports and setup firewall. Now the ODBC connection successfully gets created by accepting uid : sa and my password given.

Now Im getting "login failed for user ". " msg from my application. When I run the same application with same ODBC connection created in the SQL server PC it works fine. The two pcs operate in a workgroup.

Following  is the error log. Im surprised to note that the server logs its in Mixed mode initially and later makes a cry that its in Windows Authentication mode. !!!!

010-07-25 15:19:53.76 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
    Apr  2 2010 15:53:02
    Copyright (c) Microsoft Corporation
    Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3, v.3311)

2010-07-25 15:19:53.76 Server      (c) Microsoft Corporation.
2010-07-25 15:19:53.76 Server      All rights reserved.
2010-07-25 15:19:53.76 Server      Server process ID is 3552.
2010-07-25 15:19:53.76 Server      Auth

The remote server returned an error: 227 Entering Passive Mode (67,228,53,42,12,130)


I have writen a ftp client to download files from ftp. while downloading the files from the ftp I;m getting the same error  (The remote server returned an error: 227 Entering Passive Mode (67,228,53,42,12,130)). Particularly I am getting this error in the line
Using response As System.Net.FtpWebResponse = CType(ftp.GetResponse, FtpWebResponse)

I hope you can help me out to solve this problem.


In Sharepoint Integrated Mode whether Report Manager URL http:///Reports will open the


Hai Friends,

                I am Ali, In SharPoint Integrated mode ReportManager URL getting This Error [ This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) ].

1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.

2  In Reporting service config manager tool http://<serverName>/Reports URL is working in 'Native mode' as Fine. Here i am able to create New Roles and able create New Folders and able to deploy the Reports from BIDS and Report Builder to Report Server.

3. Now , I opened Reporting Services Config Manager Tool and I Created New Data Base(as 'ReportServerTest) In sharepoint Integrated mode.

4. ReportServer Configured Reporting Services in SharePoint Integrated mode Sucsessfully. Granted Data base.

4. Enabled Content Types Sharepoint Library and i am able to deploy .rdl files from BIDS(Designer) to sharepoint library.

5. But i need to Deploy the Reports from Report Builder 3.0 to Report Server In SharePoint Integrated Mode

I Want to op

SharePoint2010 FrontEnd Server HA mode.

Hi All, I understand SharePoint2010 Front-End servers can be configured in HA mode by using NLB (Windows). Assuming I already have a front end server, say I join a 2nd server to the farm and configure NLB between them for port 80 and 443. Will the virtual directories on both the FrontEnd servers be indentical. This is the part where it's confusing me? As SharePoint 2010 FE runs for IIS and Virtual Directories, placing a 2nd server in the farm will these virtual directories be in sync for NLB to function. Otherwise users will get different sites when viewing the virtual IP/hostname. Please advice.

Report viewer webpart in sharepoint 2010 foundation with Reporting server in native mode, possible?



We have a product on sharepoint 2010 whose major feature is with the reporting services, we are checking to see if our product can be deployed in a minimum environment of sharepoint 2010 foundation.
we have a minimal test environment with the following :

windows server 2008 R2
SQL Server Express Advanced
Reporting services configured in Native Mode
Sharepoint 2010 Foundation.

I would like to know if we can enable report viewer webpart on sharepoint foundation 2010 with the reporting services in native mode. our plan is that even if the reporting services are not in sharepoint integrated mode, we are thinking of using web services to get XML data and using the XML data in report builder 3.0 to generate reports? will the idea work in this environment? if so can anyone let us know how to get the report viewer web parts in this environment?

Thanks for any help,

- Asif

IIS web site server code: detecting if client browser supports TLS https encrption mode



Due to security restrictions, we must run our web site under the TLS variant of https (SSL is disabled on the server...only TLS is enabled on the server).

The problem we have is that some customers have TLS disabled in their Internet Explorer  Tools/Internet Options/Advanced settings...and they get a "page cannot be displayed" error.

I need a way to tell those users to "go enable TLS on your browser" (like display a page for this saying this).

Can you tell me how I can determine if (with the server having only TLS...not SSL...enabled) if the browser can support the https?

Some more details on the issue:

I've watched the conversation between the browser client and the server, and it appears that the conversation flow is as follows:

1.) Browser broadcasts to the server which https protocols it supports (and has enabled) (i.e. SSL 1.0, SSL 2.0, TLS 1.0, etc.)

2.) Server checks its configuration (which https protocols are setup to be allowed on the server) and returns back on one of the browser client matching protocols.


What I need to determine is how to detect if TLS is enabled on the browser that makes a request (determine it in the ASP.NET server code), so I can generate a page (in the case TLS is not supported on the IE browser) to inform the user.

Verify Report Server is configured in SharePoint Integarted Mode

There is no Web named "/sites/AGA/Reports/Forms/AllItems.aspx".	 
Possible mismatch between the reported error with code = 0x81070504 and message: "There is no Web named "/sites/AGA/Reports/Forms/AllItems.aspx"." and the returned error with code 0x80070002.	 
Potentially excessive number of SPRequest objects (15) currently unreleased on thread 7. 
Ensure that this object or its parent (such as an SPWeb or SPSite) is being properly disposed. 
Allocation Id for this object: {541593A7-D430-43BE-BA21-12BE66844098} Stack trace of current allocation:  
at Microsoft.SharePoint.SPRequestManager.Add(SPRequest request, Boolean shareable)   
at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)   
at Microsoft.SharePoint.SPWeb.InitializeSPRequest()   
at Microsoft.SharePoint.SPWeb.EnsureSPRequest()   
at Microsoft.SharePoint.SPWeb.get_Request()   
at Microsoft.SharePoint.SPWeb.InitWebPublic()   
at Microsoft.SharePoint.SPWeb.get_Exists()   
at Microsoft.SharePoint.Publishing.CachedObjectFactory.CreateWebFromUrl(String url)   
at Microsoft.SharePoint.Publishing.Navigation.SPNavigationSiteMapNode..ctor(PortalWebSiteMapNode webNode, SPNavigationN

SQL Server 2000 Database in "single user mode"


Hi all,

I've an old production database server with SQL Server 2000 SP4, that runs from 6 years. Now sometimes I find that the production database goes in "single user mode". Why? My error logs don't help me.

SQL Server 2005 in 2000 compatibility mode/turn off - what are the effects?

I researched this previously, but it's been months and I'm hoping someone has a handy link of reliable information. Given the scenario:

1) currently have sql server 2000
2) upgrade to sql 2005
3) sql 2000 compatibility mode is turned on

months go by inserting and updating data

4) what happens to existing tables and data when you turn OFF 2000 compatibility (to take advantage of varchar(max) and other stuff?

Is there a reliable list somewhere? any drops and recreation of columns? any butchered or loss of data? How reliable is the SQL Upgrade Advisor ?

What about sp_dbcmptlevel (Transact-SQL) for 2005 and ALTER DATABASE Compatibility Level (Transact-SQL) for 2008?

All of this assumes very large existing tables/databases from years of data storage...with stored procs and indices, etc...

Has anyone actually done this? (Turned off sql2000 compatibility on a database with data)

. · * ´ ¨ )
.· `

Is realtime SQL Server Replicated database usable realtime (not offline / single user mode)


Is SQL Server replicated (destination) database replicated by SQL Server Replication fully usable? Meaning it's not just for Disaster Recovery but is fully usable from various say BI / Reporting purposes.

In the essence it is exactly same as other replication engines and the destination database is very much usable and not just offline / single user mode.



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