Answer Questions

• Sai Kakarlamudi Help Complete This CLR Code?

  Using the tutorial at: http://msdn2.microsoft.com/en-us/library/ms131094.aspx I've determined that the code I need to follow is: Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Imports System.Data.SqlClient 'The Partial modifier is only required on one class definition per project. Partial Public Class StoredProcedures ''' <summary> ''' Create a resu ...Show All

• Deva_m SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• t7200 Is there such a thing as Data-Driven Snapshots?

  Dear Anyone, Is there such a thing as Data-Driven Snapshots Snapshots generated based on different parameters. Thanks, Joseph Hey Joseph -- No such animal :) Your best bet is to create a series of linked reports, changing the various parameters along the way. Then, create your snapshots off of the linked reports...A bit labor intensive, I know, but it will get you what you want! I replied to your other po ...Show All

• Mistweaver Cannot Connect to Server

  Hi everyone, Kindly assist me to resolve this error: TITLE: Connect to Server ------------------------------ Cannot connect to DERRY. ------------------------------ ADDITIONAL INFORMATION: [C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specifie ...Show All

• dcboy Modify RDL generated by ReportBuilder for user defined filters

  I want to grant administrator access rights to create reports using report builder.  But I also want normal users to be able to filter the data in the report before viewing the report.  Is that possible   The CommandText of the rdl report generated by reportbuilder isn't a simple t-sql query.  Instead it looks like the SemanticQuery object for Model Design.  How can I dynamically modify the rdl and add filters   Inp ...Show All

• NaiduKANAKALA Unable to uninstall SQL Server Express 2005 Tools

  I get an error message when trying to uninstall the SQL Server Express 2005 Tools.  It reports, The setup has encountered an unexpected exception in datastore.  The action is Write_CommitFlag.  The error is: Unable to write property into cache: flagCommit. XmlRW Error: Failure loading XmlRW.dll CheckAllProcedures() It is currently preventing me from installing the full Sept CPT because it needs to have the express compo ...Show All

• makoto117 Merge Replication Using RMO

  i have done web synchronisation using RMO, where replication is happening on both ends, i want to perform one way synchronisation where a sales guy wants to update only his details to the server , and not to update the data from the server, can anybody help me on this task , the code for synchronisation i have taken out from msdn for Merge Replication using RMO programming .. Thanks -ExchangeType is not supported for Web ...Show All

• Sanjit Sachan Cannot Load SQLSpars.dll

  Hello, I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one: Setup Failed: Could not load SQLSpars.dll Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displa ...Show All

• pbjorge12 ForceExecutionResult is ignored by parent

  1 Add a Sequence Container. 2 Add a Script Task to the contianer, and set the script to fail, Dts.TaskResult = Dts.Results.Failure 3 Set the ForceExecutionResult on the Script to Success. 4 Execute the package. The container fails, so it detects the Dts.Results.Failure, and ignores ForceExecutionResult. The task itself is Green, so that indicates success. I think this is wrong, as ForceExecutionResult should be observed by both the task and pare ...Show All

• Jan van Wyk Foreign Keys - Truncate Table

  Hi, if you use foreign keys with tables you can't use truncate table anymore... Is this right in all cases I need foreign keys only for "illustration", so that database diagrams can be build and other tools find out about links between tables. I need no contstraints at all. On the other hand I'm dealing with quite a bunch of data and I have to clear up big tables, so using truncate table would speed up my work significantly... Is ...Show All

• Babba72 ReportBuilder & FQDN

  Anyone run into this ReportBuilder fails to load when using a FQDN (fully qualified domain name) URL. ie: http://servername.xyz.company.com/Reports/Pages/Folder.aspx ReportBuilder loads with no issue when using the shortname URL. ie: http://servername/Reports/Pages/Folder.aspx details: ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://servername.xyz.company ...Show All

• Keph Recursive CTE performance concerns

  I've done a very, very , simple recursive CTE and I'm quite surprised by the differences in performances between the CTE and straight hard-coded selects. In this sample, the CTE is more than 10 times slower in a 10000 loop. I would have expected it to be a little bit slower, but not that much. Can anyone tell me if the performance of recursive CTE will improve before the release ships I'm using BETA 2. Please note that the ...Show All

• EdMellor OLEDB error while trying to import MDB data into SQL 2005

  Hello, I am getting an error while trying to import data into SQL 2005 from an existing Access MDB database. When I try this on another workstation there are no problems and the data is imported successfully. Could someone tell me what to look for or what setting I have incorrect. On the workstation with the problem I had removed SQL 2000 Personal Edition and installed SQL 2005 Standard Edition. Also, I have both Visual 2003 and 2005 i ...Show All

• ianemv Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path

  Hi, I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a ...Show All

• Sebastien Binet DM Windows Forms Controls in November Feature Pack for SS2005

  Hello, There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much). Here is the descriptio ...Show All