Answer Questions

• vandershnozz using EXEC to execute a formula stored in a string

  Hopefully someone will have run into this before...  Basically, I have a table with a column that stores mathematical formulas in string format.  When my UDF is executed, it needs to select an appropriate formula from this table and evaluate it using values that are stored in local variables.  Look at the example below: Suppose I have a string named @vcFormula that contains the following: "@dVar1 + @dVar2 / @dVar2" ...Show All

• Jeff Barton Escape a SQL string programmatically?

  I need to construct a SQL statement programmatically and must escape strings included as values to follow SQL rules. For example: command.CommandText = "INSERT INTO Table (strColumn) VALUES('" + EscapeSQLChars(badChars) + "')"; command.ExecuteNonQuery(); Is there a built-in .Net command that does what I want EscapeSQLChars to do Use paramitrimized queries. Then you never have to worry about format's ...Show All

• Claudio Biancardi DBSTATUS_UNAVAILABLE with OLEDB Command

  Hello, I have an issue with the OLEDB Command in a package of mine where it used to work and now it doesn't.  I had 4 different packages where I was bringing in a flat file, massaging the data, and calling 1 of 4 Stored procedures using the OLEDB Command.  Everything was working great, then we decided to use the SSIS EBCDIC conversion in the flat file connection rather than converting to ASCII outside of SSIS.  This w ...Show All

• DevLady Parent-child hierarchy: how to get readable member unique names?

  Is it possible to have a parent-child dimension which is referenced from the fact table via an integer key but shows a string key in it's MDX unique member name Here is the background to my question: I have a dimension with a single parent child hierarchy. The key column is test_key and the parent column is test_key_parent, both of type integer. This works beautifully except for the MDX member names which are similar to "[Dim Test].[H ...Show All

• SWBgHz Can not find Microsoft.SqlServer.InstApi when trying to run a SMO trace

  I install the follwing components 1.Microsoft SQL Server 2005 Management Objects Collection 2.Microsoft Core XML Services (MSXML) 6.0 3.Microsoft SQL Server Native Client (available from http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en ) on a clean machine with no SQL Server 2005 client tools. I get the following error. Failed to initialize object as reader. C ...Show All

• handshake it Error Scripting Procs: Failed to retrieve dependency information

  How can I resolve the following error when I try to script out some procs. In SSMS I right click the db and I choose 'Tasks > Generate Script', then I select 10 stored procs (without changing any of the default options). If I don't include the proc mentioned in the error below, then it works OK. TITLE: Microsoft.SqlServer.SqlEnum ------------------------------ Failed to retrieve dependency information (object_id(System.Int32) 127172 ...Show All

• peter cli Licencing -some clarification.

  Hi All, Not _strictly_ a DB engine question but could not find a better home... I have 3 boxes: A) 4 Dual core procs B) 8 Dual core procs. C) 4 Dual core Box A will have SSIS, Reporting Services and IIS. (No SQL) Box B will have only SQL. Box C will have Analysis services on. What I want to know is do I have to pay for SQL, 4 procs, for box A when it only has SSIS on it I pay for SQL, 8 procs, for box B, do I ne ...Show All

• rose-marie How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. i wan to search for the word and it will display the Omim number and the Omim number will link to another identical number to display the description.. can u do it ...Show All

• BRao manage exception message

  How to manage sql server runtime message to users understand it In my web form I added folowed code If Session( "Action" ) = "Edit" Then Try ObjectDataSource1.Update() Catch ex As Exception lblMessage.Text = ex.GetBaseException.Message End Try for manage user input for update the record. This is message returned by sql server 2005 The UPDATE statement conflicted with the RE ...Show All

• Glenn W Johnson HOW TO DEPLOY A PROJECT TO REMOTE SERVER

  hi ,i want to deploy an project(BI) which is been deployed successful on my computer to remote server,the server name is boco-ace.i do not kown how to do could you give me an solution if you give an example,i cannot bear to appreciate. the first way i did ,but it dap an error "systerm error:no mapping is completed between account and security id",why i think maybe because i built roles,so i delete the role.but it daps anot ...Show All

• Gavin Jin - MSFT How to mimic replmerg.exe in vb.net

  Hello, On an existing Merge Pull Subscription (Subscriber: SQL Express) via websync how can we start replication via vb.net We can use the cmd line replmerge.exe and all works fine however we would like this to be cleaner as it's going to be on demand sync. I saw in BOL about the RMO and how to create pubs/subs but nothing telling me how to actually start the replication process. Is there a sample of how to start the replication process in vb ...Show All

• Roman G. Installation of SQL Server 2005 Express Edition

  I have tried to install Visual Basic Express Beta2 on 2 different machines directly from the net as well as from the image file (from harddisk using ISOBuster 1.7). While the installations of the Betas of Framework 2.0, VB, MSDN Express Lib all worked OK and went on until the very end of the Server installation the system reports: "The following components failed to install: Microsoft SQL Server 2005 Express Edition April CTP". Can any ...Show All

• Sönmez 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! Adrian, Thanks again for your help here. You have been great. We do have some issues with running out of memory that I will be posting. Here is the error: Errors and Warnings from Response Memory error: Allocation failure : Not enough ...Show All

• ASKavya What is necessary to create SDF-Files on desktop legally?

  I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed to create SDF-Files if "SQL Server 2005 Express" ...Show All

• Brian Rak Breakpoint doesn't work

  I've got a breakpoint in a script task. The script task executes successfully but doesn't break. Short and sweet this one. Anyone any idea why it might not -Jamie I found that if you are in debug at a breakpoint on a looping bit of code. If you press F5 the code then continues and doesn't break on the break point again, even though the statement with the breakpoint is executed again. I thought F5 ran the code and if a breakpoint is found ...Show All