can you see the server in the serverlist when you try to register it in SQLserver management console ?

Did you check case sensitivity ?

If your server is installed case sensitive, .. your userId and password are also case sensitive !

avoid trailing blancs in passwords !

- how are you trying to connect ? Windows authenticated or SQL-authenticated ?

- can you ping the sqlserver ?

Drop / Create will be your only solution.

maybe this script can gat you on track :

set nocount on

print 'Linked Servers voor [' + @@Servername + ']'

print '------------------- ***********'

if not...

is a connectivity problem (could be anything)

- can you ping the sqlserver ?

- provide a correct userid and password for the connection.

- can you connect to the sqlserver using query...

check your stored proc "USR_Demographics" for string "g?tdate"

keep in mind that the function getdate() cannot be used as a default value of an input parameter for a stored procedure !

- end you statement with a semicolon ;

- this also can do the trick

alter TABLE [dbName].[dbo].[tableName]

add  colx bit not null default 0 ,

       coly bit not null default 0...

- maybe tablediff utility can do that for you. aarch that's sql2005

- I guess the SQL_Server_2000_Web_Services_Toolkit can do that to.

table caching is a dangerous thing to do ! because when you pinn a table, it will not be cached out ! Maybe your table grows beyond your expectations consuming...

Maybe DTS can do a better job for you.

In addition to Pam Abdulla's reply :

If you're updating a varchar-type column, it may be possible sql has to relocate your row to another page, maybe even perform some pagesplits...

just try to do an easy client install using a script when you have vs2005 installed with sqlexpress or when sqlexpress with its...

If this is a full load/refresh or your applications are offline during this load, you might want to disable your Non clustering indexes ( if your data is thrustworthy

If you have a clustering index defined for your table, when you prepare your data for load, sort it according to your defined clustering index !

This way you avoid page-splits...

If you change to simple, it will only keep info for the open transactions.

So if your load is in a single transaction, it will still grow to 95 Gb.

Can you...