Viewing 15 posts - 136 through 150 (of 7,635 total)
kumar-378458 (8/31/2012)
While i see the server log it is:
The activated proc '[dbo].[spMessageProcSample]' running on queue 'FileTableDB.dbo.SampleQueue' output the following: 'The server principal "fl\user2012" is not able to access the...
August 31, 2012 at 12:16 pm
Sean Lange (8/31/2012)
...Ahh, the devil is in the details huh? 😀
Indeed.
Well I still say that if you don't need a global temp table you shouldn't use it (which is...
August 31, 2012 at 11:24 am
The service-broker procedure or executor needs to be authorized to execute these commands.
And if it is running from a database other than your [SSISDB], then it will need...
August 31, 2012 at 11:18 am
Sound like another SqlServer Ad/Security "sticky-cache" problem. Rebooting usually fixes this for me.
August 31, 2012 at 11:13 am
Sean Lange (8/31/2012)
Sure for DBMail it works well. I just never saw anything in here that indicated that. Global temp tables can just a pain to deal with so unless...
August 31, 2012 at 11:08 am
And how have you implemented database auditing on the whole database? (there are at least a half-dozen different ways to do it)
August 31, 2012 at 11:02 am
Sean Lange (8/31/2012)
Potso (8/31/2012)
August 31, 2012 at 10:56 am
You can also add a WITH EXECUTE AS .. clause to the Trigger so that it can run under its own permissions, instead of having to rely on the User's....
August 31, 2012 at 10:36 am
Michael Valentine Jones (8/31/2012)
The engine already deals with checking that data is valid for the type, referential integrity, indexes, and many other things that you have to program into an...
August 31, 2012 at 10:22 am
rich-521822 (8/31/2012)
There is only one step beyond that of starting the job.
Just a single call to DTSRUN.
I have reset the time schedule and waited to see...
August 31, 2012 at 10:11 am
Yes, SQL Server does seem to "sticky-cache" a lot of the AD security information for a long time. Rebooting your server is probably the recommended way to fix that.
Alternatively,...
August 31, 2012 at 10:03 am
Also, make sure that you have one of the Log To Table/File options set in the Advanced tab of the Step properties. Then you should be able to...
August 31, 2012 at 9:54 am
How many steps does the Job have? What are the step types and what are the step commands?
August 31, 2012 at 9:50 am
Viewing 15 posts - 136 through 150 (of 7,635 total)