I have the following solution. I can get the user info form the sys.syslogins table. Since I know the password expiry policy (no. days). I can send...
The goal is to notify the application team via an e-mail so that they can change the configuration on the application
Hi, I have created a database user with password expire policy. I want to automate the process and get an e-mail notification as soon as the password...
Thanks. I will set up the proxy user and use it for the XP_Cmdshell.
The explanation I got from my SQL Server team is: XP_cmdshell spawns a windows command shell and executes in the security context of the SQL server...
Yes, what ever you guys said is true. The XP_cmdShell is available and we have to configure it to use it. Since the XP_CmdShell runs under security...
Hi, I am using XP_cmdShell in storedprocedures to Copy,delete, FTP files. I am migrating database from SQL Server 2000 to SQL Server 2005. I have to...
Separate names with a comma.
