just a little remark:

If you post ddl with objects using UDT's, also post the UDT's ddl.

as allready stated, you just join all rows of both tables without a filter....

were they security admins at sql2000 side ?

if yes, add them to the serverlevel security admins group.

I don't have the answer to your question, but maybe you've choosen the wrong object to server your data need.

Why did you choose a clr-object ?

Why did you choose a...

- can you post the results of xp_fixeddrives ?

- can you post the results of :

exec master..xp_fileexist 'D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Search_AST430_log.LDF'

- is there a d-drive

- does the path exist ?

- does the sqlsever service account have the authority to read/write to that path ?

- most applications actualy do NOT need sa, nor sysadmin privileges to run the application itself.

- most software installers do not know this, or are to lazy to alter the...

- Solution 1: get rid of the linked servers ! 😀 Maybe the process can be performed asynchrone, so replaces by a sqlagent job or so. You might even consider...

move the backupfolder to your c-drive to avoid this kind of hassle !

So it will be able to use c:\backup\...

Also keep in mind it has to be able to write...

Basicaly two types :

- nonclustered ( max 254 / table) (shortcut access)

- clustered (max 1 per table) (physical dataorganisation)

Full-Text Indexes are a whole different story because of their implementation.

check...

SQLServer (like any rdbms) uses statistics to determine an accessplan for your query.

If there are no statistics available it will use predefined distribution assumptions.

At database level you can set autoupdatestatistics...

- check your sqlserver errorlog file at both servers !

- maybe the script can help you out :

Troubleshooting Service Broker (SSB) http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

follow Madhivanan's advise !

select fromdate

, convert(datetime,fromdate,100) as fromdate_datetime

, convert(char(23), convert(datetime,fromdate,100), 121) as frildate_datetimestring

from emp

where convert(datetime,fromdate,100) > convert(datetime,'2/16/2007',100)

order by convert(datetime,fromdate,100)

- with sql2005 it is advised to switch to DBMail.

- Can you find a error notification in the job history ?

- Can you find a error notification in the SQLAgent.out...

you can offcourse always put the db in singleuser mode within the restore-batch.

use master

alter database yourdb set single_user with rollback immediate;

restore database your db

from ......

raiserror ('DBA- Restore Notification:...

as far as I know that is not possible.

You'll have to restart from your fullbackup and keep it in Norecovery until you decide to use recovery.

At that time it will...