Answer Questions

• tranders Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• Jinlin Chen Query Analyzer, Slow Query responses

  Hi there Running query analyzer against two different server. the first only need 1-2 secs to return the query result, the other return 7-8 secs for the query result. plz advice what could cause this slow performance thx there can be many reasons, connectivity,amount of data (on 2 servers), indexes (on 2 servers), statistics updated on one and not on another or even fragmentation of data segments... thus for a query to perform at the same rate many factors need to be considered by the DBA.. ...Show All

• Frances83 Data flow source that will take a string variable with csv structure?

  I am able to use a custom script task to receive a MSMQ package and save the package contents to a flat file. I can also use the bulk load task to push the flat file contents into a SQL table. However, I would like to save the package contents to a variable (done, it works), and then pass that string variable to a data flow task for SQL upload. In other words, I don't see any reason to persist the msmq package contents to disk. My question is: Which data flow source can I use that will accept a string variable The string variable will then need to be processed with bulk load or an execute sql task. Btw, the content of the string variable is a csv style string: "01001","11/21/2006",15 "01001",& ...Show All

• cdun2 Custom Semi-Transparent bar charts?

  I know that SSRS 2005 has a built-in semi-transparent color chart palette, but I'd like to define my own custom color semi-transparent palette. Brian Welker's blog ( https://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx) has a terrific post on how to create your own custom color palette, but it generates solid colors. How can it be tweaked to create semi-transparent colors Is there another function that needs to be created to define the transparency of the color palette Thanks in advance, Pete Transparency is more than possible with ANY system palette or custom palette. The trick (work-around whatever) lies in modifying the 'alpha' component of the colour for each series in the chart AF ...Show All

• Evgeny Popov Deadlock at trigger

  a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. i trid to change isolation as SERIALIZABLE or REPEATABLE , but i cannot solve the problem. i guess the "while loop" affects the result because i try to cancel the loop and execute smoothly. How to solve the deadlock Thx ----------------------------- i used the following commands to change isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE begin transaction commit transaction ----------------------------- the code are as follows: declare setskuCursor cursor local static for select item, qua ...Show All

• briggins5 multiple database performance

  I'm planning on creating multiple databases on a client because I'm storing a large amount of binary data (jpg's and pdf's) in tables and there are size limitations for a single database. So, in order to get around the size limitations, I'm just creating one database for my main tables and multiple other databases to hold the binary data. Any performance considerations I should consider in regards to multiple databases Any other thoughts First, what size limit in SQL 2005 are you trying to avoid Second, as someone else pointed out, saving files in the database is not a good design. The main problem is, what do you do with them once they are there How do you get them out The OS is much better at savi ...Show All

• joyson Dynamically determine subtotal visibility in matrix?

  I'm using SSAS2005 SP2 as a data source, and RS2005 SP2 for reporting. With the upgrade to sp2, users assigned to an area in a sales location tree no longer get a value returned for AGGREGATE(MyValue.Value) when looking at a region higher than they are assigned. My MATRIX reports now look like: _______________________________|___|___| Region____Sub Region____Area1__|_5___3_| Sub Region Total_______________|_______| Region Total___________________|_______| Grand Total____________________|_______| Before sp2, they had the 5 and 3 values repeated in all total rows. My thought was to hopefully dynamically hide the sub region and region groupings and their related subtotals - but when trying to do this, only the grand total shows, and ...Show All

• Nilabja Roy Unable to cast COM object of type 'System.__ComObject' to interface type 'msforms.Control'.

  I have recently installed Visual Studio 2005, and since then, my Outlook 2003 has started giving me an error. I use Business Contact Manager in Outlook, and when I double click on an Account or Opportunity to view it, it gives me an error and asks me to debug. If I click on debug, Visual Studio Just-In time debugger opens up and says "An unhandled exception ('System.InvalidCastException') occurred in OUTLOOK.EXE[2924]" I click Yes to open the debugger, and Visual Studio debugger opens with the following error: "Unable to cast COM object of type 'System.__ComObject' to interface type 'msforms.Control'. This operation failed because the QueryInterface call on the COM component for the interface with IID" Does anyone kno ...Show All

• Dany V SQL Server 2005 JDBC Driver 1.0 error in using XA datasource

  We are in the process of configuring a j2ee application with SQL Server 2005. We have downloaded the new version of SQL Server 2005 Java Database Connectivity (JDBC) Driver 1.0. We are having some issues in getting it to work using the XA datasource. Description of the error is as follows: javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error: Could not find stored procedure 'master..xp_sqljdbc_xa_init'.. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(Unknown Source) Has anyone else has encountered this and possibly found a solution. Regards, Bindu Read the xa_install.txt file that ships with the driver, there is some ...Show All

• chrisb2 Help on global variable for insert statement

    I am new to DTS, but really enjoy it and was wondering if someone could help me with the following small vb app. I am using the following DTS insert statement to insert records into my table. I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls. How can I modify my code to insert those textboxes as well as run through the boxes and then check if they have nulls and NOT insert the ones that has nulls My form has 9 textboxes. Textbox1, 2, 3  Needs to insert values into the first column. Textbox4, 5, 6 into the second and then Texrbox7, 8, 9 into the last column. My question is how do I format the following line of code to do what I need oCustomTask1.SQLStateme ...Show All

• eric shih Performance Issue - sp_cursorfetch is the culprit

  A query that accesses a linked server is causing me issues. When I traced the query from the remote server (Server B), I can see that the connection is using a cursor to return results to the remote server (Server A) where the query is run from. The sp_cursorfetch statement is processing in batches of 100 records, and apparently is generating a round-trip (to Server A) for each completion. However, when I issue the same query from Server A to Server B using OPENQUERY - no cursor is used, and the results are returned immediately. I've researched everything I can imagine, but with no results ... API Server Cursors link: http://msdn2.microsoft.com/en-us/library/aa172588(SQL.80).aspx It appears that this option is enabled/di ...Show All

• Duncan Woods How to get started?

  This is a repost of my post on the VB Express board. I would like your opinions. I am a network guy. I learned basic years ago. I can do some html edits as needed to change sites. Today I would like to start the long process of learning VB with .net applications. I thought I could start with Office developer xp to learn VB. I have that package. I also would like to be able to build SQL quaries and integrations or automate and manipulate data exports and imports later down the road. Example: Export various order and customer information from a shopping cart and import it in to Quickbooks or MS Accounting. First off I need to be able to build web sites and I know I want to grow into VB and SQL. What should I do Lear ...Show All

• andret1802 Find object owner

  Is there a query I can write that joins 2 system tables to return the owners of objects (e.g. tables) and the object's name Thanks, Dave In SQL SERVER 2005, because of the ALTER AUTHORIZATION clause, the schema owner may not always be the object owner See, http://msdn2.microsoft.com/en-us/library/ms187359.aspx So, an alternative to the above query for SQL SERVER 2005 is select user_name(objectproperty(object_id,'OwnerId')), name from sys.objects This always returns the correct owner of the object and takes 'ALTER AUTHORIZATION' into account. IN SQL SERVER 200 the SCHEMA IN the information_VIEW represents the owner OF an objects e . g . FOR tables SELE ...Show All

• hrubesh Help with installation of SQL Server 2000 SP4

  Hi, I was wondering if anyone might be able to help me here. To be honest, this is my first time i have encountered SQL Server 2000 SP4. I need some guidance as to how to install and set up the SQL Server 2000 SP4. I have done it with SQL Server 2005 Express Edition and it's (I think) a lot easier to install and get it going. My computer runs on windows XP Pro (windows 32bit). I got confused when i got to the following microsoft webpage - http://www.microsoft.com/downloads/details.aspx FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en . I downloaded SQL2000-KB884525-SP4-x86-ENU.EXE. And when running the setup.bat, the message came up saying "SQL Server 2000 is not installed on this machine. setup will now exit&quo ...Show All

• Peter Kahn SQL Server Agent Properties - History

  When you select 'Automatically remove agent history' with the parameters 2 months, it actually removed all but 2 DAYS ! This ruined 3 of my production server job histories. It also does not retain the parameter settings on this History page, not that i want to use this screen anymore until this parameter item is fixed. SQL Server 2005 RTM Dec 2005 on I64 cluster Which version of SQL Server being used here We never had such problem on our settings. My expectation is that the GUI screen option work correctly. I do not find exporting history to be an acceptable option, besides i have already lost my history. In this case y ...Show All