Answer Questions

• Xi0N Cannot access Stored Procedure

  Hi I'm using SQL 2005 with Management Studio. I started having trouble accessing one particular scalar function today. I am able to run alter, drop and even exec commands against it but when I try to generate a script for it (or Modify it using Management Studio) I get the following exception: Syntax error in TextHeader of UserDefinedFunction 'sp_name'. (Microsoft.SqlServer.Smo) at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckTextCorectness(String ddlText, Boolean enforceCreate, Boolean checkName, String[] expectedObjectTypes, DdlTextParserHeaderInfo& headerInfo) at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckAndManipulateText(String ddlText, String[] expectedObjectTypes, ScriptingOptions so, Boolea ...Show All

• KitGreen How to deploy a Package?

  Hallo I created my first Package and i am not able to deploy it in my SQL server. I created a Development Utility and in the OutputPath i got a *.dtsx and a *.SSISDevelopmentManifest file. When i run the packaage (*.dtsx) it works but when i try to install the package with *.SSISDevelopmentManifest it just genereates a folder in the selected Folder (...\Microsoft SQL Server\90\DTS\Packages\) and no more. What am i missing You mean, to schedule it You could use SQL Server Agent for that. All the "Deployment" does is copy the *.dtsx files to the file system or MSDB on the target SQL server. You apparently selected "file system". It did exactly what it was suppose do. Now ...Show All

• Roto Creating referential integrity constraints

  Two ways to do this... Creating the constraints when creating the data model OR using SQL to use the 'reference' constraint. Does 2005 provide any other automated method of creating the Primary Key - to Foreign key constraints without writing the SQL to do this Thx The books I've been reading say that you shouldn't include computed columns in a table because of the extra space they take up, but instead, create a view where the computations take place. That was what I was referring to. Kat Thank you for your answer, I didn't know that the GUI would do the things that you described.  That was what I was referring to.  I guess for me, the automated method would be that when you create a primary key, the create t ...Show All

• enam butt Can You Use Variable Column Names in an Update Statement

  I'm Creating a Table named Forecast with variable column names from month to month... This month Column 13 might be November; next month Column 13 would be December... After building the table, I need to Update the column's value (to start) to zero.... I would like to use " UPDATE Forecast SET @MonthName = 0; --- But, of course it doesn't work.... Anyone's help would be greatly appreciated. DECLARE @MonthName NVARCHAR ( 20 ) DECLARE @MyCounter INT SET @MyCounter = 12 USE Solaar ; WHILE @MyCounter < 24 BEGIN SELECT @MonthName = c . name FROM sys.columns AS c JOIN sys.types AS t ON c . user_type_id = t . user_type_id WHERE c . object_id = OBJECT_ID ( 'DBO.Forecast' ) AND c . col ...Show All

• JeZteRicp performance impact of aliasing

  hi, is there a way to reduce the performance overhead of calculations - thin about physical measure "XYZ original" and i create a caculated member called "XYZ" by the following definiton CREATE MEMBER CURRENTCUBE .[MEASURES].[XYZ] AS [Measures].[XYZ original], FORMAT_STRING = "#" , NON_EMPTY_BEHAVIOR = { [XYZ original] }, VISIBLE = 1 I would expect the same performance, but its 15 - 25% slower on my sample querie ( select {measures.[XYZ]} on columns , [Dimension].[Hierarchie]. members on rows from Cube ) returning 25000 cells. Does someone know ways to imporve this querie reduce the overhead of this really simple calculation (alias for the m ...Show All

• nate-d-o-double-g Wrong connection when switching computer

  Hi My C# application has a DataGridView which is bound to a DataSet. I used Visual Studio to add/configure the data source. Everything works fine on my computer. When I try to run the application on another computer I can't connect to the database, because it uses a wrong connection string. How can I make a specific connection/connection string permanent for a specific application Thanks. What do you mean with wrong connection string is the connection string pointing to the local computer and you always want to reference the local computer Then you might fix your problem by using the (local) keyword rather than the machinename for refering the Server in the connection string. Connection strings ...Show All

• VinceExtense Do not have instance of SQL Express 2005 installed

  I am attempting to install SQL Express 2005 on a laptop that already has MS Sql Server installed. I downloaded the SQLEXPR_TOOLKIT.EXE from Microsoft's website and let it go through its installation routine accepting all the default answers. When I open SQL Server Management Studio Express, I can only connect to the SQL 2000 instance. I have issued the 'SELECT @@VERSION' command, and When I try to connect to the instance COMPUTERNAME\SQLEXPRESS, the following error message is displayed: Cannot connect to YOUR-F8A010A9D0\SQLEXPRESS. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my be caused by the fact that under the default settings SQL Server does not allow remote con ...Show All

• Melt16 How to filter Profiler trace by dbid in 2005?

  Is there any way to filter a SQL Profiler trace by dbid This was a feature of earlier versions, but I can't figure it out in 2005. Thanks! Yep... it's a little tricky because it's not shown by default. Steps: 1) Create a new trace. 2) Click the Events Selection tab. 3) Check the box Show All Columns . 4) Click the Column Filters... button. 5) Choose DatabaseID from the listbox on the left. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Hi there. From the Profiler GUI, create a new trace, move to the Events Selection tab, click the Show all Columns check box (this is important, as the filters box will only show columns that ...Show All

• Rashar Launching DTA via "analyze in DTA" context option in SQL Editor failing

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to connect to an IPC Port: The system cannot find the file specified. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ 32bit/x86 standard edtion, build 2047 (sp1) Thanks Alexander for the details. The error seems to be different from the one I was referring to. Can you please check the following: - does the problem repro every time or only occasionally - does the problem go away if you launch an instance of DTA between steps 3 and 4 of your repro Thanks, Could someone provide more details on steps that lead to the error We've ...Show All

• Armela Reporting Services Soap API Internal Parameter

  Using the web service how do i tell if a report parameter is internal, or hidden A hidden parameter has a PromptUser value of true, but the Prompt is empty. An internal parameter has the PromptUser set to false. ...Show All

• Lj47 Help With filtering

  I have a table with the following columns ID, Dealershiplocation, VehicalMake, VColor, Vtype and VYear. 1, London, Buick, Red, sedan, 2001 ------ 20, Windsor, Ford, Blue, pickup, 2004 My question is how do I write a query so I can filter from all dealership location a specific vehical like Ford with a red color and Sedan type Please help. Thanks Juvan Dear Andrea, Thanks so much. I have no problem now, thanks for your help. Thanks again. Juvan hi Juvan, your model is not that normalized, but... you can define your filter wtih a set of consecutive AND that must be all satisfied like SET NOCOUNT ON; USE tempdb; GO CREATE ...Show All

• rayms changing database owner to access diagrams

  hello, i recently changed the machine name of my development computer and am now no longer able to create or view any diagrams for the sql database that was created by the old machine name user. i receive an error where I cannot make myself "the dbo of this database." i can see the old name in the "owner" properties field of the mdf database, but the box is grayed out and i am unable to change it to the new machine/user name. is there a way to change the owner of the database to my new machine/user name the new name has admin rights and the computer is a standalone workstation not connected to a network. i am using sql server 2005 express edition with visual web developer. thanks! ...Show All

• JUANCARLOSR Combining multiple subreports into a single report

  The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report that contains them defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over producing blank pages. Are there any work-arounds to concatenate multiple, single report PDFs into a single PDF and have page numbering too Thanks! Hi, The mechanism that we've used to achieve this is to write some code using a PDF library to combine the reports. It goes off and renders the reports and then adds them to a master document. That way we can add page numbers, table of ...Show All

• Chandresh SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• bimalr1 Problems after installing SP2

  I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1). When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog: Errors in the OLAP storage engine: The linked measure group with the ID of 'Sales', Name of 'Sales' cannot be processed because it contains MG dimension with the ID of 'Time', Name of 'Time' with different granularity attribute than its source object. Errors in the metadata manager. An error occurred when loading the Sales measure group, from the file, '\\ \C:\Pro ...Show All