Answer Questions

• sshier Problem while deploying Report on server

  Deploying to http://localhost/ReportServer Deploying data source '/Report Project1/cnt_SDS_REQUEST'. The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. I found the issue(s) First off, there were 2 application pools created by our Network Admin that were both configured for the same virtual Directory. This was causing me issues with the deploying issue. Second, They were both configured for either LocalSystem or NetworkService which would always tell me that I didn't have access to execute them. Once I stopped one of the 2 application pools and ensured that the Web service Identity matched the a ...Show All

• theonlykito Grab a dynamically NAMED field in RS2000?

  I have a hideous stored procedure involving a cursor I didn't write and don't have time to rewrite right now. I am in a super fast hurry. I returns one column with the month as the column name. This column name changes each time the report is run and I can't figure out how to grab in in SR2000. Everything I've tried comes up blank. As an example, it shows up in the data tab with a column name of 2/2006 and in the Fields as ID2_2006 but this changes each time it is run for a new month so what can I use in the report =Fields!WHAT_GOES_HERE.Value to grab that dynamic column name Some snippets from the stored procedure are: The column is named and values inserted in to a local value @MonthColumn. At the end a select * from a #TEMPSALES table ...Show All

• NeTBaPb SQL 16-bit client tools install fails

  I get an error during the SQL 16-bit client that I grabbed from the SQL 6.5 CD and I'm installing onto a Windows 2000 SP4 Server. I choose TCPIP from the Network Protocol dropdown, that's the only option I change. First error pops up with the DSHELL in the title bar: An error has occurred in you application. If you choose Ignore, you should save your work in a new file. If you choose Close, you application will terminate. I click on Ignore and get the following error with Application Error in the title bar: DSHELL caused a General Protection Fault in module MSCUISTF.DLL at 0003:1FA2. Choose close. DSHELL will close. I saw one post on another forum regarding the same exact thing but on that board it went unanswered. ...Show All

• BlueBeetle Help me remind me why I never run a package from a package

  Hi, For some reason, I stay away from executing a package from a package. I guess that this is because I have experienced issues with this in the past and because I have read some articles in that forum that pin point specific issues when you do this. So far I try very hard to either combine all I need in one package or I break it down in multiple packages and use SQL Agent to drive the package chaining. Does anyone has a better experience with SP2 as far as running child package from parent package is concerned Any bugs remaining out there Thanks, Philippe I also have a lot of packages running as Parent/Child. Sometimes they fail, but this could be related to different causes. ...Show All

• grievesy Concatenating Fields With NULL Values

  Hey everyone, This is probably a very simple question, but I am just stumped. I am storing different name parts in different fields, but I need to create a view that will pull all of those fields together for reports, dropdowns, etc. Here is my current SELECT statement: SELECT m . FName + SPACE ( 1 ) + m . MName + SPACE ( 1 ) + m . LName + ', ' + m . Credentials AS Name , m . JobTitle , m . Company , m . Department , m . Address , m . City + ', ' + m . State + ' ' + m . Zipcode AS CSZ , m . WorkPhone , m . FAX , m . Email , c . Chapter , m . Active , s . Sector , i . Industry FROM tblMembers m LEFT OUTER JOIN tblChapters c ON ...Show All

• xlordt Full-Text Crawl Error in logs

  Hello I get tons of errors of this type. Are the error-code (x14b) documented I've checked a couple of rows but don't find what could be wrong. I'm running sql 2005 with sp1, noise-word files are empty, index has many columns which are in different languages. Thanks for any support Extract from log 2006-12-20 22:52:51.53 spid20s Error '0xc000014b' occurred during full-text index population for table or indexed view '[shab001].[dbo].[TSH_SHABDATA]' (table or indexed view ID '917578307', database ID '5'), full-text key value 0x00000000001E7E42. Attempt will be made to reindex it. 2006-12-20 22:52:51.53 spid20s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Programme\Microsoft SQL Server\MS ...Show All

