Answer Questions

• # broxi # SQL 2005 Express not for Windows 2000 Professional????

  I read that SQL 2005 Express will not work on Windows 2000 Professional but the other version will work on Windows 2000 Professional as long as it has SP 4. What sense does this make and it sure hinders design of applications since many of our customers still use Windows 2000 Pro. Well I found this http://support.microsoft.com/default.aspx scid=kb;en-us;910229 Looks like the documentation lacks critical detail. It would make sense that ...Show All

• Jay McCleery - jaysonm Error importing data from oracle database to an SQL database

  Hi! When i was importing a database table from an Oracle Database to a SQL database table, the wizard returns this error: Could not connect source component. Warning 0x80202066: Source - VB_PERMISSIONS [1]: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string ...Show All

• Joe Rohde - MSFT SSIS CAL licensing

  Hello, How does licensing of SSIS work on a CAL basis As far as I'm concerned there are no users of it per se cos its a back-end process. Therefore, do you only need one CAL Thanks Jamie   Microsoft has a department that you can call free of charge that will answer this type of question. It felt a little like "poking a bear with a stick" when I called a few months ago. However, they were very helpful. B ...Show All

• Sinatra Multiple MDF in SQL Express?

  Dear all, I have the following questions about SQL Express: 1) Is it possible to use multiple MDF files simultaneously 2) If 1 above is yes, the limit of 4GB of data storage is limited to each file Or the limitation if apply to the SQL Express as a whole 3) Can I have different locale for each MDF files (say, one in Chinese, one in Korean and one in Japanese) Thanks in advance Raymond Ok i didn't read very well the ...Show All

• PeterM SCD Wizard

  I have created a dimension table for a star schema and included the following columns for treatment of historical changes: [StartDate] datetime, [EndDate] datetime, [Current] varchar(5), [IsInferred] bit My Business key is code and the historical attribute is code_desc. I run the wizard and nominate the Current attribute to be set to True or False. What should the type of this column be as it is not being populated TIA, Mi ...Show All

• PParisot Tell to split on change of ID

  how can I tell the conditional component to split the records based on change of hdr_HeaderID http://www.webfound.net/split_on_headerid.jpg let me know if you need more info...   The first 2 posts here may help: http://blogs.conchango.com/jamiethomson/search.aspx q=multiple+output&p=1 There's plenty of other stuff on my blog in regard to script components with quite a few downloadable examples as well. -Jamie ...Show All

• David Harris How can i check if Notification Services engine components is insalled or not?

  I have installed the SQL Server 2005, including in the installation the notification serviceis, I want to check that Notification Services engine components is insalled, how can i do that ! Do you see Notification Services in the Object Browser of SSMS You can right click on it, select List Versions, and see more information. HTH... ...Show All

• Apolo H Ready for Production?

  I must release a new Db on 4/1 into an isolated small network (pier workgroup) and my choices are MSDE or Express. I'm new to both (MSDE yesterday, Express today). I am familiar with SQL Server and prefer using the tools with Express, but i s it stable enough to use in this type of production environment Yep, I think it's stable enough, we went live a month ago with a shrink-wrapped product using SQL Express ...Show All

• Keith Ball Report Builder fatal error

  and yeee it’s me again :-) cannot load the report buider from http://localhost/reports result is always: Source: .NET Runtime 2.0 Error Reporting EventID: 5000 EventType clr20r3, P1 reportbuilder.exe, P2 9.0.242.0, P3 4258a543, P4 reportbuilder, P5 9.0.242.0, P6 4258a543, P7 3558, P8 b, P9 system.argumentexception, P10 NIL. any possibiblities to solve this kindest regards from austria Irie Mikky hello brian, thanks for your response, ye ...Show All

• JimmyV Concatenating Numeric Fields

  Friends, I am attempting to concatenate two numeric type fields together with character data and the query is adding them together. I am assuming I need to convert the ints to a string type but would appreciate some info on the best way to do this...I am sure it's something simple but am not finding much on the web about it. SELECT vehFacID + '-' + vehID AS vehNew FROM Vehicles Returns the sum of vehFacID & vehID. Doh! ...Show All

• NinjaCodeMonkey How can I turn off the encrypted login feature?

  Hi all. My question is, is there any option that turning of the login encrypt I've read many post that they said the login encryption is always on and can't turn that off. With MSSQL2K, I made some program that audit who try to login and when and access which db. But I can't check with MSSQL2K5 because the server and client always encrypt the login info (via TLS ) Someone said that profile the client but when the site is busy, that feat ...Show All

• Matthew Hunter Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• Ashish Kaila 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

• Argh For Loop container - out of memory condition

  Just  upgraded to the June CTP and having problems executing packages that loop using a For Loop.  The first pass is fine but when trying the second we get: Error: 0xC0208296 at LeaseFact Update, Sort 2 [5197]: The input buffer could not be cloned. An out-of-memory condition occurred or there was an internal error. Error: 0xC0047022 at (name of data flow), DTS.Pipeline: The ProcessInput method on component "Sort 2" (5197) failed wi ...Show All

• Craig Bye TRANSACTION

  Hi everyone, I have some doubts about Transact keywords. At the below snippet, transact is used for also error handling and as I understood that when the error occured in the transaction scope, the error is caught and then managed in a desired way. for instance, at the below snippet, the programmer catches and manages the error by first printing a message and then rooling back the execution(Stopping(ending) the execution).So can it be said that ...Show All