Answer Questions

• jan3784 How to create a relationship?

  How do I create a relationship between two tables when the two columns that should connect each table have different names i.e. Table Person Column Name < -- > Table Employee Column Person Name The two columns actually contain the same data type but different field name and size. I know this involves a series of steps. What are they Could you please include some sample code. Hi, The basic requirements for establishing relationship(s) among tables is to set a logical DB design and then identify the objects: Tables and their names (ENTITIES) Column names (ATTRIBUTES) for each table. In your example we have the Entities as :Person,Employee ; Attributes for Person: ...Show All

• Dominik Chrzanowski Is Keberos authentication required while installing SQL Server 2005 cluster?

  Hi All, Can any Microsoft guy confirm whether keberos authentication reqiurred while installing SQL Server 2005 cluster instance Thanks in advance ...Show All

• Sevugan Error: 14151, Severity: 18, State: 1. Error when reinitialising a publication

  Hi, I have three publications on a dev server. All are sql 2005 merge replication (push) with replication running to subscribers on the same instance of sql server (note this is just dev testing). However, I have just marked one for re-initialisation / create new snapshot / don't upload changes but when I kick off the synchronisation it says it has insufficient permission to run the snapshot. When I do this for the other two there is no problem. SQLAgent is running (using LocalSystem) so I don't know why my reinitialisation won't work. Any help would be greatly appreciated. I think I have found the source of my problem! My parameterised filter referred to a view that wasn't in the p ...Show All

• A.Gharighi RS.EXE parameters not working

  Hi Everyone, I am having a problem with the RS utility not recognizing my query parameters that I am passing to my timed subscription. I have set up my report with a "WorkOrder" parameter. I have created a trigger that causes my subscription to fire, and that trigger passes in the workorder number to the utility. The subscription fires successfully, but I am getting a blank report. I set the parameter value to "can be blank" so that I could create my subscription w/o an error. I know that my subscription id is correct when I use the fire method, because I DO get the appropriate report. I am also having the same problem when I actually log in to the report server and execute the utility from the command line. I ...Show All

• GraemeWhelan SSIS Package will not execute when DontSaveSensitive protection level is selected

  Hi, Can anyone explain to me why my ssis packages will not work when DontSaveSensitive protection level is selected My package configurations are set as SQL server configuration type, and I have a table in a database that contains all the sensitive information (passwords and such). If I select "EncryptSensitiveWithUserKey" everything works, but I will be the only one able to execute the packages (not good, I need others to be able to execute them as well). The error I'm getting tells me that the connection is not configured correctly or I may not have the right permissions on the connection. My guess is that the DontSaveSensitive drops the passwords, but when I edit the data source and re-enter the password, it still do ...Show All

