You have created an ODBC then you do you use an OLEDB provider you can create linked servers with ODBC connections.

Use a complex password and try. What dean says is right by default password complexity is enabled in sql 2005.

yes might be a permission issue. Check for permissions in registry, default installation pths, other installation paths and sql file paths.

Exclusive help for BCP is available in BOL. did you check that. If you want us to script for you can be more specific.

Is it configured through a maintenance plan job or you use your TSQL code. If the second option then perform a checkpoint before you start the back log operation. 9...

Mulitple versions of SQL Server 2000 and 2005 are supported in a single server.

If you are confident that all your servers to be linked runs under the same domain account and permissions are there and still want to use 'current security context mode'...

Is your login added to the server. Check if it enabled in sql server. also can you post the exact error message.

Goto to enterprise manager, tools, generate script and in the options tabs you can find script server logins.... check that it will script your logins in the server. include object...

create table #spacedetails (name varchar(100),totrows bigint,reserved varchar(30), data varchar(30),index_size varchar(30), unused varchar(30))

insert into #spacedetails

exec sp_MSForeachtable @command1 = "sp_spaceused '?'"

select name,totrows, replace(data,'KB','') as 'Data in KB',

replace(Index_Size,'KB','') as 'Index Size in KB' ...

Search this site for a vbs script that has been already posted that will give you a list of all user databases in an excel format for multiple servers/instances.

change the sp to take an input for sort order. have your query written as dynamic query and add the sort order what you get as input parameter to the...

Try to register the server with sa and configure the logshipping.

If you use different account then its not possible to have currenty security context with windows mode. Or check if you can impersonate your domain service accounts so that they...

Add the user to serveradmin role.