Answer Questions

• BeKe Transfer SQL Server Objects Task gives error with SQL Server authentication

    I was trying to transfer a SQL Server 2000 database  to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered:   "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“   Once I changed the authentication mode from SQL Server authentication to Windows Authentica ...Show All

• Kostil Custom Security: How do you manage groups

  Dear Anyone, We are trying to create our own custom security extension for rs2005. We are wondering how will then security extension will manage the authenticated users and how will it be mapped to an existing RS2005 group or role Thanks, Joseph You can do this by assigning security within RS using the role names (just like windows groups). To get this to work though you will need to: 1. make your implementation of IAuthentic ...Show All

• teemuh Getting sample databases in Management Studio

  How to get sample database AdventureWorks and AdventureWorksDW deployed in Management Studio. I selected to install sample database entire feature on my local hard drive and I can see it did installed all the .mdf,.ldf,.dim,.cube and the rest in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ How can I get the database in Management studio. I tried to use Attach db and it didn't worked, gave me following error Msg 1813, Level 16, State ...Show All

• SteveQ EMail Notifications

  Yukon Apr '05 CTP Using Notification Services Trying to send out notifications by mail Entry in the instanceconfig file   <DeliveryChannel>       <DeliveryChannelName>MailChannel</DeliveryChannelName>      <ProtocolName>SMTP</ProtocolName>       <Arguments>        <Argument>     ...Show All

• Davey400 SQL2005 Query Paging

  hello, I am new to this forum and to SQL, i am a beginner, and I want some information about SQL2005 query paging. I have access MSDN and searched but I couldn't found anything, so can anyone help me Thanks Sorry I dont know if it is the right forum to submit my thread in it. I am looking for a new feature in SQL 2005, which can help you to see more clearly the queries and interact with them using pa ...Show All

• Lukasz Pawlowski -- MS Generic staging design of data warehouse

  I have a question about staging design using SSIS. Has anyone come up with an ETL design that would read table names from a generic table and dynamically create the ETL to stage the table. 1. Have a generic table which would have table name and description and whatever else that was required. 2. Have a master ETL that would enumerate through the table and stage all the table names found in the generic table. This way I wouldn't have to ...Show All

• Simon Masters Trouble importing csv with flat file source

  Hi, I am having trouble importing a CSV file with double quote as a text delimiter.  The problem arises because one of the text fields has double quotes embedded in it.  This file loads perfectly in SQL 2000 DTS, but SQL 2005 SSIS will fail on the flat file source.  I would appreciate any input on this. Thank you, Nick Russo According to the documentation, the flat file source cannot parse an es ...Show All

• williamosullivan Deserialize ACL problem

  I'm developing a custom security extension to Reporting services. In my authorization class I have a problem to deserialize the ACL (secDesc parameter). I have many examples and I’m doing the same excepted for one thing I’m not in form authentication but I’m in windows authentication. The problem is in the method 'DeserializeAcl(byte[] ...)'. I encounter this kind of bug : BinaryFormatter versions incompatibility : Excpected version 1.0, rec ...Show All

• wien How to skip records in script component

  In DTS activex task, you can use skipinsert to skip a row, how to do that in script component In your ProcessInputRow method, simply use an If test or other control structure to identify the rows that you don't want to process, then...do nothing! Note that if you have a component with synchronous outputs, then the same buffers full of rows that come into your component are passed back out as outputs, whether you choose to process thos ...Show All

• happycamper1234 Round producing no value

  why is this producing nothing when zero =Round(((Fields!FeeGoal_IL.Value) / IIf(Fields!FeeSchedule.Value = 0, 1, Fields!FeeSchedule.Value)) * 100) actually ever since I changed my format to #,### I think that's the problem figured it out.  It is not obvious in BOL (at least what I read on the lousy BOL for SSRS 2005 - lack of thorough content in SSRS 2005 BOL pages) that you can combine N and 0 so N0 did the trick for th ...Show All

• MaheshKshirsagar Job fails for package containing Script Task with error "The script files failed to load."

  I have developed an SSIS package that includes a Script Task on a 32-bit machine. The PrecompileScriptIntoBinaryCode property is set to True. After I build the package, the .dtsx file includes a <BinaryItem> element for that Task. Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job. When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio. ...Show All

• JND Session based DEFAULT_SCHEMA

  Hi, My idea was to use schemas as virtual databases inside one SQL DB where tables from dbo schema will be shared for other schemas. I can change the user default schema with: ALTER USER MyUser WITH DEFAULT_SCHEMA = dat1; or ALTER USER MyUser WITH DEFAULT_SCHEMA = dat2; and in reporting tool simple query SELECT * FROM MyTable retrieves data correctly from dat1 or dat2 schema as defined by DEFAULT_SCHEMA. But this solution do ...Show All

• Jul After Installed sql express sp1, install sql sp1 error.

  setup support flie error. the error logs same as http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=363163&SiteID=1 Could you please postthe setup log files http://msdn2.microsoft.com/en-us/library/ms143702.aspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ok! thank you very much. ...Show All

• Seadap Domain - User Data Types

  Hi, I'm new in MS SQL Server; comming from Firebird and PostgreSQL. I'm trying to import the SQL Script of a database I have in PostgreSQL 8; one basic SQL functionality is the "domain", as the way to create a user datatype; in my database I have one basic domain: OID: CREATE DOMAIN dom_oid AS numeric(18,0) DEFAULT nextval('oid_secuence'); Is there a similar way to create this kind of types in SQL Server Thank you, Guillermo ...Show All

• The Markus reporting services document doesn't load

  when i try to view a reporting services document from the client pc to server's report website, the report attempts to load and just returns an empty screen the report works when i access it through http://reportservername/reportserver it does not work when i use http://reportservername/reports it also works both ways when i'm on the server's desktop but it does not work from my laptop am i missing a security setting the logs show nothing a ...Show All