Answer Questions

• chds Server Registration

  TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, ...Show All

• jaypee68 Dimensions with Startdate / Enddate fields

  Hi, I would like to know what is the best practice to manage Dimensions with StartDate / EndDate fields, in SSAS. Regards Ayzan Well first, is it possible to build dimensions with time dependance Regards Ayzan ...Show All

• newxplanet General network error

  Hi guys, Anyone encountered this error. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.". The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure cod ...Show All

• Haddibhai Join XML fragment with real table

  I was wondering how someone would go about joining an XML fragment with a SQL table. Say for example this is my XML fragment. <foo><key>1</key><description>One</description></foo> <foo><key>2</key><description>Two</description></foo> My table looks like this: key SomeInfo 1 SomeInfo1 2 SomeInfo2 I want to be able to create a Stored proced ...Show All

• Symon Buck Using Row Count

  Pardon my ignorance, but does someone have a step by step guid to include row count transformation in a package. What I want to do is to count the number of rows extracted from the source and the number of source inserted to the target. I have tried to include a row count transformation with a variable defined. But the variable keeps showing 0 after each run Thanks Jamie for this very useful blog on rowc ...Show All

• Chawmey RS on clustered server

  I installed clustered sql2k5 with RS, and went through RS configuration without error. But got following errors when try to browser RS site, IIS is running: For reports site, I got: Server Error in '/Reports' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file ap ...Show All

• Loom Get last record in a SQL database

  Don't know if this is the right SQL section, but... using VBE, how do you SQL for the last record in the database Thanks. Thanks.  I haven't yet been able to try all the great ideas I got... still wasn't able to open the database... so I'm reading a book. athanks to all fo royu help I got it I have a ID that numbers each record (key).... I was thinking along t ...Show All

• TommieLand How to restore SQL 2005 DB to SQL 2000

  Hello, I'm tring to restor a DB from sql 2005 (which is located on my local computer) into sql 2000 (which is located  on the server) and I am getting this type of message: TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Too many backu ...Show All

• eric_l Determining the most appropriate conversion for a string

  Hi, Is there some kind of code snippet to determine (a) the precise data type (and precision if appropriate) of a given table.columnname in the database, and (b) the most suitable conversion for a varchar that is being made to hold various types of data. Presumably based on the above one could have some sort of CASE WHEN to cast the data to different types accordingly. Thanks for any help on this. Please indic ...Show All

• cryofx Problem Assigning Value to Package Variable From Data Flow Script Component

  In my Script Component properties I have included "ClientReportGroupId" as a ReadWrite variable. This variable is declared as a Package Variable. So, in my Script Component I do this: Me.Variables.ClientReportGroupId = CInt(Row.ClientReportGroupId) But that returns the error : Error: 0xC0047062 at JobSet Table Task, Script Component 1 [385]: Microsoft.SqlServer.Dts.Pipeline.ReadWriteVariablesNotAvailableException: The collection of variables loc ...Show All

• Captain Anonymous Can SQL Server 2000/2005 Co-Exist On One Server?

  Can I install SQL Server 2000 and SQL Server 2005 on the same physical server and be able to access them independently through their respective tools (E/M, Q/A, SSMS) and through ADO, OLEDB We have an upgrade issue that involves some parallel testing without buying a new server. Hey, i just work here right Yes this works just fine ...Show All

• Syed Zishan Kalam Report header and footer only to appear in printed version

  HI I have a report that I view in Sql 2005 reporting services that contains no header or footer. I do not want these to be displayed in the browser. I would like to add a header and perhaps footer which will only appear on the printed document but not in the web browser. Is there any way to accomplish this task Thanks Further to the question posted above, as an alternative ... Is it possible to ...Show All

• runfaster2000 transferring database to sql server

  Hi I have a database (not sql server) with primary and foreign keys and want to transfer it to sql server. How can i do this without losing out on the constraint information   The next task is to generalize this solution to transfer any database.  Can you help Thanks! -- I can create multiple dataflow tasks and use a data reader source and sql server destination in each of them. However, this will not set the cons ...Show All

• Microsoft_TommyTP problem with calculating sum of large nos

  hello all    i am calculating sum of very large nos using sum function of SQL. but the final result i get is incorrect. i am using SQL server 2000. like value of a field(cost) is calculated by multiplying .0018 to other fields (no of units) the sum of (no of units) is 140374 but when i calculate the sum of (cost) it comes to 273.1600 which is incorrect \. it shud have been 140374 * .0018 It is r ...Show All

• TAO DE ZHI Memory Error

  Hello-    After processing a cube and when attempting to add a heirarchy to the cube I receive the following error : The query could not be processed: o Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed. I've seen reference to a hotfix for this issue, but I don't know what the hotfix number is.  Any help or suggestions on this   ...Show All