right click on your linked server, go to peroperties, go to general tab--you will see provider option.

Change the provider to 'sql server native client 10.0'

think again, your answer is already answered

Approach depends database to database.

the database which is being updated very frequently(kind of highly...

use 'sql server native client 10.0' as provider.

also in most of the case sql service are configured with windows account and that account need to be in domain users and domain admin account.

which version and edition of sql you in?

Why I asked because moving the model in sql 2008 is having different approach in compare to sql 2005.

if you have maintenance window available between 11.30pm to 5.30 am, then I will suggest check the job running on server and find the...

i have just read another very good article related to moving the database and advice you to have a look into it.

http://www.sqlservercentral.com/articles/Administration/65896/

article describe why using alter database is preferred on...

if you google it, you will find the...

Approach depends database to database.

the database which is being updated very frequently(kind of highly OLTP database), % growth is not recommended. Its better to have autogrowth with fixed size* and...

you first need to analyse your index fregmentation,

in general if fregmentation is less than 30 then reorganize is preferred else rebuild.

online = on is mainly provided from 2005 onwards...

as you configuring, so it will be active-active-passive server and you need three well prepared server.

While shortilisting the hardware limitation, please keep in mind that at emergency your one server...

yes, number of node is number of server.

read this article thoroughly, very good...

My pleasure Dias.

Venky,

as mentioned in article:-

If you haven't installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility.

check the dependency of the table using :-

EXEC sp_depends @objname = 'tablename'

try with wizard.

the column might be referred in some FK.