Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







SSIS Designer Freezing Up When Using The Debug Utility !


I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint ?

If you have any suggestions or workarounds for de same plz do reply

Thanks in Advance
Shailesh


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SSIS DATA Flow Task Freezing
Hi,

I am experiencing an error where the ssis data flow task would freeze and stop data export from a oledb source to a text file. It doesn't generate any errors the ssis package would just hang. This only happens when I run it in 64 bit mode. When I change the mode to 32 bit the ssis never freezes and runs fine. Has anyone experience this? Is there a fix so I can run my jobs in 64 bit mode?

Thanks,

View Replies !   View Related
SSIS - Cannot Debug A Script Task
I am unable to step through (in debug mode) a script task.

Have set breakpoint on first line of script in VSA.  Click Start (in debug mode). Nothing happens.

Have also tried to execute task in control flow of visual studio but it will not stop at breakpoint

 

View Replies !   View Related
SSIS Tutorial Lesson 1: Debug Error
I have followed the instructions for SSIS Lesson 1 exactly but i get these 4 errors when I come to debug at the "Lookup Date Key" lookup transformation. Last step in the lesson.

1. [Lookup Date Key [66]] Error: Row yielded no match during lookup.
2. [Lookup Date Key [66]] Error: The "component "Lookup Date Key" (66)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" (68)" specifies failure on error. An error occurred on the specified object of the specified component.
3. [DTS.Pipeline] Error: The ProcessInput method on component "Lookup Date Key" (66) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
4. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029.

I have tried this on 2 hardware setups and recreated the package several times on both. The only thing i can think of is that the collations on both servers is SQL_Latin1_CP1_CI_AS and British English (I have huge legacy databases from SQL 7.0 and cannot get my tech support to change language settings of server to UK English). Is it possible that this is causing the lookup failure mentioned above (Q1)? How can I change the collation/language settings within the DTS so that the text file matches the AdventureWorksDW database settings if this is the issue (Q2)?

Are the error codes listed anywhere and if not can they be added BOL (Q3)? I have read other threads and they suggest 0xC0209029 means lookup failed due to differing lengths. Can dates have differing lengths (Q4)?

View Replies !   View Related
SSIS && Script Transformation (debug Vs Normal)
I just ran across an interesting problem, that makes no sense. I
built
an SSIS package that updates a column, using an transformation
script.
Testing in Debug mode everything runs perfectly, but when I have SQL
sever agent run the package it insert null into the new column.


Any thoughts or suggestions would be greatly appreciated.


r/ Anthony
 

View Replies !   View Related
Error Running SSIS Pkg From Dtexec Utility
Hi All,

I developed my package in BI studio and tested runnning it through BI. Now when i have to deploy the package to main server it will be executed via batch job. This package requires an input file name too.
Now when i am trying to run the package on my loacal box using following command on command prormpt i get error given below.

COMMAND USED BY ME: DTExec /FILE 'C:ProjectIntegrationServicesSFRIntegrationServicesinpkgSFRLocation.dtsx' /SET Package.Variables[InputParamFileName].Value;'C:DataDumpInputLOC00022'

ERROR MESSAGE:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 1:29:54 PM
Error: 2008-02-22 13:29:54.96
Code: 0xC0011007
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Unable to load the package as XML because of package does not ha
ve a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2008-02-22 13:29:54.96
Code: 0xC0011002
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Failed to open package file "'C:ProjectIntegrationServicesSFR
IntegrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The speci
fied path is invalid.". This happens when loading a package and the file cannot
be opened or loaded correctly into the XML document. This can be the result of
either providing an incorrect file name was specified when calling LoadPackage o
r the XML file was specified and has an incorrect format.
End Error
Could not load package "'C:ProjectIntegrationServicesSFRIntegrationServices
inpkgSFRLocation.dtsx'" because of error 0xC0011002.
Description: Failed to open package file "'C:ProjectIntegrationServicesSFRInt
egrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The specifie
d path is invalid.". This happens when loading a package and the file cannot be
opened or loaded correctly into the XML document. This can be the result of eit
her providing an incorrect file name was specified when calling LoadPackage or t
he XML file was specified and has an incorrect format.
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Started: 1:29:54 PM
Finished: 1:29:54 PM
Elapsed: 0.047 seconds

PLease let me know solution to creating batch job for executing this pkg with input param.

View Replies !   View Related
Package Runs Fine In Debug.. Fails Outside Of Debug
I created a package that runs fine while in debug... but when I run outside of debug (just choosing Debug.. Start without debugging) I get an error of:

     Message: The task "Formulate SQL Query and Destination" cannot run on this edition of Integration Services. It requires a higher level edition.

I am on SP1 on my workstation and the only SSIS server I have.  I am not doing anything fancy in my script..  I have created other packages and ran outside of debug mode without issue.  I did uninstall SQL2005 and SSIS from my workstation as it was eating up too many resources.

The script I am running is (removed some of the SQL etc to shorten it):

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

Public Sub Main()

' Create the SQL

Dim SQL As String

SQL += "SELECT "

SQL += " -- Lots of stuff"

SQL += "FROM "



SQL += CStr(Dts.Variables("gvSourceTableName").Value) & " "

SQL += "WHERE "

SQL += " stuff = '" & CStr(Dts.Variables("gvCurrentSymbol").Value) & "' "

SQL += "ORDER BY date"

Dts.Variables("lvSQLQuery").Value = SQL

' MsgBox(CStr(Dts.Variables("lvSQLQuery").Value))

