.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

30 days limit to Passive server until it must be fully licensed

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :


I read this restriction in the MS SS08 licensing DOCX file. I just want to ensure I understand. Is this 30 days in total a year (Oracle is like 10 days in total a year). Is it a one time fail-over that can last up to 30 days?


Another concern is that if I fail over in our MIRROR cluster, perhaps I just want to leave it there until I fail back for a failure purpose. The licensing docs imply to me then I must fully license this as an active/active cluster...

View Complete Post

More Related Resource Links

Database server connection limit exceeded..

I have an SSIS package and have been adding additional DFTs to it.  Where there are dependencies between transformations I identify them.  However where things can procceed in parallel I do not constrain them form a control flow standpoint.  After adding another DFT I am now getting package failure due to "Database server connection limit exceeded" (my local source database is SQL Anywhere and it has a max connections of 10 in production it will be full blown Sybase and will probably not be so constrained).  I think I can solve the problem just my making control flow dependencies to reduce the amount of parallel activity but I am wondering if there are other things I should consider doing.  For instance are there other settings I can tweak that tell SSIS to run parallel up to X connections out of a connection pool? (or something like that). Some may comment that this relates to my post of yesterday on package strategy (master-child packages or one big package).  I still have one big package for now but may break it into master-child.  Still I think I can control the amount of parallel activities through control flow even if it remains one package. Any thoughts or comments on this would be appreciated. - Charles PS - just ran my package and this time it succeeded - sometimes I hit the limit of 10 connections sometimes not...

database size limit about SQL Server 2005 Express

I know that there is a size limit (4 GB) for SQL Server 2005 Express, but I am not quite sure if the limit is applied for only ONE database data file or for ALL the database data, suppose I have two databases DB1 and DB2, so which of the following statement is correct? A. The size limit for DB1 is 4GB, and the size limit for DB2 is also 4GB, so if DB1 is 3G and DB2 is 3.5G,that will be OK. B. The total size for both DB1 and DB2 can not be larger than 4GB, which means if DB1 is 3G, then DB2 can not be large than 1G.

Issues reinstalling a Second Node (Active/Passive) SQL Server 2005 Lustering

We originally had an Active /Active-Passive Node Cluster; (SQLCLUSTER1 (S1) and SQLCLUSTER2 (S2). After a client who needed access to SQLCLUSTER2 was unable to connect, I discovered that the TCP Ports somehow got corrupted.  I couldn’t find a 1433 port. So, I obviously had to do a reinstall.  NOTE: S1 contains the R and S drives (SANs).  S2 contained the T and U drives (SANs as well).   I used the following site to check my install: http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx  By: Brad McGehee   While installing a failover (active/passive node) everything was going well, until I got to the Cluster Group Selection screen.  Under Available cluster groups showed: Cluster Mgmt Group (this Group contains the Quorum Q drive). Under the Unavailable cluster groups showed:  SQL Cluster Group (SQLCLUSTER1) – Already contains a SQL Virtual Server and the next one, SQLCLUSTER2 – Already contains a SQL Virtual Server. Under Data files:  I tried to place the data on the T: drive and I received an error stating that I cannot put data on the same drive as the Quorum drive.   Prior to the reinstall of S2, I deleted/removed all SQL Server data on S2.  Perhaps, this is where my problem may lie. So, my first question is, do I need to reinstall S2? My second question is, could there be


How do you limit the execution of stored procedure / or update of items only to happen on specific days.   i need this only to execute if today is day 3 through day 7 (tue - sat) UPDATE itm SET AVG_WHSL_PRC = AWP.CURR_AWP_AMT ,AWP_EFF_DT = @Pricing_Date ,UPDT_DTS = GETDATE() ,UPDT_OPR_ID = RIGHT(SUSER_SNAME(), 7) FROM dbo.T_ITEM_PRC_CHG itm JOIN #TEMP_AWP awp ON itm.EM_ITEM_NUM = awp.EM_ITEM_NUM WHERE itm.PRC_CURR_CD IN ('C','F') AND @Pricing_Date BETWEEN itm.PRC_EFF_DT AND itm.PRC_END_DT AND itm.HOME_ACQ_COST > 0 AND ISNULL(itm.AVG_WHSL_PRC, 0) <> awp.CURR_AWP_AMT

SQL Server XML Size Limit

Hello,I am aware that the maximum amount of space an xml variable can hold is 2GB, and I am fairly certain that is not my problem here; though it does seem to be some sort of size constraint.. kind of? First, my example code, basically generating xml from a table of 4 columns and 275 records: -------------------------------------------------------------------/* SETUP */use tempdbgocreate table mytest (col0 int,col1 varchar(30),col2 varchar(30), col3 varchar(30))godeclare @v intset @v=0while @v<275begin  insert into mytest values (@v,                             'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA',                             'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',                             'CCCCCCCCCCCCCCCCCCCCCCCCCCCCCC')  set @v=@v+1end/* TEST */DECLARE @xmlDoc XMLSET @xmlDoc = (                SELECT 'BEGIN' as '@BEGIN',                      ( SELECT col0 as '@REC_NUM',                               col1,                                col2,                               col3                          FROM mytest                        FOR XML PATH('MYPATH'), TYPE )                FOR XML PATH('XML'), root('ROOT')                )SELECT @xmlDoc as 'WHY IS THIS EMPTY?'/* CLEANUP */drop table mytest------------------------------------------------------------------- My problem is that after creating and populating the table, the code in the 'TEST' section does

Identity Range Value (Max Limit Finished) SQL Server 2005 (Merge Replication Problme)


Hi ,

I am using SQL Server 2005 enterprise edition, I Confirured the Merge Replication to my database). I have a replication of 21 database from various locations.

