You shouldn't have any problems is you are purely working with datetime, as SQLBill states these are represented the same internally regardless of you regional settings.

However you may experience...

I've not tried it, but have you investigated using Hetrogenious Replication, either for a Snapshot or for merge (not sure which, if either, is possible

Hi SQLBill,

You should be able to execute sp_password from Access in VBA by creating an ADO command object with parameters for the old and new passwords.  These can...

Hi SQLBill,

I have a web app which allows super users (application administrators) to manager SQL Server logins on-line and standard users to modify their own passwords.

My ASP page calls sp_password to change...

One tool that I've heard very good things about (but not used myself) is Clementine (http://www.spss.com/clementine/). 

Has anyone out there had any first hand experience interfacing MS SQL Server...

Try using BACKUP from the source and RESTORE on the destination then.  It doesn't transfer Jobs, Errors, objects in master or logins, but it does work.

There's an article on MSDN with this error:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274463

In summary it says if the destination server is started with the Local System account, or an account that does not have local...

One issue to watch for when using DTS to import MS Access data is that Access date/time fields support 'older' dates (100 AD through to 9999 AD) compared to the...

I had a problem with performance accessing data using views from two databases. In the end I combined the two databases into one and the performance improved considerably.

This may...

The problem with using DATEDIFF() for you criteria is that DATEDIFF will round to the nearest number, and so cannot be used in this way, for example, if you run...

Use Enterprise Manager. Select the SPs you wish to transfer, right click and choose Generate SQL Script. Select any additional funcitons or views that you wish to script and set...

Another option would be to have the stored procedure run the view using a SELECT statement. This wouldn't work if you used an updateable view though.

Alternatively if you wish...

quote:

---

Was thinking. How about a SQL assistant? It can hover around EM and QA

---

It would...

That may interrupt the agent and cause an error, but I wouldn't have thought that it would remove the agent from the server...

You can coax SQL into scripting table updates. Try running something like:

SELECT 'UPDATE Messages SET ArabicMsg = ''' + REPLACE([ArabicMsg],'''', '''''') + ''' WHERE...