Nothing was restored. Even if it had been restored this server was setup originally in mixed mode so there would never be any backup of windows only mode.

Thanks for the...

This happens in 2005 and they are loggin in with the same credentials. I tried creating a sql account and connecting to management studio with it and then opening a...

I am having this same problem. I as a dba do not have admin rights on the box. I have a default instance of sql and I have been granted...

I am looking for the samething but I would rather not purchase something to do this. Anyone have any scripts?

This is what I did but I think it stinks that the datepart function won't return the two digits even though you specify mm or dd.  Isn't that the reason...

Thank you all for your input.

I've fixed the problem by copying that table from another server but I wanted to know if anyone else had this happen to them. The stored procedures that are...

I have resolved this issue. Thanks.

We have tried to get the information from peoplesoft but they are being very tight-lipped. Are you running peoplesoft on oracle or sql server?

Are you running peoplesoft on sqlserver?

Thanks. I got it working.

I'm sorry I did try that and it does not seem to be working.

I'm not getting any errors. I receive the email minus the attachment.

ALTER PROCEDURE [dbo].[sp_send_mail]

@From varchar(100) ,

@To varchar(100) ,

@Subject...

I am still having problems with this. I have tried all the methods discussed and still can't get the thing to send attachments. Any more suggestions?