Hi,

I think what you may have done is to Restore the database with the 'Leave database read-only and able to restore additional transaction logs' option selected.

This mode allows you to...

Make sure that you have updated the Stored Proc with your own SMTP server name and that you can access that server accross your network by pinging it by name...

If you table has an Identity column on it with an increment of 1 you can use a select statement to do this which uses the modulo operator to separate...

I've only given the code a quick once over, but it looks like you could do away with the cursor. Cursors are heavy on resources, so it tends to...

It depends on why and when you wish to run the command, and what it does.

If you are calling the exe in response to a client action then consider running...

Is this a command prompt error or a ‘refiner’ error? Also NT Administrators can be denied access to files and folders - but they can just reset the permissions...

Is 'refiner.exe' expecting user input? If so it may wait indefinately (and so hang Query Analyser). Run the command from the Command Prompt on the server and see...

Try loading MS Outlook on the server (Outlook 2000 for SQL Server 2000), and set up an Mail Profile for the login which the Server Service uses. You can...

I don't think that you can rename a user, but you can use EM to script just the object permissions (deselect 'CREATE' and 'DROP' and select 'object-level permissions') and use...

There are occasions when your tables will have this warning and still be acceptable. I typically get this error when I work with the sql_variant data type, which has...

If the table is only updated once a day then a cursor could be used to loop through this table, starting at the record before the changed one up to...

It would seem to me that if it is really that important to hide the other databases, then your client should consider investing in another server and isolating the database...

Have a look at this FileUploader Library for ASP

http://www.asp101.com/articles/jacob/scriptupload.asp

I used this to grab jpegs to display on ASP pages, but it could pick-up files of any type, and should...

I used to have problems with SQL Mail on SQL Server 7 failing every few weeks for no reason. (There may be a buffer filling up somewhere, but this is...