Answer Questions

• nil130180 Changing SQL 2005 Password Policy not working

  I have modified the Security Settings>Account Policies>Password Policy on my PC as follows: Minimum password length: 10 characters Password must meet complexity requirements: Enabled However, when creating a login within SQL Server 2005, which does not adhere to the amended policy, this does not seem to be taken into account: CREATE LOGIN testlogin WITH PASSWORD = 'a' , DEFAULT_DATABASE = [master] , DEFAULT_LANGUAGE = [us_english] , CHECK_EXPIRATION = ON , CHECK_POLICY = ON have tried restarting the SQL Server and rebooting the PC, but this does not solve the problem. That all depends. There are some rudementary rules you can enforce at the SQL Server level, b ...Show All

• mstcrow5429 check if schema exists

  How can I tell if a schema already exists so that it doesn't have to be created If your schema should exist in the form of an .xsd file then you can use the system.io.file object as: if system.io.file(path\name.xsd).exists then the exists method will return a true if the file is present. If this is not what you are looking for, where else might a "schema" exist that you would have to create one In SQL There too is the "Exists" keyword in t-SQL, you can, for instance create an SP that would look something like: [based on the pubs demo db] CREATE PROCEDURE dbo.MakeEmployeeTable AS if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[employee]') and OBJECTPROPERTY(i ...Show All

• R.Tutus GetDataDrivenSubscriptionProperties vs GetSubscriptionProperties

  Is there a similar method for Data Driven Subscriptions like there is for plain subscriptions ListSubscriptions. I would like to get SubscriptionID for use with the GetDataDrivenSubscriptionProperties just as I do for GetSubscriptionProperties. When I execute GetSubscriptionProperties for Data Driven Subscriptions there is no array of Subscriptions. Here is an examole of the code which I execute using rs.exe: Sub Main() 'Dim rs As New ReportingService() 'rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim DRPlan As DataRetrievalPlan Dim extSettings As ExtensionSettings Dim desc As String Dim active As ActiveState Dim status As String Dim eventType As String Dim matchData As Str ...Show All

• MShetty DTS 2000 Package Error(s)

  From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server.  I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get: Error Source : Microsoft Data Transfformation Services (DTS) Package Error Description : The DTS host failed to load or save the package properly. I click the OK button and get: The selected package cannot be opened. The DTS Desiger has been closed. I click this OK button and get to now famous: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer. ...Show All

• Luis Esteban Valencia Muñoz Problem Sorting a Matrix report

  I have created a Matrix report with 5 row groups (customers and store locations), one column group (division) and two data columns -- Sales Dollars and Percentage. The report works fine except that it does not sort properly. I want to sort the customer rows in descending order by sales dollars. My top customer in dollars should appear first and so on. I took the following steps -- I highlighted the matrix and in the properties dialog box, selected the groups tab. In groups I selected each row group, hit the edit button, clicked the sorting tab, and changed the ...Show All

• WBurggraaf Including Views in Replication

  I have a three server peer-to-peer replication setup that includes articles for tables and views. As I understand the BOL, scheme changes -- which I take to mean changes, amont other things, changes in the design of a table or view -- should automatically replicate to the other servers in the topology. Here are my quesitons: When including a view as part of the publication, what is it, exactly, that is getting replicated If all the tables supporting a given view are being replicated, and the view exists on all three boxes, whatelse, besides the view schema (and changes thereto) is being replicated Secondly, if in fact schema changes are replicated, why can't I modify a view that is part of a publication When I try to make a change t ...Show All

• sheiderpbsj partitioned views Explain Plan

  Hello I created a partitioned view on my database db1 and It comes from the UNION ALL of 2 tables (I split 1 very big table in 2 smaller tables... Horizontal partition!!) that are on the same db1. When I query them I receive in the EXECUTION PLAN an Item called CONCATENATION of both input tables, This seems to be more expensive than using only one big table so partitioning the big one gets none sense.. I would like to know if this is normal and If I'm doing well with partitioning. Please see the script below: CREATE TABLE [dbo].[TREP_NOVEDADES_2006] ( [NMSEC_NOVEDAD] [numeric](12, 0) NOT NULL , [CDCONCEPTO] [varchar] (12) NOT NULL , [CDTIPO_VALOR] [char] (1), [CDPRECIO] [varchar] (12), [CDTIP_HECT_DTO_PAG] [varchar] (2), [FEG ...Show All

• ZopoStyle transfer database task error

  hi, I have created a SSIS package that does nothing more than loop through all DBs and copies the userDBs to another server. However, I keep getting an error after the task has created the database during its execution of "Create Role" statements. Here is the error: Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE ROLE [aspnet_WebEvent_FullAccess] " failed with the following error: "User, group, or role 'aspnet_WebEvent_FullAccess' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection ...Show All

• DigitalFusion Out of virtual memory

  I have one package that is constantly running out of virtual memory, right now I am on a development server, running only this package. The package is moving data from one table into another on the same server in the same database. The server has 3 Gb of memory and is only running SS2005 and SSIS. I am a local admin on the server and running the package through BIDS, once again for our initial testing. I tried setting the property BufferTempStoragePath to our E drive so it can utilize the 100 Gb of free space we have but that doesn't seem to work either. I have also tried setting the MaxRowSize to many different values to no avail. I am constantly getting an error, see below for exact error, when it gets through roughly half the load. More ...Show All

• Binu Jeesman Configurations and Child Packages

  Hello, I was hoping someone might be able to clarify how configuartions work with child packages. My process has 3 levels of packages. The main packages called two child packages each of which calls more child packages. I'm using Configurations to pass variables from parent packages to child packages. But each level of packages contains Data Flow Source/Destination connections. I was planning on having only 1 XML Configuration file in the main package that would allow the data connections for the main package to be configured for the target enviornment. When the job is scheduled I will be able to point a configuration file for use with the main packages. But will that configuration file be applied to all child packages that will ...Show All

• Robert Mileski [SSIS] Image's integration in a SQL server 2000 Database

  Hello, I would like integrate images from a folder in my computer into SQL Server 2000. It's bmp, jpg or gif images. But I don't know how integrate them. With script compenent in a dataflow Can you give a example please Regards Hello , I found a solution for a SQL SERVER 2000 Database. I think it's ok for a 2005 version. This is the package. There are two dataflows. It's the dataflow with the script task that is ok (the second dataflow). The first dataflow reads an image with a connection manager but returns sometimes more then 1 line, so it's impossible to integrate in the database. If you find a solution write to me. <Code> < xml version="1.0" >< ...Show All

• trampas Debugging Stored Procedure ERROR: execute master.sp_sdidebug

  Trying to debug a stored proc that resides on our dev sql server 2005 machine. I'm running VS2003. The error message is: Cannot debug stored procedures because the SQL Server databas is not setup correctly or user does not have permission to execute master.sp_sdidebug. Run SQL Server setup or contact database administrator. ...Show All

• Marius Matioc SQL SERVER 2005 time mdx queries

  Hi, Thank you for your reply.... Just to correct something. Curently there is no number of incoming patients as a cube measure so even if the time mdx query will return the names of the patients that came between 6am-8am in the hospital ,i will be happy. The time dimesnion has times . Thank you... Could describe the time dimension - does it include date as well, or just time of day And is there a cube measure for the number of incoming patients ...Show All

• Constantijn Enders Reindexation

  I have a very large database, in wich the indexes are constantly "getting lost". I execute DBCC Reindex and everything goes back to normal. Still, I don't know why this happens. I have to run this process once or twice a week, sometimes as a scheduled task, some others manually. Why are the indexes 'getting lost' What could be wrong with the database Thanks in advance You might find some help with the DBCC commands. They will help you with physical and logical errors. Here is a good link for an introduction to those: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=30&rl=1 And here is a more in-depth explanation of the DBCC CHECKDB command: http://msdn2.microsoft.com/ ...Show All

• tattoo Reports + Setup

  Hi, I need to create a setup project that will create a new folder in the Reports Server. The folder should contain all the reports I have developed. The folder should have a browse permission for a user that I will choose (from the Active Dir.). Everything must be programaticlly. In other words, I need to create a folder and set the permissions for it using code. Is there a way Do you have something in mind 10x, Solved it using the followings: for the folder creation part: _service = new ReportingService2005 (); _service.Credentials = System.Net. CredentialCache .DefaultCredentials; _service.CreateFolder(directoryName, "/" , null ); for the security part: Role role = new Role () ...Show All