HI Everyone,
I need to ask you a question about T-Sql Debugger. I have installed the sqldbreg.exe and sqldbg.dll in the program filesmicrosoft sharedsql debuggin directory. What I need to know is how to access this tool so that I could debug my procedure I have written in sql server 7.0
Thank you so much!!
sj
After writing a Stored Procedure(which is giving correct reasult) how can I go for optimizing it?Is there any tool to debug a stored procedure?
View 1 Replies View RelatedI am an old guy that comes from the large IBM 370 generation, at that timewas very easy for me to debug programs using cedf tool., even if theprogram was object code with this tool you were able to intercept CICScommands and sql commands.I have a delphy application., only object code., that has access to a sqlserver.., what tool may I use to intercept the sql commands released fromthis application ?? I know this is not a particular question regarding mssql server, but for sure you guys knows a lot more than me about thisenvironment.RegardsJCortes.
View 1 Replies View RelatedHi,
I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above.
Am I missing something here? Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging?
Can I automate the process with MSBuild or NAnt? If so, is there an example of this anywhere?
Thanks in advance,
Lawrie.
I don't see the option to debug a stored procedure. I right click on
the procedure and should'nt it appear in the properties window. Do I
need to install some extra component to get the debugger.
How can I view the raw SQL code that ASP.NET sends to SQL Server when using parameters?
The code below doesn't display the actual SQL statement, but instead: System.Data.SqlClient.SqlCommand.
string SQL = "INSERT INTO [BLAH] VALUES (@startDate)";
SqlConnection mySqlConn = new SqlConnection(ConfigurationSettings.AppSettings["DSN"]);
SqlCommand mySqlCmd = new SqlCommand(SQL, mySqlConn);
mySqlCmd.Parameters.Add(new SqlParameter("@startDate", SqlDbType.DateTime));
mySqlCmd.Parameters["@startDate"].Value = Request.Form["start_date"];
lblSQLDebug.Text = mySqlCmd.ToString();
TIA.
I'm trying to debug some procedural functions in SQL Server 2000 using Query Analyzer, and not having much luck.
Any help would be appreciated!
Thanks,
Doug
I am trying to debug a classic ASP application using Visual Web Developer Express and SQL Server Express editions. When my application tries to execute a stored procedure, I get the following error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
Is there a way for me to trace queries that are getting executed in SQL Server Express so I can see which stored procedure is failing? I seem to remember being able to do this with SQL Server 2000. Any other ideas on how to debug SQL Server errors like these using SQL Server Express?
TIA for the help.
Michael
Hi Everyone!
Just started looking into Assemblies within SQL Server in the hope of creating a multi-threaded application and when writing a basic test assembly I came across the following problem...
When I create a worker thread within my assembly I am unable to do the following in my newly created thread:
Stop on a breakpoint in VS2005
Use Debug.Writeline to output to the output window
I know the thread is running as I am able to write to the EventLog, but VS2005 seems to be unaware of any thread other than the main SQL server thread.
If anyone could tell me whether there it is possible to debug non-SQL server threads, whether I am doing something wrong, or whether I should be doing things differently that would be great!
Thanks in advance for any help!!
The code is as follows (apologies as its not very well written!):
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Threading;
using System.Diagnostics;
public partial class StoredProcedures
{
/// <summary>
/// This stored procedure starts the comms
/// </summary>
[Microsoft.SqlServer.Server.SqlProcedure]
public static void StartComms()
{
try
{
// Output some debug output to show the thread is running
Debug.WriteLine("Comms is starting");
// Create the thread to run in the main thread class
Thread zThread = new Thread(new ThreadStart(ThreadFunction));
// Start the thread running
zThread.Start();
// Sleep to let the other one run
Thread.Sleep(2000);
// Output some debug output to show the thread is running
Debug.WriteLine("Comms is about to wait for thread to finish");
// Wait for the thread to complete
zThread.Join();
// Output some debug output to show the thread is running
Debug.WriteLine("Comms is ending");
}
catch
{
throw;
}
}
/// <summary>
/// The main thread function
/// </summary>
public static void ThreadFunction()
{
try
{
// Flag to keep thread running
bool bRunning = true;
// While the thread is running
while (bRunning == true)
{
// Output some debug output to show the thread is running
Debug.WriteLine("Thread function running");
System.Diagnostics.EventLog.WriteEntry("SQLServerThreadTest",
"Thread function is running");
// Sleep for two seconds
Thread.Sleep(5000);
}
}
catch
{
throw;
}
}
};
is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies View Relatedhi friends,
Anyone give give me the steps we have to follow for debussing a stored procedure in sql server 2005...
Please help! I cannot debug CLR procs remotely. Whenever I try to start debugging in VS2005 I get the error: Unable to start T-SQL Debugging. Could not attach to SQL Server process on .... I have clr enabled set to 1 and I have Allow SQLCLR Debugging set on. But I continue to get this error. Any help would be greatly appreciated.
Thanks!
GN
I have a DTS package that I brought over from SQL server 2000 in to SQL Server 2005. I have installed all of the legacy components to run the DTS packages but I need to debug an ActiveX script task. In SQL Server 2000 I could turn on Just-In-Time debugging and use the stop operator (in my vbscript) to break the running script and launch the debugger.
I don't see how to do this in SQL Server 2005 Management Studio. Is it possible to debug a script object in a DTS package running in SQL Server 2005?
Jay Abbott
I've installed Visual Studio 2005 Professional evaluation edition on both my desktop & on the server to try out the Debugger to be used with my Stored procedures
I got this error message every time i try to 'Step into Stored Procedure' from my desktop to connect to the stored procedure which resides on the Server.
Error message: Unable to Start T-SQL Debugging. Could not attach to SQL Server Process on 'Server1'.The RPC server is unavailable
The 'Step into Stored Procedure' works though if I open the stored procedure directly on the server.
Both my PC and Server has been installed with Remote Debugger and my windows login has been assigned permission to debug on the debugger that resides on the Server and has sysadmin server role on SQL 2005 both on PC and Server.
Can someone tell me what i miss out to debug Stored procedure in the SQL Server 2005 on the Server from my PC?
Thanks in advance.
I have an environment of SQL Server 2K5 and 2000 servers. The environment is mostly data warehouse than transactional. There are some applications working continiously to provid reports. The servers must be up and running.
I have to provide high availability, monitor performance, and minimize down time. Is there any "really good" tool for a DBA for this environment? I would like to hear your experience with the tool you are using. Any practical suggestion is highly appreciated.
Thanks,
[1/29/07] It's first time on this forume for me that I had no reply for about 4 days! Any idea? Any experience to share?
Quest Software has released a SQL Server version of its highly popularOracle tool - TOAD. It is freeware! You can see more about it athttp://www.toadsoft.com/toadss.html and download it athttp://www.toadsoft.com/toad_ss.zip.
View 2 Replies View RelatedBack in July I released the (then) latest version of SsbAdmin. For you who
don'r know what it is; it's a tool which allows you to graphically administer
SQL Server Service Broker.
I have now uploaded a new version which is compiled against the released
versions of SQL Server 2005 and .NET 2.0.
You can download it from here: [0].
After download, un-zip to some directory and read the README.doc file.
[0]: http://staff.develop.com/nielsb/code/ssbadmin.zip
Hi
I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
Hi,
I have installed "SQL Server 2000 SP 4" to SQL server and it is running fine.
But when i install the "SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4", i get below error:
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.
When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail.
By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file.
Appreciate if anyone tell me the solution.
Thanks in advance.
Best regards,
Plane.
Hi
I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
Hi my server people have informed me that there is a tool that I can access the server with. Can anybody point me in the right direction?
Many Thanks
howlinhuskie
Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..
View 1 Replies View RelatedHello,
I am looking for an ASP.NET tool that allows me to access a SQL Server remotly. We have created a database and would like to begin populating the tables before development of our site. The main funtionality I am looking for is to be able to view all tables within a database in the SQL Server. Also, I would like to be able to insert data into these tables. Is anyone aware of a tool like this?
Thanks a lot!!
Hi
Thanks for help me!. I was working the last 3 years with the 6.5 version, and now i`m moving to version 7. I need to know if there is any simple tool like the MSQUERY from 6.5 version, to make simple changes in a easy way, or all querys must be made using commands ?
Sorry by mi English!
Does anyone know of a web based tool that allows a SQL Server databaseto beadminstered from the Internet? (in php)
View 2 Replies View RelatedHi,I want to connect to Sql 6.5 server database server, What clientToolshould I use to connect it?And also Is it possible to update records in the Sql 6.5 usingADO.net 2.0?Thansk In Advance
View 2 Replies View RelatedIm trying to install the SQL Server Compact Tools in Windows Server 2008, but the installation program wonīt let me continue since it says that I must install the IIS Backward Compatibility Tools. The problem is that I canīt find where I do that.
I know that Windows Server 2008 is not listed as a supported os for the server tools, but surely I must at least be able to install them?
I just ran the utility without any commands ant the wizard has come up. This is all independent of my web application.I am guessing this is going to install the database tables to my existing database. UPDATE: They have been createdWill I then connect my web app to this database schema that is created?How do I change the membership/roles users in my web app to point to the database tables?
View 6 Replies View RelatedI currently install SQL server 2005 CTP and I couldn't find the diagramming tool which used to view the conceptual model of the database structure, relationships and entities visually. This diagramming tool feature is available in SQL server 2000, however I couldn't find in SQL server 2005. Anyone would like to give me some recommendations or show me where this feature is hidden?
View 1 Replies View RelatedHi, I'm looking for a tool to compare 2 sql server database and makes a script of the differences (like an added table or record). We want to use it to generate a script which we can send to our customers to update their database if a change has been made. Example: We send our customers database A. After half a a year they request some changes to be made to the application that affects the database, say a table has to be added. We want the tool to automatically detect the difference between database A when it was first released and after the changes has been made and generate a script. Anyone suggestions? T.I.A., ratjetoes.
View 1 Replies View RelatedHi !!We are developing an application where we need a Query tool which allows customer to do Ad-Hoc or random query.. something similar to lets say http://salebyowner.com/advancedSearch.phpWe have few more options than this on which customer can do search. I don't think dynamic query in C# code or something like that is going to help me. Am I right? Do we have to use any type of query tool or something for doing this?
View 6 Replies View RelatedI am looking to purchase tool where I can perform the stress test on SQL 7.0.
Any recommendation will be appreciated.
Need Recommendation on Tool for SQL Server Development
I have inherited a SQL Server 7 database (actually a SQL Server 6.5 database running on SQL 7 in compatibility mode) with 1000s of objects with triggers and stored procedures with zero documentation; i need to make major changes to this database; are there any tools available that will allow me to quickly search through the database objects and code (like stored procedures, etc) for keywords and other useful criteria? Do you recommend any SQL Server specific tools that will help me learn this database in the shortest amount of time?
Thank you!
--llyal