• Juergen Lorenz MDX help - calculated members make performance very poor

  I have a cube in AS2000 where the fact table holds the figure I want to use as a cumulative amount by month, e.g. if ￡1000 is received in March 2006 and ￡500 in May 2006 then ￡1000 is held against March and April and ￡1500 against every month from then on. However, I need to use this figure on a movement basis and a cumulative basis so that the users can see the development by month, quarter etc. To this end I have developed several calculated measures - one which makes it into a movement, e.g.: Our Share EPI Conv, for which the MDX is IIF ( Not IsEmpty ([Measures].[Our Share EPI CONVbasecalc ]), ([Time].[EPI] .CurrentMember ,[Measures].[Our Share EPI CONVbasecalc ]) - ([Time].[EPI] .PrevMember , [Measures].[Ou ...Show All

• Sabrecat Accessing Views via ODBC from MSAccess

  Hello, This started as a simple thing, allow somebody to access to a database on a SQL 2005 server so they could get to it from MSAccess. I have created a login (Windows Authentication) so they can see the database and gave them "public" and "datareader" abilities. The user then informed me that while they could see the views they could not see the data. Not being a DBA (sorry) I added "public" to the view's permissions (under properties) and granted it "Select" access and nothing else. After I completed this the user could not even see the views to pick them (via the ODBC link from MSAccess) and when I try to remove "public" from the permissions it dissapears, but when I reopen the p ...Show All

• Amelia_Dev ERROR AT DATA FLOW TASK

  HI, I HAVE A NEW PROBLEM...HOPE SOMEONE KNOWS WHAT THE $#%#$ IS HAPPENING. HERE IT’S THE THING: I’M USING A DATA FLOW TASK TO READ DATA FROM AN ORACLE SERVER AND  TRANSFER THE INFO TO MY SQL 2005 SERVER, THE SOURCE IS AVAILABLE  AND THE CONNECTION IS WORKING, I'M USING A DATA READER SOURCE TO CONNECT AND EXTRACT.  I’VE PUT THIS DTS IN A JOB AND IT WAS OK, IT HAD BEEN RUNNING OK FOR ALMOST A MONTH BUT SUDDENLY HIS MORNING IT FAILED WITH THE FOLLOWING ERROR: SSIS package "SAZSIE_CargaVentasSeguros (1).dtsx" starting. Information: 0x4004300A at Extrae SAZ_GranoO_New, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Extrae SAZ_GranoO_New, DTS.Pipeline: Validation phase is beginning. Information ...Show All

• Jeff Sholl Heterogeneous queries, ANSI_NULLS, ANSI_WARNINGS

  I have stored procedure: EXEC sp_addlinkedsrvlogin @FailedRegionServerName, 'false', NULL, 'sa', 'pass' DECLARE @a varchar(100) SET @a = @FailedRegionServerName + '.Ithalat.dbo.Product' DECLARE @s varchar(100) SET @s = ' SELECT * FROM ' + @a EXEC ( @s ) When I execute it I get the error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. Then I put SET ANSI_WARNINGS ON SET ANSI_NULLS ON lines into the procedure. Also checked "Ansi Nulls" and "Ansi Warnings" in the properties of SQL Server. It didn't work Then I tried: DECLARE @s varchar(300) SET @s = 'SET ANSI_ ...Show All

• GTH passing a timestamp datatype column to a variable and back

  After several hours of trying, I trow the towel in the ring and come here to ask a question. Source system uses a timestamp column in the transaction tables. which is equal to a non-nullable binary(8) datatype (sql 2000 bol). What I want to do is get the timestamp at the start of the transfer and at the end of the transfer of data. and store these in a controltable I try to do this in 2 sql execute tasks: sqltask 1: "select @@DBTS AS SourceTimestamp" and map the resultset to a variable. Here come's the first problem what variable type to take DBNULL works (meaning it doesn't give errors) (BTW: is there a way to put a variable as a watch when debugging sql tasks ) INT64 and UINT64 don't work error message that t ...Show All

• Frank Uray Create Time dimension Year, Week, day problem

  Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. Week 42-2006 should start on 16 th. october and end on 22 th october, but in this case it starts on the 15th october and ends on the 21 october. So what happens is that it starts 1 day before it actually should. This is my Time Dimension: DatePart(year,"dbo"."fCapacityLedgerEntry"."Posting Date") DatePart(week,"dbo"."fCapacityLedgerEntry"."Posting Date") 'Week ' + convert(CHAR, DateName(week, "dbo"."fCapacityLedgerEntry"."Posting Date")) convert(CHAR,"dbo"."fCapacityLedgerEntry"."Posting Date&quo ...Show All

• crazy_boss extract data from SSAS and feed to a formated file / another application

  Hello, I'm looking for a tool which is able to connect to SSAS Cube, extract data and transfer it to a file (as interface to another application). With reporting services I can extract Cube data but can't transform to the right file format and with SSIS I can't extract the data from Cube. Do you have any ideas, tools, links, etc. Thanks in advanced! -flyall- Hi, I tried a MDX query in "OLE DB Source" -> "SQL Command" but the tool can't identify the output coumns. Is this a typical problem cu -flyall- Why would you say: "with SSIS I can't extract the data from Cube" - what is the issue Others in the forum are app ...Show All

• Fuzzy6280 Error List, Sql Server 2005

  Hello, I would like to know if there is an list of mistakes where appears all errors that you can find to interact with the SQL. for example something similar like this: Error number 2627 Means that exists a record with the same primary key Error number 505 Means that ther is a row with doesn't accept nulls Thanks, my email pac_mt@hotmail.com . Are you looking for the possible error messages You can query master.dbo.sysmessages in older versions of SQL Server and sys.messages in SQL Server 2005. Older versions of Books Online also has the list of error numbers/messages. The problem is that sysmessages doesn't contain all error numbers. For instance, I can't find the error 132 ...Show All

• Imad.Ozone SSIS - on execute package "out of memory " error

  Hi, when i am trying to execute package in ssis then given below errors comes many times.how to fix it.any body can ...... in ssis default buffer size 10 mb. soure is iseries-db2 on as400 in production server , and destination is db2 udb on windows in dev server. usersapce page size in db2 is 16-32k 4 gb ram support in server with 2003 server standard edition. errors are--- Information: 0x4004800D at CHDRPF 312-315, DTS.Pipeline: The buffer manager failed a memory allocation call for 15728400 bytes, but was unable to swap out any buffers to relieve memory pressure. 3 buffers were considered and 3 were locked. Either not enough memory is available to the pipeline because not enough are installed, other process ...Show All

• humble.apprentice default render

  Is there a way within rs2000 to set the default render to pdf for a particular report I have a report which asks for parameters which will be exported to pdf before printing. I want the report to go straight to pdf when 'view report' is clicked rather than http. No, I don’t think that this is possible. (Didn’t see any switched or tweaks for that). HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All