AX Development

Hey All, I am trying to get a list of error messages on a server using the sp_readlogerror stored procedure. I have a central server A and I am trying to get the information from Server B. exec [server B].model.sys.sp_readerrorlog the above statement works well and gets the data, But it throws up a transaction error when i try to insert into a temp table on server A. Here is the code running on server A: create table #ErrorLog(LogDate datetime, ProcessorInfo varchar(1000),Text varchar(5000)) insert into #errorLog exec [Server B].model.sys.sp_readerrorlog this Throws up a transaction error as below OLE DB provider "SQLNCLI" for linked server "BHSF-BTR-W318" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 3 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "BHSF-BTR-W318" was ...

Hey Guys, I have come across a very interesting article by one of the members (Paul White)  of the SQLServerCentral group. Here is the Link to that:   http://sqlblog.com/blogs/paul_white/archive/2010/08/04/another-interesting-merge-bug.aspx have Fun....

/*This Script is used to list all the Unused tables on a Server. The script does not work for the sql 2000 Server*/ declare @sql varchar(2000), @DatabaseName varchar(100) /* LOOP THROUGH THE SERVERS*/ If Object_ID('tempdb..#unusedTables') is not null drop table #unusedTables create table #unusedTables(DatabaseName varchar(100), Object_Id int, TableName varchar(100))    /*CURSES THROUGH ALL THE DATABASES ON THE SERVER  */     declare Database_list cursor for         select     name from     sys.databases where     name not in ('master','msdb','modeL','tempdb')     open Database_list fetch next from Database_list into @DatabaseName while @@fetch_status = 0 begin      /* THIS PART GETS THE LIST OF TABLES IN A PARTICULAR DATABASE*/         set @sql =    'select   ...

USE [MTSC] GO /****** Object:  StoredProcedure [dbo].[TimesheetHoursDailyReminder]    Script Date: 11/03/2010 13:28:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[TimesheetHoursDailyReminder] AS /******************************************************************************** Stored Procedure Name:    [dbo].[TimesheetHoursDailyReminder] Date Written:             10/06/09            Author:                    Chitanya Chitturi Project/System:            MTSC                Purpose/Description:    Time Sheet Reminder Input Parameters:        Tables:       ...

/*FINAL CODE*/ declare @servername varchar(200), @sql varchar(2000) /* LOOP THROUGH THE SERVERS*/ if object_id('tempdb..#failedjobs') is not NULL drop table #failedjobs create table #failedjobs (servername varchar(200), jobname varchar(500)) declare server_list cursor for select     servername from     dbo.servers where     enabled =1     and retired = '9999-12-31 00:00:00.000'     open server_list fetch next from server_list into @servername while @@fetch_status = 0     begin         set @sql =    'select                     jh.server as server_name,                     sj.name job_name                 from  ...