.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Recomended tools for SQL Server Programming.....

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hi all Iam Part in development team,I want give a session to Developer and tester on SQL Servers tools and utilities which can help develper and tester  give very good product as a whole. I preffer to give session on: Developers 1.Execution plans 2.Profiler Testers: 1. windows counters 2.Execution plans 3.Profiler Is it ok...I need give session on DMV as well for all Teams. Please some body recomend me so useful tools which I missed... Thanks in Advance  SNIVAS

View Complete Post

More Related Resource Links

Under the Table: Programming with FileStreams in SQL Server 2008


There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.

Bob Beauchemin

MSDN Magazine May 2009

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer


In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

BizTalk Server 2000: Architecture and Tools for Trading Partner Integration


This article provides an overview of the concepts involved with implementing a trading partner integration system on BizTalk Server 2000 and details the document interchange server architecture and toolset. Additionally, an early look was taken at some business process integration features planned for the production release of the product that allow easy design, execution and sharing of new business processes with trading partners. The concepts and architecture presented allow companies to prepare internal line-of-business applications and trading partners for systems that improve customer service and reduce operating costs.

Aaron Skonnard and Bob Laskey

MSDN Magazine May 2000

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2?  The regular remove program does not have this option highlighted.    I am trying use some of the advance option and learn something more and now ssms is useless.         the discovery report tells me these are installed but I have no way of uninstalling.  .  I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version.  Please help.  I'd really appreciate it. " Sql Server 2008     Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008     Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

MySQL to SQL Server Conversion Tools

Anyone know of any FREE database conversion tools?

Can't Uninstall SQL Server 2005 Express Tools


I am attempting to install SQL Server 2008 Enterprise Trial and receive the follow error during installation.


"The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools."


I have used Add or Remove programs to remove all components of SQL Server 2005 Express.  I have even reinstalled the Workstation Tools of SQL Server 2005 just so I could indiviually remove those tools, and then completly removed the SQL 2005 installation.


I have used regedit to search for any instance of SQL Server 2005, there is none.



There is still an entry for SQL Server Mangement Express in my all programs listing.  However trying to launch that program fails with errors, so it is partial still installed.


Can anyone tell me how to wipe out these last bits of SQL Server 2005 Express Tools?  I have tried everything I have found searching this forum to no avail.



Can I run Sql server 2000 client tools and SQL server 2005 on teh same machine.



Could you please advise me on this issue.

I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.

The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.

They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?

Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?

I am using windows 7 and i3 processor.

Thanks in advance.



Install App that uses .NET Framework 4 and SQL Server 2008R2 Express (with Tools) - what .NET Framew


I am a little confused about how to install my application.  Written in C# using VS 2010 and targeted for the .NET 4 Framework.  It also uses a SQL Server 2008 R2 database.

In my installer I install .NET 4 Framework if not already present on the host machine.

For SQL Server 2008 R2 (with Tools) I understood I need Installer 4.5 and Powershell 1.0.  The install of install of 4.5 installer goes ok but requires a reboot.  The install of Powershell says it needs .NET Framework 2 SP2 - even tho' .NET 4 is installed.

I decide to ignore this and carry on so manually install SQL Server 2008 R2 Express (with Tools).  It unpacks and complains it needs .NET Framework 3.5 SP1!

My application has to deploy to a disconnected machine installed in the cab of a logging harvester so I can't rely on automatic wwindows updates.


To deploy my app with SQL Server 2008 R2 (with Tools) do I need ...

  • .NET Framework 2.0 SP2 and
  • .NET Framework 3.5 SP1 and
  • .NET Framework 4



I had presumed all I would would be .NET Framework 4 since it is "mostly" backwardly compatible.

Install time and complexity is HUGE is I need all three Frameworks.


Can someone please clarify for me?




Decrypt the encrypted store procedure through the T-SQL programming in SQL Server 2005


HI ,


I have a encrypted store procedure in my production server .Right now I do not have the script now I want do some modification.

Please any one can help me to decrypt the store procedure it will be a great help for me.


For any suggestion thanks  in advance.

" Education is the beginning of transformation. Dedicate yourself to daily learning via Blogs/Forums/books and coaching "
Click here to read my blog

Installing SQL server 2005 client tools.

I searched on internet and documents, but could not find the steps to install only client utilities for SQL Server 2005. I need something like Query Analyzer and isql to connect to the database.
I selected client tools only after clicking setup.exe, but query analyzer and isql or Microsoft Server Management studio were not installed.
Any help will be useful.


How much can affect the performance heavily loaded sql-server intensive use of such tools as SQL Ser


How much can affect the performance heavily loaded sql-server intensive use of such tools as SQL Server Profiler ?

5%   ?

15% ?

30% ?

Error - Installing SQL Server 2005 Client Tools



I am trying to install sql server 2005 client tools and I get the following error:


Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this


Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools


I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.

SQL Server 2008 Installation fails when installing Management Tools option


After installing SQL Server 2008 successfully I went back to install the Management Tools option.  I get an error after most of it has completed...Interestingly enough it's actually there but given the failure I'm concerned about issues.  Can anyone help?

Here is the Summary File:


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2068643839
  Exit facility code:            1203
  Exit error code:               1
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2010-10-12 16:23

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e



got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
   at System.Configuration.BaseC

SQL Server 2008 Tools Installation Error - "The process does not possess the 'SeSecurityPrivilege'


I'm trying to install 2008 SQL Server Enterprise client tools on Windows XP Professional 2002 SP3. I am an administrator in the machine I'm trying to install it on and I'm getting the above error.

Here's the detail.txt file contents related to this error:

2010-10-14 13:19:17 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2010-10-14 13:19:17 Slp: Inner exceptions are being indented
2010-10-14 13:19:17 Slp:
2010-10-14 13:19:17 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2010-10-14 13:19:17 Slp:     Message:
2010-10-14 13:19:17 Slp:         The process does not possess the 'SeSecurityPrivilege' privilege which is required for this operation.
2010-10-14 13:19:17 Slp:     Data:
2010-10-14 13:19:17 Slp:       DisableRetry = true
2010-10-14 13:19:17 Slp:     Inner exception type: System.Security.AccessControl.PrivilegeNotHeldException
2010-10-14 13:19:17 Slp:         Message:
2010-10-14 13:19:17 Slp:                 The process does not possess the 'SeSecurityPrivilege' privilege which

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend