Answer Questions

• hozdemir Conditional Split Question

  Hello, I am have an ID column that sometimes contains all numeric characters and sometimes contains all digits. I would like to the records with all digits (0-9) to continue downstream in my Data Flow. I would like the records that contain characters other than digits to be logged to a table. This sounds like a job for the Conditional Split transformation, but I don't see a way to easily test for a numeric value. For example, I would like ...Show All

• BillRP Calculations on members and aggregation

    I'm designing a Profit And Loss report dimension that has the following attributes: Report Line, Cost Center and Account. Attribute relationships are defined between the attributes so that Report Line->Cost Center->Account. A Report line is either A) A combination ofcost centers and accounts like : Report Line A - Cost Center 1 --Account 3000 --Account 3001 -Cost Center B .. And so on   Or B) A cal ...Show All

• Alex2147 Last Modified to Store Procedure

  Hello everyone, I have store procedure that was created on 9/15/2005. It went through some modificiations since then. How can I find out when was the last updated or last two update on this object Thanks select modify_date from sys.objects where name = '<object_name>' Thanks Thanks Zoya. It workout perfectly Tom ...Show All

• user_whatever Ssimple Data Flow ? - processing after using a Destination

  I have a data flow that reads multiple rows from a table and then inserts to another table for each row. I use an ole destination for my inserts. However, after that insert I need to do other table inserts and I can't figure out how to continue the data flow with the fields in the pipeline. Out of the destination is only the Error flow - Is there a way to do this thx Thanks for the quick response next step - on the multicast - ...Show All

• Ran Mouri Scripting entire DB to multiple files or comparing DB objects

  We are training ourselves to use the new SQL 2005 SQL Server Management Studio. One of the things we do regularly in the earlier SQL Enterprise Manager is to script out all DB objects to individual files. We then use Source Safe to compare the objects from one version of the DB to another to identify where changes have been made. In 2005, although you can script the entire DB, there is no option to create individual files for each object. ...Show All

• Prakash Raman how would you design this query better ( does not contain lots of code)

  i have a number of business programs. Each program is started anew at the beginning of each fiscal year. each program has a number of goals and customers subscribe to the goals. i have to pull all this info out of the database. i have a cursor that gets the first program, inside this program i have a cursor that gets the first period, and inside that i have a cursor that gets the info on each goal. program cursor { period cu ...Show All

• francisk Problem in bulk insert

  Hi All, I am trying to perform Bulk Insert for an existing folder containing the data files into an existing destination table . I get the following error : [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\PD Data\PDDW_md_costs\Files_to_load" could not be opened. Operating system error code 5(Access is denied.).". Here Files_to_load ...Show All

• j_reins Keep getting Virtual Memory errors

  Hello, I am wondering if there is a way to solve a virtual memory error We randomly get the following error when trying to run sycn over the http websync. Some clients have 512 MB running sql express, others are full instances that have 1.5 GB. The merge process could not allocate memory for an operation; your system may be running low on virtual memory. Restart the Merge Agent. How long are these s ...Show All

• Richard Garand Grant on all tables

  Hi, is there a way to grants object privileges on all tables of database to an user like this: grant select, insert, update, delete on <all tables> to usernamedb go thanks!!!! In 2005 you can grant access to a schema's set of objects: grant select, insert, update, delete on schema::dbo to bob For example, in the AdventureWorks DB: use adventureWorks go create user bob without login go --first prove no accss execute as use ...Show All

• Tomas Srna Publisher become subcriber to other publication.

  Hi, I just want to know, is it possible to do this If yes, how to do it Thanks. Please note that if the same articles are involved, the root publisher (top of the replication chain) has to be setup before the republisher is setup. See SQL Server 2005 BOL article: Republishing Data http://msdn2.microsoft.com/en-us/library/ms152553.aspx Yes, it's called republishing and common for merge publications. Please search ...Show All

• katic SQL Express - can't change language setting

  I've got a problem in Server Management Express CTP - in the SErver properties dialog I can't change any of the properties on the 'General' page. At the moment the Language is set to English(United States), which is giving me a problem with datetime formats, but I can't change it. Am I missing something obvious In order to change the collation on a database open the properties dialog, switch to the "Op ...Show All

• kokolyo SSIS Registry Configuration

  Hi, I have an SSIS Package which reads the properties values from Registry. As per the constraint of SSIS I have created the keys under HKCU in the registry and things work fine from the designer. But, when I schedule the SSIS Package to run under SQL Agent (which is running under Local System) the values of configuration do not seem to be picked up from Registry. How I tested was: I am picking up the server name for the Connection Manage ...Show All

• Tom Robins how to retrieve inserted rows in sql server 2000

  Hi, I have this scenario: items should be inserted into a item table before they are converted into assets. The database server is sql server 2000. so item-> itemTable ->assetTable When I insert items into the itemTable, how can I retrieve the itemID (an identity column) that will be created during the insert I know I can use scope_identity(), but if two or three person are inserting items to the same table, which scope_iden ...Show All

• BethM Subscription Log Errors

  This question has already been asked a couple of times with no answers posted, so hopefully someone has actually solved this but just not posted. When trying both email and file subscriptions with SSRS 2005 they fail with the log showing the following: <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product> <Locale>en-US</Locale> <TimeZone>GMT Standard Time</TimeZone&g ...Show All

• Olusola Abiodun How can I get Transactional Republishing to work?

  I'm starting a new thread to keep things clean and simple. This is a transactional republishing issue. In my simplest scenario, I'm transactionally replicating a single table from database A to database B and then from database B to database C. (And C will need to transactionally replicate to D, but ignore that for now). All databases are on the same XP server (in this simplist version of the problem). This is SQL 2005 RTM. Publication A to B ...Show All