Answer Questions

• chrisryp Debugging DataFlow components

  I'm trying to do design time debugging of a dataflow component that I developed. I'm clearly doing something wrong, but I can't figure out what so I'm looking for suggestions if anyone has had a similar issue. The reason I think I doing the steps correctly is that I can debug other components. However, that set seems to be limited to those developed in C#. My component is developed in VB. Shouldn't matter, I wouldn't think. As a test I tried to debug other VB components from the SQL Server Samples and I have the same problem with them. Last one I tried was ChangeCaseVB. Though I just tried ChangeCaseVS and it didn't stop for me either... The problem I have is when I drop the controls onto the design surface in the second instance ...Show All

• magr40 Cannot connect to SQLExpress

  Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server ------------------------------ Cannot connect to YOUR-4105E587B6\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink ProdName ...Show All

• Vijay TV Exclusive Row Locking in SQL SERVER 2000

  Hi I have a table with 1 million records. I Have 5 applications (identical) that read from that table and perform the actions. Now, I want an exclusive locks on the data selected. The sql statement is below. select top 1000 * from Numbers With (***I need this part *** Exclusive lock on the selected data, not allowing other apps to even read) where IsSent = 1 How to achieve this. Please explain. Regards, Noorul Thanks Uma, Ok, if that would consume more resources then how about splitting the table into 5 tables (with no repetition of course) and using those tables If so, then could you provide me the code to how to split the tables plz. I am relatively new to SQL Regards, Noorul ...Show All

• Arnie Rowland Problem with merge replication publication

  How can I go about solving this error Your help is kindly appreciated Thank you Creating Publication - Creating Publication 'SQLMobile' (Error) Messages * SQL Server could not create publication 'SQLMobile'. (New Publication Wizard) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Invalid object name 'dbo.sysmergepublications'. Publication 'SQLMobile' does not exist. Changed database context to 'SQLMobile'. (Microsoft SQL Server, Error: 208) I got it run on the emulator and it states that cannot connect with current connection settings. I had ...Show All

• Martinp23 I use the newest version JDBC, but still return no suitable driver error

  Hi. I am using the following statements to connect my SQL Server 2005 database: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); con = DriverManager.getConnection("jdbc:sqlserver:172.16.0.5//:1433; DatabaseName=Security", "pasw", "pasw"); These code works for couple months, and later on, it returns "java.sql.SQLException: No suitable driver" Error. Then I download the jdbc driver from MS for SQL Server 2005, but it still return such errors. Also, here is one sample way to connect using SQL 2005 driver: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection conn = DriverManager ...Show All

• Mr_White How do I create a checkpoint file?

  hi everyone, Does anyone ever used or created something like that What kind of format it might be and so on... TIA Ok about the format but I'm looking for any sample of that XML file or how to build it from an editor. Why would you want to create one manually SSIS creates and maintains checkpoint files as required, if you have enabled the relevent options. SSIS then uses the file if available to restart from the point of failure, in a given state. If you want to see what a file looks like, use a package to create it for you. You could set a breakpoint to pause execution, or get a task to fail, and then go in a manually open the file that has been created. Thanks for that. XML format   ht ...Show All

• Kevin Rodgers What data type to save GPS coordinates in a data table.

  I am working on a program in VB 2005 in which i want to store and retrieve GPS coordinates. I am not sure which data type is the best to use to enter Latitude & Longitude numbers and maintain their proper integrity. Like LAT ( N38 28.025' ) and LONG ( W105 52.098' ) The numbers will be entered by the user and that format can be maintained, but how to re-enter & or insert them into the database using the same format is my real question. I hope I have explained this right. The numbers in BOLD are what I need to maintain. Thanks for any help in advance. Steve Hi Steve, are you using SQL Server 2005 YOu could create your own data type for that ! I am not quite sure if since now anybody did already one for tha ...Show All

• Corey Furman Configuring SQL Express -- getting login failed exception

  I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed.  When I attempt to open a database from an ASPX page, I'm getting an exception with the message: "Cannot open database "Tasks" requested by the login. The login failed. Login failed for user 'MYDEV\ASPNET'." I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.  For your information (in case it makes any difference), the computer is connected to a domain.  And the authentication methods for the virtual directory (in IIS) is configured for "Anonymous access" and "Integrated Windows authentication." Does anyon ...Show All