' Create the filename

Dim Dir As String

Dim FileName As String

Dim FullFileName As String

Dir = CStr(Dts.Variables("gvDestinationRoot").Value) & "" & CStr(Dts.Variables("gvRunID").Value) & ""

FileName = CStr(Dts.Variables("gvCurrentSymbol").Value) & "--.txt"

FullFileName = Dir & FileName

If Not Directory.Exists(Dir) Then

Directory.CreateDirectory(Dir)

End If

Dts.Variables("gvDestinationFile").Value = FullFileName

' MsgBox(CStr(Dts.Variables("gvDestinationFile").Value))

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

View Replies !   View Related
Error Executing SSIS Package With DTEXEC Utility
 Hi All,

I developed my package in BI studio and tested runnning it through BI. Now when i have to deploy the package to main server it will be executed via batch job. This package requires an input file name too.
Now when i am trying to run the package on my loacal box using following command on command prormpt i get error given below.

COMMAND USED BY ME: DTExec /FILE 'C:ProjectIntegrationServicesSFRIntegrationServicesinpkgSFRLocation.dtsx' /SET Package.Variables[InputParamFileName].Value;'C:DataDumpInputLOC00022'

ERROR MESSAGE:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 1:29:54 PM
Error: 2008-02-22 13:29:54.96
Code: 0xC0011007
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Unable to load the package as XML because of package does not ha
ve a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2008-02-22 13:29:54.96
Code: 0xC0011002
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Failed to open package file "'C:ProjectIntegrationServicesSFR
IntegrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The speci
fied path is invalid.". This happens when loading a package and the file cannot
be opened or loaded correctly into the XML document. This can be the result of
either providing an incorrect file name was specified when calling LoadPackage o
r the XML file was specified and has an incorrect format.
End Error
Could not load package "'C:ProjectIntegrationServicesSFRIntegrationServices
inpkgSFRLocation.dtsx'" because of error 0xC0011002.
Description: Failed to open package file "'C:ProjectIntegrationServicesSFRInt
egrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The specifie
d path is invalid.". This happens when loading a package and the file cannot be
opened or loaded correctly into the XML document. This can be the result of eit
her providing an incorrect file name was specified when calling LoadPackage or t
he XML file was specified and has an incorrect format.
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Started: 1:29:54 PM
Finished: 1:29:54 PM
Elapsed: 0.047 seconds

PLease let me know solution to creating batch job for executing this pkg with input param.

View Replies !   View Related
SSIS Deployment Utility - Manifest Doesnt Show Up
When I create a deployment utility I...
- set AllowConfigurationChanges to True.
- set CreateDeploymentUtility to True
- DeploymentOutputPath is set to binDeployment
- I click 'Build' and it creates the binDeployment directory and writes all my DTSX files and my dtsConfig file
But it doesn't create a manifest file. Why not?
Thanks

View Replies !   View Related
Ssis Designer Immediate Window
Where can I find instructions on how to use it?

View Replies !   View Related
SSIS Dataflow Designer Bug
When I drop a new component onto the design surface, it appears with dotted lines around it, as it is selected.

But, the F2 key (the hotkey for rename) does not work.

I have to click on some other component, and then back on the new component, and then the F2 key works.

I remember reporting this bug back in the beta cycle, but it is still present even in the release -- I actually think Ã?'m using the SP1 version of 2005, but see version info below to be sure:


Remote terminal services broke my copy buffer again, as is so often does, so pasting in the version info failed -- falling back to manual typing -- SSIS 9.00.2047.00.

View Replies !   View Related
Enhancement: SSIS Designer
Not quite sure if this is the right place for this comment...

While using SSIS Designer came across a DUE where the package was setup to:

SEQ1 - Truncate staging tables
SEQ2 - Load staging tables (sequence container had been setup to hold multiple data flows)

For some reason one data flow was run before the truncate table sequence.

Looking in the designer it appeared that the dataflow was a member of SEQ2 but looking at the Package Explorer it was outside the sequence container.

It would be good to have some visible indicator  to show that a task is a member/not a member of a container

John.

View Replies !   View Related
How Install SSIS Designer?
Hi,

I have sql server 2005 express and toolkits installed. However, I only see Report Server projects in my Visual Studio 2005 when I choose a Business Intelligence project.

Will someone please help me download the right file to start using SSIS designer?

Thanks,
Jae

View Replies !   View Related
Variables In Ssis Designer
Hi there,
 
I have a script which grabs data from a source server. The problem is I have over 50 source servers, so I have to make a script for each one.. EXACTLY the same code but different linked server address.
 
So I was wondering if i can put the server name into a variable so I only need to make one script.
Is that possible?
 
thanks,

View Replies !   View Related
Visual Studio Output Information In Debug Mode While Running A SSIS Package
Hello

When running a package in VS you can see something like this in the output window:

SSIS package "logging.dtsx" starting.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file.
Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total number of data rows processed for file "C: est ssis loggingad_data1.txt" is 477.
Information: 0x402090DF at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, OLE DB Destination [1011]: The final commit for the data insertion has ended.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file "C: est ssis loggingad_data1.txt" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "DataReaderDest" (87)" wrote 0 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (1011)" wrote 1 rows.
SSIS package "logging.dtsx" finished: Success.

This is exactly when I need when a package is running but I want to be able to see it without using Visual Studio.
I would do it in Reporting Services but I need to find out to get the information. The SSIS logging feature in a package does not provide that kind of info.

Did someone try this already?

Thanks!

Mop

View Replies !   View Related
SSIS Deployment Utility - Package Configurations Doesnt Show Up??
Hi:

After moving my deployment folder to the Target Server, I run the Installation Wizard. As I move next, I am missing the window which is supposed to allow me to set package config values as stated in MSDN:

"If the package includes configurations, you can edit updatable configurations by updating values in the Value list on the Configure Packages page."

Source: http://msdn2.microsoft.com/en-us/library/ms141802.aspx

Does anyone know why I am not seeing it? In my deployment bundle which I have moved over has currently 3 files:

1) SSIS Deployment Manifest

2) SSIS Package

3) SSIS Config File

Again, I double click on SSIS Deployment Manifest, and it starts fine. I go thru the steps for File System Deployment, and then it prompts for installation folder path. After that, it takes me directly to validation. Why is it not showing me the Configure Packages Page as described in the MSDN Documentation. Please advise. Thanks.

View Replies !   View Related
Unable To Create A SSIS Deployment Utility For A Solution Which Are Having 2 Packages
Hi All,
 
I have created a solution which contains only 2 packages say Package1.dtsx and Pakage2.dtsx. I want to create a deployment utility to deploy onto other developers machince. I changed the project properties "CreateDeploymentUtility" to TRUE. When I do the build it is not creating the files in "Deployment" folder. It is saying Rebuild All Failed but the error is not showing.
 
For more information the 2 packages have 4 indirect configurations from environment variables which are storing the actual config file path.
 
Am I missing something here?
 
Thanks.
Venkat.

View Replies !   View Related
[IM001] Error In SSIS Designer
Hi all,

I've been tasked to do some investigation at my workplace as to the best way to move forward with changing from our SQL 2000 DTS' to SQL 2005 SSIS packages.

Our main issue at the minute seems to be that we are using ODBC drivers to pull many of the raw tables which we then manipulate into our own SQL Server tables.

I've had a go at pulling them through the Datareader Source, using the ODBC provider and I recieve the following error;

Error at Data Flow Task [DataReader Source [1]]: System.Data.Odbc.OdbcException: ERROR [IM001]
Driver does not support this function.

Would this be to do with our ODBC drivers being out of date? Does anyone know how to resolve this issue?

View Replies !   View Related
SQL Server SSIS Designer Installation
How to Install SQL Server SSIS Designer? Is it part of SQL Server Buisness Intelligence?

View Replies !   View Related
SSIS Project Running In Debug Mode Brings Up The Wrong Script Task In The Debugger
 

This would actually be funny if I weren't under serious time constraints right now. I have an SSIS project with several script tasks in the control flow. I put breakpoints in one of them to allow me to step through and see whats going on. However, when I start the project, the IDE brings up the script editor for a different script task. The breakpoints in this task are actually on the same line numbers as the task I need to debug but the code is all wrong. I checked the task for which the code is being displayed and there are no breakpoints there.
 
Thanks for the assist!
 
Don

View Replies !   View Related
Removing A Custom Component From SSIS Designer
How do I remove a custom component from SSIS Designer pernamently? I can easily remove it from the tool box, but I want to get rid of it completely.

I tried searching in MSDN for an answer to this question but I could not find it.

Thanks

View Replies !   View Related
SSIS Package Designer Performance After Installing SP1
Hi,

When I installed SP1 on my SQL Server 2005, the performance of the package designer dropped enormously. I have to wait like 30 seconds after I drag-and-drop a datasource from the toolbox to the design area. Also it takes a very long time to run the very simple package. Not to mention opening some complicated package that was done before applying SP1. The package scheduled in SQL Agent went from 3-4min to 5-6min.

Can anyone address this issue? Maybe there's something I did wrong?

While installing SP1 I ecountered strange behaviour (some messages about file locking, rebooting and stuff), but in the end it said that it was successful

Best Regards
Wojtek

View Replies !   View Related
Cannot Insert A Variable In SSIS Package Designer
Hello,
This morning I got an odd problem, I just added a new package to my dtproj and I cannot add a variable. Am I missing anything. ?

here is the image

View Replies !   View Related
SSIS Package Designer Lookup Component GUI Error?
Has anybody seen this issue already?

If you try to "enable memory restriction" from the Lookup component GUI you need to input both 32 and 64 bit size of maximum memory. However when clicking "OK" on the editor you get a message like :

TITLE: Microsoft Visual Studio
------------------------------

Error at Update Execution Logs [Lookup folder path 1 [4429]]: Failed to set property "MaxMemoryUsage64" on "component "Lookup folder path 1" (4429)".

 

------------------------------
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------


You can only set the properties directly for mthe Properties window (F4).

I think this is a post SP1 bug in Visual studio designer...

 

 

View Replies !   View Related
SSIS Package Designer Error Displaying The Layout
Our Visual Studio installation suddenly starting producing the error below upon trying to open any .dtsx package; although by "suddenly" I'm sure it was due to some Windows update or other program install, update, or uninstall.  I've spent two days uninstalling, reinstalling, and repairing everything that is seemingly related to VS, but no luck.  I've searched the forums and could not find this specific error mentioned, although I have tried some of the suggestions to fix possibly related 'class not registered' errors, but again no luck.
 
