Answer Questions

• Bill Tice Download Microsoft OLE DB Provider for DB2

  Hi The readme file for SQL Server 2005 says: 4.10.1 Obtaining the Microsoft OLE DB Provider for DB2 The Microsoft OLE DB Provider for DB2, which is a component of Microsoft Host Integration Server 2004, can be downloaded for use with SQL Server 2005. For information about how to install and configure the OLE DB provider, see the documentation that is included with the provider. For instructions about how to download this provider, see this ...Show All

• CamCC Recommendations related to Skinning or rebadging SSRS portal

  Hi Experts!! We are interested in recommendations relating to "skinning" or rebadging the SSRS portal and related components to conform to our applications look and feel and also to better integrate our branding / logos etc. Please provide the required help or suggestions ASAP, at least a useful link wud also be fine. Thanks in Advance Shaun The Report Builder user interface is not customizable in this release. Thanks Brian for your ...Show All

• Donald Burr Processing options in AS2005

  I'm trying to get my hand around these new fangled processing options in SSAS2005 and have read TK Anand's excellent paper on the subject: http://msdn.microsoft.com/sql/default.aspx pull=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp . Unfortunately I can't see the wood for the trees so here's a question. Is it possible to selectively remove data from a partition i.e. Without doing a ProcessFull or ProcessClear Here's the scenario ...Show All

• Thomas Lee graphics appears in false position.

  Hello experts, I have fallowing problem in MS-Reporting Service: In the designsurface in V-Studio, i greate and adjust 2 graphics side by side. If i activate the preview in V-Studio or i copy the report on the server, the 2 graphics jump through the page. The side property are ok. A4 Format Where is the problem You can view the problem under following Link: www.schlempi.de/problemRS.pdf Thanks for your help!! my english is not the best, ...Show All

• dcaton reporting services parameter problem

  I have a report that uses as available values for a parameter a query. My problem is that the query return a list of available months, however, sometimes, i would like the user to choose null when they want to see all months in the report. but the query does not have a month null so null is not allowed. Is there anything I can do I cannot add a null record in the table itself. thank you, drey You can either allow null for a param ...Show All

• Wade1701 Synchronize SQL Mobile 2005 using ActiveSync

  I want to synchronize my database on Pocket PC / The Emulator that use WM5 and SQLCE3, but the synchronize is doesn't use IIS as the bridge, but i want to use ActiveSync as the synchronizer bridge. The rule like this. 1. Have database on Pocket PC. 2. Have application on Desktop PC. 3. When device or emulater placed on cradle, then the database automaticaly synchronized with database server on desktop pc. Why I want to use ActiveSync as synchron ...Show All

• Nenad Lakinski Server Registration

  TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, ...Show All

• lhoward SQL syntax to sum fields from two SQL statements

  I have two SQL statements that return sum(pcs) and sum(amt) from two differnt conditions. How do I get a total sum of pcs and amt from these two SQL went I union them SQL1: return columns value, SUM(pcs), SUM(amt) where amt is value*pcs $2 , 4pcs, $8 $5, 5pcs, $25 SQL2: return similar columns value, SUM(pcs), SUM(amt) FROM another condition giving: $2, 3pcs, $6 $5, 1pc, $5 If I use (SQL1 union SQL 2), I get $2 , 4pcs, $8 $2, 3p ...Show All

• Ranju_Akram Error "Logon failed" - SSRS Service user account rights

  I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link: Logon failed. Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569) I googled for that and it seems to be an authentica ...Show All

• Balaam problem with connecting to Sql Server 2000 from a mobile device

  Hi, I'm using SqlClient connection class to connect  via IP address (wireless connection) from: Windows CE 4.2 / .NET Compact Framework v1.1 to: SQL Server 2000/Win XP sp2 The connection string has a form like this one: Data Source=190.190.200.100,1433;Initial Catalog=MyDB;Integrated Security=false;User ID=sa;Password=; I succeeded to install SQL Server 2000 and to establish connection with the mobile device on my PC . But when ...Show All

• Ours backup does not backup

  Hi. SQL Server 2000 EE was able to do this but just found out that SQL Server 2005 EE does not do this. When I select a database to backup, even if i select a different path to backup to - it says it has successfully backed up and verified the backed up database however I am unable to locate it in that path specified.   I have also ran a Windows Search on the file - it does not pick up anything.   When I go back to SQL S ...Show All

• Mirko1728 System tables are not visible at all, why?

  Dear all, When you go to Sql Management Studio->Object Explorer and select Tables and then System you don’t see any at all. Why are not visible system tables for each user database as previously did Sql Server 2000 They are hidden or there is other stuff Any thought or view would be very appreciated. Tools forum is better for Management Studio questions: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=84& ...Show All

• MichaelY SQL Server Agent Job Help

  Hi, I get a large amount of data on my SQL server each morning via DTS Package, usually at 6:00 AM. However occasionally the DTS package fails and my SQL Jobs still run causing the tables it updates to be incorrect. The DTS package does update a table with the date that it ran. I've started to create this STEP which would be step 1, but my problem is that how do I write it so that the step will fail if RecCount = 0 Select count(*) as 'RecCo ...Show All

• SVK SQLexpress and autoincrement

  I've been searching for an answer a long time now... but nowhere I found a clear solution... Is it possible to implement autoincrement with SQLexpress edition thanks, that is what i was looking for! thank you both for the help... are you talking about IDENTITY property for integer-type column Yes it's supported. you can apply IDENTITY ...Show All

• rezaA Inconsistent package failures

  I'm debugging my first SSIS package and is getting inconsistent results. The package does not always complete successfully. When the package does fail, it fails at different tasks that accquire database connections. Any of the following error message would show up: [Execute SQL Task] Error: Failed to acquire connection "FORGE.FMC". Connection may not be configured correctly or you may not have the right permissions on this connectio ...Show All