Answer Questions

• Andreas Asterlund Site Settings gone missing

  We have an RS installation where suddenly we can't seem to find the Site Settings link (even when logged in as the local administrator on the machine). We suspect that somehow the BUILTIN\Administrators group was deleted from the role assignments. Is there any way to get back in TIA, Zig As an addition to the above information I found out that if you allow anonymous access to the report server site then the Site Settings link is no longer visible. However, I checked the settings for the site and anonymous access is not set for the reportserver site. Zig ...Show All

• MarkDanielMaltby Page Break for SSRS 2003

  Hi, I've been looking for a way to apply a page break in my report and I've read a few of the solutions presented in the forum. However, to my understanding, they are only applicable to SSRS 2005. Is there a similar hack around the problem for 2003 This might work. Add a list with a dataset and select the page break after option. For the dataset, you could just type in select 1 as dummydata. Then shrink the list. cheers, Andrew thanks andrew. i tried your solution and the page break works but it isn't what i had in mind. what i actually have in mind similar to exporting reports into excel which exceeds 65k rows. to my understanding, i need to utilize page breaks which also af ...Show All

• bzoli Declare cursor based on dynamic query

  Hi, I am declaring the cursor based on a query which is generated dynamically. but it is not working Declare @tempSQL varchar(1000) --- This query will be generated based on my other conditon and will be stored in a variable set @tempsql = 'select * from orders' declare cursor test for @tempsql open test This code is not working. please suggest Nitin You can not use dynamic sql while opening the cursors.. it should be like this Declare Test1 cursor for Select * From Orders this is not possible. i agree with waaz Instead of local cursor, you can create a Global cursor with dynamic sql, which is available beyond the scope ...Show All

• magicalclick Full Cached Lookup with Parameters

  Parameterized queries are only allowed on partial or none cache style lookup transforms, not 'full' ones. Is there some "trick" to parameterizing a full cache lookup, or should the join simply be done at the source, obviating the need for a full cache lookup at all (other suggestion certainly welcome) More particularly, I'd like to use the lookup transform in a surrogate key pipeline. However, the dimension is large (900 million rows), so its would be useful to restrict the lookup transform's cache by a join to the source. For example: Source query is: select a,b,c from t where z=@filter (20,000 rows) Lookup transform query: select surrogate_key,business_key from dimension (900 M rows, not tenable) Ideal Lookup ...Show All

• pattyg BACKUP CERTIFICATE alters ACLs on created file

  NOONE ASKED FOR THIS!!! why the heck is BACKUP CERTIFICATE altering the file's ACLs - it's just a PUBLIC CERT I'm exporting!! in additions MS doesn't seem able to add the ability to re-inherit file-rights from parent objects via the command-shell. I export the public-key for a reason! I want to import it on another machine (automatically) to establish a trust. But this freaking "feature" is costing me HOURS of research on how to get rid of these ACLs on a public certificate!!! argh!!! sorry, I really had to get this out! why not at least give us a switch we can set in BACKUP CERTIFICATE command to stop this from happening is there a work-around now I need to activate EXEC sp_configure 'show advanced options' ...Show All

• dimkaz Identifying obsolete views

  I am trying to optimize a database that has a large number of views. I believe some of them are no longer used by any application and are obsolete. Is there an easy way to determine the frequency actual use of a view You would either need to trace the Access on the objects via SQL Profiler to see if the views are still access or analyze the log files with any thrid party logreader. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Bruce Baker SQL Server 2005: Backward Compaibility Errors

  I am running a SQL Server 2000 enterprise default instance and SQL Server 2005 standard named instances on a machine. I uninstalled the default instance and tried to instance 2005 but was unable to with the error: 'an installation packages for the product Microsoft SQL Server Backward Compatibility cannot be found. Try the installation again using a valid copy of the installation packages sqlserver2005_bc.msi' I have tried to repair the backward compatibility currently installed and have also tried runing the msi file again but it will not install. I have also put back 2000 as the default instance. then tried to apply sp1 to the 2005 named instances and i cannot do that either. anyone have any ideas Thank you. ...Show All

