restore from backup

Steve Jones

steve@dkranch.net

I believe the query for xp_sendmail must be a statement(s) that returns a single result set. You are attempting to output messages witht the print statement, whcih is not the...

You just pass it in as a varchar.

create procedure MyPRoc

@MyParam varchar(100)

as

select @MyParam

return

go

declare @c varchar( 100)

select @c = '1,2,3,4,5'

exec MyPRoc @c

Steve Jones

steve@dkranch.net

You have the wrong password for the service. Login failed means the service tried to login and could not. Check this in Control Panel | Admin Tools | Services |...

Not sure what you mean. Do you mean that you need to know what you need to know? Or what you need to hire someone (temp or perm) to do?

You...

I do not believe this is stored. The current session is as long as you are connected with isql. When you "quit" of disconnect, the password is not stored any...

I'd drop them to the local drive and then ship them. SQL Zip will work, also you can use my PushFTP process. Been using it for months and had to...

most people only send mail, they do not receive it. If you do this, there is no virus infection. If you read mail, I believe Antares is correct, but I...

Log things from teh DTS pacakge. Either use the logging of the tasks, of write an ActiveX task to help.

Then run findstr from your batch file on the log file...

In a similar situation we added a column to tables that need logging and insert/update this column with the userid from the sproc. If this column is not updated or...

Can you backup to disk? Try a simple backup of master to disk and see what happens.

If this works, try a manual backup of master to tape and see what...

Agree with Jordan. I don't like running this on servers for a variety of reasons. Set a strong administrative policy that people should not be running browsers, etc. on servers,...

Agree with jgee. I import into a table that duplicates the setup on the main table.

Then I update the main table from the import using the PK as a match...

Have you logged in as the sql server account and successfully sent mail using iNotes? Be sure this profile is the default profile and Outlook is not set to ask...

Just like multiple physical disks enhance performance, multiple controllers can as well because the load can be spread.

I agree with Andy' suggestions and don't know which is best. Compaq and...