Answer Questions

• AntiSilence Show / Hide Parameters on a Report

  Is there any way to get the parameters to remain visible after clicking on a report link Currently, when I click my report link and pass parameters, the new report loads with all the parameters hidden even though they normally appear fine when you go to the report straight. Now, there is a way to make them visible by clicking the "Show / Hide Parameters" button on the far right of the screen. However, I would really like to hear of a way to automatically keep my parameters visible after clicking on a report link. This is especially useful since most general users won't know to click the "Show / Hide Parameters" button and won't be able to specify new parameters after clicking the report link. Any ideas Thanks!!! ...Show All

• Joost Schermers Accessing the name of all the related tables name

  Hi Everyone, I would like to ask a question, Is there any way or tool available in the sql server 2000, that tells the user, how many tables contains the same column name (such as Col_N, is a primary key and I want to know all the table names that have the same Foreign key (COL_N)). If anybody knows that, pls help me. Thanking you Gaurav Using SQL 2000, you may wish to examine the Information_Schema views for a list of which tables contain a particular column, such as: SELECT Table_Name FROM Information_Schema.Columns WHERE Column_Name = @x ...Show All

• SankaraNarayanan Nagalingam Executing an asp page from sql server.

  Hi; I don't know if this is the right forum, if not please move it. I have an asp page using fso etc to create txt files on server. I want to call this asp page from sql server for example a table is updated. I mean I want to execute or call this file inside a trigger so a table is updated sql server will execute that asp page and create the text files i needed automatically. Any help will be appriciated. Thanks... hey, Triggers behave synchronously which means that you will have to wait for the external application (which you probably would need) to come back for the transaction to commit. In common this leads to very bad performance as well as a lot of ugly error retrieving if anything goes ...Show All

• RajLakamana Tran Log Backups Fail 40 minutes after the Differential backup.

  Running SQL Server 2005 Standard Edition. Database is in Full Recovery mode. I have full backups scheduled weekly, differentails scheduled daily and tran log ackups scheduled for every 15 minutes. The tran log backups only work for the first 40 minutes or so after the daily backup. Once the daily has occured, the tran backups will work again, but for only 40 minutes. I run consistency checks on the db daily and there are no errors. The error returned from the tran log backup is 'BACKUP LOG cannot be performed because there is no current database backup' Any thoughts would be appreciated. Turns out another guy in the office was truncating my tran log and did not inform me that he wa ...Show All

• chris townsend SP1 and remote distributor ?

  Hi There If i apply Sql Server 2005 SP1 to a remote distributor can i keep all publication and subscriptions intact I am hoping i simply stop all repl jobs on the distributor, apply SP1 and then restart the jobs. Is this correct Thanx it should work just fine. ...Show All

• Forsaken Reaper Different Result Same Sql Queries

  I wrote 2 sql queries in two different ways. The only difference in both queries are One using '=' and other one using 'in'. All the other data is same.In my sense '=' and 'in' same Both queries should give same result. But one query giving different result and other query giving different result. Is this 2 queries different SELECT sum(SALES_ITEM.NET_PRICE) FROM PRODUCT_GROUP_LINK, PRODUCT, SALES_ITEM WHERE (PRODUCT_GROUP_LINK.PRODUCT_CODE=PRODUCT.PRODUCT_CODE) AND (PRODUCT_GROUP_LINK.PRODUCT_CODE=SALES_ITEM.ORIG_PRODUCT) AND PRODUCT.STYLE_CODE='MC001 ' AND (SALES_ITEM.PRICE_LIST='1FAC ' OR SALES_ITEM.PRICE_LIST='1FAW ' ) AND CLASS_CODE='TYPE ' group by STYLE_CODE SELECT sum(sales_item.net_price) from PRODUCT ...Show All

• K.V.Bharath Deploying multiple projects

  Is it possible to deploy multiple Analysis Services projects into one OLAP database, or you have to create all cubes into same project Thanks from answers! Peter Jeah, that is problem, but I thought there is trick, so unfortunately there isn't.. Thanks. If it would work you could have problems with name collisions like dimensions with the same name. I also tried copy paste from one project in BIDS to another, still without any luck. Regards Thomas Ivarsson Hello. The problem is that you will overwrite the existing cubes and other objects with the latest project that you deploy to an existing database. I think the a ...Show All

