Answer Questions

• SonicWave DSO in SQL2005

  Anybody can share the way to administer AS2005 using DSO Hmm - so it seems that using DSO from an application against AS2005 is not a good idea   It sound slike from your description that the use of DSO will overwrite any modifications made directly using SQL Mgmt Studio   Thats not good. I have been trying to use DSO also in this scenario - where is the RepositoryConnectString supposed to point to - and what provider shpuld be used   The MS documentation gives no hints to this, when I try pointing to the access mdb you suggested I get: Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect. If I point to the Analysis server da ...Show All

• windflower cannot find dsn

  Hello everyone, This must be too simple to be true but im trying to set up the tutorial cube that comes with analysis manager and ive set up the cube and its dimensions but i cant progress beyond the storage design wizard as it gives me the following error when i try to process it: [Microsoft][ODBC Driver Manager]Data source name is not found and no default driver specified why is it that i am able to use this dsn to create the cube but not to process it or create the aggregations in the cube Ive set up the dsn exactly as described in the setup dsn pages (Tutorial/setup_sys_datasource.htm) and it has been working fine till this, i can even add further dimensions to the cube, just not process it, whats going on with much thanks ...Show All

• Roozbeh Sharafi SSRS 2000 SP2 Failure Sending Email

  I am getting this error when sending an excel file via email. Failure sending mail: The Report Server has encountered a configuration error; more details in the log files The scheduled job which emails an excel spreadsheet has been working and now it doesn't. I've done some research and this KB article is close to the error that I'm seeing however the win 32 error 87 is different. http://support.microsoft.com/ kbid=842423 Has anyone any idea's I have not applied the hotfix for SSRS 2000 sp2. Log file has this. ReportingServicesService!library!7b4!09/28/2006-15:00:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration e ...Show All

• Chrisull Sql Server Express Hangs and does not allow any connections

  Hi, We have few installations of SQL Server express on Windows 2003 servers, platforms varrying from Celeron to P4. Sql Server on system hangs after running for some time. Time varies from few hours to few days. When we try to connect it just gives connection timeout error. Any idea how to isolate the problem We would like to to enable more detail tracing but do not know how to do that. Thanks in advance. User Instances are completely separate process from the main instance of SQL Express, and they don't run for several days, they are started at runtime and shut down about 60 minutes after the last connection to the User Instance is closed. User Instances also have separate log files located at C:\Documents ...Show All

• mohdtmn Need to get separate pages for each person..help

  I'm fairly new to RS and have a problem. I have a query that pulls information on people, courses they have taken, their score and so on. I have a date parameter setup so I can run it by year. Everything works ok on the query side, I get all the information I need on all the people and the courses they have taken. However, when I run the report, I do not get a separate page for each person and their relative information. The first page shows the first name and the rest of the 700 pages list all the courses and other information, with no break. How do I render the report so that I can get a separate page(s) for each person and their specific info I can glady provide more info/code if need be. Bill ...Show All

• Behz Help with SQL

  I have a table named "policy_details" having four columns called policy_details(varchar),effectdate(datetime),Historyid(int) and policy_status(varchar). I want to keep only the maximum historyid records in "policy_details" where policy_details and effectdate should be equal and policy_status should be '30240084' . I want to delete the remaining records where policy_details and effectdate should be equal and policy_status should be '30240084'. Cheers Praveen Can you explain what the query is trying to do in english rather than trying to decode your criteria. The potential query may differ depending the nature of the data in your table e.g. uniqueness and nullability of ...Show All

• Sorrythedisplaynameyouhaveentere Adjusting the priority of the replication process (SQL 2000)

  Hi, I need information on adjusting the priority of the replication thread(s) within SQL Server 2000. All I've been able to find is how-to's on adjusting the priority of the SQL Server process itself, as well as information on how to adjust the relative priority of changes made to the database by subscribers. Here's the situation, from time to time our replication system goes down, it starts itself up after waiting 5 minutes but this causes a problem. When its starting up it seems to be taking up far too many CPU cycles. As such the server is unable to process SQL queries, which forces its subscribers to time out. This is a bad thing as the subscribers are control systems on an assembly line. What I want to do is lower the priority o ...Show All

