Answer Questions

• Haziman package and file location dependencies on deployment

  My parent package calls packages stored in the file system. While developing, I would like to call packages in the project bin directory. In production, I would like to call packages in a different development. Is this possible I can change the package connection string with an expression that refers to user variables PackageLocation1 or PackageLocation2. I would like to do this automatically. Is this something that should be done at deployment time Or is there a run time value that I can check and conditionally use PackageLocation1 or PackageLocation2 Development and deployment is done on the same server, so the same enivronment variable value would be used in an indirect configuration. Same thing applies to a file configuration. ...Show All

• figuerres The annoying WMI configuration error

  I'm recieving the following error: The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008). I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything. Please give some suggestions on how I can resolve this issue. Have you tried anything yet to repair WMI For example, running the following commands: Mofcomp.exe %windir%\system32\wbem\cimwin32.mof Regsvr32 %windir%\system32\wbem\wbemupgd.dll Regsvr32 %windir%\system32\wbemwbemsvc.dll wmiprvse /reg ...Show All

• Dhondtie type mismatch between column and unnamed parameter

  I trying to build a report using a dbisam ODBC driver. This is my sql statement: SELECT div.group_id,div.description AS divdesc FROM awgrgrp AS mg, awgrgrp AS div WHERE div.Parent_ID = mg.Group_ID AND mg.group_id = And whenever I run the query I get the following error: TITLE: Microsoft Report Designer ------------------------------ An error occurred while executing the query. ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11949 SQL error - Type mismatch between column 'mg.group_id' and constant ' ' in WHERE or JOIN clause ------------------------------ ADDITIONAL INFORMATION: ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11949 SQL error - Type mismatch ...Show All