• bszom Select statement possiblities??

  Hello all, I was wondering if there was anyway to use an "IF" statement inside an SQL SELECT statement. something like the following: SELECT somecolumn, SUM(something, something) AS Total, (IF Total <= 40 Then SUM(something, something) / 60 * somecolumn) AS Total2, SUM(0,0) AS GrandTotal Else SUM(something, something) / 60 * somecolumn) AS Total2, SUM((Total - 40) * somecolumn) AS GrandTotal End If) FROM someTable any idea how to accomplish something simular to this Thanks Louis, I am using SQL this time and the case statement looks like just what i need. im trying to return a column for regular hours worked (UP to 40) & a column for Overtime Hrs worked (40+) for ea ...Show All

• Corgalore Problem Authentication with reporting services.

  Hello everybody: I installed (settled) the example of authentification for reporting services supplied by Microsoft: http://msdn2.microsoft.com/fr-fr/library/ms160724.aspx For executed the example and after the recording of a new user, he(it) posts(shows) me in the same page this message: " Not valid Space of names” What is that somebody had the same problem Thank you very much. ...Show All

• Lorenzo Soncini9198 SQL Express Installation error (Error Number:29530 )

  Hi, I am trying to install "Microsoft SQL Server 2005 Express Edition" through VS2005 Setup but it is always failing to install. I am presenting here log file information.I appriciate if any one help me on this..I have marked all failed message with red color -------------------------------------------------------------------------------------------------------------------- Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Wed Dec 20 15:04:57 2006 Machine : DATLA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:\Program Fi ...Show All

• Thymen Fastest connection method?

  I am trying to find some info on the fastest connection transport for an app that is running on the same box as a SQL 2005 instance. The app does a large number of updates (high volume of data).. win32 using native ODBC. I am trying to find info on which connection mechanism is best... socket, pipes, etc. I read somewhere that there is a file mapped method available but i cannot find info on that either. Also, is there any performance difference between the old SQL OCBD drive and the new SQL Native Client OCBD drive Thanks. For best performance, I recommend you use the SQL Native Client ODBC driver with SQL 2005. I would also recommend you use TCP/IP as the transport. Regards, Uwa. Thanks f ...Show All

• KBV_RBJ Programmatically Data Conversion component creation

  Hi there, I have created a package which simply imports data from a flat file to a SQL Server table. But I need to incorporate a data conversion component by which I may change the source-destination column mapping programmatically. So what I thought that I need to add a data conversion component into the dataflow task. After adding this component (I found its component id as {C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C} ) I have created a path which establishes the mapping between output columns of source component and the input columns of data conversion component. Now I am not sure how to establish the mapping between the data conversion component’s input column collection and output column collection. I am giving my code snippet her ...Show All

• Mr. Howe xp_delete_file

  I created a maintenance plan to remove files older than 2 weeks. The plan executes successfully, but does not work. I notice in the log that the single quotes are doubled. I ran one command which worked, but others did not. Is there a problem with the command Here is a copy of the log: Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399 Report was generated on "SQL". Maintenance Plan: Clean Up Backup Files Duration: 00:00:12 Status: Succeeded. Details: Cleanup Master (SQL) Maintenance Cleanup on Local server connection Cleanup Database Backup files Age: Older than 2 Weeks Task start: 9/12/2006 7:34 AM. Task end: 9/12/2006 7:34 AM. Success Command:EXECUTE master.dbo.xp_delete_file 0,N''F:\SQLBackup\master'',N''ba ...Show All

• Jason Swalwell Problems with WMI Reader Task & WMI Connection

  Hi, I am using For Each container loop to read set of data in to variables and populating my WMI reader Task. WMI reader task uses WMI connection. I am assigning the Server Name for the WMI connnection during the run time of for each loop. Expression for WMI Connection is like that Expression ServerName @[User::WMIConnection] I have verified the my @[User::WMIConnection] variable has the proper server name like \\servername but it is not poulating the serverName filed of WMI connection. I also tried to assign the ServerName property using Script Task but DTS.Connection("conn") does not have the ServerName property. Please Guide Thanks Shafiq! It looks like ...Show All

• Kevin Dente how to implement unique key on multiple field

  hello guys, I have one table which is using to keep 10 difference type of serial number (that mean i got 10 column in the table).  Is there any way to do unique key checking (individually, not combine) on these 10 serial number without sacrify the performance thank you. Sure, i you wnt to check them only per column you can put a UNIQUE Constraint on those columns, that will check like the primary key for uniqueness. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All