Answer Questions

• Roggan Set default value on column object

  I am trying to set the default on a column object and it does not seem to be the same as SQL-DMO.  In SQL-DMO, I just set the DRIDefault.Text property and it was all good.  Now when I set the Default property I get an error creating the table telling me that getdate() is not a default.  At this point, I tried creating a Default object and setting the TextBody and TextHeader.  When I try to create the default it says there is ...Show All

• Mike Martin24365 How to sort that does not include duplicates in display?

  Hi everybody,    I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me I need to sort them and load them in a Datatable. Loop thorugh all records and display them in a label control created at run time. Thanks in advance. Sample Data: Topics Table TopicId  TopicLevel  Topic  ...Show All

• RabBsl Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva In SSIS you can handle errors one row at a time as Jamie describes. See http://msdn2.microsoft.com/en-us/library/ms141679.aspx What kind of errors do you expect to encounter Donald Here are BOL topics that might help http://msdn2.m ...Show All

• Gretchen Macdowall Annoyed with SQL Server 2005 Imponderables - Help!?

  Hello, upon our recent upgrade to SQL Server 2005, there are three issues that have plagued me that I cannot find a workaround for, despite much forum scouring. 1. I have a DTS package that I migrated to SSIS.  The migration seemed to go smoothly, and I can successfully run the SSIS package.  However, when I try to create an SSIS job from it, the job fails to run.  I merely get a "The step failed" error message.  I've ...Show All

• DRLaff VB.Net CF App falls over on SqlServerCe ExecuteNonQuery under WM5 but not PC2003

  I have a VB.net 2005 application that uses both System.Data.SqlClient and System.Data.SqlServerCe which has worked on PC2003 handhelds but falls over in Windows Mobile 5. It seems to be when I have used a SqlClient connection and then use ExecuteNonQuery on the local sdf file - the application just bombs out - no error message, nothing. Weirdly, if I am connected to a CE database through Query Analyzer 3.0 at the same time as running this ap ...Show All

• Wes1234 Login error

  I want to tranfer few objects from SQL server2000 to 2005. I used tranfer object task and defined the connection but i am getting the error cannot apply value null to property login:value cannot be null. How can i solve the problem/ from Sufian Search this forum. Plenty of people have had the same problem. -Jamie ...Show All

• thembi Is there any sample code which creates login and user of one database using SMO?

  Dear All Is there any sample code which creates login and user for database using SMO I cannot find any C# sample code can do this. Any help would be appreciated:) Hi, sorry the same day you posted the question I wrote quick application, I imported that in a q&d Winform solution, which might help you to see the way to do it: http://www.sqlserver2005.de/SharedFiles/UserMappingwithSMO.zip HTH; Jens Suessmeyer. --- http://w ...Show All

• Jurgen Devlieghere Cannot install AdventureWorksDW to make a tutorial.

  Hello!! I have a question about AdventureWorksDW. I try to make this SQL Server Business Intelligence Development Studio tutorial and I need to have AdventureWorksDW database. The problem is that it is not installed on my computer and when I try to install it once again from the CD I get the error message that it IS already installed on my computer. What should i do Thank you so much Yan! I downloaded ...Show All

• Soham Sign a document by SmartCard on the .NET client and verify on the SQL 2005 server

  Hi! I'm working on the following application: In the client application (written in C#) an user signs a document by private key, stored on chip card. Signed document and the signature are stored into database on SQL 2005 server. There is my client code for demonstration: Client application sample: System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Data Source=localhost;Initial Catalog=Tes ...Show All

• vivek.bhoj Killer problem with Scheduled Reports

  I'm running on SQL 2000 with SRS. Standard install ( I think, it was all set up by IT) I have reports that run fine in the Report Manager but when they are run through a schedule (email) some of them (albeit most) "rsProcessingAborted" because of a report error. Looking at the logs it seems generally based around comparison failure because of datatypes, eg (from the logs): Microsoft.ReportingServices.ReportProcessing.Rep ...Show All

• Dal **Dump thread - spid = 21, PSS = 0x0456C7B0, EC = 0x0456C7B8 (Location: "logmgr.cpp":5334)

  Hi All, I am suddenly getting error in SQL 2005 and database corruption. I just rebooted the server and when it came up, I had 3 DB's recovering (Still) and some pretty looking errors in the log file.   A summary of the error: **Dump thread - spid = 21, PSS = 0x0456C7B0, EC = 0x0456C7B8 2006-03-09 10:06:10.89 spid21s     ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQ ...Show All

• Zee83 Using SMO and ClickOnce deployment

  Hi, I'm writing an app that I want to use ClickOnce deployment with. The app may have to ask the user for the Server and Database name to connect to if it is the first time it has been run. I'm thinking of using Sql SMO but I see the requirements for this include MDAC 9.0. Can anyone tell me how this could affect a clickonce deployed app I'm no export with clickonce, sorry. I'm hopeing it is possible to deploy MDAC 9.0 via clickonce too. Any hel ...Show All

• guilhermecvm Repeat Report Title On EveryPage

  Dear Anyone,   All reports have report titles especially in RS. These are usually big textboxes that can be found in the beginning of the report. When a report is executed, normally, these report titles, dissapear once we opted to go to another page of the report. Is there a way to make the report titles repeat on each page Thanks, Joseph Ollero I read in another thread that it was not possible in RB. dlesko ...Show All

• Glenn N. RS2005 breaks my build: Version 2.0 is not a compatible version

  Hi, We've developed a RS DataExtension on RS2000, including a reference to Microsoft.ReportingServices.Interfaces.dll. Since I have installed RS 2005 on my machine, (we actually saw this issue first on our build server) the project no longer compiles. We get this error: fatal error CS0009: Metadata file 'c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.ReportingServices.Interfaces.dll' could not be opened -- 'Version 2.0 i ...Show All

• Vishal Chopra Will IP Change cause problems?

  The IT department at my company is doing work in our server room and is planning on a few changes, among them changing the IP addresses of our servers. Will this cause any problems with SQL Reporting Services or our existing reports aloha, Jdolier This depends on how the connection strings for your data sources are set up. If you reference the server by name and the names are staying the same, then there will ...Show All