• Mark Macumber Database restore speed

  This problem isn't specific to SQL Server, but because of the size of the files I deal with with SQL Server, it is the place I notice it more often, and hopefully one of you has, too. If I am restoring a database (or simply copying a huge file) that takes more than a couple of minutes, I find, by watching the network bandwidth, that after a couple of minutes, the data rate cuts on half and stays that way for the rest of the restore (or copy). If I have a Gb/s connection, maybe I start at 240Mb/s and then drop off to 120MB/s. If I have a 100Mb/s connection, maybe I start at 70Mb/s and drop to 30-40MB/s. It is fairly consistant in how long before the drop and in the magnatude of the drop (approximately 50%). The network staff have no c ...Show All

• GlennZarb SP_Help

  I need to write dynamic SQL statment that will delete a code from a table but before you can delete that code...I need to find all the foreign key constraints (all the tables that references this table to either update or delete from them and then delete from this table last) I know how to get this information from SP_Help but i dont know how I can do this dynamically. Please help. Emadkb Hi why don't you enable cascade update/ cascade delete and this will do the job automatically. The following query will return all foreign key related tables for a given table (2005 syntax...for 2000 replace sys.sysforeignkeys with sysforeignkeys) : select object_name ( rkeyid ) parenttable , object_name ...Show All

• qzrlsd Identity Specification limit

  what happens when a column marked as Identity Specification reaches the limit for example, I have some code tables using tinyints as keys, the actual number of entries will be 20 or so but there is some volatility, so eventually the 255 limit will be reached, what happens then the same thing applies to ints or bigints used as keys, eventually the database must run out of numbers information will be appreciated David Wilson. right, I did about the same thing (not quite as elegant :-)) - with the same result the question is - How do you fix it and how do you code something into a daily checkup routine or the like to find it and fix it before it happens Hi, ...Show All

• Richard G.H.Lin How to convert a value in a parametered sorting

  I've made a parameter for sorting data in a report. The expression for the table sorting is: =Fields(Parameters!Parametername.Value).Value The parameter has two labels (and values): 1. Item (Description) 2. Item number (Item_No) The description is a string, but the item number is a integer. In de parameter properties I can set one value for string or integer. When I use a "locked" sorting I can use the CInt function: =CInt(Fields!Item_No.Value) but when I use a parameter this doesn't work. Please help! I’ve found a solution.The fields used in the parameter could be different types, for example text, decimal, etc. So it is not possible to convert different fields in on ...Show All

• R1ZWAN Can I launch an application using T-SQL?

  For example, before bulk insert, I should uncompress zip files (or untar) from remote machine. Thank you very much. That is what I want. yes possible use the following code... xp_cmdshell 'Your Command' ...Show All

• mjoc69 Vista installs SQL Server 2005 SP1 every night!!

  With Vista Ultimate (release), I installed SQL server 2005 Developer edition. I installed SP1, apparently successfully. But my Windows update history shows the SP being installed successfully every night. I have automatic updating turned on (via AD policy). Has anyone seen this, and does anyone know how to fix it Thanks in advance. Peter There is a known issue were SQL Server SP1 through Microsoft Update/Windows Update fails to install. As SQL Server SP1 is not supported on Vista, the Vista OS actuals blocks the install. I am surprise to hear you say it was successful. As we have not heard from customers encountering the problem yet, we have not planned to update the SQL Server SP1 detection logic yet, ...Show All

• Uturn Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• graye SSIS 2005 MSDN Tutorial - Lesson 1 - Error

  I am new to SSIS 2005 http://msdn2.microsoft.com/en-us/library/ms167106.aspx SSIS 2005 MSDN Tutorial - Lesson 1 - subsection namely 'Adding and Configuring the Lookup Transformations ' - in that STEP 7 not working. Not able to select the 'columns' tab. Anybody worked-out this Lesson1 with the step provided by MSDN. Pls help. Thanks I hope you did, otherwise the tab isn't available. Did you " drag the green arrow onto the newly added Lookup transformation to connect the two components" in Step 2 Hope i didn't... I will check it again. Thank you very much ...Show All