===================================
There was an error displaying the layout. (Microsoft Visual Studio)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DDSErrorDeserializeDiagram&LinkId=20476
===================================
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (msddsp)
------------------------------
Program Location:
   at MSDDS.IDdsDiagram.CreateShape(String ProgID, Boolean Visible, Int32 X, Int32 Y)
   at Microsoft.DataWarehouse.Controls.Interop.AxMSDDS.CreateShape(String progID, Boolean visible, Int32 x, Int32 y)
   at Microsoft.DataWarehouse.Design.ComponentDiagram.OnCreateShape(Object logicalObject, Int32 x, Int32 y, Boolean visible)
   at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.OnCreateShape(Object component, Int32 x, Int32 y, Boolean visible)
   at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateShape(Object logicalObject, Int32 x, Int32 y)
   at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.CreateExecutableShape(DtsContainer dtsContainer, Int32 x, Int32 y, Int32 width, Int32 height)
   at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.RefreshSequenceExecutables(IDTSSequence sequence)
   at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.AfterDeserialize()
 

 
Any help would be greatly appreciated.
 
TIA,
 
Scott

View Replies !   View Related
Text Qualifier In SSIS Designer For Flat File Source
 
 
Unlike SQL Server 2000 DTS, SSIS Flat File Connection Manager Editor does not provide available list of Text qualifier,
 
i tried
 
-- ""
-- double quote {"}
-- "
--{"}
 
but none of them worked....!
My file sample looks like this
 
"Col1","Col2"
"1234","3456"
"3456","1234"
 
what qualifier should I use then?
 
Many Thanks,
 

View Replies !   View Related
Running A Large Number Of SSIS Packages (with Dtexec Utility) In Parallel From A SQL Server Agent Job Produces Errors
Hi,
 
I have stumbled on a problem with running a large number of SSIS packages in parallel, using the €œdtexec€? command from inside an SQL Server job.
 
I€™ve described the environment, the goal and the problem below. Sorry if it€™s a bit too long, but I tried to be as clear as possible.
 
The environment:
Windows Server 2003 Enterprise x64 Edition, SQL Server 2005 32bit Enterprise Edition SP2.
 
The goal:
We have a large number of text files that we€™re loading into a staging area of a data warehouse (based on SQL Server 2k5, as said above).
 
We have one €œmain€? SSIS package that takes a list of files to load from an XML file, loops through that list and for each file in the list starts an SSIS package by using €œdtexec€? command. The command is started asynchronously by using system.diagnostics.process.start() method. This means that a large number of SSIS packages are started in parallel. These packages perform the actual loading (with BULK insert).
 
I have successfully run the loading process from the command prompt (using the dtexec command to start the main package) a number of times.
 
In order to move the loading to a production environment and schedule it, we have set up an SQL Server Agent job. We€™ve created a proxy user with the necessary rights (the same user that runs the job from command prompt), created an the SQL Agent job (there is one step of type €œcmdexec€? that runs the €œmain€? SSIS package with the €œdtexec€? command).
 
If the input XML file for the main package contains a small number of files (for example 10), the SQL Server Agent job works fine €“ the SSIS packages are started in parallel and they finish work successfully.
 
The problem:
When the number of the concurrently started SSIS packages gets too big, the packages start to fail. When a large number of SSIS package executions are already taking place, the new dtexec commands fail after 0 seconds of work with an empty error message.
 
Please bear in mind that the same loading still works perfectly from command prompt on the same server with the same user. It only fails when run from the SQL Agent Job.
 
I€™ve tried to understand the limit, when do the packages start to fail, and I believe that the threshold is 80 parallel executions (I understand that it might not be desirable to start so many SSIS packages at once, but I€™d like to do it despite this).
 
Additional information:

The dtexec utility provides an error message where the package variables are shown and the fact that the package ran 0 seconds, but the €œMessage€? is empty (€œMessage: €œ).
Turning the logging on in all the packages does not provide an error message either, just a lot of run-time information.
The try-catch block around the process.start() script in the main package€™s script task also does not reveal any errors.
I€™ve increased the €œmax worker threads€? number for the cmdexec subsystem in the msdb.dbo.syssubsystems table to a safely high number and restarted the SQL Server, but this had no effect either.
 
The request:

Can anyone give ideas what could be the cause of the problem?
If you have any ideas about how to further debug the problem, they are also very welcome.
 Thanks in advance!
 
Eero Ringmäe

View Replies !   View Related
Report Designer: Copy Result Cells From Generic Query Designer And/or Preview?
Hi,

 

I'm working with reports requiring the Generic Query Designer (complex queries against IBM AS400 via ODBC driver).  I'm using SSRS initially as an ad-hoc query tool, exploring a database and it's data.

 

I've noticed that on the Data tab in Report Designer, when in in Generic Query Designer mode I can't copy the data out from the Result Pane as you can using the Graphical Query Designer.  I find this a bit surprising.  Does anyone now how to achieve this?

 

A viable alternative might be the Preview tab, but I can't see how to copy text from that window either?

 

Do I have to run a Preview and then an Export each time?

 

Mike

View Replies !   View Related
Query Analyzer Freezing
My 2000 sp3 sql analyzer keeps freezing when closing a window. This is not during a query, and I may not have even edited anything. The entire app will freeze, and after hitting the close button several times, it will get around to an "End Task" popup, and finally close. Doesn't happen every time, doesn't happen with the same number of windows open or the same query open. I have unloaded, reloaded, etc...Still occurs. :confused: Any ideas? TIA.

View Replies !   View Related
UPDATE Freezing Problem
Hi, i am having a problem with UPDATE.

I have the following table with about 4 million rows:
CREATE TABLE [newauth] (
[authnumber] [int] NULL ,
[batchnumber] [int] NULL ,
[accountnumber] [varchar] (20) NULL,
[authcode] [varchar] (10) NULL ,
[authused] [char] (1) NULL ,
[loaddate] [int] NULL ,
[trandate] [int] NULL ,
[trantime] [int] NULL ,
[cardtype] [char] (1) NULL ,
[mcc] [char] (4) NULL ,
[amount] [int] NULL ,
[transactionnumber] [int] NULL
) ON [PRIMARY]
GO

There is an index on the authnumber field. I am calling the following stored procedure to update the transactionnumber.

CREATE PROCEDURE UpdateAuthWithTrans(@lAuth int, @lTrans int)
AS
UPDATE NewAuth
SET TransactionNumber = @lTrans
WHERE AuthNumber = @lAuth
GO

I need to update about 1 million rows. Approx 50000 calls to this SP work OK. Then the DB freezes. Enterprise mgr shows the following (screen shot attached)

I cant figure out why this is freezing. I have tried update statistics newauth, dbcc checktable, rebuilding the index, rebooting the server.

Any ideas would be appreciated, thanks in advance for any help.

View Replies !   View Related
JOB FREEZING IN THE EXECUTING STATE
I am having a problem with one of the jobs.The Job freezes in the executing state and takes four to fifteen hours. it only happens sometimes. can anyone suggest the problem i dont seem to get the root of the problem. Kindly give some sugessions.

 

Thanking in Advance

Jacx

View Replies !   View Related
SQL Server 2005 Std And SP2 Freezing
Both SP1 and now I've tried SP2 freeze when installing.  I'm attaching the log file from the server.  At around 8000 lines in, it appears to be failing and leaving the install program running with no warning.  Any thoughts?
 
Installing on Windows 2000 server fully patched.
 
Any help would be very much appreciated. 
 
TR
 
tail end of the log file is below
 
Property(S): SystemLanguageID = 1033
Property(S): SQL200532Hotfix2047 = \SPKSQL02f$7dc9ef46b6f9ec52a35742ea3b74HotFixSQLFilessqlrun_sql.msp
Property(S): BrowseAuto.2FC2D269_8625_4826_BB3F_F9059090CB38 = 3
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 1729
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:859]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:875]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:875]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:875]: Transforming table Error.
MSI (s) (08:FC) [08:57:55:875]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (08:FC) [08:57:55:875]: Product: Microsoft SQL Server 2005 -- Configuration failed.
MSI (s) (08:FC) [08:57:55:875]: Attempting to delete file C:WINNTInstaller4a859f.msp
MSI (s) (08:FC) [08:57:55:875]: Unable to delete the file. LastError = 32
MSI (s) (08:FC) [08:57:55:906]: Cleaning up uninstalled install packages, if any exist
MSI (s) (08:FC) [08:57:55:906]: MainEngineThread is returning 1602
MSI (s) (08:4C) [08:57:55:906]: Destroying RemoteAPI object.
MSI (s) (08:A8) [08:57:55:906]: Custom Action Manager thread ending.
=== Logging stopped: 7/26/2007  8:57:55 ===
MSI (c) (0C:A0) [08:57:55:921]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (0C:A0) [08:57:55:921]: MainEngineThread is returning 1602
=== Verbose logging stopped: 7/26/2007  8:57:55 ===
 

