On Saturday we had planned DB maintenance where we failed over all of our instances to their corresponding correct primary node. In doing so all of the web/windows services...

CREATE TRIGGER NameOfTrigger ON ALL SERVER

FOR ADD_SERVER_ROLE_MEMBER

AS

IF SUSER_SNAME() NOT IN ('sa')

BEGIN

PRINT 'Only DBA''s can modify this server and it''s logins'

PRINT 'You''r statement has been logged and emailed to the...

you need to add in the ADD_SERVER_ROLE_MEMBER event to capture anything adding to a fixed server role

this URL might help in the future on finding the correct events to capture...

if you can (which will probably be a long shot) try and push for an upgrade to AX2012.

I've not had any experience with 2012 but from what I have heard...

personally you should do this at the application layer

if you want or have no other choice than to do it at the SQL layer, take a look at cross-tabs or...

AX 2009 is a tricky beast to trace as its all mostly written in APICursors

The attached RAR file has a couple of documents in it in relation to planning your...

the error says its a unique index so I am guessing that the table being inserted has a unique index on the a column or selection of columns which is...

what is the definition of the index which is referenced in this error?

Cannot insert duplicate key row in object "table" with unique index "INDEX". The duplicate key value is ("VALUE").

whatever way you tackle the approch you will increase network traffic

linked servers will establish the connection to server1, then it will talk to server2 and server3 so in essence you...

it would seem like the value is duplicated on the linked server side

the below should bring back any values where the value is duplicated on the linked server

select value from...

i was looking through the threads a couple of days again and someone wanted an inventory of their SSRS server reports.

one poster pointed the OP to this url http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/

it contains...

you might want to look at creaing custom views in msdb which the user can then call which filters on jobs owned by the users SID

even if you grant to...

in essence replication is used to transfer data from one server to another

so do you only want to execute the search query once, on one server? if so you need...

take a look here http://msdn.microsoft.com/en-us/library/ms188283.aspx this will detail which one of the three roles to grant the user in to within the MSDB database, then set the owner of the...

speak to your exchange admins and ask them to add in the ip address of the server into the mail relay configuration, it needs to go into two places in...