Martin

Did you try changing the default language of the login?  Having reread your original post more carefully, I think that this is the only thing it could be.  The data...

You don't give many details.  Have a read about merge replication and transactional replication with updating subscriptions and see if either of those meets your needs.

John

The dates you are importing are in the UK format.  So, in order for SQL Server to interpret them as UK-format dates, I would have thought that the user who...

Rudy

PAE/AWE won't have any effect if you have 4GB of RAM or less.  Only the /3GB switch is required here.

I will also add that if Alex does decide to use...

Manutosh

I'm not really sure what you're asking.  Is there a firewall between the client and the server?  If so, you will need to ask for the port that SQL Server...

Inspired by Lowell's suggestion to use sp_fkeys, I have finally come up with a script that I hope will work in all situations.  Here it is:

SET nocount ON...

You're right to say that active/ative requires two separate installs, because there are two instances of SQL Server on the cluster.  However, it's not true that there is no auto...

Claudia

1. I don't know, but I don't think it would hurt if you did.  Then you can follow all the way through the article in one go.

2. Not sure what...

Jeff

Take the following lines out of the previous script:

insert @columns

(

tablename,

columnname

)

SELECT 'MyTable', 'MyColumn' union all

SELECT 'ThisTable', 'ThatColumn' union all

SELECT 'AnotherTable', 'AnotherColumn'

and substitute my script in their place.  This...

The first one is saying that you need to grant your service account the Lock Pages in Memory right.

With regard to the second article, it seems to me to follow...

Yes, you're right.

John

I did see a script posted on this site that generated a script for all the foreign key (or was it primary key?) constraints in a database.  You could try...

As far as I know, the same rules apply to Windows 2003 as to Windows 2000, if you're not using the 64-bit edition.  The memory restrictions are not due to...

William

Could it be the absence of a comma before (and after) the fifth line?

John

Reet

I've never seen this message before, but I'd guess that when the backup was taken, it was striped across two backup devices or files, and you only have one of...