Answer Questions

• MartinHills ssis security short coming, major issues

  Hello, I feel like ssis encryption model has a serious flaw. Especially when linked to SQL Agent jobs. I have posted and others have posted messages about this. Something is plain wrong with ssis encryption keys and password protection. Also, you do not have the choice not to protect the packages. In my case, protecting packages is completely useless. Here is the story. After this post http://forums.microsoft.com/MSDN/ShowPos ...Show All

• Aarom SetPolicy - Using SSRS web service

  Am using the Web service of SSRS to assign the roles for a user (which is already available in Report Manager). Policy[] p = new Policy[1]; p[0] = new Policy(); Role[] R = new Role[1]; R[0]= new Role(); //RoleGroup Rg = new RoleGroup(); R[0].Name = "Report Builder"; p[0].GroupUserName = "MyMachineName\bvikas"; rs.SetPolicies(@"/",p); The same I have tried with SetSystemPolicy method also. Policy[] p = new ...Show All

• ipa WMI for SQL Replication Agents

  Is it possible to obtain the status, running or not running, of the distribution agents that appear under Replication Monitor\Agents\Distribution Agents in Enterprise Manager using WMI If yes, can you please tell me the WMI namespace and objects that can be used Thanks WMI, no. but in SQL 2005, you can use RMO, and in SQL 2000, SMO. You can find more information about this in Books Online. ...Show All

• Nick65465464 sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks Management Studio Express doesn't run side-by-side with the full version of Management Studio.  If you have any version of Management Studio installed on your machine, Management Studio can't start. There is supposed to be a message box that pops up in that case explaining the proble ...Show All

• AnilYu Empty report: displayed on server 1, error on server 2

  Hello, I'm deploying the same report on different servers, same database. For the year 2007, I have no data. When I display the report on server 1 or in VS2003 locally, I see an empty report. But on server 2, I have the "rsProcessingAborted" error. Is there a way to configure the server so that it displays an empty report even if the dataset returned is empty Thanks for the answers! Tiago ...Show All

• Halsafar Question about Database Collations

  I sent a couple of detached databases to a customer.  When he installed his SQL Server he got database collation value of Latin1_General_CI_AS however, when he attached my databases they have a collation value of SQL_Latin1_General_CPI_CI_AS. Now my stored procedures that use temp files are failing and a message is coming out SQL Server "Cannot resolve collation conflict for equal to operation" I am assuming that the temp database has one c ...Show All

• John Fabian Creating Dimension Template...

  Hello, I need to create a dimension that has pre-defined multiple hierarchies, attributes, and the data source table the dimension will be based on would be different for each customer. (The structure of the data source table would be the same though, just the underlying data would be different) Thus, I thought about using the dimension template. However, the steps in the dimension template wizard is quite confusing to me. Does any know w ...Show All

• ?®€?§Q? Automate partition creation

  Hi, Is there any example out there on how to automate the creation of time based partitions As an example, I would like to create 1 partition for each quarter and when a new quarter start have a new partition automatically added with the same attributes than the previous one. I would also have the oldest 4 partitions automatically deleted as soon as the total number of partitions reaches 13. Any thoughts or links Thanks, Philippe ...Show All

• blange cannot set permission in SQL Server DBE for a database

  In my attempts to connect a SQL database to VS I tried to set up permissions for the database in properties. None of the checked boxes has been accepted. I set up "user or roles" to "public." Then a long list of "permissions" appear with two options: "permit" or "deny." The error message is "Grant Failed for database *****" Additional Information: "Cannot grant, deny or revoke the connect database permission to roles and application ro ...Show All

• Bill T. Error in Aggregation wizard - AS2005 cubes

  Hi, I got the following error message while i was trying to do the aggregation wizard for SSAS 2005 cubes. I chose the storage setting as MOLAP then in the next screen , when i hit on the count objects, i am getting this error message. 'IBMDADB2.1' failed with no error message available, result code: DB_E_OBJECTOPEN(0x80040E05). (Microsoft Visual Studio) Please let me know any one has got this error before and hot to fix it Thanks ...Show All

• Atroa [Time].&[2007].&[2] vs.[Time].[2007].[SEMI2]

  Hi [Time].CurrentMember in Browse Data returns : [Time].&[2007].&[2].&[4].&[12].&[52] VS In Excel Addin or MDX Sample App. [Time].[2007].[SEMI2].[Quarter 4].[June].[WEEK 52] This affects formulae. How can I be sure of how a 3rd Party Tool will behave Can I force this setting What is this direct naming convention called shirtname ...uniquename Thanks Later G ...Show All

• Magechore Stored procedure runs interactively but not via application

  We have a stored procedure that we recently modified to improve performance. It runs fine interactively (Rapid SQL) but will not run when executed via the application. Up until our modification, the stored procedure did run via the application. The change we made to the stored procedure was the use of 'hints', specifically the use of 'with index' that enabled the execution time to improve from 10 seconds to 1 second. Environment: ...Show All

• 1Pierre1 cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All

• Jason88 Object is invalid. Extended properties are not permitted on ...

  when attempting to execute the following query from within 2005 Mgmt Studio: sp_dropextendedproperty @name = 'test_me' , @level0type = 'schema' , @level0name = 'dbHSPS.dbo' , @level1type = 'table' , @level1name = 'Conflict' /*[ , [ @level2type = 'column'] { 'level2_object_type' } , [ @level2name = ] { 'level2_object_name' } ] */ I receive: "Object is invalid. Extended pr ...Show All

• Saber01 Combining XML

  Assume I have the following, in T-SQL: declare @xml1 xml declare @xml2 xml set @xml1 = '<first></first>' set @xml2 = '<second></second>' I want to combine these, into the following, and return the results typed as XML: <results> <first></first> <second></second> </results> I can't seem to find any way to do this - other than converting ...Show All