Marios Philippopoulos

Forum Replies Created

Viewing 15 posts - 511 through 525 (of 1,518 total)

RE: Being alerted when a certain stored procedure is blocked

dmoldovan (3/22/2010)
See if these help:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/04/06/event-notifications-monitoring-blocked-processes-and-other-events-end-to-end-how-to-set-it-up-and-make-it-work.aspx
http://blogs.microsoft.co.il/blogs/dannyr/archive/2008/10/07/getting-blocking-info-in-sql-server-2005-amp-2008-the-easy-way.aspx
http://www.sqlservercentral.com/articles/Blocking/64474/
Thanks! I'll have a look at these links.

March 22, 2010 at 3:48 am

#1137463
RE: Deployment Error in Analysis Services Tutorial - The source attribute doesn't have the attribute hierarchy enabled

denglishbi (3/12/2010)
You can definitely set the AttributeHierarchyVisible property to False, but you must make sure that any attribute that is part of a user defined hierarchy has the AttributeHierarchyEnabled property...

March 12, 2010 at 8:19 pm

#1133101
RE: Managing SQL Analysis Service Objects with SSIS and AMO

Marios Philippopoulos (2/26/2010)
Thanks for the article.
I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.
I'm...

February 26, 2010 at 9:50 am

#1125691
RE: Managing SQL Analysis Service Objects with SSIS and AMO

Thanks for the article.
I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.
I'm using SSAS...

February 26, 2010 at 9:04 am

#1125651
RE: Report on SSAS-cube role properties

Is Analysis Management Objects (AMO) a good way to go?
Anyone have any AMO code that does similar things that they could share?
Also any other feedback on AMO would be appreciated.

February 26, 2010 at 8:35 am

#1125625
RE: Trying to Achieve Security and Audit-Trails

Elliott W (2/24/2010)
The MS provided tools are not the only tools and blocking them alone not really secure. Basically anything a user can do from SSMS can be done...

February 25, 2010 at 11:20 am

#1125130
RE: Trying to Achieve Security and Audit-Trails

Elliott W (2/24/2010)
You still haven't addressed the fundamental problem.. So we keep SSMS out, that is nice, but "programname" is set at the client, there are no controls on...

February 24, 2010 at 10:38 am

#1124390
RE: Trying to Achieve Security and Audit-Trails

Elliott W (2/24/2010)
mphilippopoulos (2/24/2010)
You can use logon triggers for objectives 2 and 3:
http://msdn.microsoft.com/en-us/library/bb326598.aspx
Logon triggers won't help audit WHAT data was changed just that a user logged in and some metadata...

February 24, 2010 at 8:40 am

#1124306
RE: Automating SQL Reporting-Services (SSRS) Encryption-Key backups using RSKeyMgmt utility

Edogg (2/23/2010)
Stumbled across this link a while ago, it's a handy little trick.
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8976dd8f-44a8-4fb7-b3ac-05b06f33f9f1/%5B/url%5D
Thanks! That'll work...

February 24, 2010 at 3:30 am

#1124183
RE: Reporting Services Encryption Keys - how often should they be backed up?

Anybody?

February 23, 2010 at 11:09 am

#1123773
RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

sihaab (2/10/2010)
Not at all...It is just a trigger and fires every time when user logs in.
Believe me, if you are Operational DBA or Production DBA, you need this to...

February 10, 2010 at 1:11 pm

#1117159
RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

sihaab (2/10/2010)
This will help you to understand what is server wide log in audit..
Link 1)
Linke 2)
You can control the user by host name, application and more...
I Google my self on...

February 10, 2010 at 12:01 pm

#1117057
RE: Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

Thank you for the answers.
The situation is like this: we have given access to the Windows accounts of members of our developer and business-analyst teams so they can provide application...

February 10, 2010 at 11:23 am

#1117039
RE: How to kill Rollback process

GilaMonster (1/29/2010)
rotkehlchen105-kak (1/29/2010)
I don't know why people keep saying that the rollback will resume when restarting the server. That's BS
Nope, it's fact. I can pull error log entries out to...

February 3, 2010 at 2:52 am

#1112717
RE: Strange error while doing backups - Error: 3041

Thanks all for the responses.
The command is syntactically correct, has run to completion many times before.
I may have missed a comma or two in my earlier post, as I...

February 1, 2010 at 11:53 am

#1111858

Viewing 15 posts - 511 through 525 (of 1,518 total)