Answer Questions

• Anonymousandmad User-based security in Reports

  We understand that Report Server supports role-based security such that users in the different Windows user groups have certain rights with reports.  In addition to role-based security, we’re investigating Reporting Services 2005 to see if it suits our needs to providing user-based security in reports.  For example, user1 and user2 are both in the Windows Power Users group such that they can both browse a certain published report in r ...Show All

• NB at AeM Publishing from Oracle to Sql Server 2005

  HI guys, Am trying to do the above. Managed to configured the distributer. However, while trying to configure my oracle publisher, it failed as follows: ==================================================== Creating Publication - Creating Publication 'oraTest' (Success)  * SQL Server created publication 'oraTest'. - Adding article 1 of 1 (Error)  Messages  * SQL Server Management Studio could not create article 'USERS'. (New Publ ...Show All

• Chester Flake SP2 - Need Your Feedback!

  My team keeps emphasizing the importance of community participation and value all the feedback posted in the groups, forums and all possible channels to communicate with you all, the customers; and loop the feedback provided to improve the quality of product. I personally felt the importance after being part of the community during our SP1 release cycle, it really helped to address most of the customer impact defects in our ...Show All

• Anika Query to Get and Set Image data type Value in SQL Query

  Hi   I'm using Sharepoint Services in my application. My database is SQl server 2005 My Sharepoint site using one database there is one table called docs. In this table one column is called MetaInfo and its datatype is Image.  My Question is How to write a Query to Get and Set Image data type Value.I want to execute the Query in SQL Itself. If anyone knows the answer Please let me to know. Thanks Regards, Vinoth It is not cle ...Show All

• Eve Rallo Need Help on importing data from text file

  Hi All, I am a newbie in the SQls. Can ne one help me out abt how to import data from the text files.I have delimited the data with "|" symbol. Waiting for ur reply Karthik ...Show All

• txksa SQL Table size

  Hello, If i want to know the size of table then how can i do it in SQL Server 2000 and in SQL Server 2005. -- how much amount of data can a table store in sql. -- On which thing the size of table depends. or Can anyone give me a introduction about the size of table in sql in SQL Server 2005 you can use CTE and ROW_NUMBER then the query would be this with ReturnFifthRow as ( select row_number () over ( o ...Show All

• DIFSMGULD2005 Count() function

  hi I have a problem in using Count function. I want to search a XML file and in that file I want to find the the number of child elements "Science" keyword in them and then I want to count how many times the word Science appear in any of the child nodes. If i try by the way u told it works but does give the right results. so if the nodes are <Package> Science made life very simple. Bio-Science , Organic Science are the part of ...Show All

• CanUHelpMe RS.exe Scripter DataSource error

  Is it possible within an .rss script to set the data source of a report In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script. Learn this is the sample i used to attach the datasour ...Show All

• Steve1234 SQL server 2005 management studio

  I just installed VS 2005 along with sql server 2005 cpt. No errors & VS works fine, but I cannot find the management studio. I have used Add/Remove to check for the possibility that I could add management studio -- no luck. Did a file search for sqlwb.exe -- again no luck. When viewing list of installed programs with Add/Remove I do not see an entry for sql 2005 tools. Should there be Any help would be much appreciated -- TIA. ...Show All

• bearNP DTS transaction problem

  I created DTS package that has two connections “Source” and “Destination”, contains several “Execute SQL” tasks and several “Data Driven Query” tasks after them. For all tasks workflow properties are set to “Join transaction if present”, “Rollback transaction on failure” and “Fail package on step failure” except the last “Execute SQL” task that has also “Commit transaction on successful completion of this step” property set. The problem: when ...Show All

• Dome C. Generating a PDF type report and embeding fonts

  When a .pdf file is generated by reporting services, does it embed the fonts used into the .pdf , or is there any way to tell reporting services to "embed all the fonts" Thanks in advance. Hi Sunny -- No, the PDF extension does not do font embedding...There is no way to force this behavior, either.  Is there a plan to add this to newer versions of Reporting Se ...Show All

• vasu4us SQL Mgt Studio 2005 - Printing Diagrams

  Hi When I layout a diagram in SQL server management Studio 2005 everything looks fine, however the automatic recalculation of page breaks is causing me problems. I have a number of tables laid out over two pages and everything looks ok and fits well, until i click auto recalculate page breaks and it messes everything up and pushes the table views half way down the page... dont click this option i hear you cry... i thought that, set my tabl ...Show All

• WJ The never ending DTSX package

  Hi Champs I want to implement a rutine that watches for specific files in a specified folder. I've found the WMI sample "File Watcher Task" for SSIS and it looks fine. My question is now: how shall I run this package; shall I start it at let it run forever And also how do I monitor that the package is running Many thanks Rogvi I'm looking for the same. Rogvi Knudsen ...Show All

• Ian Jagger XmlSerialization with CLR

  Hi,   I have created the CLR Trigger Project. In that Project i'm refering one external.dll which is also deployed in the same database. This external.dl uses one method to serialize the data and send it  to the server through socket.(The connection for the socket is already established). For this to work i know i need to turn on the Generate serialization assembly from the Build of Project Properties. After i ...Show All

• deepshikha Package Configuration in SQL

  I have an OLEDB SQL Connection that has a connection string that is set as and Expression using a User Variable (@[User::server_name]).  I pass the server name as a command line option.  The Package Configuration table is being accessed using the setting for User::server_name in the package and not using the parameter entry for it. The command being issued is similar to: dtexec /FILE "packagename.dtsx" /SET "\package.variable ...Show All