Answer Questions

• Nigel Sykes More than 1 client with the same account...?

  Hello, I'm developing an application for 20 mobile devices. The program in all the devices will connect the SQL Server with sa user.More than one devices can connect with the same login account (I cannot test because i have only 1 device right now,thats why i'm asking) Thanks in advance. Yes, sure. More than one connection can be established using one login account. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Yelnik Restricting memory Express constumption

  Hi We are developing some applications for Sunit computers (In-vehicle computers) which have limited memory . Because the applications display maps, the will consume alot of memory. Because of this, we want to restrict the amount of memory and other resources SQL Server Express uses to a minimum. I've tried setting 'max server memory', which doesn't help too much as this is only a limit on the SQL engine and not the sqlserver.exe process. What other settings and restrictions can I apply to limit memory consumption by the process We have considered using SQL Server Everywhere, but as it doesn't support ODBC (will there be any ODBC support ), we are not too happy about using it. As of now, we have no experience with OLE DB, and the ap ...Show All

• Giri Synonym to a Database

  Hi All, I know this might sound very stupid but am really pondering whether its possible to create a Synonym over a database, SQL 2K5 is what am using, and when i click the drop down to specify on which object type this synonym has to be created, there is no 'Table' in it. Can somebody help on if its possible If yes then how to do it thanks, I am not sure if I understood your question correctly. Do you want to create a synonym for a database or a table SQL SERVER 2K5 does not support creating synonyms for a database. It supports creating synonyms for a table If the name of your table is tbl1 and it is in the schema sch1 ; you can create a synonym by using the following sql. CREAT ...Show All

• Peter Marshall SqlDataSourceEnumerator.Instance; not returning all instances

  ...static void Main() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; System.Data.DataTable table = instance.GetDataSources(); ... Hi MS SMO folks, I'm not getting all instances returned in my table. I know there are issues surrounding this call but I have 1 dev box, 1 nt 2003 server and a total of 3 sql srv instances. 2 of which are on my local dev machine. All are 2005. Both servers have SQL Browser enabled and all protocols are enabled. All of my MacAfee and Windows firewalls are temporarily Off. The only instance returned is mylocalbox/sqlexpress. I can understand why it may not see the server, due router or other h/w, but what I really d ...Show All

• Ben Vanik YTD Comparison

  When I run the Business Intelligence wizard for Year to Date, the following script is generated: [Year to Date] -> Parent hierarchy -> Time D. Time Time D Calculations Scope( { [Measures].[AMOUNT] } ) // Year to Date ( [Time D].[Time Time D Calculations].[Year to Date], [Time D].[YEAR].[YEAR].Members, [Time D].[YEARMO].Members ) = Aggregate( { [Time D].[Time Time D Calculations].DefaultMember } * PeriodsToDate( [Time D].[Time].[YEAR], [Time D].[Time].CurrentMember ) ) Before discovering the wizard, I calculated YTD with: sum(ytd(),[Measures].[Amount]) Anyone have any insight (performance, etc) on one method versus the other As far as I can tell, the ...Show All

• Duckboy rsProcessingAborted Error!!

  Hello all, I am in a fix here. I run RS2000 on SQLSERVER2000, IIS6. My dev env is VS2003( .net 1.1). About 2 months back I deployed reports to an intranet site. They worked as expected. All of a sudden I get the folowing error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'XXX'. (rsErrorOpeningConnection) Get Online Help SQL Server does not exist or access denied. The SQLSERVER exists and is up and running. I use SQL authentication which is fine. I can preview the report in dev env, from VS2003 but the server simply does not like. I can ping the SQLSERVER from the reporting server BOX, I created a test DSN as with the sql login ...Show All

• Nerick Measure Dimension

  Hi What's the difference between the two following queries as the returne value of the second one is "#Error" . My aim is to count the number of customers that purchased the mountain product through Internet. I've used the Adventure Works sample database. WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, "Internet Sales" )) SELECT [Measures].[Number Of Mountain Internet Sale] ON COLUMNS FROM [Adventure Works] WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, [Measures].[Internet Sales Amount] )) SELECT ...Show All

