Answer Questions

• SteveCsharp How to release large unused/allocated space

  Hi, I have 6 filegroups that contain over 30 gigs of data. I manage the transaction log space efficiently by using a script and 'shrink database'. But, the allocated unused space of the data files are very large, over 30 gigs. The configuration is standard for all files: - Automatically grow file by percent - Maximum file size - Unrestricted How do I release the unused space Thanks, - gshaf Hi Gshaf, You can issue the DBCC SHRINKDATABASE statement with TRUNCATEONLY. This will shrink the database the maximum amount possible, and release the space back to windows. If you want to control how much space in the db left for growth, you'll need to issue DBCC SHRINKFILE and specify the am ...Show All

• Pawel B. Dynamic modification of data flow objects

  My idea is to read in source and destination values from a table and using these values within a ForEach loop dynamically alter the source, destination and mapping on the data flow within the package. My reading on SSIS leads me to believe that these properties are not available for modification at run-time. Has anyone any ideas on how to accomplish this task. I have data in over 200 tables to import every 4 hours so I'd rather have to maintain 1 package rather than 200. OK, you have to create 200 packages. But you only have to create them once. You are correct that the only other option is to dynamically build the package. That's not much fun, believe me! -Jamie Peter G D wrot ...Show All

• ProSlamBanO Unable to add Securables to a DB Role

  Hi All, I am having problems with a sql server 2005 database. Basic information on the setup, I have two windows user groups, admin and users. These both have logins to the sql server 2005 which are using Windows Auth. They in turn are users inside a database. In the database, there is one Schema that has been used to create all the data tables, stored procs. This was all done back in sql server 2000 days. Now, I have created two roles (one Admin, one Users) and want to add Securables to each of these roles. Essentially, the Admin will have access to all the secureables (except tables - but all stored procs) - and the Users will have access to stored procs that Get data (ie: No updates, deletes, adds). When I add these secureab ...Show All

• Oliver_Schwarz how to set the disable property at runtime for sequence container

  I have a package that contains multiple SEQUENCE CONTAINERS, each execute a bunch of tasks. I try to use the script task to dynamically disable or enable each of these SEQUENCE CONTAINERS base on parameters that pass in from parent package, but for some reason, I can’t set the disable value to True/False at runtime. Anyone knows how to do this   tm9t9 wrote: I have a package that contains multiple SEQUENCE CONTAINERS, each execute a bunch of tasks. I try to use the script task to dynamically disable or enable each of these SEQUENCE CONTAINERS base on parameters that pass in from parent package, but for some reason, I can’t set the disable value to True/False at runtime. Anyone kn ...Show All

• tawm How to use the Microsoft OLE DB Provider for DB2.

  I follow the steps: 1.In configure OLE DB Connection Manager dialog, I click New. 2.In Connection Manager dialog ,I choose Native OLE DB\Microsoft OLE DB Provider for DB2. 3.In Connection Manager dialog I click the "Data Links" button. Now I am on "Data link property" dialog.  4.On connection tab, I enter fmdb for data source, which is my remote database name. On Network section I choose TCP/IP Connection and set the right IP/Port. Uncheck Single sign-on and enter the user and password. Then comes the Database section. Database name fmdb for Initial catalog,"fmdbrun" for Default Schema,  then what is Package Collection (My db2 database is in a AIX/RS 6000 box). 5.On advanced tab, I choose DB2/6000 fo ...Show All

• DrJim Maintenance Plan Problem

  I cannot seem to get maintenance plans to work. Everytime I try to create a new plan, it tells me that managment tools are not loaded on the remote machine. Tools are loaded, server is registered as local. Any hints TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwl ...Show All

• ASaleem Reporting service sample -Adventure works installation

  Hi, I have installed samples. Opened AdventureWorks Sample Reports and followed the instructions for SQLExpress (changing service endpoint etc.) When I try to deploy I get the following error message Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: AdventureWorks Sample Reports, Configuration: Production ------ Deploying to http://localhost/reportserver$SQLExpress Error rsAccessDenied : The permissions granted to user 'PC-NOEL\IUSR_PC-NOEL' are insufficient for performing this operation. Deploy complete -- 1 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Is this an IIS iss ...Show All

• Jelena Flustered... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

  Hello everyone, I have been playing with a Standard Version of VS 2005 and SSE 2005 and I just cannot get these two to interact together well. I am sure it is a noob problem but I have seen this error addressed on this forum and I am just not getting it. Here is exactly what I am doing. I want to create a database within SSE using the Management Studio. Then, I want to connect to it with VS2005. Both SSE and VS2005 are local. I just cant seem to get this to work. I always seem to get this error "An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Second.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. ...Show All