Problem is: When is trying to remove one subriction from the publisher and add a fresh subriciton to it. it is poping any error saying the Identity Range value exceed its Max Limit try to change from int to bigint. is there any solution for it not changing from int to bigint.

Thank you.


Action required on SQL Server side(Active /Passive) cluster,when Upgrade iscsci Upgrde.


Hi all

Storage engineers are planning to Upgrade storage Drive and that storage using for SQL Server 2005 Active /Passive cluster.

as DBA what action I have to take.

I am planning

1.Backup all Databases.(Inluding system)

2.Takning all Databases OFFLINE(make sure no body using Databases)


3.Stopping Instance and Agent .

which is the best way.


any advise is helpful for me.


I cannot seem to be able to fully install Mircosoft Server 2008 32 Bit Trail version


Hi have been trying without any success to install Mircosoft Server 2008 32 Bit Trail version on my Windows Vista 32 Bit Desktop at home.  Below are the error messages that I received both times.

Feature Name


Database Engine Services


SQL Server Replication


Can anyone out there please tell me what I am doing or not doing correctly? Any suggesti

SQL Server 2008 Report Manager is not fully working



On Windows server 2008 R2 Enterprise Edition, we have installed SQL server 2008 R2 Reporting services and SQL Server 2008 database with Reporting services.  Both have different instances.

Now, we can work with Report manager of SQL server 2008 R2 without any issue. i.e. assignment of new user role etc. is working fine, but when we try to do same thing with report manager of sql server 2008 then its not working. No error message is being shown by the report manager when we try to assign new user a role and press OK button it doesn't show any message.


What could be the problem?





Cannot get past max message sixe limit-- {"The remote server returned an unexpected response: (400)



I keep getting a HTTP 400 exception whenver I try to send a large message.

My service contains a messageContract that consists of 3 int32s and 1 stream (Regular stream, not memorystream or any other derrivative of stream)

When I send a messageContract that has the 3 ints and 48837 bytes on the stream, the sending and recieving work. When I set it to 48838 bytes, however, I get the following error:

 System.ServiceModel.ProtocolException was caught
  Message=The remote server returned an unexpected response: (400) Bad Request.
    Server stack trace:
       at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)
       at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
       at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)

SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).


Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).

1.I have already have SQL Server 2000 SP4 Installation.
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?


Thanks in advance


Sql Server 2005 table item limit



I am having a file which is contain 70,000 data. i try to upload this file into sql server table using front end sharepoint server.i am getting time out period expired error.

So please help me to solve this issue





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.


Converting from SQL Server 2008 R2 demo to licensed version

Do I need to unsinstall the demo version of SQL 2008 R2 and install the licensed version.  If so, will my existing database be destroyed or will the DB and settings be available when I install the licensed version.

Running licensed SQL Server 2008 Analysis Services with SQL Server Express editon?



We have a SQL Server 2008 Standard Edition. We've also installed Analysis Services and are using cubes.

Is it possible to have the Analysis Services on another server, to take some of the load of the "relation engine" server?

Do we need a relation engine on this server? Will SQL express be sufficient for this?


Thank you,


call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.
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