Viewing 15 posts - 151 through 165 (of 2,635 total)
Creating a new DBA group? The domain logins must be created before you can add them to SQL Server. You can use CREATE LOGIN and sp_addsrvrolemember to give the...
February 24, 2010 at 10:37 am
By default, only members of sysadmins can access sysxlogins, so are you executing the stored procedure as a sysadmin?
February 24, 2010 at 9:31 am
No. The Transfer SQL Server Objects Task is for moving objects + data (if table). You should use an Execute SQL Task to insert/update/delete the data in the...
February 19, 2010 at 11:52 am
GSquared (2/19/2010)
SSIS packages don't have to be run as jobs. They can be run from the command line using dtexec.
Yeah, I know. What I was trying to illustrate...
February 19, 2010 at 9:20 am
Don't maintenance plan jobs run as the SQL Agent service account like other jobs even if they're owned by another login? I don't use maintenance plans much so I'm...
February 18, 2010 at 12:34 pm
See my reply in this thread: http://www.sqlservercentral.com/Forums/Topic863044-146-1.aspx#bm863413. In my case, the objective was to trigger execution of an SSIS package from an application.
February 18, 2010 at 12:22 pm
I've used this method:
Have the Server A job update a table on Server B when it completes, then have the Server B job query the table in it's first step...
February 18, 2010 at 12:07 pm
Is anyone else confused? Are k2000.rajesh (the op) and k2000rajesh the same person?
February 17, 2010 at 4:52 pm
If you enable package logging to SQL Server, it will log errors in msdb.dbo.sysdtspackagelog and msdb.dbo.sysdtssteplog. You can query those.
Enable logging by editing the package, opening Package Properties...
February 17, 2010 at 4:35 pm
If you mean when the file will be deleted by the Cleanup Task in the maintenance plan, I think you can only find that in the plan itself, not in...
February 17, 2010 at 1:02 pm
k2000rajesh (2/17/2010)
In step1 bpmc_cmd_costobject adjacencylist_postdeploy reported.the process could not be created for step1 of job 08a9bc(reason the system cannot find the path specified)
please let me know
If there's a backup statement...
February 17, 2010 at 12:47 pm
You've fragmented the thread by posting this question in another forum: http://www.sqlservercentral.com/Forums/Topic867314-266-1.aspx. Follow Paul Randal's advice in that thread
February 17, 2010 at 12:40 pm
Paul Randal has a nice article about logging here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx?pr=blog.
Logging can't be "turned off" and it's never been controlled at a table level in SQL Server. Maybe...
February 16, 2010 at 10:02 am
You can find lots of scripts by searching this site. Here's one I've used: http://www.sqlservercentral.com/Forums/Topic436343-359-1.aspx. You can also see the object permissions of a role in SSMS by...
February 16, 2010 at 9:43 am
Duplicate post. Please direct answers to this post: http://www.sqlservercentral.com/Forums/Topic864318-148-1.aspx#bm864417
February 12, 2010 at 2:14 pm
Viewing 15 posts - 151 through 165 (of 2,635 total)