Answer Questions

• Alexandre Mineev MSFT SQL Db and attachments

  What kind of field type is used to store attachments as part of a record in SQL server database I am not sure what you mean by attachments. If you're talking about large binary values, you should consider using varbinary(max) which allows you store large binary values (up to 2GB). If they're smaller than 8kb, then you can use varbinary(8000). ...I think you should find a SQL S ...Show All

• Eugene Dorofeyev Allowing no selection in dropdown boxes

  If i have multiple values in a dropdown but not allow mulitple selection, it makes me select a value . I am writing a search report where that field can be left blank Is there a way to do this ...Show All

• Rafiq SQL Server 2005 mobile edition

  I am considering upgrading to 05 mobile on a pocket pc, Does anyone know if you can pull table data from A visual fox pro table to 05 mobile database ...Show All

• dolf degenerate dimension and partitioning

  I needed to provide drill down to some granular attributes, so I setup a degenerate dimension with several attributes like serial_number, etc. Doing so has somewhat understandably caused my processing time to increase from 2 minutes to 45 minutes for my sample set of data. To handle this increased processing time, I'm attempting to use partitioning. Now, the trouble I'm running into is how do I process the degenerate dimension in step with th ...Show All

• Michael Blome Problem converting VS2003 code to VS2005

  Hi: I am trying to convert my VS2003 project to VS2005 beta 2. The actual conversion has gone fine, but some code that was working fine under to old IDE is now giving me an exception when run under the VS2005 generated code. The code is: using ( SqlConnection conn = new SqlConnection ("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GestionNET00001;Data Source=localhost" ) {   ... } And the error I'm getti ...Show All

• Grant Holliday Does anyone have a script to reset SQL login passwords?

  We are doing a consolodation whereby we are pulling 2 servers into one big one. We have a problem with duplicate logins and differing passwords. I want to be able to cursor (or tran ) through a list of logins resetting their passwords to a default. This will currently run under SQL 2000, but I may want to do it on our 2K5 server at some time - I feel the second part may be more difficult though. Does anyone have a script lying around in th ...Show All

• Rami Reddy sql transaction

  I have created three stored procedures. Each one has a begin transaction and commit transaction and in the begin catch statement it has rollback transaction. i.e. create procedure sp1 as begin try begin transaction insert into table1(field1) values('field1') insert into table2(field2) values('field2') end transaction end try begin catch rollback transaction end catch -------------------------------- create procedure sp2 as ...Show All

• JohnHappy SSIS XML Source with random child ID??

  Hi, I am trying to load a XML document using SSIS into relational tables and pulling my hair out. In it's simpliest form I have: <Batch> <POSBasket> <Header> <SomeDetail/> </Header> </POSBasket> <POSBasket> <Header> <SomeDetail/> </Header> </POSBasket> </Batch> Now, when you have a parent child situation, you ...Show All

• John Butare 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

  64 bit Server 2003 with Sql 2005 64-bit I can't seem to do a lot of things. Like... backup the database through the SQL agent. I'm catching flak from the client who was told by a microsoft rep that SQL 2005 works like a charm.... It's too late to move away from SQL 2005, we've already migrated systems over to it, and now I'm stuck. This error happens when trying to export to a flat file using Export Wizard(right click database and choose export ...Show All

• PAS30339 3753 Provider is not specified and there is no designated default provider.

  i just bought a brand new server and put windows server 2003 x64 sp1 on it then put sql server 2000 sp4 on that and set up a trusted odbc connection. however, it gave me the following error: SQLSTATE:IM002, diagnosis:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified so i made a vbs file (adodb.connection) to see if that could connect to it and it came out with this on the err.number err.description er ...Show All

• Billy2005 Counting no. of records

  Hi I need the ability to calculate the no. of records based on the no. of times a value in the sql report is given. For example based on a table shown below: Ref No. First Name Surname 18 test test 18 test test 18 test test 19 test test 19 test test I need to calulate the records returned on the ref no. I have managed to set page breaks based on a new ref no. with grouping and therefore the count will be disp ...Show All

• portlond SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• step Updates to SQLServer 2000 DLL's when 2005 client tools installed

  Hi, I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc. I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server. So, I have dev edition of sql 200 ...Show All

• Anar Lookup Tables And Joins

  In a table I'm storing as integers recCreatedBy and recModifiedBy values; I have a lookup table I'm doing an INNER JOIN with to pull a string value for an Alias 'CreatedBy'.  I'm trying to Alias a 'ModifiedBy' from the same lookup table in the query.  Any help would be greatly appreciated. SELECT     tblStaffPhysicians.docIndex, tblStaffPhysicians.docFullName, tblUsers.userLogin AS CreatedBy FROM &nb ...Show All

• CoderJames Strange issue with Precedence Constraints and Set Values

  Hey everyone, I have used the set values option of the execute package utility many times to change values on variables in the package with no problem before, however have run into a stumbling block when coupling this with precedence constraints. I have a package that goes down a different path based on a precedence constraint that works perfectly if the default value of a variable is used....however when I pass in a new value via Set Values in ...Show All