Answer Questions

• dfgdgdfggfghg55rrgr Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)

  I just received this message: Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum) I am completely dead in the water. Cannot connect to SSAS 2005. HELP! We are actually still working on the issue. The last recommendation was to move UP to the 64-BIT version of SSAS 2k5. As we continue to peice-meal the cubes into the 32-BIT solution there is an entire discussion about maintenace and care of ...Show All

• samitha Wired to Wireless Connection Issues

  When using both SQL Server Management Studio and my own application to connect to my SQL Server, I can connect and retreive data without issue when on a wired connection. As soon as I unplug the wire and switch to the wireless connection I have problems. I can connect to the SQL Server without issue (in MGMT Studio and through my code). I can even return small tables, however when the table is larger (about 175 rows) I get the following error: ...Show All

• yinmin Transferring table data from an ODBC database to a SQL Express database

  I am a SQL newbie.  I have two connected databases that I work with in Visual Web Developer Express or Visual Basic Express.  One is an ODBC master database that contains much table data and the other is my new destination sql express database.  Where I was once very comfortable using the query grid in Access to accomplish almost anything with tables, it seems like now it is much more difficult.  Can someone offer m ...Show All

• MA2005 How to encrypt database in SQLServer2000, please help me, thanks

  I have 2 questions: 1. How to encrypt data of database in SQL Server 2000 Someone can't see true data if without password or something else. 2. If i have 2 database . All of them have same table, structure, ....How to update or insert or change in the second database when i update or insert or change in the first database automatically Thank you very much. Oops, I didn't realize you were referring to SQL Serve ...Show All

• Ewald SQL help

  I need to get the all the row for the value 11 from the below table. Could you give me sql statement for this. create table teststring(a varchar(25)) insert into teststring values('11:02,05:BL') insert into teststring values('16:03,11:RS') insert into teststring values('13:01,04:LL') insert into teststring values('16:05,11:RS') drop table teststring Sory Folks, The below ligic will work better  as I e ...Show All

• LeszekG Question about OLE DM provider and OLE DB provider?

  Hi, all here, I am having a question about OLE DB provider and OLE DM provider. What exactly do OLE DB (Ojbect Linked Embedded Database) provider and OLE DM (Object Linked Embedded Data Mining ) provider mean Would any expert here give me some explanations about how it works or giving me some example like code for it Also, what is the difference between OLE DB and OLE DM With best regards, It's actually the OLE DB for DM provid ...Show All

• Lew130 Data Source / ODBC error

  Hi all, My replication of those SQL 2000 servers gave errors: Data source (11): General Network Error. Check your network documentation... and ODBC (08S01): Communication link failure. The replication was across the WAN. I don't know where to start to troubleshoot this problem. Please help! Thanks in advance. John Hi, This is not the first time the replication failed. It worked perfect before. DNS is fine since I did ...Show All

• Tim Tow Converting AS2000 DSO from VB6 to VS2005

  I have a VB6 program that uses Analysis Services 2000 DSO to Automatically Process an AS2000 Database. I ran the Upgrade Wizard in VS2005 for Visual Basic on this VB6 program but the result has an error I can't find how to correct. Here is the original code - Dim mdDatabase As DSO.MDStore Dim dsoServer As DSO.Server Set dsoServer = New DSO.Server dsoServer.Connect ("CubeServer") Set mdDatabase = dsoServer.MDStores("TestCu ...Show All

• kawak Copying database using "Copy Database"

  I am struggling with the "Copy Database Wizard" in SQL Server 2005. I am used to working with DTS to copy data from one server to another, but with the new tools, I am having serious problems (in fact, it's unusable) 1. When copying a database using the "SQL Management Object" method, I always get errors concerning logins. If I select not to copy logins, I get errors "sp_grantdbaccess failed". If I do select to copy logins, the logins can't b ...Show All

• VasilyU Parent Child Relationship

  I created a parent child relationship in SA 2005. It works great, except when adding it to the cube and browsing it. It shows the ID instead of the Name attribute. How do I make it show the name attribute Thanks in advance, Mardo When I do that, I get the following error after entering it... Another 'DimensionAttribute' object has the 'Name' name. Is this a bug in a version of BIDS I have been struggling with this all day and I f ...Show All

• Bob Y Copy Table from another table

  How to create a Table from another Table I need both structure and data If any one know pls rply bye murali murali@gsdindia.com The simplest method of all for doing this is to simply use the SELECT INTO statment. Here's how: Suppose you're trying to copy the authors table of the Pubs SQL Server database with data and structure. To do so simply use this SQL script: ----------------------- USE Pubs GO SELECT * INTO copy_of_authors F ...Show All

• Darius K Report Manager - Blank Reports Page

  Hi, I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space. I had it working fine a week ago. Any ideas The RS runs on Win2003 Std, SQL 2005 Std. Thanks When you first launch report manager, it defaults to the home folder. This is also known as the 'root' or the folder with path "/". You n ...Show All

• JanDV Currency Conversions

  Hi! I am having trouble wrapping my brain around currency conversions. Here is my situation: My fact table contains values in local currency with a reference to the currency dimension. These local currencies need to be converted to two reporting currencies: Actual Rates and Budget Rates. I have rates on a daily basis for both reporting currencies. How should my table structure look, and how do i set it up in AS so this ...Show All

• Jasonlkk RUNNIG A JOB???

  I HAVE A PROBLEM,, I``ve just deployed a package into my server..it runs without problems from my SSIS.. but when i set a job with the sql agent and the package to it,. the job just fails .. why any solution please somebody help me!!! Ruk, as Micahel noted the KB article I referred to is now published. Please review the article. Based on experience, the article should cover all the possible cases that would result in the issue you se ...Show All

• Jim Vinsel Storing values from an array to a SQL database

  Im not sure if this is the correct forum to ask this question for suggestions, but im gonna go ahead and ask anyways. I have an array that has the x, and y co-ordinates of a graphic that was moved around by the user on the screen. Each user will create a name for the different motion, say Motion1..2...3..etc. (so each motion is considered a different set of x and y co-ords). Im trying to figure out the best way to save this data. i thought ...Show All