• pencil Won't select rows with null field values

  I cannot in the life of me understand what goes wrong here... In a webapplication (C#.NET) I traced an inability to retrieve existing records to SQL Server, where I cannot do the same either. The problem is that in the parameterized query, some fields can be null, and thus when the corresponding fields in the database record are null also, they should be selected. But this won't happen for some reason. I wrote a test SQL statement that gives me the same bogus: DECLARE @institution int, @collection int, @serialnr int, @subnr nvarchar(50) SET @institution = 1 SET @collection = 1 SET @serialnr = 240 SET @subnr = NULL SELECT ID, Institution, Collection, SerialNumber, SubNumber, AccessionYear, Sagsnummer, DanekraeNr, TaxonIdentified, ...Show All

• Antioch delete files

  I need to delete all the *.txt file in a specific folder modified date is older than 2 months,. How can I do this in a stored procedure You don't do these in SPs. It is easier to do it on the client-side using a VB Script program or batch file. If you want to do it from SPs then you will have to either use xp_cmdshell to run the script/batch file or use OLE automation. Both of these approaches are inefficient and complicated. Hi Jens, Thanks, can I see that code As I saw the question on the public forums, I just wanted to qoute the solution that was posted: http://www.realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html#extended Meanwhile I created a small .NET program which can take various parameters to ...Show All

• Kardi SQLSERVR.EXE process is taking up a Huge Memory.

  Hi Everybody, I have a windows service which populates data to my SQL Server Database ( 2000 Version ). when the service is running my sqlservr.exe process takes up a huge space in the memory. The process memory stays in that level even after me turning off the service. Kindly send me some suggestions.. Thank you, Veera. SQL Server's memory manager is designed to keep as much data cached in memory as it can in order to speed up access for incoming queries. In order to play nicely with other processes on the machine SQL Server will release memory when a low memory notification is sent by windows. The memory may be committed by the sql server process, but it will be released if another application requests ...Show All

• Niehls uniqueidentifier to string returns all uppercase while inverse REQUIRES the string to be lowercase

  I have a maintenance plan that consists of several parts. It basically backs up all the databases, deletes old backups and then shrinks the databases. The odd thing is that it appears to back up all the databases, can't tell if it does step 2 or 3 and then it fails with the errors below. How do i correct this short of throwing it out and starting from scratch This is a package originally from one server that i'm trying to deploy to a 2nd server. Already using configuration files to chagne the target connections etc. thx. PackageStart,WSWT4361,NT AUTHORITY\SYSTEM,ProdBackupPlan,{645B67A9-0377-4462-BE81-755D4B1CE9DD},{AB598508-1858-41BC-8844-CA793A7861D4},2/28/2006 5:09:16 PM,2/28/2006 5:09:16 PM,0,0x,Beginning of package ...Show All

• irvendeep Problem with displaying workflow?

  Hi, I just recognized a strange displaying problem in one of my SSIS jobs. I created job which contains a sequence container. Within the sequence container there is one "Execute SQL Task" and one "Foreach Loop Container". Within the "Foreach Loop Container" there are 4 task which are connected with precedence constraints. Now my problem is that if I load the SSIS job and open the "sequence container" while the "Foreach Loop Container" is already open then the precedence constraint won't be displayed. If I close and open the "Foreach loop container" again then the precedence constraints will be displayed again. My first assumption was that it might be a problem with the ...Show All

• vzzvzz Is this possible?

  Hi guys, Is there any mechanism or tool to convert T-SQL query to its corresponding MDX query Please let me know. Sincerely, Amde That begs the question: is there necessarily a corresponding MDX query So if you could explain the context, or what problem you're trying to solve, that would help. A couple of questions: Is 24th the end of the fiscal or reporting month - in which case create a separate "fiscal month" For each row listed above, is some data or measure to be aggregated over the date range Not exactly, but depends on what overall problem you're trying to solve - I think it's useful to understand the capabilities of Analysis Services OLAP in its ow ...Show All

• Alvin Kuiper export to PDF (reporting services)

  Greetings!, Does anyone here know where to configure the document properties/security settings of PDF files generated by reporting services thanks! Hi, ABCpdf from WebSuperGoo will allow you to do what you want. One word of caution they currently don't have a 64 bit version of their component. Regards, Sanjay Thanks Brad. Any suggestions on other 3rd party components where I can do export to PDF (asp/htm to pdf) programatically I want to make the PDF not printable, not modifiable, set passwords...etc.. These properties are found under the Document Security tab under the File menu in Acrobat reade ...Show All

• wadnerk osql batch command does not return any records when executed using Scheduled Tasks

  I've read a similar post but there was no solution It seems a bit weird.  I created a batch file which runs osql which runs a very simple SELECT statement - no parameters, simple WHERE clause, etc.  When I execute the batch file, it generates a file which contains the results of the query.  But when I run the same batch file using Scheduled Tasks, it does not return any record at all.  The account that I use to execute the batch file and execute the query is a member of the sysadmin role.  Am I missing something out Has anybody encountered this before ...Show All

• Khenat.Ram Simple Yes/No Question Regarding Inferences

  I was looking up information regarding SQL when I came across this on a website ( http://www.dbpd.com/vault/9801xtra.htm ): 19. Redundancy is good. Provide as much information as possible in the WHERE clause. For example, if the WHERE clause is WHERE COL1 = COL2 and COL1 = 10, the optimizer will infer that COL2 =10. But if the WHERE clause is WHERE COL1 = COL2 and COL2 = COL3, then optimizer will not infer that COL1 = COL3. Is this true for SQL Server Thanks - Jason "DiZASTiX" DiZASTiX wrote: In Re Adamus: All birds have wings. All flies have wings. ================================= Therefore all birds are flies. <--Logically true but disturbing. The ...Show All