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...

figured it out

MetaData.value('declare namespace NS="http://core.company.com/MetaData.xsd"; (/NS:MetaData/NS:StateStandard)[1]','NVARCHAR(MAX)')

just one thing that I am not so sure on and might cause an issue

when you change from Simple to Full, before you can take a TX log backup...

from what I remember when I was looking at this

you need to look at the authentication methods needed for SSRS, will need custom or forms auth based, then you just...

load the log into a temp table then do a query against the date column

create table @errorlog (date, source, message)

insert into @errorlog exec sp_readerrorlog

select * from @errorlog where date >=...