Viewing 15 posts - 16 through 30 (of 36 total)
Hi Jpotucek,
The moment you think about an Active-Active Cluster you will need to think about double the resources on each node of the 2 node HA cluster, at any given...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
June 6, 2012 at 2:16 pm
If you were using SQL Server I would ask you to use Hierarchy column.
In other ways, if both the employee and the manager details are stored in the same table,...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
June 6, 2012 at 1:10 pm
Hi Vertigo44,
Answer to first Question (What would be better for two independent systems to be kept in sync):- Replication is the best candidate to keep the data in sync from...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
June 6, 2012 at 10:31 am
I just tested Vinu's Query, and can confirm there are no duplicates returned for the data set provided.
Query :
Select empId, [basic], [da], [hra], [ta], [medical] From sal
Pivot
(max(IncomeAmount) For sal_comp IN...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
June 6, 2012 at 9:00 am
GSquared (9/17/2009)
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
September 17, 2009 at 7:46 am
sqlwars (9/16/2009)
Using the copy database wizard
Create a package to copy the database on the same server with different DB name
Use the copy...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
September 16, 2009 at 4:21 am
Chirag (9/14/2009)
I tried a small procedure and found that USE Database does not change the execution context to that database specified in the USE...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
September 15, 2009 at 11:15 pm
Hi There,
I am looking at copying over any new tables, views, functions and Stored procedures developers create on a base database to 3 other databases on the same server.
Later...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
September 15, 2009 at 11:13 pm
Could anybody please help me on this, I haven't figured this out yet.
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
September 2, 2009 at 6:03 am
could paste me the screen shot of the error you see ?
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
August 21, 2009 at 6:17 am
By default when you browse for SQL Servers to connect, all servers in the same network are identified, and for those not on the same network, we add these SQL...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
August 21, 2009 at 6:00 am
Gail,
I assumed the issue was only to query the base tables, and not modify. as per his first request.
I agree with you, we cannot change these tables even with DAC.
Regards,
S
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
August 21, 2009 at 5:53 am
Hi San,
Add an alias to this database in the configuration manager from where you are trying to access and see if that works with your remote machine.
Regards,
S
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
August 21, 2009 at 5:49 am
Panwar,
SQL Server 2005 does not allow for direct user access to the underlying database and catalog system tables as was the case in previous versions of SQL Server, where you...
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
August 21, 2009 at 5:25 am
Hi Manu,
I have created the bpaclient folder in the bootstrap and copied the .dll and the upgrade was successful.
thanks for all the help.
Regards,
Suleman
=======================================================================================
Visit my technical reference; you might find some of your issues already documented.
January 2, 2009 at 12:59 pm
Viewing 15 posts - 16 through 30 (of 36 total)