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...

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,...

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...

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...

GSquared (9/17/2009)

---

The only way I can think of to automate what you're doing is to create a DDL log, probably using DDL triggers, and then use dynamic SQL and some...

sqlwars (9/16/2009)

---

Did you try the copy database option in SQL:

Using the copy database wizard

Create a package to copy the database on the same server with different DB name

Use the copy...

Chirag (9/14/2009)

---

Whats the error that you are getting.

I tried a small procedure and found that USE Database does not change the execution context to that database specified in the USE...

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...

Could anybody please help me on this, I haven't figured this out yet.

could paste me the screen shot of the error you see ?

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...

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

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

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...

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