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...

One way round it is to have the objects created as owned by their creators, but then changing ownership afterwards.  The script below will create a view in your database...

Clement

Assuming all currency fields in your database have the "money" data type, this will generate a script that will change your values as required.

John

SELECT 'UPDATE ' + c.TABLE_NAME + ' SET ' + c.COLUMN_NAME + ' = ' + c.COLUMN_NAME + '/1000.000'

FROM INFORMATION_SCHEMA.COLUMNS c JOIN INFORMATION_SCHEMA.TABLES t...

Ian

Temporary tables aren't less efficient than table variables.  Both will be created in memory if there is enough; both will end up in tempdb if they end up too large...

You say that Node B was rebuilt three months ago.  How was it rebuilt - from an image file or by reinstalling the operating system?  How did you reinstall SQL...