Sean Lange (8/27/2012)

---

Saga... (8/27/2012)

---

SELECT @MSGOUT = @MSGOUT + '

<tr>

<td>' + ss.ServerName +'</td>

<td>' + ss.DBName +'</td>

<td>' + Occurrences +'</td>

</tr>

'

FROM /*DBINVENTORY ss --after...

Luis Cazares (8/27/2012)

---

You were joining your grouped results with the original table with duplicates. You can get an even simpler version of your code like this, no need of a...

SELECT @MSGOUT = @MSGOUT + '

<tr>

<td>' + ss.ServerName +'</td>

<td>' + ss.DBName +'</td>

<td>' + Occurrences +'</td>

</tr>

'

FROM /*DBINVENTORY ss --after removing this commented...

Main objective is to find duplicate db's...... and out put is perfect..... which I am looking for....

Can you please help wi

Hi All,

sorry for late reply.....

Laurie it worked out.... tons of thanks!!!!

GSquared (7/12/2012)

---

Generically, a "staging" database is one that's used as a part-way step for loading data from one format into another format. For example, I've used staging databases to...

I am not asking about my environment .... I just gave that example...in fact my environment is not like this... I raed in some papers.... so want to clarify my...

Yes I am asking in terms of application.... that application needs staging database, with main database to start some services.

just want to know generic terminology for staging.

I mean for e.g I have database HP561CT and HP561CTstg.

As per this demo names, i have reffered master means main HP561CT and HP561CTstg as staging database.

Just wanted to know...

For replication it creates some job....

please specify why you want to do that with agent off.

there is a way in which you can use one utility from microsoft replmerg.exe...

and what in terms of costing....

Thanks a lot guys for your reply...

Reason I think for oracle's popularity is they are very complicated, most important is platform independency.

As our Microsoft is limited. Even microsoft...

You just said that only High Availability offering AlwaysOn is the new functionality added...

But SQL 2012 is cloud ready platform... my question is in that context....

because database administration...

you can use batch file execution using Powershell script.....

Thank you grant and Koen...

I am seeking career opportunity....

New technology....

New job roles....

Cloud compatibility...

How it can be beneficial through all aspects.....