• Nick Gravelyn Formatting a field to spec in SQL

  Can anyone tell me how to format a field to spec Example: Select num_field from table = 12345 I want Select Format( num_field, "0000000000") from table = 0000012345 or some equivalent. I know in Access you could do this using the Format function, but I cannot seem to find anything like this in SQL. Thanks in advance, Michael You are sure right, my mistake :-) Hi Jen, Thanks for the response, it works with one small exception, I need to use the RIGHT function not the LEFT. But all is good, and it works...THANKS! Michael Hi, there is no format function in SQL Server, you will have to do it this way here: LEFT('0000000000' + CONVERT(V ...Show All

• AlexReg SQL 2005 Standard on Vista RTM

  Hi All, I've read a number of threads on here where users have managed to get 2005 working on Vista RTM. I'm having no such luck however. The issue I have is as follows: Clean Install of Vista RTM Ultimate 32bit. Attempt to install 2005 Standard. This error appears: SQL Server Setup Failed to compile the Managed Object Format (MOF) file D:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. I've read elsewhere that I need Sp2 of SQL Server. I can't install SQL server though so that makes it hard to apply a service ...Show All

• E. Palmer ERD 1:1 Relationship

  I am trying to create a 1:1 relationship, but not primary key to primary key. In table 1 I have a uniqueidentifier as a primary key. In table 2 I have an int as the primary key and a column that takes the uniqueidentifier from table 1. Everytime I drag and drop the relationship line and link table 1 to table 2 it creates a 1:N relationship: ie. tbl1.primarykey links to tbl2.column2. So I'm not linking primary key to primary key however I still want a 1:1 relationship. How do I do that Thanks in advance. There will always be a parent and child in any relationship. So you will simply have one table reference the other, and then apply a constraint of some sort to enforce the cardinality. Since you ...Show All

• amrhesham Final Model

  I am creating a report model and have to keep going back and forth between VS2005 and Report Builder to see what the "Final" report is going to look like. I am using folders to group together some really nasty list of fields, denormalizing lookup tables, etc. Is there any way to see this without having to reload Report Builder each time I have thought about an XSLT for the SMDL, but that is some seriously ugly XML (especially with the denormalizations). R If you leave RB open, create a new report based on some other model, then create a report on the model you're working on again, it will clear the cache and you will see your changes. Inside Model Designer, you can edit the Expression pro ...Show All

• oaix BI Portal connected to analysis services 2005

  Anyone has connected the bi portal with analisys services 2005 I have a security problem. Thanks I did what you said, i connect with the as2005 when i test the connection all work fine, i make the datasource but the webcomponents don't show the pivot table... it gives me an error and show nothing... i don`t know what i can do... (i have the owc11 installed) I don't know what to do... perhaps i have to enable the http access The owc connect to the as2005 via http I really don't understand what is happening, i can connect with the cube via excel but when i am using the owc i have errors.... I had to do this a couple of days ago. The only way I could get it to work was if I went into th ...Show All

• harryvidhya Using OLE object within a procedure

  Can anyone help me address pros and cons of calling OLE object within a stored procedure. As we know system stored procedures such as sp_OACreate, sp_OAMethod are used to create and call OLE objects. I have to decide between whether it is advisable to use sp_ in my procedures or to do something outside the database. I need to use an external component to transfer files between FTP servers. This can be done using a procedure and job to schedule the calls. Thank you, Yogesh Why not just use VB to transfer files between FTP sites I'm not sure why you're trying to use SQL Dim host As String = "ftp.getpaid4spam.biz" Dim user As String = "Login" Dim ...Show All

• Deepu.MI How do I order columns in my custom destination component?

  Here is the situation. I have created a package that takes 50 columns from a comma delimited flat file. I then validate and clean the data. Next I add two columns that were not in the original source file. These two columns need to be in the 5th and 9th column position when the file is then re-written to a text file. How do i get those two columns to write out in the desired order Any ideas K. Lyles You set the order in the mappings to your flat file destination. Set up your FF destination appropriately, then simply drag the columns to their destination. ...Show All

• Kamii47 What is sysname?

  USE <database, sysname, AdventureWorks> What is "sysname" object I frequently see it among parameters for stored procedures. Thanks. Hi, sysname is just a builtin data type which can hold the names of system objects. It is limited to 128 Unicode character. it is often used to define objectnames within scripts. You cannot use it to craete a column with it, although it is a SQL Datatype. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- How to approach this is highly dependent on why you're doing this. Is this a one time thing that you're doing for some kind of testing Is it a one time thing for application development Is this part of an applicatio ...Show All