datatools12 (1/28/2013)

---

Yes, I recommend you to go for Data Cleansing Software and De duping software. The Data Cleansing Software will remove the erroneous data from the SQL server, and the...

What you need is a TRIGGER:

http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx

If you post your table schema, I will put together a sample trigger for you.

Matt

Sounds like a good plan for 'hardware consolidation'.

I personally, wouldn't want to do it that way. Why not have 1 or 2 instances of SQL for all your databases? Is...

You can switch off schema replication?

What about just giving them access to SQL Server Management Studio 2012 express?

http://www.microsoft.com/en-us/download/details.aspx?id=29062

We sell software to the Healthcare industry (mainly NHS in the UK) and our customers are usually really slow to adopt new versions.

However, we've got half a dozen of...

We would need more information.

I presume you are talking about a Virtual Server in the cloud - if so, who is the provider?

Can you not ask them?

You can do this through SSMS, using Registered Servers:

http://msdn.microsoft.com/en-us/library/bb964743(v=sql.105).aspx

Can't you just order by Order ID?

Surely it's easier to see default locations and security settings in SSMS than trying to read through a log file?

No-one? That's surprising.

Hi Steve,

It was between 06:50 and 7:20AM if that helps.

Thanks.

What storage are you planning to use under your cluster?

In theory, the setup should be the same as far as the Windows cluster goes.

Some good info here: http://www.sqlservercentral.com/articles/Clustering/65994/

It's also bloody slow to post anything!

Edit: High CPU usage?? http://monitor.red-gate.com/Alerts/Details/591229

When the virtual lab opens, you should get two windows. One is the VM and one is the manual.

The password will be in the manual and is most likely: pass@word1