Answer Questions

• Balaji Dave Incorrect syntax near 'HelloWorld'

  Hello, I'm testing a CLR SP in SQL Server 2005 using Visual Basic .NET Express The code is : Imports System.Data.SqlServer Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Imports System.Data.SqlClient Public Class SQLCLR    Public Shared Sub HelloWorld()        SqlContext.Pipe.Send("Hello World from SQLCLR !!")     E ...Show All

• Henrik Jensen parallel execution

  Hi I have 3 sources as Flat files and the destination is a single table. Is it possible for running a package so that it is executed parallelly. I mean , all the 3 files should run at the same time and load it into the destination table. If it is possible, please let me know how to do it Regards M Is it possible to make the MULTIFLATFILE connection load in parallel I have tried using one to load 4 csv file in ...Show All

• Michael Kariv SQL 2000 EM Prob. after 2005 install

  After installing SQL 2005 Dev. I get an error from SQL 2000 Enterprise Manager's MMC Console when I right-click on database properties for any database shown in the EM list, and EM freezes requiring me to close it and re-launch it. Should I re-install SQL 2000 along with Analysis and Reporting Services Thanks for any help. Re-register sqldmo.dll fom the SQL Server 2000 directory. Only one SQL DMO dll can ...Show All

• ryanflucas Cannot connect to "Reporting Services" using Microsoft Sql Server Management Studio.

  Hi, I installed latest SQL Server 2005 180 days trial version on my windows XP SP2 machine with the named instance "RS2005POC". I opened sql server management studio and selected Server Type = Reporting Services Server Name = localhost\RS2005POC Authentication = Windows Authentication. Connection failed with the following error message. Any help on this is much appreciated. Also I tried with "cjecw-h1708\RS2005POC" where cjecw-h1708(instead ...Show All

• daz.uk Dummy dimension for passing parameters

  Hi, I'm just having a little problem... I have a calculation, which is a non-trivial formula. This needs input from some dimensions (no problem with that...) and some information, which is independant from the data itself. The idea is to have something like a dimension but which is not connected to the data itself. You can't slice anything using it, it's just used to provide some input for the formula. Just imagine you have some amounts and y ...Show All

• Waiman Li Access is denied error on bulk insert using UNC filename

  I want to do a bulk insert of a file located on a different machine then the SQL Server database. machine1 and machine2 are running Windows Server 2003 Standard Edition. SQL Server v8.0 is running on machine2. Neither machine1 nor machine2 are in any domain. (These are servers at a hosting company.) I use a UNC filename to specify the file to load. It looks something like this: \\machine1.someplace.com\report ...Show All

• hyan Unabel to connect to SQL 2005 Analysis Services in SQL Management Studio

  I just installed visual studio 2005 and SQL sever 2005 standard edition. I experimented a bit, and I got the following messag when I want to connect to Analysis services in SQL Sever 2005 Management studio. When I click the connect button, I got the following message: " A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomnClient). No connection could be made because the target ...Show All

• AugustWind Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed ...Show All

• Jason McCullough DTS .... is it the best solution?

  Hi all, I am just about to install a new crm package with new database, the existing db has a customer, product table ect and i need to copy the infomation from one db to another. Not all the information will need to be moved just parts of each table. I am getting the software next week and will be setting it up on the test server first, i am not sure if it will be db installation on the existing server or i will install a new instance on ...Show All

• jonpfl No reporting services instance found on localhost

  hi.. i'm a newbie in ms reporting services. i'm having this problem to deploy the report. when i try to configure the report server using configuration tool, it says that "No report server were found on the specified machine Details : Invalid namespace" i installed ms rs 2005 enterprise ed and had chosen to instal everything. i've tried using rsconfig in command prompt and gotten this message: 'No Reporting Services instance found on localhost' ...Show All

• Dawn Wood Cannot figure out how to write this script?

  Hi was wondering if somebody could help on this one. I have a table called LocalisationText and a field called "ResourceText".After localization bad data went into the ResourceText field (double and triple quotes instead of singles). EG Entrada ""{0}"" en ubicacion """"{1}""""" 在或大 ""{0}"" 的命令出 User Post Code Group of Type ""{0}"" is ""{1}""  Now I have been asked to write a script that converts all the double/triple quotes preceding ...Show All

• ASHISH SAHI More Chart Palettes?

  is there a way to expand the out of box Chart Palettes It is very limited Check the following blog article with a sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx -- Robert ...Show All

• DontBotherMeWithSpam Quick way to Round all fields

  I am having to go through each of my fields in my table to edit and put Round() around them. Is there a quick way to do this instead of having to edit every textbox So you want to Round values in textboxes, not the field values coming from DB Then yes, you need to change expression in every textbox. You can round them in SQL query. select ROUND(col, ...) from t here is the syntax: http://msdn.microsoft.com/library/defaul ...Show All

• tinybunny_8 Concatenate text with expressions?

  Hello, I have a textbox and I want to concatenate my text with some value from the datasets, I have tried differente syntax but nothing De acuerdo con & Fields!NombreEvaluando.Value De acuerdo con & =Fields!NombreEvaluando.Value Thanks Try "De acuerdo con " & =Fields!NombreEvaluando.Value Stan Expressions start with "=". Use ="De acuerdo con " & Fields!Nombr ...Show All

• Cosmin Paun Installing SQL 2005 Express via InstallShield

  Is it possible to install SQL2005 Express via InstallShield Has anyone had any experience doing this Any suggestions or recommendations Thanks have a look at the following MSDN Article it might help.. Embedding SQL Server Express into Custom Applications Hi, Mike. When I tried to install SQL Express 2005 from command line in Win VISTA, and not specify any SQLAccount value, the installation fails, sayin ...Show All