• Fogel can't find Enterprise Manager and Query Analyzer after setup

  I downloaded the trial version of sql server 2005. but after installation, I couldnt find the Enterprise Manager and Query Analyzer. Any idea about that Thanks. Which Edition of SQL Server 2005 do you download If it is SQL Server 2005 Express, such tool is not included. Please try SQL Server 2005 Expree with Advanced Services, which includes tools. You can get it from the same download website as SQL Server 2005 Express. Thanks djartsinc - do you know where on the control panel has the function I spent a long time trying to find, but couldn't... Hi zhishan, I believe those services can be configured from control panel (turn windo ...Show All

• Mick . Reading value of a Windows variable in a SQL script?

  MS SQL Server 2000 Hello Everyone, I am executing a SQL script from a Windows batch program using isqlw.exe as: rem - test.bat set SCRIPTS=C:\Scripts set TMP=C:\Temp isqlw.exe -S dbserver -E -i %SCRIPTS%\test.sql -o %TMP%\test.tmp -FA Is it possible to read the value of the SCRIPTS or the TMP variable inside test.sql Thanks for any suggestions. I am 99% sure that you can do anything you need to do with 2000 using SQLCMD. You wouldn't be able to do things in 2000 that are only supported in 2005, but the tools should work fine since it wouldn't rely as heavily on things like system tables as a GUI tool would, and the GUI tools are backward compatible too. You can download SQLCMD and ...Show All

• markse Which Visual Studio .NET Version?

  Hello, we want to introduce Reporting Services 2000 in the next few months. Basically, 2 - 4 interns will work with it at the same time. Which version of Visual Studio .NET is recommended for such an environment I do not have ANY experience with Visual Studio .NET, so excuse if this is a dumb question ;) Thanks, Michael If you just want to design some reports in SQL 2k, you will just need a one language VS edition, which you will get for about 100$ per client. For viewing reports you just need an IE and a SQL Server CAL or a processor license. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- For Reporting Services 2000, you will need to use Visual ...Show All

• Koen Vermeire Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express?

  Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express I DownLoad the tool named XM.exe,but It's only a Query tool and I have to do everything using scripts.I realy want to know Is there a tool that I can use to Create db and restore db and backup db and create table etc. like the Admination tools in SQL 2000 Thanks for u kindness. Tonny. Thanks for ur kindness ,and Is it a single tool or integrated with the SQL2005 TCP Developer Version Is it free to download If yes, Could u tell me where Can I Download the tool or Where Can I DownLoad the SQL 2005 TCP Developer Version Thank u again. Tonny. You can use the tools that come with the June CTP Developer Edition. ...Show All

• Namrata Prashar Trying to add Time Intelligence and hitting an error...

  I'm setting up a new cube, and trying to add time intelligence. The IDE doesn't give me the option, instead showing a warning message: A time dimension is required to enable this functionality. Ensure that you have a dimension of type Time, that contains at least one hierarchy with a level flagged as a time period. Now, as far as I know, I have a dimension of type Time and it contains a hierarchy of levels with Types that are time perionds (year/quarter/month/day), so I'm a bit puzzled by this message. My Time dimension is represented by a physical date/month/quarter/year hierarchy in the relational database, and I have created a dimension hierarchy that matches. I've got attributes in my time dimension with types Days, DayOfMon ...Show All

• Vaish Access denied for network drive

  Sql server prompts "access denied" while firing the following query EXEC master..xp_cmdshell 'dir \\servername\sharedfolder\ *.* ' how to access the folders and files existing in network drive. I agree your comments, but my login has sysadmin privilege. But how to find the account that is used to the start the sql server service. Here is part of it: I assume that the account you log into SQL server has server SYSADMIN privilege I think you need to know what account is used to start the SQL Server service (somebody check me here ) You need to know if the account that starts the SQL Server sercice has permission to access your designated share The path is different if your acco ...Show All

• Kent Waldrop Fe08 Export to Excel failed with ReportItems and sub report

  Hi, I have two RDL files, one is main.rdl, the other one is sub.rdl. In the body of main.rdl, I threw in a subreport that links to sub.rdl. Follow by the subreport is a table, in which has a textbox called mytitle. In the page footer, I added one text box that references to mytitle by using ReportItems!mytitle.Value. When this report rendered in HTML or PDF format, it worked fine. However, when exporting to excel format, it failed. I figured it is because there isn't a ReportItem in the subreport called mytitle. I tried adding a dummy textbox into the subreport and called it mytitle, but again, no luck. Did anyone ever encounter the same problem Is there a work around way Thanks, i have vs ...Show All

• Artem Bytsin devenv.exe hangs up with alomost 100% cpu usage

  For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio. Any resolution Thanks I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly. As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem. Let me know if you come up with a resolution. Thanks, Darryl darryl_jewett@msn.com We were able to reduce the occurrence of hangup by 90% ...Show All