Answer Questions

• Tecumseh Microsoft VBScript runtime error '800a000d'

  Hello, I all of a sudden seem to be getting the following error: "Microsoft VBScript runtime error '800a000d' Type mismatch: 'QueryString' /admin/equipment/addequipment.asp , line 128 " I am running an intranet site desgned on dreamweaver using SQL Server 2005. I have a page where I can update equitement, all the other equipemnt links work fine but it won't let me update this one. The section in dremaweaver it refers to is: Dim equipspec__urlid equipspec__urlid = "1" If (QueryString("ID") <> "") Then equipspec__urlid = QueryString("ID") End If %> <% Dim equipspec Dim equipspec_numRows Set equipspec = Server.CreateObject("ADODB.Recordset") equ ...Show All

• h1 oracle oledb provider not registered in local machine

  Hi, I am trying to establish a connection to an Oracle database using the following code in a script task: Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=DBxxx;" & _ "User ID=Userxxx;" & _ "Password=Passxxx" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() When I execute the script task, I receive the following error: The 'OraOLEDB.Oracle' provider is not registered on the local machine. Am using the correct provider I do not know how to resolve the said error. Here are some facts: Oracle 8i is installed. Tnsnames.ora is updated. I have successfully ...Show All

• Karin Huber SQL Server 2005 Hanging - Selecting uncommitted data

  We have found an issue with using MSS 2005 with odbc connections, some of our code inserts data, then reselects the data back with a select using a different handle. This hasn't caused any issues before but in one customer this causes a lock up. The timeout error doesn't occur as you would expect if trying to select data that is uncommitted by another user. Although obviously we could re-code to avoid selecting uncommitted rows, can anyone tell me why this works sometimes but not others. Some kind of setting in MSS that we're unaware of maybe. The code works ok on other MSS 2005 & MSS 2000 servers and oracle & sqlbase. Hi, are there differences in ConnectionPools / Queries Hints or lock be ...Show All

• ron nash Filtering on primary key (lots of them) SQL 2000

  Hi all I have around 250 primary keys and I want to retrieve all of these records from our SQL Server 2000 database, this query takes around 15-20 seconds, and my approach is to construct an sql that unions all of these 250 queries together, here is the sql that will be unioned: select [ServiceUser].* , [ServiceUser_Data].[item] Link_Data, [ServiceUser_PrimarySource].[item] Link_PrimarySource, [ServiceUser_OtherSources].[item] Link_OtherSources, [ServiceUser_Duplicates].[item] Link_Duplicates, [ServiceUser_DuplicateKeys].[item] Link_DuplicateKeys, [ServiceUser_Master].[item] Link_Master, [ServiceUser_QualityChecks].[item] Link_QualityChecks from [ServiceUser] left join [ServiceUser_Data] on [ServiceUser].[gu ...Show All

• Abhishek bhadouria SQL 2000 SP4 performance monitors over Windows 2003 X64 Edition

  Hi to all: I have recently migrated our SQL 2000 to a W2003 x64 Enterprise Edition, and I'm trying to save performance counter to document performance. I've started C:\windows\SysWOW64\perfmon.exe and I'm able to see SQL counters, but when I try to save a new Counter Log for later analisys, no SQL performance counter are saved only windows counters. It seems that only x64 counters are saved and not SQL Server (SP4) counters. I've have searched all the web trying to find some help but I wasn't able to find any solution. Can anyone help me with this thanks in advanced. -- Rodrigo Acosta ...Show All

• vkv Tricks with IN operator

  I suppose to write query using in operator which contains dynamic values. declare @var varchar(30) set @var = '''anatr''' + ',' + '''alfki''' select * from TableName where ColumnName in (@var) Above written batch doesn't returns any values, whereas below return query returns value select * from TableName where ColumnName in ('anatr','alfki') What would be the problem.. Thanks sandy. It works fine. Hi Manick When you are trying to use multiple parameter values concatenated into one variable try to use 'Exec' In your case it should be : declare @var varchar(30) set @var = '''anatr''' + ',' + '''alfki''' Exec('select * from TableName where ColumnName in(' + @var + ')') It works for me .Hope it works for you t ...Show All

• jamesIEDOTNET Replication Error 28559

  We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication). We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition. I had a chat with one of the Micro ...Show All

• bkejser passing a timestamp datatype column to a variable and back

  After several hours of trying, I trow the towel in the ring and come here to ask a question. Source system uses a timestamp column in the transaction tables. which is equal to a non-nullable binary(8) datatype (sql 2000 bol). What I want to do is get the timestamp at the start of the transfer and at the end of the transfer of data. and store these in a controltable I try to do this in 2 sql execute tasks: sqltask 1: "select @@DBTS AS SourceTimestamp" and map the resultset to a variable. Here come's the first problem what variable type to take DBNULL works (meaning it doesn't give errors) (BTW: is there a way to put a variable as a watch when debugging sql tasks ) INT64 and UINT64 don't work error message that t ...Show All

• imdqa Database Diagrams tool

  When I use the sql 2005 "Database Diagrams" tool for the first time I always get the message: "The Database does not have one or more of the support objects required to use database diagramming. Do you wish to create them " 1. Does anyone know what the " support objects" referred to are 2. Why SQL doesn't automatically create these support objects for me (e.g. do they require a lot of hard disk space so they shouldn't routinely be created ) 3. Is there any way to make Sql automatically create them If you can address any of these points I'd appreciate it. TIA, barkingdog As noone prevents you from scripting the stored procedures and related obje ...Show All

• redshock Delete sys.Transmission_Queue

  I have seen this buried deep with the questions on Service Broker, but I am looking for it again. How do you delete all records from your sys.Transmission_Queue. This is on a test server and I want to clean it before some more test. alter database foo set new_broker; ...Show All

• Amde SQL Server Management Studio 2005 "is Busy" message when trying to save a database diagram

  Hi, I like to add new tables and their relationships with each other using the Database Diagram.  I create a new database diagram, and then add new tables to the diagram – also drawing up their relationships with each other.  When I click Save, SSMS seems to hang for a very long time with the Save icon flashing in the bottom right corner.  When I try to do something in SSMS, I get a popup message stating "is Busy". I work on a fast-enough computer, and saving the changes I made to the diagram pane (even if I just added one new table), sometimes literally takes 5 to 10 minutes to complete. While this is happening, a "Delay Notification" icon appears in my System Tray with the same "is Busy" message.  The comple ...Show All

• ron nash Impact of SELECTed colums on the execution plan

  Hi guys, I have something weird that I want to understand. I have a big table, containing around 17 millions of rows. This table has been progressively indexed over time, mainly by following some of the recommendations of the DB tuning advisor. As a result, we have around ten indexes on this table, some of them are using the new "INCLUDE" feature of SQL2005 indexes with non-key data. The problem I have is the following : I have a very simple query (SELECT <some columns> FROM that_table WHERE <simple clause conditions>) which should benefit from the indexes built on the table. But depending on the columns I select, the execution plan varies totally !! With one column selected, the good index is used, and th ...Show All

• Roozbeh Sharafi Auto hide not working properly

  When I start Management studio for the first time on boot the Auto hide (Pin icon) does not work. I have to pin it first and then unpin it to make it work. Initially I thought it happens only on my machine but same thing I tried on couple of other machines. Happens only with Object Explorer not with Properties pan. All these machines have good primary 1GB RAM and processing power Intel dual core CPU 1.60 Gz. It is very minor issue but little annoying! Anyone else experienced similar behavior Using MS SQL Server 2005 EE There was a glitch (technically speaking) with the Connect site. It appears to be back up and functioning as expected. I found your posting: https://connect.microsoft.com/SQ ...Show All

• Chaitanya15 Runtime temporary table in SQL2000

  I am trying to create a runtime temporary table at SQL2000 server in my VB 6.0 program. However, I am keeping getting "object not found" error from my program when I trying to issue a SELECT or INSERT statement in my program. Can anyone shows me how to do it properly. I thought I can create a temporary table with a # prefix as a table name. Am I correct Help is very much appreciated. John Tsoi John, Can you paste the code that you are using to perform this task. The temp table you are creating are only accessible on the connection on which they were created. So it might be the case that you are using another connection to perform the select. Are you using ADO What provider are y ...Show All

• Akbur SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana Trim is a character function that you can use in the expression of a derived column transformation. That might help.   When  using 'Data Convertion' between 'Source table' and 'Destination table' by SSIS, some data could not be transfered to 'Int' or char(1) from Varchar(200). In fact, 98% of them should be int or char(1) or null.  I tried to 'redirect  row' the rest 2% to a wrong table. However, all data went to the wrong table during 'Data Convertion'  and nothing went to the destination table.   I checked the ErrorCode is :   0xC020907F ...Show All