• arsonist SQL 2000 Replication Status Question

  Hello, I'd like to be able to poll a SQL 2000 subscriber database to obtain the current replication status. For example, I'd like to know when the subscriber is sitting idle (e.g. "waiting for changes..."), when it is actively replicating (e.g. "applying script..."), or when it is in an error state (e.g. "The Merge Agent failed..."). I realize I can query the table MSmerge_history which contain a comments and error_id field that may be useful. However, there is no status field that I could easily code against. Does anyone have any ideas hi, you can check the sysjobhistory table in the msdb database regards, joey Isn't there a runstatus column in MSmerge_history See BOoks ON ...Show All

• Sweed Datareader Destination as source for other datareader source ?

  HI! as far as I know from docs and forum datareader is for .NET data in memory. So if a use a complex dataflow to build up some data and want to use this in other dataflow componens - could i use data datareader source in the fist dataflow and then use a datareader souce in the second dataflow do read the inmemoty data from fist transform to do fursther cals how to pass in memory data from one dataflow to the next one (i do not want to rebuild the logic in each dataflow to build up data data Is there a way to do this and is the datareader the proper component (because its the one and only inmemory i guess, utherwise i need to write to temp table and read from temp table in next step) (I have only found examples fro .NET VB or C# ...Show All

• MrJP Unable to install SQL Server 2000 evaluation version

  I know this is old database but when I download this evaluation from microsoft website, I got problem installing it. First, I unzip it. By default, it is unzip to C:\SQLEVAL. Then, I went to install it. I don't which file I should click. So, I double click the autorun file. When I did that, there is a screen, I saw the screen saying "microsoft SQL Server 2000 Evaluation version". Then, I click "SQL Server 2000 Components" Then, it comes to next page, and I click "Install Database Server". But after I did that, nothing happens! After I click again the same thing all over again, it says "Another instance of setup is already running". I'm using Window XP Professional. Anyone encounter this problem ...Show All

• fbalas printing error

  Hi, some of my application users doesn't have Admin Privileges to their machines. When they try to print the reports, its giving a message "Unable to load client print control". Please help me how to solve this problem Can you login as an admin and print a report I believe that the first time you try to print any report, it installs the print controls. Then you can log off and let the user back in. This way, the print controls would be installed for the user the next time they need to print. Hope this helps. Jarret ...Show All

• MuscleHead Excel export problem

  I have a report that the users want to export to Excel. One of the problems that I am having is that some of the cells in the excel export are renamed as _402, _404, etc. I want them to come in as B22, B24, etc. Any idea why this is happening and how I can stop it Joe The Excel renderer gives unique names to cells that are the operands of formulas. Then, the formulas reference those unique names instead of the cell addresses. This is by design and there is currently no way to export live Excel formulas without using those unique names. That feature is on our list of hopeful features for a future release. If you want to get rid of formula export entirely and just have the calculated values put into th ...Show All

• Xelestial Sql Monitor or something to manage SQL

  Hello Everybody: I need something to manage my querys in SQL server 2000. I dont know how to make a graph of the querys from the users, or make some kind of report of store procedure (user's store procedure, querys, etc), and i'm not talk about Performance Tools of Windows 2000, i need something more complete and visual. any information about this will be very useful. thanks Right...i need something like "Performance" of windows 2000, but more complete..any info about this can you be more specific about your requirements it sounds like to me that you want a report of queries being ran against your server, but I am not sure here is a list excluding Windows PerfMon of t ...Show All

• bud1024 Table visibility

  Hi, I have a table in my Sql report which dynamically displays data .If there is no data in the dataset i don't want that particular table to be shown.How do we do that / There is a "No Rows" property in the table which can be used to display some information instead of the table, you can also use Something like " " in there. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- What about using the =IIF(COUNT(Fields!ID.Value, "DataSet1") = 0, True,False) on the Visibilty hidden property of the table by querying the dataset for available rows HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All