Answer Questions

• Wytboi w3wp causing memory paging, crash on reportserver?

  Summary: We host reports off of one server that are accessed and refreshed 24/7/365. On a daily basis, I receive calls about reports taking several minutes to run IF they run at all. (normally these reports take seconds). There has yet to be an actual "error message" associated with this behavior. When I check the server at these times, I will find that w3wp.exe process is taking up about 4G and is causing paging. It seems that once it gets to that point, it will kill itself and all goes back to normal. However, it's a slow death and is impacting business. We're using MSRS 2005. Hosting the reports is the job of this server--no other applications are hitting it. There is a development SQL db on the box, but not in use at this ...Show All

• sofakng Different T-SQL statements?

  Hi, i just want to know if the T-SQL statements in SQL server 2005 are different from SQL Server 2000 If they are different, where can i find the Server 2005 T-SQL Statements Not able to edit information...error logged so please find changes in this post... Hi, I think you basically need clarity regarding various database statements.These statements are not specific to SQL they are applicable to Oracle and also other Database technologies too.The DDL,DML,DCL statements are an integral part of a DBMS that help a DB developer design the schema,structure it as well as have it functioning in a controlled manner. A select statement is used to retrieve information from database objects. And, ...Show All

• i3tech SQL 2005 Transact-SQL Full Outer Self Join

  Can someone please help me to find out the problem with the following Self Join using Full Outer Join SELECT T1.product, T1.vendor, T2.product, T2.vendor FROM ( product_vendor T1 FULL OUTER JOIN product_vendor T 2 ON T1.vendor = T2.vendor ) WHERE T1 . product = 1 AND T2.product = 2 This query always returns only the matching rows (as if INNER join). Is there a way to get the non-matching rows too, using a single query, without using temp tables If I put the results for Product 1 and Product 2 in two different temp tables and then do a FULL OUTER JOIN on the temp tables, I could get the desired result. I tried putting the WHERE clause condition in the Join, having <> etc., - but, nothing ...Show All

• Morganificent Problems Seeing CLR Stored Procedure in Data DropDown

  Good Day: I created a C# CLR stored procedure. I am able to run it on the SQL server directly and thru the Management Studio Console. The problem is that I do not see the Stored Procedure in the SQL Reports project in the Management Studio Console in the Dropdown of the data tab. If I type the name of the procedure it tells me the procedure does not exists. I created a standard procedure and gave it the same permissions as the CLR stored procedure and it is visible in the dropdown. Anyone know what I am missing Thanks, Omar Soto I was not able to correct this problem so, I ended up creating a wrapper StoredProcedure that was visible in SQL Server Reports. Omar ...Show All

• David Murray Error: Subreport could not be shown.

  I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1. Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown." I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information: You can try out the latest CTP release of the upcoming service pack 2: http://ww ...Show All

• vitagreen SSIS: Roll Backed Data transfer task

  Hello, I'm Designing sql server 2005 SSIS Packages. According to my requirment i have a sequence container. It has few data flow task, on success of one next one is running. If any one of them get failed then it should roll backed all the transaction. Each Data flow task transfering a data from one server to another server in similar table. Thanks. Thanks for guiding me. Transactions are covered quite well in Books Online, and here are some other links to articles on transactions. Native Transactions ( http://wiki.sqlis.com/default.aspx/SQLISWiki/NativeTransactions.html ) Transactions in SQL Server 2005 Integration Services ( http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservic ...Show All

• giddy Implementing ranking position

  Hello, I have a group that is custom made on the table's grouping expression, something like =SWITCH(Fields!Country.Value= "Portugal" ,IIF(Fields!Storetype.Value= "Frs" , "Portugal Frs" , "Portugal" ), Fields!Country.Value= "Italy" , "Italy" ,Fields!Country.Value= "Spain" , "Spain" ,Fields!Country.Value= "United States" , "United States" , Fields!Country.Value= "Internet" , "Internet" ,Fields!Country.Value<> "" , "Other" ) The thing is that i order this by my value, and then i use a column that is the rowcount, but sadly i got 11 Portugal 19 United States 30 Spain How ...Show All

• quiklearner MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No books are published yet. Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431 All answers and ideas in 'any form' are appreciated. Thank you very much. ...Show All

