Hello,

XSQL Software offer a free “Lite” version of their s/w bundle which includes schema and data comparison and synchronisation tools (http://www.xsqlsoftware.com/LiteEdition.aspx).

Okay it is not open source, but it is free.

Regards,

John...

Hello,

Logical Design: Select Natural Primary-Keys or allocate Surrogate Primary-Keys in each table (Location, SubLocation, Area, SubArea). Create one-to-many relationships down the hierarchy i.e. one Location has many Sub-Locations, one Sub-Location...

Hello,

I'm not 100 percent sure what your question is.

Is it "DBCC CheckDB" that you are after?

Regards,

John Marsh

Hello,

Take a look at the tools provided by SQL Solutions: http://www.sqlsolutions.com

In particular we use SQL Heartbeat.

Regards,

John Marsh

Hello Again,

To answer your new questions:

1) It depends on what kind of .Net application it is, but theoretically you could allow access to a client application located on a server...

Hello Again,

Thinking more about it, It could be related to the maximum number of connections, or the connection pool e.g. if the maximum number of concurrent connections allowed is 20...

Hello,

You could run a profile on the SQL Server to see what is happening.

Regards,

John Marsh

Hello,

What technology is the application developed in e.g. is it using ADO.Net?

I guess it is executing asynchronous DB commands i.e. the code does not wait for one insert to complete...

Hello,

To answer your questions:-

1+2) If the customers require SQL Server then you can install SQL Server Express for free.

3) If you have some VB experience already then the following link...

Hello,

In Enterprise Manager, expand the Management node and then the SQL Server Agent node. Right click on Jobs and select New Job, or right click on Alerts and select New...

Hello,

"I think the next step could be phoning Microsoft"

It's looking that way. Please post the resolution, as it could help somebody else in the future i.e. me 😉

Regards,

John Marsh

Hello Fred,

Thanks for the feedback.

I'm fortunate at work as the company pays for a license of the full Redgate Tool Kit, but following your tip, I'm going to download the...

Hello,

If your users are within a Windows Group then you could create a Login for the group (if it doesn't already exist) and then execute the following:-

Use master

Go

Grant View Any...

Hello,

The following thread suggests the issue might be related to the Service Account that SQL Agent is running under, rather than your account: http://www.dbforums.com/showthread.php?t=1631567

Is the Agent Service Account a domain...

Hello Fred,

Sorry, I didn’t quite understand what you needed first time. If you want to synchronise the schema between your Dev and Production DBs then a tool like Redgate's SQL...