haiao2000 (10/29/2012)
Jeff Moden (10/28/2012)
This can be done pretty easily. Create an SQL Server job to run the proc and have the app kick the job off.Saying I have a SQL job that executes a stored procedure as follow. Could you give an example (VB or C#) code to execute this job. Provided procedure DoSomeCleanupTasks takes 2 parameters (A Int, B DateTime)
My apologies. Can't help there. I'm a hardcore data troll. I don't even know how to spell C# never mind use it.
--Jeff Moden
Change is inevitable... Change for the better is not.