• AAtallah Failure to open SQL Server with given connect string.

  So, I have a Server running Windows 2003, windows firewall offline, with Sql Server 2005 and SQL Server 2005 Mobile Edition. This server is running behind a firewall. When I try to PULL data with RDA from the internal network, all work's great! But when I try it from the exterior, internet, I always receive this message: Failure to open SQL Server with given connect string. [ connect string = Provider=sqloledb;Data Source=<MY INTERNET IP>,11433;Network Library=DBMSSOCN;Initial Catalog=testdb;User Id=sqlceuser;Password=test; ] On my firewall, I unblocked port 80 and 11433 and mapped them to my internal server IP with port 80 and 1433. I use port 11433 on internet because my ISP block the 1433. How can I solve this pro ...Show All

• kenmcd4 Restoring a backup of a Subscriber database to a new database

  I have a Subscriber database updated using transactional replication and want to create a copy for development & testing. The Distribution database is running on the same 2005 instance as the Subscriber and the Publication database on another server running SQL Server 2005. If I use a TSQL script to run the restore, the database is restored to a usable state but I get the following messages: Msg 15247, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 112 User does not have permission to perform this action. The replication agent job [job name] was not removed because it has a non-standard name; manually remove the job when it is no longer in use. (I’ve removed the job name from th ...Show All

• EnigMa_AnGeL Burning to CD demo install of SQL Expr Ed

  We burn to CD a demo install of our app along with SQL Expr Ed for potential new clients. (yeah, we filled out the paperwork) For the SQL, we pre-extract the SQLExpr.exe files and setup a custom template. Batched the install with our app. AOK perfect so far. The problem is when we burn to CD. The file names under \SQL2005Express\setup\program files\microsoft sql server\90\tools\binn\windows\winsxs\manifests\ are all over 64 chars in length... which is a problem for all/most CD burners.... Who on earth really needs file names 75 chars long I don't have an answer, but would like to TELL MICROSOFT about this. It's hindering our abilily to sell our app and sell MS SQL products. (we're also a MS Partner). How about in the next release ( ...Show All

• programmer01 Contextual Relationship mappings

  Is there a 'best practice' method within BID to constrain a relationship path when different contexts are available For example: tbl.Revenues provides data for both tbl.Rentals and tbl.Sales, and aggregates/totals are provided for both Rentals and Sales (via relationships to tbl.Revenues from each of the two other tables). How can I assure that values for Rentals are _not_ shown when the path to Revenue was via the Revenue-Sales relation Thanks in Advance. This blog article may also be helpful: http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx If you want to selectively show items based on the user or user group then you should use ...Show All

• programmer01 Deadlock problem? 3 way conditional split of data from one table to another never completes

  I have a source table which I'm splitting 3 ways based on a column value, but the target is the same OLE DB destination table. One conditional path is to a Multi-Cast two way split to same OLE DB gestination table. The default split is to a flat file for logging unknown record types. For a test I have data for only the 3 column values I want, but I'm having trouble with the process completing. If I pre-filter the data going into the source table by one or two values I can get the process to complete even if one split is to the multicast. If I include all three data types in the source table, I get different results depending on the order in which the conditions are specified - sometimes only two split paths are executed; other times all th ...Show All

• vdv_phuong automatically copy database to another pc

  When I create a setup program for my vb.net 1.0 app which has embedded sql express database, it successfully copies the database to the new machine alone with the upgraded app. However, if I just copy the vb.exe app to the other pc and also copy the mdf, ldf files, I get an error opening the sql database. I am presuming that the setup program does some kind of backup restore or detach, attach to copy in the .mdf. If the user cannot do this from the management studio (or if they do not have the management studio installed), is there any way I can create some method to have this copying done automatically via some code by the user Thanks SM Haig Yes, you can run a restore script using t ...Show All

• Santosh A H xquery and attributes

  i have some data stored as xml in a datatable which i need to extract and work on. Have looked at the SSIS XML Source control - but the problem is that the data is stored in the attributes rather than the elements - so am now trying xquery as a method of getting the dataout <my:case_common xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:my=" http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-07-25T01:09:46 " my:CaseID=""> <my:reporting_authority my:OfficerName="" /> <my:case_identification> <my:name my:Surname="MarkTest" my:GivenName="Mark" /> <my:nhi my:IdentNumber="777777" /> <my:address my:housenumber=&qu ...Show All