• zppro environment variable

  hi, can you show me how to get the value of an environment variable from a script task thanks! Public Class ScriptMain Public Sub Main() Dim home As String = System.Environment.GetEnvironmentVariable("HOMEDRIVE") + System.Environment.GetEnvironmentVariable("HOMEPATH") Dts.Variables("MyDocuments").Value = Path.Combine(home, "My Documents\") Dts.TaskResult = Dts.Results.Success End Sub There is a sample package that illustrates the method in action here - Environment Variables- Raw Files ( http://wiki.sqlis.com/default.aspx/SQLISWiki/EnvironmentVariables-RawFiles.html ) Try Environment.GetEnvironmentVariable method http://msdn2.micros ...Show All

• Alvin Kuiper Bug in MS Management Studio for SQL-Server 2005 while creating a publication!

  Hello, I found a bug in Management Studio, which can be reproduced with following steps: 1. Create a new publication with the 'New Publication Wizard' 2. Select a database which contains at least 2 tables. 3. Select 'transactional publicatioon' 4. Select at least 2 tables as articles 5. Set article properties for all table articles 6. Change 'Statement Delivery' to 'Insert statement', 'Update statement' and 'Delete statement' and save the article properties. 7. If you now check the properties for a single article you find that the 'Statement Delivery' is set to 'Do not replicate...'. If you generate this publication and create a subscritpion you will see, that actual no replication take place. It took me a while to find out why my replicat ...Show All

• swalker MSVCR70.dll

  While trying to run Yahoo Browzer, Got I got a message saying MSVCR70.dll was not found. How can I get it fixed Rick This does not look like a SQL Setuo question. Please post with more details if it is. Thanks Michelle ...Show All

• llorrac Problem with named calculation

  Hi, I wish all the best fro the new year. I encounter a serious problem with creating a named calculated colunm programmatically to the DSV of an analysis database. \i would like to create this named calculated column by means of VB but any help in C# is acceptable. I have already created this column in Microsoft Visual studio design but I need to be created programmatically now. Thyanks in advance Best regards, manolis The named calculations and named queries should adhere to the standard SQL language used in relational database you use as a source for DSV. Now if you would like to create a function that performs calculations for specific column, you can create stored procedure in relational database and ...Show All

• Sam_res03 How to nightly copy 1 database to another

  I know this is probably an easy thing to do but I've been struggling with this on and off for the past month or so. All I want to do is copy two databases (our app db's) to two other databases (for app testing and training) on the same server every night. The databases aren't used during this time so they can be taken down if necessary. I've tried using the Copy Database wizard and scheduling the resulting job but that isn't working... Thanks in advance for any direction/help! OK, I think the following T-SQL will do what I want... does this look functional Keeping in mind ILS and ILSSys are the two db's I want to copy to Testing1 and Testing1Sys respectively. Use Master GO Exec sp_detach_db 'Testing1', ...Show All

• NickoM Error 15401 Adding Domain Group to SQL Server

  I have tried rebooting the system, I have ran the script to look for duplicate sids and am still having the issue when trying to add a domain group to SQL. I get the Error 15401: Windows NT user or group'mi\Trust Legal' not found. Check the name again. Running SQL 2000 Std, with SP3a, and the collation is set to SQL_Latin1_General_CP850_BIN, which makes this instance case sensitive, and the group name is spelt right and am following the case sensitivity of the name as well. Apprciate all the great advice, but nothing seemed to help. 1) I am able to login into server using the account in which sql is running under, and am able to add the group to a folder on the box 2) ran the groups sid up against sid2name, and found the ...Show All

• Ori&amp;#39; IBM iSeries Access for Windows with Report Builder

  I have successfully deployed a standard SSRS Report (i.e. non Report Builder) to our Report Server using a Shared Data Source to an iSeries Access for Windows Driver. The Data Source has the following properties: Type : OLEDB Connection String : Provider=IBMDA400.DataSource.1;Data Source=AA;Initial Catalog=AA;Default Collection=MITDTA;Catalog Library List=MITDTA,MVXBDTA The Report works perfectly using this connection. However when I try to run a Report Builder Report based on a Report Builder Model that uses this same shared connection I get the following error: An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server. --------------- ...Show All