.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Execute DDL Task logging disappears after applying SQL Server 2008 SP2

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

I am using various SSIS packages to manage different Analysis Services (SSAS) databases.  The packages create the necessary DDL for processing the dimensions and partitions in the SSAS databases and then run the DDL using Execute DDL tasks.


I've been using SSIS logging to capture the log information for the Execute DDL Tasks and directing that log data to a SQL Server table.  I've noticed that since the application of SP2 I only get the 'Started building processing schedule.' log message for the Execute DDL Tasks and none of the other event log entries.


This has happened at a couple of the sites that I support.  Install SP2 = no logging (with the one exception) from the Execute DDL Task steps.


Is this a known issue?  I did a couple of searches and didn't find anything.


Thanks,


Ray




View Complete Post


More Related Resource Links

Post Upgade task, Upgrading SSIS Pacakges to SQL Server 2008.

  
Hi, I am trying to upgrade sql 2005 packages to sql 2008 after doing in-place upgrade of DE and SSIS. Can I know what packageformat column in msdb.dbo.sysssispackages refer to, as according to http://msdn.microsoft.com/en-us/library/cc879336.aspx the value should be 2 if the package is in sql 2005 and it should be 3 if it is upgraded. But I am seeing only 0 or 1.   Can I know any other method to figure out version of the ssis packages? I am having issues upgrading SSIS Packages from 2005 to 2008, using SSIS package upgrade wizard.   Thanks for your help. Regards, KRanp.

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

  
I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

sql 2008: the activity monitor is unable to execute queries against server

  
Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

The Acityvity Monitor is unable to execute queries against server <server name>.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

Additional information:
   Unable to find SQL Server process ID xxxx on server <server name>
   (Microsoft.SqlServer.Management.ResourceMonitoring)



Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

Please help.

Applying SP1 for 2008 Standard Server

  
Dear users, This morning I attempted to apply SP1 to a 2008 Enterprise SQL Server. I encounter this message. I wonder what I should do to resolve this problem. Could you advise me what to do? Meanwhile I will search for solution. Thank you in advance. TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_DTS_Full,Connectivity_Full,SQL_SSMS_Full,SQL_BIDS_Full,SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed. Error code 0x84B20001. ------------------------------ BUTTONS: OK ------------------------------

Error Applying SP1 to SQL Server 2008 Standard

  
Has anyone seen this error when applying SP1 to SQL Server 2008 Standard Edition.  It's on a Windows 2008 SP1 Server 64 bit machine.  Here is the error:

The process cannot access the file 'C:\Windows\SysWOW64\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

I've tried stopping the SQL Server agent and rebooting but I'm still getting that error.  Anyone ecounter that before?  What is that dll used for?

"Cannot execute as the server principal..." SQL 2008 SP1

  
I found an article about this error but pertaining to SQL 2005:

http://support.microsoft.com/kb/913423

Looks like it hasn't been fixed in SQL 2008?

Anyway....

I created a GROUP in AD on the domain controller.

 

I created a login for this group on the SQL 2K8 SP1 server.

 

I created an user one of the databases.

 

When I look at the properties of that database, and attempt to see what the effective permissions are for th

Applying SP1 to 2008 Enterprise SQL Server

  

Dear users,

 

I ran REPAIR and it ran successfully. After that I applied SP1 but got a below error at the first page

 

TITLE: SQL Server Setup failure.

------------------------------

 SQL Server Setup has encountered the following error:

 "A failure was detected for a previous installation, patch, or repair for instance 'XXXXXXXX' during configuration for features [MPT_AGENT_CORE_CNI,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed."

 Error code 0x84B20001.

Could you advise what to do?

 

Thank you,

 


SQL Server 2008 query execution time is different if i execute it in management studio or from code

  
When I execute query from software which i wrote in c# it required lots of time to complete but if I execute exactly the same query from management studio it will be done in seconds. In both cases execution plan is the same. 

SQL Server 2008 TempDB overload, simple logging

  

Hello,

I have the following stored proc:

ALTER PROCEDURE [dbo].[spgetspreadstage2all]
	-- Add the parameters for the stored procedure here

	
	
AS
BEGIN
/****** Object: Table [dbo].[tblspgetspreadsectornew2]  Script Date: 08/20/2010 18:35:51 ******/
	IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[tblSpreadsStage2]') AND TYPE IN (N'U'))
	DROP TABLE [dbo].[tblSpreadsStage2]

	CREATE TABLE [dbo].[tblSpreadsStage2](
	ID int identity (1,1)not 

Execute stored procedure on linked DB2 server from MS SQL 2008 SP1 64 bit problem

  
Hi everybody. I am trying to execute stired procedure on linked DB2 server from MS SQL 2008 x64
I installed IBM Access client x64 and on provider tab showed up 3 providers IBMDASQL,IBMDA400,IBMDARLA
I installed linked server as shown on this two links:

1)http://www.mcpressonline.com/database/db2/db2-integration-with-sql-server-2005-part-i-linked-server-enhancements.html
2)http://stackoverflow.com/questions/329051/execute-db2-iseries-stored-procedure-from-a-sql-2005-linked-server

I installed linked server using all this 3 providers

sp_addlinkedserver
    @server=N'DB2',
    @srvproduct=N'DB2 UDB for iSeries',
    @provider=N'IBMDASQL',-- provider for example
    @datasrc=N'ASTEST', -- mydatasource
    @catalog='S65CF29B'
go
exec sp_addlinkedsrvlogin DB2,false,null,'telebank','password'

I can run procedure from the extended stored procedure, but when i try to execute it as shown on the linkes above i get the following error:
Could not execute statement on remote server 'DB2'.


declare
  @branch    as varchar(4),
  @cli   as varchar(6),
  @suffix    as varchar(3),
  @date1     a

How to execute sql script file in Sql Server 2008

  
want to execute a sql script file if user want to apply the new database changes. That script file is present on the server and if user wants to apply the new changes it just press a button i want to know how to execute that script file to a particular server database in Sql Server 2008. Im using C# for coding

HttpContext.Items and Server.Transfer/Execute

  
The problem was basically that when a Server.Transfer call was applied the script container (and also various ClientScriptProxy script embedding routines) would potentially fail to load up the specified scripts.

Sql Server 2008 Tutorials

  
This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

  
Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008

  

i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database

  

dear Friends


For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 


And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	


Please help me to overcome this issue and let me know where can I download that database too.


Thanking you

happy Coding


PostGreSQL to sql server 2008?

  

Hi,

I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?

Regards,

ap. 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend