Answer Questions

• GSReddy Connection to database takes up alot of memory in application

  Hi all, I was just wonder what the normal memory consumption is when just simply making a connection to a database. I have an application that starts, and when it connects the to a database, it eats up around a 1.5 MB, yes I keep the connection open for the life of the application (as its in a kinda global class, and when database reads/writes are performed I just get the open connection object) - I don't run any queries against the database here, just connect. Is this a normal amount of memory to consume on a simple connection to a database Tryst Sounds normal to me, that’s about the size of SQL Mobile binaries and they need to be loaded in order to do anything with SQL Mobile including simple connection. ...Show All

• Jeon SMO Job Step Starting datetime?

  Hi, I have a job running... and i want to know at what time that job started running Is it possible Or do i only have a way to know the lastrundate and the nextrundate Best Regards ...Show All

• jrboddie two dimensional array using form designer

  How can i create a two dimensional array within a form using the form designer. Moving to tools forum. I think you're probably looking for the .NET DataGridView control. See http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx for more info. Hope this helps, Steve Is this in SQL Server you are asking I am talking about a screen painter in visual c++ (form designer). I might be in the wrong forum. This has nothing to do with SQL server. I just want a simple two dimensional array on a screen (form). My be i am not speaking the right language or term. To someone that has used the .net system it should be very easy. Thanks Thi ...Show All

• wwwxwww initialize counter in "script component" from package variaable

  i need to initialize my variable in the "script component" from a package variable. how can i do that i'm referring to the script component in the dataflow   thanks.. You need to do it in the control flow. You could use a Execute SQL task if the value comes from a table or use a Script task (different that script component). You may have other options depending on the logic used to get that initial value. Does this help Public Class ScriptMain Inherits UserComponent Dim MyVariable as Integer Public Overrides Sub PreExecute() Dim vars As IDTSVariables90 Me.VariableDispenser.LockForRead("MyGlobalVariable") MyVariable = vars("MyGlobalVariable").Value vars.U ...Show All

• hrubesh How to delete rows in tables...

  I need to delete some rows in some of my tables after tranfering data from my OLTP to SQL database. Im using SQL 2000 I have tried with the following: Delete from fsalesinvoiceline Join dsalesinvoiceheader on Fsalesinvoiceline.salesid= dsalesinvoiceheader.salesid and Fsalesinvoiceline.company= dsalesinvoiceheader.company Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’ Go Delete from dsalesinvoiceheader Where dsalesinvoiceheader.billtocustomerno=’INDTAST DEBITORNUMMER’   I get the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'JOIN'   What am I doing wrong /Soren D. Jensen ...Show All

• crino SQL Server is unable to connect

  Hi there, There is a SQL instance (sql2005) and I am trying to add a new distribution. Replication wazard says: SQL Server is unable to connect to server 'SERVER1'. (New Publication Wizard) SQL Server is unable to connect to server 'SERVER1'. (New Publication Wizard) SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SERVER1'. (Replication.Utilities) There is the only local instance of the server on local computer and 'SERVER1' is actual name. What is wrong Thank yuu Hope this article helps: http://msdn2.microsoft.com/e ...Show All

• toughtalk Dynamic Dataset for Chart in Report

  Is it possible to dynamically set the dataset for a chart on a report What I'm trying to do is generate a single chart on a report. Depending on what items a user selects as parameters would determine the dataset used. Unfortunately, one dataset comes from Oracle the other from SQLServer. Thanks! You could have two charts - one per dataset. Set the chart.Visibility property so that only one chart is visible depending on the selected parameter value. -- Robert ...Show All

• Kevin Dente running stored proc with parameter

  hi, im getting an error when i run the stored proc with a string parameter in execute sql task object. this is the only code i have: exec sp_udt_keymaint 'table1' I also set the 'Isstoredprocedure' in the properties as 'True' though, when you edit the execute sql task object, i can see that this parameter is disabled. How do i do this right cherrie Cherrie, Not sure I am understanding the details of your problem (may be if you post the error you are geeting...); but here is my shot: Assuming the parameter inside of your procedure is table1; then the SQLStatement of the SQL task should be something like: EXEC sp_udt_keymaint @table1= The in the parameter mapping page ...Show All