View Replies !   View Related
Freezing Columns In A Table
 

Is it possible to freeze columns in a table elements. Lots of times we are being forced to use matrix to freeze columns - when in fact we should actually be using a table element.
 
Any idea if this is going to be part of MSRS in the future or should we just use matrixes..
 
Thanks
 

View Replies !   View Related
SQL Server 2000 Freezing
I am completely new to this forum, so forgive me if I am in the wrong place.

I have been running this application for about 3 years with no problems, but over the past couple of weeks I have been having major issues!

Background: I am running an Access 2003 frontend with SQL Server 2000 backend.  The SQL Server resides on the server, and each user has a local copy of the Access 2003 application.

Issues:  Over the past couple of weeks users have been recieving errors that lock everyone's application up, and the server has to be rebooted.  Some of the errors recieved:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).  (#10054)
 
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.  Check your network documentation. (#11)

Microsoft][ODBC SQL Server Driver][DBNETLIB]Timeout Expired (#0)

So after these errors occur, they have to reboot the server.  It has happened to different users, never the same user, but once and error occurs, it locks up every user.
I have searched the internet high and low for troubleshooting, but have not found anything to fix these issues.  I am not really knowledgable with SQL server.  I created the database in Access and then used the upsize wizard to get it into SQL.



Oh, and I have also checked the error logs and found nothing that stands out as an error problem. 

View Replies !   View Related
Freezing Column And Header In Report
I have report with large records and many columns

I would like to freez header and specific column like excel

I tried to freez header it self it's worked

I tried to freez  a column it self it's worked

when I tried to freez both in same report it does not work..

any help??

View Replies !   View Related
Freezing Column And Header In Report
I have report with large records and many columns

I would like to freez header and specific column like excel

I tried to freez header it self it's worked

I tried to freez  a column it self it's worked

when I tried to freez both in same report it does not work..

any help??

View Replies !   View Related
Query Only Freezing When Put Into A User Defined Function?
I'm experiencing quite an interesting issue with our database. We're currently running SQL Server 2005 Standard (x64) (v9.00.3054.00) and I have a block of code that just insists on not working within a UDF.  Everything I've read seems to point that I'm doing this corerctly but apparently I'm missing something. 

Executing the query below:

DECLARE @sp DATETIME
DECLARE @ep DATETIME
DECLARE @trackType INT

SET @sp = '4/21/2008'
SET @ep = '4/28/2008'
SET @trackType = 1

    SELECT
        c.unqempid, isnull(count(c.contactid),0) AS contacts, isnull(bookings.count,0) AS bookings, isnull(showed.count,0) AS showed, isnull(ow.totalPurchased,0) AS purchases, isnull(ow.totalSold,0) AS volume
    FROM
        contacts c WITH (NOLOCK)
    LEFT JOIN
        (
            SELECT
                b.unqempid, ISNULL(count(bookingid),0) AS count
            FROM
                bookings b WITH (NOLOCK)
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.contactid = b.relcontactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep
            GROUP BY
                b.unqempid
        ) AS bookings
        ON bookings.unqempid = c.unqempid
    LEFT JOIN
        (
            SELECT
                b.unqempid, ISNULL(count(bookingid),0) AS count
            FROM
                bookings b WITH (NOLOCK)
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.contactid = b.relcontactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep AND didshow > 0
            GROUP BY
                b.unqempid
        ) AS showed
        ON showed.unqempid = c.unqempid
    LEFT JOIN
        (
            SELECT
                c.unqempid, count(leadid) TotalPurchased, sum(saleprice) AS TotalSold
            FROM
                ordermgmt.dbo.orders o WITH (NOLOCK)
            INNER JOIN
                ordermgmt.dbo.appointments a WITH (NOLOCK)
                ON a.weborderid = o.orderid
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.personid = a.leadid
            INNER JOIN
                bookings b WITH (NOLOCK)
                on b.relcontactid = c.contactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep
            GROUP BY
                c.unqempid
        ) as ow
        ON ow.unqempid = c.unqempid
    WHERE
        c.contactdt BETWEEN @sp AND @ep
    GROUP BY
        c.unqempid, bookings.count, showed.count, ow.totalPurchased, ow.totalSold


Yields no issues however if I put this into a UDF, it runs and never finishes executing.  I'm not quite sure what my issue was so I'm hoping someone could point out where my goof is. 

Here is the function:

CREATE FUNCTION [dbo].[fnEmployeeSchedulingResults]
(   
    @sp        DATETIME,
    @ep        DATETIME
)
RETURNS TABLE
AS
RETURN
(

    SELECT
        c.unqempid, isnull(count(c.contactid),0) AS contacts, isnull(bookings.count,0) AS bookings, isnull(showed.count,0) AS showed, isnull(ow.totalPurchased,0) AS purchases, isnull(ow.totalSold,0) AS volume
    FROM
        contacts c WITH (NOLOCK)
    LEFT JOIN
        (
            SELECT
                b.unqempid, ISNULL(count(bookingid),0) AS count
            FROM
                bookings b WITH (NOLOCK)
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.contactid = b.relcontactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep
            GROUP BY
                b.unqempid
        ) AS bookings
        ON bookings.unqempid = c.unqempid
    LEFT JOIN
        (
            SELECT
                b.unqempid, ISNULL(count(bookingid),0) AS count
            FROM
                bookings b WITH (NOLOCK)
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.contactid = b.relcontactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep AND didshow > 0
            GROUP BY
                b.unqempid
        ) AS showed
        ON showed.unqempid = c.unqempid
    LEFT JOIN
        (
            SELECT
                c.unqempid, count(leadid) TotalPurchased, sum(saleprice) AS TotalSold
            FROM
                ordermgmt.dbo.orders o WITH (NOLOCK)
            INNER JOIN
                ordermgmt.dbo.appointments a WITH (NOLOCK)
                ON a.weborderid = o.orderid
            INNER JOIN
                contacts c WITH (NOLOCK)
                ON c.personid = a.leadid
            INNER JOIN
                bookings b WITH (NOLOCK)
                on b.relcontactid = c.contactid
            WHERE
                c.contactdt BETWEEN @sp AND @ep
            GROUP BY
                c.unqempid
        ) as ow
        ON ow.unqempid = c.unqempid
    WHERE
        c.contactdt BETWEEN @sp AND @ep
    GROUP BY
        c.unqempid, bookings.count, showed.count, ow.totalPurchased, ow.totalSold
)



Any help would be greatly appreciated!

-Justin

View Replies !   View Related
Freezing Multiple Rows And Columns In Matrix Control
Hi all,

I hv a matrix control in my rdl which looks like -

       Report Name

     (static row)Fund Name          =Fields!FundName.Value(Dynamic Column Header)

      (static row)Broker Name       =Fields!Broker.Value(Dynamic Column Header)

     (static row)Account No.         =Fields!AccountNo.Value(Dynamic Column Header)

    ---then other static rows    

now i want these 3 column header's and there corresponding static rows should be freeze.

Can anyone suggest me any solution for this.

I can use either RS 2000 or RS 2005 

View Replies !   View Related
2 SQL CE Native Error Codes (28037 And 28600) Freezing Up My Windows CE .Net Application???
I am running a .Net application (VB.Net, .Net Framework 2.0) on a Windows CE 5.0 handheld device.  I am relatively having good success with SQL CE replication, however sometimes (2 users out of 30 every 2 weeks), are freezing up in the application.
 
Here is what CE SQl software versions I installed:
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.wce5.armv4i.CAB
 
I have a trace log in my application, and here is what pops up before the hang (warm rebooting the handheld works)
 

NativeError: 28037
SQL Msg: A request to send data to the computer running IIS has failed. For more information, see HRESULT.
 
NativeError: 28600
SQL Msg: The database is currently synchronizing with the server.
 
 
I am using a Thread to syncronize (microsofts built in class), as you can see I am well aware of 28600, it just means some other thread is already syncing, so I can wait until next time to syncronize.  However, my users apps are freezing just after both error codes occur.  Anything in the code below causing issues??? (maybe   _repl.Dispose()   is freezing up my handheld, because its freezing after this line of code (see below code):
 
"MTM.SPUD.Utilities.Utilities.Log("[DEBUGQLThread#" + threadId + "]: End of Thread Life.")"

 
 Public Sub AsyncSyncronize(ByRef PendingData As Boolean, ByVal Publication As String, ByVal Subscription As String, ByRef LastSyncDateTime As DateTime)
  Dim _repl As New SqlCeReplication()
  Try
...
   savedAsyncResult = _repl.BeginSynchronize(objDelegate1, objDelegate2, objDelegate3, objDelegate4, _repl)
  Catch ex As Exception
  Finally
  End Try

 End Sub
 
 Public Sub OnSynchronizeComplete(ByVal asyncResult As IAsyncResult)
  Dim _repl As SqlCeReplication = Nothing
  Dim threadId As String = ""
  Try
   _repl = DirectCast(asyncResult.AsyncState, SqlCeReplication)
   threadId = _repl.InternetPassword
  _repl.EndSynchronize(asyncResult)
            dataIsPending = False
 
Catch exce As SqlCeException
   _repl.CancelSynchronize()
   MTM.SPUD.Utilities.Utilities.Log("[DEBUGQLThread#" + threadId + "]: SQLCE OnSynchronizeComplete() NativeError: " + exce.NativeError.ToString + "SQL Msg: " + exce.Message.ToString)

dataIsPending = True
If exce.NativeError.ToString = "28600" Then
    MTM.SPUD.Utilities.Utilities.Log("[WARNINGQLThread#" + threadId + "]: Will try again next time")
    Return
 End If
 
  Catch ex As Exception
   Return
   'MTM.SPUD.Utilities.Utilities.Log("App Exception: " + ex.Message)
   'Throw New Exception("EndSynchronize Failed: " + ex.Message)

  Finally
    MTM.SPUD.Utilities.Utilities.Log("[DEBUGQLThread#" + threadId + "]: End of Thread Life.")
            If _repl IsNot Nothing Then
             _repl.Dispose()
             _repl = Nothing
            End If
  End Try
 End Sub
 
 

View Replies !   View Related
Link Server Doesn't Work Except Through Query Analyzer: MSSQL Freezing / Timing Out
Environment:Server1 (Local)OS Windows 2000 ServerSQL Server 2000Server2 (Remote)OS Windows 2003 ServerSQL Server 2000(Both with most recent service packs)Using Enterprise Manager, we have set up the Link Server (LINK_A) inthe Local Server 1 to connect to Server 2.The SQL we need to run is the following:INSERT INTO table1(column1,column2)SELECT A.column1, A.column2FROM LINK_A.catalog_name.dbo.table2 AS AWHERE A.column1 xxxx;When we run this from the Query Analyzer, it completes with no problemsin a few seconds.Our problem:When we add the DTS Package as the ActiveX Script (VB Script) to theLocal Package, it times out at "obj_Conn.Execute str_Sql"Dim Sql, obj_ConnSet obj_Conn = CreateObject("ADODB.Connection")obj_Conn.Open XXXXobj_Conn.BeginTransstr_Sql = "INSERT INTO table1("str_Sql = str_Sql & "column1"str_Sql = str_Sql & ", column2"str_Sql = str_Sql & ")"str_Sql = str_Sql & " SELECT A.column1"str_Sql = str_Sql & ", A.column2"str_Sql = str_Sql & " FROM LINK_A.catalog_name.dbo.table2 AS A"str_Sql = str_Sql & " WHERE A.column1 0"str_Sql = str_Sql & ";"obj_Conn.Execute str_Sql----------------------------------------------------------When we make a Stored Procedure and run the following SQL, it freezes.INSERT INTO table1(column1,column2)SELECT A.column1, A.column2FROM LINK_A.catalog_name.dbo.table2 AS AWHERE A.column1 xxxxWe've also tried the following with the same results;INSERT INTO table1(column1,column2)SELECT A.column1, A.column2FROM [LINK_A].[catalog_name].[dbo].[table2] AS AWHERE A.column1 xxxxThe same thing happens when we try to run the "SELECT" by itself.SELECT TOP 1 @test=A.column1FROM LINK_A.catalog_name.dbo.table2 AS AWHERE A.column1 xxxxORDER BY A.column1What is going wrong here, and how do we need to change this so that itruns without timing out or freezing?

View Replies !   View Related
Sql Debug Help
how can it be that
when I do the query

select * from rep where batch=133 it returns 730 and


select* from rep left JOIN Information ON rep.site = Information.Sitecode where batch=133 returns more then 730

I want it to return the same records as the first query but with the additional information from the information table --

what am i doing wrong?

View Replies !   View Related
T-SQL Debug
Hello, everyone:

How to debug T-SQL codes? Can QA do that? Are there the special tools?

Thanks.

YTZ

View Replies !   View Related
Can U Help Me Debug This!!!!
to all the experts can u help me about my codes Truncated incorrect DOUBLE value: 'NoOfPositives'
here's my code

select
ref_region.regionName,
ref_facility.facilityName,
ref_facility.adr,
ref_facility.facilityNo,

(select count(*)
from dto_initial_screening
where (dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'TotalScreened',

(select count(*)
from dto_initial_screening
where (dto_initial_screening.testResult = 'POS' and
dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'NoOfPositives'

from dto_initial_screening
left join ref_facility on dto_initial_screening.facilityNo = ref_facility.facilityNo
left join ref_region on ref_facility.adrRegionCd = ref_region.regionCd

where
('NoOfPositives') < (select Cast(paramVal as UNSIGNED) from ref_param where paramCd = 'minPositives')

View Replies !   View Related
How Can We Debug An SP
Is there a way like we do in programming or even bettre. Is there any better practice for this.
Thanks

View Replies !   View Related
Need To Debug SP's....
Hi,

I need to debug my Store Procedures with diff parameters at regaular intervals which shows me memory usage, CPU usage and other usage.

Is there any way to do this?

-- Regards
Prashant Hirani

View Replies !   View Related
How To Debug A Sp?
How to debug a sp in sql server 2005?

View Replies !   View Related
JIT Debug HELP
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at HP.CUE.Video.PlaybackControl.UpdateProgressBar()
   at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
hpqimzone
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe
----------------------------------------
hpqiface
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
hpqcc2
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll
----------------------------------------
hpqutils
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll
----------------------------------------
hpqfmrsc
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll
----------------------------------------
hpqtray
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll
----------------------------------------
hpqovskn
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll
----------------------------------------
hpqimvlt
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll
----------------------------------------
hpqimgrc
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll
----------------------------------------
hpqntrop
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll
----------------------------------------
Interop.hpqcxm08
    Assembly Version: 3.0.0.0
    Win32 Version: 53.0.13.000
    CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll
----------------------------------------
System.Xml
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
LEAD
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll
----------------------------------------
LEAD.Wrapper
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll
----------------------------------------
LEAD.Windows.Forms
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll
----------------------------------------
LEAD.Drawing
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll
----------------------------------------
interop.hpqimgr
    Assembly Version: 3.0.0.0
    Win32 Version: 53.0.13.000
    CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll
----------------------------------------
hpqthumb
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll
----------------------------------------
hpqasset
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll
----------------------------------------
hpqmirsc
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL
----------------------------------------
hpqedit
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll
----------------------------------------
hpqvideo
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll
----------------------------------------
LEAD.Windows.Forms.DrawingContainer
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll
----------------------------------------
hpqmdmr
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll
----------------------------------------
LEAD.Drawing.Imaging.ImageProcessing
    Assembly Version: 13.0.0.113
    Win32 Version: 13.0.0.113
    CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll
----------------------------------------
hpqimlib
    Assembly Version: 3.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll
----------------------------------------
hpqglutl
    Assembly Version: 4.0.0.0
    Win32 Version: 053.000.013.000
    CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll
----------------------------------------
Interop.hpqvideo
    Assembly Version: 3.0.0.0
    Win32 Version: 53.0.13.000
    CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.


 

View Replies !   View Related
Debug
 

Hello guys!
I am trying to debug a sql procedure inside Server Explorer  but I can seem to step into each line.
When I run the procedure it doesn't stop in the breakpoint I set.

By the way I am running in a client pc..

Please help guys!

View Replies !   View Related
How To Debug A SqlCommand?
How to test @au_lname's value sends to the following following sql command?
Dim MyCommand As New SqlCommand("UPDATE [authors] SET [au_lname] = @au_lname",  MyConnection)MyCommand.Parameters.Add(New SqlParameter("@au_lname", SqlDbType.NVarChar)).Value = me.au_lname.text
I tried to print the "MyCommand.CommandText.ToString" but only get UPDATE [authors] SET [au_lname] = @au_lname with no value in the command text.
Thanks!
 

View Replies !   View Related
Debug In SQL Server
HI all, i try to debug a store procedure in SQL Server. I do an example.
1.Open Server Explorer.

2.Under the Servers node in Server Explorer, expand the SQL Server machine name, expand the SQL Servers node, expand the SQL Server instance, expand the Northwind database node, and then expand the stored procedures node.

3.Right-click the CustOrderHist stored procedure and then click Step Into Stored Procedure.

4.The Run stored procedure dialog box opens, which lists the parameters of the stored procedure. Type ALFKI as the value for the @CustomerID input parameter and then click OK.

5.In the Visual Studio design environment, a window opens that displays the text of the stored procedure. The first executable line of the stored procedure is highlighted. Press F11 to step through the stored procedure to completion.

6.In the Output window, the following message is displayed, which indicates successful execution:
The program 'SQL Debugger: T-SQL' has exited with code 0 (0x0)

But in step 5, the first executable line of the stored procedure is not highlighted, so I can't press F11 to step through.

Please help me

View Replies !   View Related
How Do You Debug A VB Script In DTS ?
Hi;

I want to load 36k records into a SQL table from a text file.

The VBscript that I am using loads 6K records before encountering a problem with
the transfromation.

I have tried using msgBox but this is no way to deal with 30K worth of records.

Could I run a SELECT to start in a table at 6K records and return a 100 at a time ?
--
Thanks

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved