Answer Questions

• TJ_1 How to access to an another database?

  Hello, I 'm making a procedure that needs to use a table that is in an other database and that database is in an other SQL Server Group. Did you know if is it possible. How can I make this Thank you very much for your help and time. Jonathan. Thank you very much, Nithin Khurana!!!! Jonathan yes u can do this...add the other server as a linked server to ur server..using sp_addlinkedserver... then refer the table in other db as servername.dbname.dbo.tablename eg. select * from server1.mydb.dbo.table1 ...Show All

• Horst Klein Exotic Unpivot Transformation

  I totally give up. I need to import an csv file with system monitor performance counters into a sql server 2005 database example csv format: "(PDH-CSV 4.0) (W. Europe Daylight Time)(-120)"," Server1 \Memory\% Commited Bytes In Use", )"," Server2 \Memory\%Commited Bytes In Use" "07/18/2006 10:08:57.295","24.701095057336488","30.701095077776488" and I want it to transform it into: Time ServerName Memory\% Commited Bytes In Use 07/18/2006 10:08:57.295 Server1 24.701095057336488 07/18/2006 10:08:57.295 Server2 30.701095077776488 I have two problems: I need to trim the servername from the column values I need to insert an extra column ServerName and put those server names in it I ...Show All

• veXed Key Maintenance and Stored Procedures

  Basically I would like to ask whether parameters can be used to pass the value of the 'symmetric key id', 'certificate' and optionally 'password' to a stored procedure that uses encryption functions. The reason this is appealing is that when encryption keys etc change over time (we have a requirement to decrypt data, destroy and create new keys, then encrypt data every time we lose a staff - don't ask), as we would be passing the value of keys, passwords and certificates as parameters to a standard stored procedure. Hardcoded Example (Working) USE PSS GO CREATE PROC insert_payer_ba -- define parameters @param_rec_id NVARCHAR ( MAX ), @param_bsb NVARCHAR ( MAX ), @param_account NVARCHAR ( MAX ), ...Show All

• Diango SSIS interview questions.

  Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions. Thanks Chris Honcoop wrote: In re: to your original question... Do you know SSIS well yourself I've seen some questions on web pages for SSIS (maybe even some posted by Jamie) that focused on some specifics that maybe you can ask in a phone screen but they will not really get to the heart if the person applying is a good SSIS developer. If you know SSIS yourself I would make up some situations and ask the person applying for the job to give an outline etc of how they would design a package to overcome the problem. On the basic level you can tell right away if they ...Show All

• Lucas Pasquali Forcing Function recompilation in SQL 2000

  A stored procedure in the cache is automatically recompiled when a table it refers to has a table structure change. User defined functions are not. Here's a simplified code sample: set nocount on go create table tmpTest (a int, b int, c int) insert into tmpTest (a, b, c) values (1, 2, 3) insert into tmpTest (a, b, c) values (2, 3, 4) go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fTest]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[fTest] GO CREATE FUNCTION dbo.fTest (@a int) RETURNS TABLE AS RETURN (SELECT * from tmpTest where a = @a) GO select * from fTest(1) CREATE TABLE dbo.Tmp_tmpTest ( a int NULL, b int NULL, d int NULL, c int NULL ) ON [PRIMARY] IF EXISTS(SELECT * FROM dbo. ...Show All

• Vitaliy Kochubiy It's possible to call a view from a different SQL Server?

  dear friends, It's possible to call a view from a different SQL Server I need to create a connection inside one view from the first server to call the second server... Thanks hi, did you try this : SELECT T2 . Netbios_Name0 , T1 . Manufacturer0 , T1 . Model0 , T4 . SerialNumber0 , T3 . TotalPhysicalMemory0 , T2 . User_Name0 FROM [GCXNCLISM1S301 . SMS_B02] .[ dbo] .[ v_GS_COMPUTER_SYSTEM] T1 INNER JOIN [GCXNCLISM1S301 . SMS_B02] .[ dbo] .[ v_R_System] T2 ON T1 . ResourceID = T2 . ResourceID INNER JOIN [GCXNCLISM1S301 . SMS_B02] .[ dbo] .[ v_GS_X86_PC_MEMORY] T3 ON T2 . ResourceID = T3 . ResourceID INNER JOIN [GCXNCLISM1S301 . SMS_B02] .[ dbo] .[ v_GS_PC_BIOS] T4 ON T2 . Res ...Show All

• fgarzonhz CLR Function - Invalid character in the given encoding

  Hello! I wrote a CLR function, which is receiving some XML parameters. In certein situations it gives me the following error message: Msg 6522, Level 16, State 1, Line 58 A .NET Framework error occurred during execution of user-defined routine or aggregate "svmScale": System.Xml.XmlException: Invalid character in the given encoding. Line 1, position 27. System.Xml.XmlException: at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String arg) at System.Xml.XmlTextReaderImpl.InvalidCharRecovery(Int32& bytesCount, Int32& charsCount) at System.Xml.XmlTextReaderImpl.GetChars(Int32 maxCharsCount) at System.Xml.XmlTextReaderImpl.ReadData() at System.Xml.XmlTextReaderImpl ...Show All

• Will Buchanan Interative sort for same report different parameter value on same web page

  We have a report being used 3 times on same web page, with different parameter values e.g. report1.rdl has two parameter i.e. type and orderdate. Type value used are the same for all three report but, there's the difference: First report uses orderdate=thisweek, second report uses orderdate = lastweek and third report orderdate = twoweeksago. The report uses interactive sort on all columns. When the web page first loaded, everything seems fine i.e. 3 reports with three different sets of results. But when user click on any of the sort arrows on first or second report, the result will be sorted on that column but the records returned were those of third and last report (in this case - twoweeksago). When the report is run on report manager us ...Show All

• Covi Mapping of an xml column to variable

  I have a For Each Loop that iterates over a recordset stored in a variable. One of the columns in the recordset is type xml and I want to map it to a variable using Variable Mappings of the For Each Loop container. I am getting this error: Error: 0xC001C012 at FELC Loop thru report defs: ForEach Variable Mapping number 4 to variable "User::Parameters_xml" cannot be applied. I have tried changing the type of the Parameters_xml variable to Object and String, but I get the same error. Any ideas you can try using a script task instead. I tried casting the xml-typed column to varchar(8000) and then it worked. ...Show All

• JPC16 Running Report gives error "root element missing"....

  I have some users building a report in ReportBuilder through SSRS web service. When they run the report they are getting the error "root element missing". Anyone know what this means I'm getting that too when I create a new fields that contains NOW() or TODAY().  Just creating a field that is equal to either will cause the error message.  Can anyone help with this issue ...Show All

• AlanKohl MDX Set Expression Converts to Constants (and I don't want this to happen)

  First, I should mention this problem is occuring in Proclarity 6.1 with an underlying SSAS 2005 cube. We want a rolling 12 month window displayed in our chart. I have written: SELECT { Tail(Filter([Time].[Month].Members,Not IsEmpty(Time.CurrentMember)),12)} ON COLUMNS , Which works just fine when I enter it. But when the Proclarity book is altered in anyway (say, by changing from one measure to another), this MDX expression is converted ("instantiated" is that the right word ) to constants: SELECT { [Time].[All Time].[2005].[Quarter 3].[August], [Time].[All Time].[2005].[Quarter 3].[September], [Time].[All Time].[2005].[Quarter 4].[October], [Time].[All Time].[2005].[Quarter 4].[November], [Tim ...Show All

• Mar_GP DTS import stores the last {LF} in Table.

  Hi i have a csv file where the last column usually happens to be null. So my file is like this: 1,2,3,,{LF} 4,5,6,,{LF} 7,8,9,,{LF} {CR} I run the dts export from csv file to db and it doesnt save the last row (column5) in the table us null. instead it stores the {LF} character. Ascii =10. How can i resove this problem. the csv comes from a third party application. the DTS needs to un automatically and somehow resolve that last problem on its own. but how is there a code that can trim the last character in the last line to delete the last {LF} or some query in DTS that can achive this..... 16896,"Optioned",25510,65,0,,,,20060920,25510,FALSE, 16897,"Optioned",25510,65,0,,,,20060920,2 ...Show All

• jlviera Accessing cubes parallely from 2 clients

  Hello, When 2 logins try to access a cube(in MSAS 2000), we are getting the following error message, "This database is locked. User (....) on computer (....) has locked (....). Description : Cube edotir has locked cube (....) for writting." Is there anyway we can access a cube simultaneously from 2 client machines (read only type of access) Thanks in advance.... Revin Hi Revin, Is the Analysis Manager open and modifying the cube structure at the same time. If so, close the Analysis Manager and try again. It will place a lock on the repository file and will not allow other connections. If this doesn't work then stop and start the Analysis Server to free up any locks tha ...Show All

• woeter Custom Data Flow Task throwing error when run from command prompt

  Hi, I developed a custom data flow task in .net 2.0 using Visual Studio 2005. I installed it into GAC using GACUTIL and also copied it into the pipeline directory. This task runs absolutely fine when I run it on my local machine both in BIDS and using the script in windows 2000 environment. However, when I deployed this package into a windows 2003 server, the package fails at the custom task level. I checked the GAC in windows\assembly directory and it is present. Also I copied the file into the PipeLine directory and verified that I copied it into the correct pipeline directory by checking the registry. The version of the assembly is still Debug. I looked up documentation in MSDN but there is very little information about the error ...Show All

• Cyberjunkie Custom Assembly Problem

  I am trying to use my own custom assembly in my SQL Server 2005 report. I have coded and compiled the following code to produce the ReportLibrary.dll: Imports System.Data Imports System.Security Public Class myClass Public Function myFunc() As Integer Dim value As Integer = 0 Dim permission As New SqlClient.SqlClientPermission(Permissions.PermissionState.Unrestricted) Dim myCommand As New System.Data.SqlClient.SqlCommand() Dim conn As New System.Data.SqlClient.SqlConnection( "MY CONNECTION STRING”) myCommand.Connection = conn myCommand.CommandText = "MY SELECT STATEMENT" Try permission.Assert() ...Show All