how many instance use in sql server 2005
Answers were Sorted based on User's Feedback
Answer / trived
normally sql sever 2000 16 instance possible
in 2005 50 instance possible
Is This Answer Correct ? | 26 Yes | 2 No |
Answer / setaceo
In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / neel
Establishes the maximum number of SQL Server 2008 instances
that can be created on a server. Enterprise Edition
supports up to 50 instances on a server, Compact Edition
only supports one instance, and all the other editions
support up to 16 instances.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / varinder sandhu
Dear All,
normally sql sever 2000 supports 16 instance,
this is right.
in 2005 max number is not 50
because sql server 2008 R2 Datacenter supports 25 instance only
i don't think previous version sql server mean 2005 support
50 new 2008 R2 support only 25
it does not make sense.
Ref Article :
http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx
Thanks,
http://varindersandhus.blogspot.com/
Is This Answer Correct ? | 1 Yes | 3 No |
What stored by the model?
What are transactions and its controls?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What all db objects can be found in MSDB database of a SQL Server instance?
Why use view instead of a table?
What's the purpose of Stored Procedure?
Can you insert NULL in unique column?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that