This should prove helpful

http://support.microsoft.com/kb/224071

Hi,

Thank you very much, I now seem to have something working. Will continue to refine and consider the sa issue.

Thanks

Colin

hi,

Thank you, very helpful. I have created a password protected bak and restored it. However, I need toadd a date to the file name, as you get when...

Hi,

Hi,

Error Log stated that it had problems access the Drive holding the LDF files or the LDF files themselves.

Investigations showed that the AD user which runs...

Any idea what the following values from sysdatabases are - they are not mentioned in BOL and Google is not being much help, at prtesent.

STATUS1STATUS2

DBase124 ...

Hi,

Critical updates are currently being removed, so am unable to access Log file at present.

Have run DBCC CheckDb and get the following

Server: Msg 945,...

Thanks folks. Have tried xp_cmdshell without success and I am now trying ActiveX. My script below fails with "Expected end of statement" but I cannot see any error. Thoughts? Thank...

Thanks for the replies. I have been running the process on the server and saving the results to file. Will take on board the suggestions made and see if this...

Rohit,

This should be a fairly simple process, if you have any experience of DTS.

Open DTS and add a lonk to tour spreadsheet and also a link...

Thank you very much. I suppose that I now have to wait for a failure to test the code. 😉

Colin

  Have made progress with this, but get an error "ActiveX componenent can't create object: 'Excel.Application'

   Am I right in thinking that the server running the DTS must have Excel...

   Thank you. I assume that this will be the last step in the DTS package.

    Will need to do some more reading on the subject, but the principle...

Thanks. I think it best to run them in squequence, suits my tidy mind.;-)

Am I right in saying that I need to do the same thing for each database, including...

Just trying to understand the process and ensure that things get created in the right order. A user cannot be allocated to a database if they have not already been...