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

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

SQL Server 2008 Profiler--Templates Missing

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
For some reason (even after an uninstall, reinstall and updating the the Community Update) there are no templates visible in the Profiler for SQL Server 2008. On another system it works fine but the Trace Provider Type shows "Microsoft SQL Server 2008". On the problem system it shows "Microsoft SQL Server 10.0".   What's up?

View Complete Post

More Related Resource Links

SQL Server 2008 - Missing SQL services


I followed the thread on "SQL 2008 Services missing" and pretty much did everything the threads suggested.  I am running Win/XP (SP3), and up until a few days ago was running SQL Express 2005 successfully for a couple of years.  I decided to upgraded to 2008 to be consistent with others co-workers on current projects. 

Long and short of it, I completely had to strip out 2005 and reinstall 2008.  After a couple of runs at it, it all appeared to install clean and neat, until I attempted to log onto the local server (which shows up as installed in Add/Remove programs, just not as a service either in SQL configuration tool or from the Services list under XP.)

Despite following the SQL Express logon instructions from the previous thread I mentioned, I continually get the error

Cannot connect to ..

A network-related or instance specific error occurred while establishing a connection to SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that the SQL Serve is configured to allow remove connections. (provider:  Named Pipes Provider, error: 40 - could not open a connection to SQL server) (Microsoft SQL Server, Error: 2)

Server type - "Database Engine"

Server name - "." and "./SQLEXPRESS" (neither have worked thu

SQL server 2008 profiler


I am trying to run a trace in the SQL management studio to find out queries taking long time to run. But the when I do the new trace it only lets me select an instance but not a particular DB. How can find out about the quires in  a particular DB.


SQL Server 2008 R2 Missing Maintenance Plan Wizard

I do not see the "Maintenace Plan" option under the "Management" folder in SQL Server Mgt Studio

SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

I am attempting to install SQL Server 2008 Developer Edition on my laptop.  I already have VS 2008 SP1 installed and the .NET Framework 3.5 SP1 installed on my machine.  When I run setup.exe, it fails saying the .NET Framework 3.5 installation failed and that .NET Framework 3.5 is required for the installation.  I obviously have this already on my machine.  What's the problem and how do I get this to install?  Below is the text in my SqlSetup.log file:

10/10/2008 13:22:25.453 ======================================================================
10/10/2008 13:22:25.515 Setup launched
10/10/2008 13:22:25.546 Attempting to determine media source
10/10/2008 13:22:25.562 Media source value not specified on command line argument.
10/10/2008 13:22:25.578 Setup is launched from media directly so default the value to the current folder.
10/10/2008 13:22:25.609 Media source: C:\Downloads\en_sql_server_2008_developer_x86_x64_ia64_dvd_x14-88839\
10/10/2008 13:22:25.640 Attempt to determine media layout based on file 'C:\Downloads\en_sql_server_2008_developer_x86_x64_ia64_dvd_x14-88839\mediainfo.xml'.
10/10/2008 13:22:25.703 Media layout is detected as: Full
10/10/2008 13:22:25.718 Media LCID is detected as: 1033
10/10/2008 13:22:25.734 Local setup.exe not found, so continuing to run setup.exe from media.

Invalid or missing username or password. - Installing SQL 2008 on Server 2008


I'm new to SQL 2008 and while installing I receive the following error during as I'm installing. 

Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service.


I attened the SQL/Server/VS 2008 launch in LA and was given time bomb copies of SQL/Server 2008. 

On a new machine I installed Server 2008.  (It't a stand alone machine, no AD.)

After Server 2008 installation was completed I tried to install SQL 2008.

I'm hung on the install on the user name/password page.


I'm assuming the account I specify does not have to be created, SQL will do it, or is that my problem?


Can you offer any assistance?



Microsoft.SqlServer.SMOEnum dll missing in Sql Server 2008


I am Creating a Project in SQL Server 2005 for Finding the Database Servers in the Network using SQL SMO.

But when I Upgrade my project from SQL Server 2005 to SQL Server 2008, my code throws some SMO Error.

My Code is looks like :


Function FindServers()

    Dim dtlSQLServers As DataTable


      dtlSQLServers = SmoApplication.EnumAvailableSqlServers(True)

    Catch ex As Exception


      dtlSQLServers = Nothing

    End Try

    Return dtlSQLServers

  End Function

SmoApplication throws error and shows that it is unavaliable in SQL Server 2008.

and not found manually C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.SmoEnum.dll.


So, what is the substitue of SMOEnum ?

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Missing 'new item templates'


 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.


Michael J. Hill

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

PostGreSQL to sql server 2008?



I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?



Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

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

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

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