Answer Questions

• Marek21 semicolon terminator

  Can someone define for me what is a statement when it comes to having to use semicolon statement terminator This is absolutely undocumented in BOL. Googling only finds this incoherent article which is far from official documentation. TIA Hi Carl. Just for clarification, the ; statement teminator isn't new to SQL 2005...it's part of the SQL-92 standard, and has been an optional statement terminator for ...Show All

• Zane Kelly Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare ...Show All

• Herwin Grauel Need more info on integrated reporting controls

  I am looking for more detail on these "integrated reporting controls" mentioned below (from http://www.microsoft.com/sql/2005/productinfo/top30features.asp#B ): "With SQL Server 2005, Reporting Services will provide report controls that will be shipped with Visual Studio 2005. Integrated reporting controls will provide improved reporting capabilities for enterprise applications". Specifically, I am looking for more detail on these new ASP.NET 20 ...Show All

• mesanjeeb Are double byte characters supported in Report Builder?

  Dear Anyone, Are double byte characters supported in Report Builder I've done this with Reporting Services but I cant make it work with report builder even if I use Arial Unicode as the font. Any ideas anyone Thanks, Joseph Will you attach a screenshot or include some sample text values in your report that are not displaying properly All Unicode sequences should work correctly in Report Builder. Can you provide a specific example o ...Show All

• shax removing replication table

  Hi all, Can Enterprise Manager remove a table from replicating to another server I've tried looking at the article tab of the property of the publication but couldn't find a way to delete a table from the article. Any idea Thanks! Sachin, Me too. Step 5 should have been "dropped the database" instead of table. Best Regards~ Don Many thanks for the info! ...Show All

• BJohnson SQL Server Management Studio Express CTP?

  Ive succesfully installed the final versions of VWD Express and SQL Server Express and SQL Server Management Studio Express CTP. Everyhting is working fine except the SQL Server Management Studio Express, when i click on it in the start menu nothing happens at all, ive tried uninstalling, repairing etc but it still never starts up when its clicked on. Any ideas please The problem with the SQL Express BOL is t ...Show All

• pluto2005 Problem: Can dhcp callout dll insert new row into dsn database?

  I current working on this dll, but i found the dll doesn't response to any of the cdatabase execute response I have try all the cdatabase and sql in c++ console and found that it can be run. The database is open success and the sql statement is correct. After then i put it into the dhcp callout dll, and compile success. When i add it into the registry and try the dhcp server, it doesn't have any response database table. And i using ...Show All

• Sean K. Campbell How to add columns dynamically based on number of groups used.

  Hi,    I am pretty new to the Microsoft Reporting services. I wanted to know if this is possible to design in the reporting server. I have a requirement to take the number of groups in my report as input. So if there are two groups I will have two columns and if I have three groups I will have three colums. Is there any way I can dynamically set the number of columns based on the input. Currently I am having to design different report ...Show All

• Cal Zant 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 You should see an .rdl.data along with the .rd file after previewing the report. This entry in Russell Christopher's blog explains how others can use this file: http://blogs.msdn.com/bimusings/archive/2005/06/22/431489.aspx >> How to preview a report without direct access to its data source in SQL Server Reportin ...Show All

• CBueche Exporting XML using bcp

  I am exporting XML query results from a stored procedure using bcp. The query is pulling data from several tables and create XML using FOR XML EXPLICIT. The following is the bcp command used to export the result: bcp "exec sprocname" queryout output.xml -w -T The resulting output file appears to limit the number of charcters per line to 2033 characters and cut the data into the next row regardless whether the 2033th charact ...Show All

• Naga2k2 Interface with Report Builder

  Is there a way to interface with report builder to get the name and path of the report from reportserver database and insert into application database, when the user saves a new report. Also is there a way of displaying the list of available reports from report server in application without using reports manager or report server web page. ...Show All

• allez How can we write C# code in sql.

  Hello Anybody knows how to write c# in SQL All responses appreciated. thanks. hello thank u, i got what i wanted. regards There are many examples out there, one of them is http://www.codeproject.com/dotnet/CLR_in_Sql_Server_2005.asp . But anyway if you google for word like clr or c# in combonation with SQL Server 2005 you will find some good examples out there, depending of what you want to do (tr ...Show All

• zseven How to avoid HTTP 401 error with ASP 2.0 ReportViewer 2005 Std and two servers?

  I’m completely lost with some security issues and have no idea how to solve it.   My scenario is as follows:   Developer PC: WinXP SP2, IIS 5.1, VS 2005 Pro, SQL Server 2005 Client (Mgm.Studio etc.) Server: W2K3 RC2, SQL Server 2005 Standard, Reporting Services activated   Both systems are running in the same domain.   I have built an ASP.net 2.0 website with forms authentication that is using ...Show All

• Cuzzlor Problem with SQL Server 2000 DTS Package:Column Delimiter not found

  I am trying to import data from a text file to SQL database through a DTS package. i am always getting "Column Delmimeter not found" error at record number 8000. i copied the 8000th record into the beginning of the file to test if there is any problem with data but still i got the error at 8000 th record. i know it was a problem before and was fixed with sp1. i installed SP4 and still gettting the same error. any help on this is appreciated. Tha ...Show All

• Ishtiaque Hussain Database Mail

  I am trying to configure Database Mail on a new installation of SQL Server 2005 and the 'DatabaseMailUserRole' does not exist. How do I add this role to the server I am having similar problems - I just added the (missing) DatabaseMailUserRole using the example provided. Now I am trying to execute the code in the 'troubleshooting' box sp_addrolemember @rolename = "DatabaseMailUserRole', @me ...Show All