• ihackdw How to Schedule Reports and How to use File Share Suscription

  I tried to schedule reports using File Share Subscription as specified in MSDN, But was not able to schedule the report. Can you give me detail of the nature of your issue ...Show All

• ares_l Trying to return whole records with distinct fields

  Hi I am trying to write a query that will return a full record with a particular distinct field (the rest of the record being the first such record that includes the distinct field). For example, for the following: Fruit Like Colour Apple Y Green Orange N Orange Banana Y Yellow Grape Y Green Grapefruit N Yellow I would want to return (assuming Colour was the distinct field): Fruit Like Colour Apple Y Green Orange N Orange Banana Y Yellow How do I do this I've tried using a join (of all different kinds) with a subquery that uses SELECT DISTINCT but this doesn't seem to work. I've tried GROUP BY but none of the aggregate functions seem to just take th ...Show All

• MRDPrince Matrix-last column not subtotal of row

  Destination Country Valid Mail Austria Belgium Austria 1.9 1.7 1 23 23 Belgium 1.7 9.7 2 23 23 Valid Mail 1 2 3 hi, i have some question for matrix: how to display 'Valid Mail' which is not subtotal for each row. how to display 'Valid Mail' which is not subtotal for each column. if reporting services do not have this function, what should i do in order to get the same result using reporting services  Thanks Best Regards, Penny         Hi It seems to me that you may have a similar problem to the one i had. Please see the following i ...Show All

• Adhi78 #@ Row 1, Column 7: String data, right truncation @#

  I am trying to BCP a ton of data files into a SQL 2005 database. The first row of data in one of my files looks like: 1000|100000156752|100000176409|100000000000|100000000000|9.4|M|9.4||1/22/1993||1||||100|||||||||1|1/22/1993||||||| The error file has this: #@ Row 1, Column 7: String data, right truncation @# 0 0 0 0 0 .00 17|27.7|M|27.7||2/2/1993||1||||100|||||||||1|2/2/1993||||||| I've built a format file based on the SQL Table definitions with this command: FOR %%f IN (*.*) DO bcp IRIS.dbo.%%f format nul -T -n -t"|" -r"\n" -f%%f.format The format file for lines 1-8 look like: 1 SQLNUMERIC 1 19 "|" 1 SITE_ID "" 2 SQLNUMERIC 1 19 "|" ...Show All

• anisk how to insert int variable...

  hi, I have two question string a; int i; insert into sss (id, name) values(.....) as id is integer and name is nvarchar in the database. how can I write this variable within the values paranthesis 2) how to adjust a column in sql server 2005 to auto number thanks I may be mistaken, but these seem to me to be questions which are not specific to the ADO.Net vNext technology preview--but rather general SQL server questions. Given that assumption, I'm moving this thread to a more appropriate forum. If I'm mistaken and this does more directly apply to the ADO.Net technology preview, please post again back in that forum. Do you want to know how to exactly insert them in .NET o ...Show All

• Sylpheed Member Properties

  Hi How to create a member properties in AS 2005 Regards In AS 2005 (SSAS2005) it is the same as attribute hierarchies. All attributes in a dimension table no longer have to be included in a user hierarchy. If you run the dimension wizard and turn off the autocreate hierarchies you will get a dimension without hierarchies which is the same as member properties in AS2000. Or , if you use this feature(autocreate) you will get user hierarchies(the same as dimensions in AS2000) and attribute hierarchies(the same as member properties). Still the word member properties is sometimes used for attribute relations. But this is not the same as in AS2000. HTH Thomas Ivarsson Interesting answ ...Show All

• bkraja RB - New table info didn't show up on the Report Builder report

  Hi All - I'd like to add some more info to an existing RB report by adding a new table. I am able to add a new table to DSV and build relationship. I am also able to add the table to report model as a new entity and source fields. The report model gets rebuilt and redeployed without problem, and the old report still runs fine. But when I open the report in report builder and want to add more info, the new table/entity/attributes are not showing up at all. A report that already contains data displays the entities related to the data already in the report. If your new entity is not related to the data in the report, you will not be able to select fields from that entity and add them to your report. If the e ...Show All