Answer Questions

• septembereleven VS 2005 Invalid database version SQL CE

  VS 2005 windows application SQL CE 2000 dim strSQL As String Dim ssceconn As New SqlCeConnection("Data Source = c:\atisoft\atisoft.sdf") ssceconn.Open() Dim sqlInsertRow As SqlCeCommand = ssceconn.CreateCommand() Invalid database version. [ Db version = 0,Requested version = 0,File name = c:\atisoft\atisoft.sdf ] Hi , Ilya The provided link was absoultely help full for converting the old databse to the l ...Show All

• Achileos failed to connect to the server

  When I have a subscription built for a report it runs at the time expected, but the report send via e-mail fails. I can run the report from a client workstation just fine. I can also run it from the admin tool fine too, it just will not run as part of a subscription. The full context of the error message is as follows: Failure sending mail: The transport failed to connect to the server This is not my first Reporting services report, but I ...Show All

• Claude Vernier How to launch programatically a SSIS package?

  Dear all, I wrote this post others times but the answer did not satisfied so that I'd like to know if really anyone has ever used or experienced with this possibility. No by .Net language rather than Vb 6.0 or ASP or even instanciacing DMO library. According this link http://support.microsoft.com/ kbid=817248 it seems possible but I haven't idea if possible keeping in mind that it has been made by yourself no for others... So that, I mean, ...Show All

• stanb Performance, handling 1.2 million rows takes 7-8 hours?

  Hi! I'm working on a project restructuring some data using SQLIS. The problem is one package that is handling about 1.2 million rows takes about 7-8 hours to complete. To my question, is there any of the dataflow components that are know to be slow that you should avoid regarding performance issues The following list is a brief specification over the component that are contained in the package: --------------------------------------- ...Show All

• mr hamed need to edit .sdf files from local desktop

  I am needing to know if there is a way to edit .sdf files from my local desktop ( I need to copy the .sdf file to my local machine and edit the information if necessary) Our mobile devices use SQL CE 2.0. Thanks for your help the best tool I have used is at www.primeworks.pt though there are others that are also well suited for this. Darren However, you can use SQL Mobile/Everywhere 3.0 both on desktop and device. Than ...Show All

• JDSS Export a report to Excel : Data in a column become several columns

  Export a report to Excel : Data in a column become several columns When i export a report to Excel, the problem is coming, the report data that is in a column become several columns in Excel. Why the problem happens How to solve it. I have solved this problem! The solution is simple : i made the header's width equal to the body's width! [ May i ask some questions about you: Fang Wang is seemed to a Chinese name[王芳or王方]! Ar ...Show All

• Kawarjit Logon Failu unknown user name or bad password - using xp_cmdshell or bulk insert

  We had some SQL Server automated web routines that stopped working when some security patches were applied either to SQL Server 2000 or Windows Server 2000. The Web users would upload a file to a directory on the web server. Then a Stored Procedure would be executed that would do a bulk insert into our SQL Server table. The bulk insert now fails giving this error #1326: Logon Failure: unknown user name or bad password. It used to work flawlessl ...Show All

• Symon Buck Any solution for that?

  I've got a .dts which load data to several Sql2k servers by Copy SQL Server Objects Task. I'd like to add another task for a Sql25k but I can't because of it's requesting SMO. It seems that such task need DMO. I know that there are other ways for do such stuff in that DTS but I wonder if there is any trick or shortcut for to avoid this barrier. How odd, if you use Dts Import/Export Wizard from EM sql25k is accepted. ...Show All

• CarlosCNS 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

• anonymizer How to find which stored procs and UDFs reference a column

  How can I list the stored procedures and user-defined functions that reference a given column I could search ROUTINE_DEFINITION in INFORMATION_SCHEMA.ROUTINES for '%MyColumnName%' but MyColumnName is not always unique. Thanks. The depnumber column in sysdepends should give you the column id of the table that the procedure/function references. You can modify your query above to also join the depnumber column in sysdepends with the id c ...Show All

• Matevz Gacnik problem with connecting to Sql Server 2000 from a mobile device

  Hi, I'm using SqlClient connection class to connect  via IP address (wireless connection) from: Windows CE 4.2 / .NET Compact Framework v1.1 to: SQL Server 2000/Win XP sp2 The connection string has a form like this one: Data Source=190.190.200.100,1433;Initial Catalog=MyDB;Integrated Security=false;User ID=sa;Password=; I succeeded to install SQL Server 2000 and to establish connection with the mobile device on my PC . But when ...Show All

• alleh Convert SQL 2005 to SQL 2000

  I started a project using SQL 2005 and now the customer has decided they can't go to 2005 yet so I need to convert it back to 2000.  I didn't use any new features of 2005.  How do I move it back to SQL 2000 On the script side, I looked more closely and I think the (IGNORE_DUP_KEY = OFF) syntax is incorrect. I believe you either have IGNORE_DUP_KEY specified or it is absent (which is the equivalent of OFF). Another way you co ...Show All

• Dinesh Reddy N Y Report Designer Sorting in Details Group?

  Can you specify the Sorting in the Details group in reports designed with Report Designer   If so how I know that I can set the Sorting in the Details group in reports generated with Report Builder (the Sorting element is a child of the Details element). Thanks!!! -Brian To display the Table Properties dialog: 1. Click the table so that column and row handles appear above and next to the table. 2. Right-click in the upper-left hand c ...Show All

• Joshua07 Report Table Question

  I have a report that contains 3 tables. I want to create a 4th table that contains data from the 3 other tables. Is there a way to reference the value from one of the other tables' textbox in my new table. All of these tables are contained in the same report. The 4th table is basically a summary of the other three tables. Thanks in advance. I've done this before. You have to name the text box that you are referencing first in its n ...Show All

• Jeffrey De Pretre How to change default script generation options in SQL 2005 tools or VS 2005

  Ok, this has been driving me crazy in both SQL Management Studio and VS 2005 Server Explorer. How do you change the default script generation options When I right-click a stored procedure, table, etc. in the SQL Management Studio's Object Explorer, or in the VS 2005 Server Explorer and choose to generate a create script for that object it does not prompt me for any scripting options (like do I want to script dependant objects (where my answer i ...Show All