Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Execute Jobs

    I got one more problem, your tip works fine but now i need to know when the job stops. If i give the user 'sysadmin' permissions he can get the...

  • RE: DTS and VB

    you need to add the SQLDMO.DLL to your project, and then try this code

    Public Sub ExecutJob(JobName As String, Server As String)

    Dim oJob As New SQLDMO.Job

    Dim sqlServer As New SQLDMO.sqlServer

    'Trusted connection

    sqlServer.LoginSecure...

  • RE: Splitting a column into Fname Lname

    rmarda code works fine if you just have first and last name. If you a complete name you need something like this

    SELECT LEFT(fullname,CHARINDEX(' ', fullname, 1) - 1) AS fname,...

  • RE: Execute Jobs

    Where do i grant this permissions (database role 'TargetServersRole') because i can't find it anywhere!

    Thanks

  • RE: Scheduling DTS

    I don't want to run the package, but run the job that i scheduled for the package. When i try to do it for this users they could not see...

Viewing 5 posts - 1 through 5 (of 5 total)