Only Title

Answer Questions

• Rashmiaa VSS6 and SQL Server Management Studio

  I'm trying to get our older VSS 6 to work in a new project on Microsoft SQL Server Management Studio. In our current VSS - we have a folder named: DATABASE and subfolders named as SP, Views, UDF, and so on. I beleive I'm supposed to create a project and point it to the DATABASE folder location in VSS. On my local drive I have it mapped as d:\DATABASE\ However; I'm having trouble figuring out how to add the existing sub-folders that are ...Show All

• yavvie Custom code assembly with config file

  Hi! My report has a reference to an assembly of a class library I did. This class library has a config file, classLibrary.dll.config, where I set some parameters, one of these being the "initial path" to the project's folder(for example, project folder is myProject, and you would use the initial path to say it's in c:/projects/tests). When I preview the report everything works fine, but when I publish it I get this error: Abso ...Show All

• Anoop_Abraham Unable to retrieve Column information when using Ole Db Provider for sybase

  Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data ...Show All

• Calvin Thomas Working with fields already added to report

  In my SSRS 2005 Report I have 5 calculation fields added to my table Group and they are: =IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) (the Label is Field1) =IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) (the Label is Field2) =IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0)  (the Label is Field3) =IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, 0)  (the Label is Field4) =Fields!FeeGoal_AZ.Value \ Fields!FeeSche ...Show All

• Ian Huff can't modify stored proc which is in a publication

  Hi SQL 2005 sp1 - merge replication - HTTPS. We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic and another with SyncType = SubscriptionSyncType.None. The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data. When we try to modify a proc which is in the publication with SyncType = Automatic, the query never ...Show All

• ananasgroup Different Execution Plans -> Same Query, Same Database, Different SQL Server Install

  Background:  Same database, restored from development to production. Indexes up to date.  Service Pack 3 on Production.  Originally RTM on Development, upgraded to Sp4, Execution Plan remained the same. The query itself is not my concern, but that there is such a wide difference in performance between 2 boxes.  Is there a setting on the Production that might be slowing it down   My system seems to have selected ...Show All

• ahsankhan Read-Only Cell

  Hi, When I create a new xml column using SQL server 2005 the column by default is set to "read-only cell". I've looked around at the properties and don't see anything to change this behavior. Anyone know what I need to do so that I can write to this cell useing the SQL browser. I'm able to update the cell programatically, BTW. Any help greatly appriciated. - Pardner test, plz ignore wrote in ...Show All

• Brendan Egan .NET 64-bit and .NET 32-bit Framework on a Win 2003 server x64: which aspnet_regsql wizard is recommended?

  Hi everybody, I installed on an Win 2003 server x64 .NET 64-bit framework (beta 2.0.50215). After that I installed VS2005 beta 2 (2.0.50215) and SQL2005 (VS 2005 Beta Experience Kit). No problem are visible. Two .NET frameworks are installed, ...\Microsoft.NET\Framework\v20.0.50215 and ...\Microsoft.NET\Framework64\v20.0.50215. What aspnet_regsql wizard is recommended to use to configure a SQL Server database that stores information for ASP.NET ...Show All

• rajkumar sharma SQL workgroup / domain authentication

  In the following scenario, I am getting the message 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'. I am running a Windows Server 2003 with development environment and Sql Server Management Studio in a workgroup on a virtual PC. My SQL Server 2000 is running on a domain server. On the virtual Pc I have setup my user login and password to be the same as my domain login and password. Why is t ...Show All

• mojgan behrooz Secure Social Security number in my DataBase

  Hi, i have a data base in SQL 2005 and i it has many tables with confidencial information Like Social Security numbers, Credit card Numbers, etc. And i would like to encrypt this information or make something to make this info invisible to any hacker, or any person that logs on the server. Here are the limitations: 1 - I cant make any changes in the front end, so if i encrypt the data, I have to make all the modifications in the dat ...Show All

• CrazyHakiko SUM is summing like values

  The problem with my SUM below is that I don't want it to sum up like amounts.  For example, there may be multiple rmstranamt showing but if in the list there are 2 that are alike, just sum up one of them along with the others.  In other words, I need to somehow do a grouping of the rmstranamt so that I'm not summing up one unique number twice in my SUM. Example output. Lets say my query finds 3 rmstranamt records for a particular accou ...Show All

• Hagen O. SSIS Inport Wizard does not import dates...is this a bug?

  I have an Excel file with 52000 records. One of the columns is a date column d-mmm-yy. This column is NULL-able. Approximately 12,000 records have a value on this column. I started the wizard, and it happens to be that the first record containing a date on this column is record 11,012. However, the wizar imports NONE of the values, and the column shows NULL in all records. Now, if I sort first the data in the Excel spreadsheet so that ...Show All

• almir VSA and ConnectionManager - AcquireConnection

  Hi all In a SSIS Package I have defined a ConnectionManager to a SQL Server 2005. Now I am trying to query data in a Visual Studio for Application Script. I tried the following: Dim local_SQLConnectionManager As Microsoft.SqlServer.Dts.Runtime.ConnectionManager Dim local_SQLConnection As New System.Data.SqlClient.SqlConnection Dim local_SQLDataReader As System.Data.SqlClient.SqlDataReader Dim local_SQLCommand As New Syst ...Show All

• BasharSS Save Report .rdl including Data

  Where is the option in SSRS 2005 to save a report .rdl with data so I can send it to others for troubleshooting I have a problem with his technique. I have several datasets in my report and so when I go through his steps, my datasets are still trying to reference stored procs and my preview errors out. What do I do in this situation http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/0d2569d2e55e392e > ...Show All

• AnewMember Catch Error message in Variable?

  Greetings all, When an error occurs it is written to a log file (Assuming you have loggin on). Anyone know of a way to catch the error in a variable When an error occurs I send an email explaining where there error happened and to view the logfile. I would like to include the last error in the email. Saves having to go view the log... Thanks Hi Jamie/Crispin, Thanks for your comments. I missed the point that u said. As Crispin tol ...Show All