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

We use acursor driven proc but just altering it to be #temptbl oriented, you might handle it like this:

DECLARE @SQLStatement nvarchar(4000)

--DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY FOR

Declare @tmpReindexList table...

Best practise is to always map your procedure parameters.

Otherwise parameterse are mapped according to their position in the parameterlist in the exec-clause.

Also keep in mind when using e.g. a vb.net...

if you need order, then you'll have to tell it to the system.

So add and "Predicate_order" column so you can sort your select set according to it.

If you need rows...