• SulaimanA Please help me to optimize this sql query, it takes 28 seconds to return result. Please give me a tips where I went wrong?

  SELECT * FROM ( SELECT TOP 15 * FROM ( SELECT TOP 15 CMDS . STOCKCODE AS CODE , CMDS . STOCKNAME AS NAME , CMDS . Sector AS SEC , CMD7 . REFERENCE AS REF , T1 . HIGHP AS HIGH , T1 . LOW , T1 . B1_CUM AS 'B/QTY' , T1 . B1_PRICE AS BUY , T1 . S1_PRICE AS SELL , T1 . S1_CUM AS 'S/QTY' , T1 . D_PRICE AS LAST , T1 . L_CUM AS LVOL , T1 . Chg AS CHG , T1 . Chgp AS CHGP , T1 . D_CUM AS VOLUME , substring ( T1 . ST , 7 , 6 ) AS TIME , CMDS . SERIAL as SERIAL FROM CMD7 , CMDS , CMD4 AS T1 WHERE T1 . ST IN ( SELECT max ( T2 . ST ) FROM CMD4 AS T2 , CMDS WHERE T1 . SERIAL = T2 . SERIAL AND CMDS . SERIAL = T2 . SERIAL ...Show All

• jim rozak Bulk Insert working with servername and not server IP

  Hello I'm working with VB.net on a SQL server 2000. The VB code is launching a stored procedure on the server. The stored procedure is doing a bulk insert. One parameter is given to the stored procedure which is the UNC path to the file for the bulk insert (say \\servername\share\filename.csv ). Servername is the name of the sql server, share a shared directory on this server (so the file is everytime on the sql server). In this case everything is working fine. When the UNC path is given to the stored procedure with the ip adress of the server (say \ \56.151.35.5\share\filename.csv ) i nstead of his name, i'm encountering time out without error message. The both case are working fine in isql, so i don't uderstand where the problem ...Show All

• Karim Hemani Setting up Query Notification and Performance issue

  We are in development stage of an application which uses Query Notification feature of SQL Server 2005. When the development started what the development team did was, they just Enabled broker on the database by SET ENABLE_Broker statement and they started using Query Notification. Now the application is in testing phase and when we test with many user, the performance is really slow. What i want to know is , when we use Query Notification what all are the setting to be done at the database level. Is this setting enough. And also how can i tune this system. any useful link is appreciated. thanks in advance Madhu     I will describe the whole scenario. (a) Application is developed in ASP .net 2.0 /C# and cac ...Show All

• Tecnomage Saving Reports as a file share

  Hi everyone, I have been trying to set up a subscription as a file share to save the report on a shared folder with full control on a server that is outside the domain the reporting services server is on. I am having a login name or password incorrect error returned. Saving the same report as a file on my personal desktop worked fine, so I know that the server is connecting and authenticating correctly. Any ideas Thanks. ...Show All

• krhoover copy content of txt file

  Hi Guys, What approach should I use to copy content of a text file. Is BCP capable of doing this How about SSIS Example of the text file's content: Date, "20060101" ST_Code, "101" A_Code, P_Code, T_Code, amount, price "0001", "1111", "0101", 550, 230 "0002", "1111", "0102", 345, 122 "2001", 0212", 0930", 410, 90 In the example above, I just want to copy the rows Date, "20060101" and ST_Code, "101" into a table. Regards, Lars hi, if you know the location of the row you want to copy you can use the -f anf -l switch of BCP which stands for -f = the first ...Show All

• yanivpinhas Examples for using DirectRow method?

  Hi! I was just wondering if there are any examples on how to work with the Script Editor, and more specifically how to use the DirectRow method I've seen some examples that say that the editor automatically creates the methods DirectRowTo<output buffer>, but it doesn't say how that is done. If I just specify Row.DirectRow(output buffer #), it says that the method is protected. Any help or just pointing me in the right direction would be greatly appreciated! Thanks! Jeff Tolman E&M Electric jeff.tolman@enm.com This should be a big help: http://www.sqlis.com/default.aspx 311 -Jamie That's what I needed! Thanks Jamie! Ok, I see ...Show All

• Brett Metcalfe How can I display different bands (detail records) based on a key column in a table.

  How can I display different bands (detail records) based on a key column in a table. Based on a key field, I will like to display a different set of columns Data is shown below keyid Name Company 1 Brenda USAirways 1 Lawrence Costco 1 Linda WalMart 2 Sarah MCI 2 Peter Dell 3 Paul Stanford 3 Tina HP 3 Felix Apple 3 Susan TDK I will like to display columns Keyid, Name when keyid is 1, Columns KeyId and Company when keyid is 2, and Columns KeyId, Name, and Company when keyid is 3. Daniel: This is probably going to sound strange, but I'm from Wheels in Livermore....a packet of papers was found on one of our buses and a few of the papers had your name on them. I sort through the lost and fo ...Show All

• sunny123 sp_cycle_agent_errorlog fails/SSMS recycle Agent log fails

  Hi, The sp_cycle_agent_errorlog stored procedure fails on our primary SQL Server 2005 server; the SSMS context menu option (right click Error Logs under SQL Server Agent in object explorer) to recycle the agent log also fails. If we run the SP then we get the following: Msg 22022, Level 16, State 1, Line 0 SQLServerAgent Error: 32. If we try the SSMS option we get this (in a nice dialog): Cycle agent error log failed for JobServer 'UKSQL04'. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) SQLServerAgent Error: 32. (Microsoft SQL Server, Error: 22022) We are running SQL Server 2005 x86 Enterprise E ...Show All

• Jeremy Thake Report code and dataset question

  I have a strange (maybe not too strange) problem. I have data populating a report and everything is fine. This table also references another table where there might be zero to several prefixes associated with the name. If I have one row from the main table, but there are three prefixes that have to be concatenated to the beginning of the Name field (like a one to many situation), what would be the easiest way to do this I thought of doing a separate Report code and I have the following: Function addPrefix(byval current as string, newToAdd as string) as string dim deg as string deg = current + " " + newToAdd return deg End Function In the text box, I have it referencing it's own value. So the textboxes express ...Show All

• DOSrelic Having 2 CALCULATE statements no longer works after installing SP2!!!

  I received the following email from a collegue of mine:   I think we may have found an issue with SQL SERVER 2005 SP2   1. Some of the Analysis Services Properties when you click the advanced tab are missing!   2. The MDX scrip behaviour is not the same. In our cubes we had two CALCULATE statements - first to aggregate the data as normal, then some code to calculate MTD and YTD figures and then another CALCULATE statement. This enabled us to calculate percentages later on in the script without having to sum up all the data at leaf levels first.   With SP2, this no longer works!!! All our percentages are now being added up (like all other measures) which is clearly ...Show All

• vb2005 MSDASQL error requires SQL Service restart

  I am having trouble with a linked server using MSDASQL.  I'm connecting to a PostgreSQL database and pulling over data.  This process has been working fine. In trying to pull data from a different client database (same schema), I received an error that the MSDASQL couldn't read the column names. The actual problem I want help on is that after this happens, I am no longer able to make valid connections to any of my Linked Servers using MSDASQL.  The only way I can get my other linked servers to work again is to restart the SQL Service.  Usually this is impossible for me to do because of the number of active users. Two questions: 1) Is there another way to restart a more targeted service or sub-set to reset MS ...Show All

• ChinmayaNayak Where to use SQLCLR ? Data access is not recommended?

  Just wondering which scenarios is suitable to use SQLCLR. Any kind of data access is not recommended I guess. Only things that cannot be easily done in TSQL should be done in SQLCLR but why Can't those things be done in app layer itself Scenarios recommended for SQL CLR: - External data access like filesystem, registry etc - Complex calculation - Recursion without data access (this can be implemented with CTE for data access) If data access with SQL CLR is not recommended why should CLR should be even used and logic reside in database layer.. it makes no sense to me. Any thoughts (Duplicate post) Hello Sequel2k5, I suppose set-based TSQL would be faster than iterating ...Show All