Answer Questions

• TopTN Sql 2005 SP1 (x86) upgrade failed....

  Installed sql 2005 sp1 on standalone Win 2003 Server box in workgroup. (sql 2000 is default instance, sql 2005 is named instance and sql 2005 Express is floating around somewhere).). Box does not have any prior CTP SP1 versions. When I reach the "Authentication Mode" dialog during the SP1 install, and click Next, I get "Your account information could not be verified for one or more instances. Ensure that you ...Show All

• Shete General Network error

  I am using Windows Form with web service, I am getting error ocassionally when I am accessing records " System.data.sqlclient.sqlexception General Network error " , When I click again the error disappears. The information here is really not sufficient for us to help figure this out.  Can you give us some more detail as to what your configuration is   Are you running .Net 1.1 What version of SQL Server are you running It c ...Show All

• jarnaiz SQL CE Push ConnectTimeout

  My application synchronises data with a SQL Server using RDA, the synchronisation process take place in a background worker thread. Due to the single connection limit with SQL CE 2.0 the form thread has to wait until the synchronisation process completes before connecting to the database to perform any updates or inserts. Normally the RDA push method executes quickly and the delay on the form thread is not noticeable. However CPU usage on the S ...Show All

• HariValath "The statement did not return a result set" error on SPs with exec

  I'm trying to modify our application to use the SQL Server 2005 JDBC driver. After making the appropriate changes most stuff seems to work OK, except for any stored procedures that contain an exec statement and return a result set. When the stored procedure is called with executeQuery it throws a SQLServerException with the error "The statement did not return a result set". Other query SPs that don't have an exec work just fine. It doe ...Show All

• Tùng linked server exec stored procdure results in Transaction context in use by another session.

  I am using sql 2005 beta Microsoft SQL Server Management Studio (expires in 355 days)      9.00.1116.00 Microsoft Analysis Services Client Tools      2000.090.1116.00 Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML      2.6 3.0 6.0 Microsoft Internet Explorer   ...Show All

• gowrishankar lookup and commit; How it works

  Lookup and commit; How it works I am importing data from text file and I have data lookup to check reference table. If the reference row doesn't exist I want to add row to reference table, other wise row is added to the detail table. I am using oledb destination to saving reference table row with rows per batch to 1 and maximum insert commit size to 1. When I run the package duplicate rows are in grid view. How can duplicates end in the ...Show All

• imkamran Can't Create New Database on Device via ActiveSync

  In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition--> ActiveSync  Connected Device when I hit Test Connection I hear ActiveSync's connect sound and I get this error Microsoft Development Environment Microsoft 5QL Server 2005 Mobile Edition and/or NET C ...Show All

• Atheist Where is Service Manager in SQL Server 2005?

  I installed SQL Server 2005 CPT on a new machine running XP.  I do not see SQL Server Service Manager.  Has something changed in 2005 over 2000   There are times when it is necessary to stop the database.  The old way you just clicked on the icon in the lower right of the PC (with the green arrow) and selected stop.  I realize I can go into XP Services, find SQLServer2005, right click and select stop, but is there some ...Show All

• Niram SQL 2005 Supports strongly typed variables/parameters?

  Hi, Does SQL Server 2005 support strongly typed variables/parameters i.e can we have a stored proc with input parameter that directly maps to a table column similarly also for local variables.. makes the tables the only point of change when datatypes in tables change Or as a workaround, can we define a UDT that can maps directly to a table column and then use that UDT in an SP parameter No, we do not suppor ...Show All

• WPX Query Question (SQL Noob from MS Access)

  Question: How do you concatinate fields in SQL   I tried in a SQL query, but did not have any success.  I'm coming from MS Access where it is simple to add fields together. *** MS Access SQL *** SELECT Table1.Field1, Table1.Field2, Expr1: Table1.Field1 & " - "& Table1.Field2 FROM Table1 *** END *** You could add fields and put characters between the two different fields like a space and/or some sort of seperation ...Show All

• CrystalDev Using custom cookies

  Hi, We are writing our custom authentication for report server. However, we do not want to use .net generated cookies but our own mechanisms to check for the user and call the logon method etc. What is the right way to go about achieving such a task . Our application, report server both should use the same custom cookie. Thanks. ...Show All

• Schu Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All

• gvphubli Could not load file or assembly ADODB, Version=7.0.3300.0

  I have an application broadly deployed (about 10 computers). As of yesterday, two of these computers are unable to start the application, and failing with the error below. All other computers run the application just fine. System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified ...Show All

• BarryBenight impoert and export data

  where is the import and export data function in sql server 2005 express i have a data in ms access which i want to import to sql server 2005 express.. thank you Thanks for your feedback. Microsoft does have development tools for tranforming data and debugging stored procedures that are shipped with SQL Server 2005 Developer Edition and Visual Studio, respectively.  Management Studio Express is e ...Show All

• xhead Transactional Replication sp question

  Why in some of the MS generated procs is there a secondary create proc statement I believe it has something to do with primary and foreign keys but it is not consistent accross all tables that have primary keys. I have included the code of one of the procs. create procedure "sp_MSins_AH_MEMBER_ALERTS" @c1 bigint,@c2 smallint,@c3 bigint,@c4 int,@c5 datetime,@c6 datetime,@c7 bit,@c8 uniqueidentifier AS BEGIN insert into ...Show All