Hi Brian

I haven't used SQLping, may u perhaps share more light on that

Tx

Thank you once again for suggestions:-)

Thanks a lot, now it's sorted:-D

I changed it to d:\ with the same permissions on c:\ and folders

Tx, how do put that together in a code e.g is the below correct

select col1,col2,DATEADD(day,-1,getdate())

from test

ta

Hi

Thanks for ur response, it's a parameter for a report but the report will schedule within SSRS to send an email auto

Ta!!

Thanks for your response.

My sql server security propeties is set to audit both failed and successful logins. What about syslogins?

Thanks for your response!!

No i dont get that error from SQL Conf Manager. When go via computer management, that's were i get an error.

Thanks

Thanks for your response.

xp_cmdshell it's part of my code but now the tricky part is, i'm using replication then i have a job that validates all subscribed articles, if one...

In my case the process runs from Peoplesoft application and connects through linked server to another sql box that runs a billing app. so the process from Peoplesoft insert and...

Hi

No partition on the table

Thx

Thank you very much for your help it worked. Now it's on production

Thanks for your time and help, i found the problem it now works.

I need help on the same issue with regards in updating the domain account. Example

Staff_numb ...

Thanks for your response, i applied the below with few modifications.

After exec, no record affected. Please help. Thanks once again

CREATE PROCEDURE SP_UpdateStaff

@staf_num VARCHAR

AS

Update SECURITY_USER1

SET PASSWORD_FULL = NULL

WHERE staff_numb =...