Joseph

More information needed, please.  What type of replication are you using, and in what topology?  What database are you trying to restore (publication, disribution, subscription)?  Are you restoring from a...

Glenn

Not the version, the edition.  You can get this by right-clicking on the server name in Enterprise Manager and choosing Properties.  There are also functions in T-SQL you can use. ...

John

For tables with a clustered index, drop the clustered index and recreate it on the new filegroup.  For tables without a clustered index, create one on the new filegroup.  Then...

Have a look at SET DATEFIRST in Books Online.  Then you can use CASE and the DATEPART function to subtract the correct number of days from the date.

John

Glenn

Also, you don't say whether you're using SQL Server 2000 Standard or Enterprise Edition.  If it's Standard, you're stuck with 2GB whatever you do.

John

To add a column to your table:

ALTER TABLE MyTable ADD Cash_WTD_Min INT  

To populate the column:

UPDATE MyTable SET Cash_WTD_Min = (SELECT MIN(Cash_WTD) FROM MyTable)  

You would need a trigger to keep all of this current.  However, I wouldn't recommend that...

Fredrik

Something like the script below will generate some SQL that you can inspect and then run against your database.

John

SET nocount ON

SELECT 'DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']'

FROM information_schema.tables

WHERE TABLE_SCHEMA = 

Martin

That's strange.  I think you're right - the next thing you need to look at is the regional settings of the computer on which you're running the import.  I think...

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