.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

CLR Integration With Microsoft SQL Server

Posted By: Faizal     Posted Date: December 04, 2009    Points: 2   Category :Sql Server
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

View Complete Post

More Related Resource Links

User Defined Functions in Microsoft SQL Server

User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common uses for functions. LEFT, the built in function for getting the left part of a string, and GETDATE, used for obtaining the current date and time, are two examples of function use. User Defined Functions enable the developer or DBA to create functions of their own, and save them inside SQL Server.

Security Briefs: Add a Security Bug Bar to Microsoft Team Foundation Server 2010


Take a peek inside Microsoft's strict development security structure as Bryan Sullivan describes the objective security bug classification system?the "bug bar"?used by internal product and online services teams. He will show you how to incorporate this classification system into your own development environment using Microsoft Team Foundation Server 2010.

Bryan Sullivan

MSDN Magazine March 2010

CI Server: Redefine Your Build Process with Continuous Integration


Jay Flowers demonstrates how to set up and use a Continuous Integration server using both discrete tools and the more comprehensive CI Factory solution.

Jay Flowers

MSDN Magazine March 2008

Agile Development: Extend Team Foundation Server To Enable Continuous Integration


How does Visual Studio 2005 Team System and Team Foundation Server facilitate the process of agile development and continuous integration? Here Ben Waldron explains it all.

Ben Waldron

MSDN Magazine March 2006

ISA Server 2004: Developing an Application Filter for Microsoft Internet Security and Acceleration S


The beta version of Internet Security and Acceleration (ISA) Server 2004 is now publicly available. It includes a rich SDK with several extensibility mechanisms that allow third parties to integrate their specialized solutions on top of the ISA platform. In this article, the author explores the application filter extensibility mechanism, which enables you to add high-level application layer filtering capabilities to ISA Server and to provide rich content filtering solutions. He also highlights the new features of the ISA Server 2004 SDK, then moves on to describe how to develop a basic application filter that monitors all data going through the ISA Server, and how to integrate a filter into the ISA Server management console to create a seamless interface experience for your users.

Yigal Edery

MSDN Magazine March 2004

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

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

"This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported"



I am getting the following error when i want to add a remote connection in the Server explorer:

'This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported'

what can be the problem. On Microsoft site i saw, you need to install following update: 'Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'

But i have a Microsft SQL Express Server 2005 SP3...

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Microsoft SharePoint Server 2010 Beta - Now Available!

SharePoint 2010 provides a robust development platform to rapidly build solutions using familiar tools like Visual Studio 2010 and SharePoint Designer 2010. Developers gain access to a rich set of out-of-the-box features such as Business Connectivity Services for read/write integration between application data, the web and Office 2010 client.

Microsoft SharePoint Server 2010: Deprecated Types and Methods

This resource contains text files that list all of the deprecated types and methods in Microsoft SharePoint Server 2010 and Microsoft Office SharePoint Server 2007.

WFE is out of synch? HTTP/1.1 200 OK Server: Microsoft


Encountering a strange situation here.... a little background.

We have 3 nodes.

Two servers are dedicated WFE's. Node 1 & Node 3. They are load balanced with a CSS.

One server is a dedicated indexer/crawler. Node 2.

We recently moved our database from a single server to a SQL cluster. We used the SQL Aliasing method as outlined here:


Everything works great, EXCEPT node3 seems to be out of synch. All existing sites are operating as expected. However, any new site collections I create only function on node1. If you hit node3 you recieve the following:

     HTTP/1.1 200 OK Server: Microsoft-IIS/7.0 Date: Fri, 27 Aug 2010 15:14:17 GMT Connection: close

It's like the site doesn't exist on node3. It doesn't matter if a new site collection is created in a new contentdb or an existing contentdb, it doesn't work on node3. On node1, new site collections are displayed as expected.

Here is what I have tried:

an IISreset on node3.
Initiated a full index.
Manually initiated a sync via stsadm
stsadm -listolddatabases is not listing any orphaned GUIds.
created a new contentdb.
flushed the c

convert to ASP.NET set objHttp = Server.CreateObject("Microsoft.XMLHTTP")


Hi all,

i don't know nothing to ASP and i need your help to convert the following code to ASP.NET

set objHttp = Server.CreateObject("Microsoft.XMLHTTP") 
objHttp.open "POST", "https://api.c4sms.com/?" & strQueryString, false 
objHttp.setRequestHeader "Content-type", "application/x-www-form-urlencoded" 


I need help for this.

Thank you very much.


If you known the full code is:

   Option Explicit 

   'Replace values with your C4 username and password 
   CONST c4USERNAME = "Your C4 Username Here" 
   CONST c4PASSWORD = "Your C4 Password Here" 
   Dim strReturnValue 

   'Function to send the SMS message 
   Function sendSMS(strSendToNumber,strMessage,strFromNumber) 

      'Create new variables 
      Dim strQueryString      'Holds data to post to C4 website 
      Dim objHttp            'The XMLHTTP object to make the post request 
      Dim strResponseTxt      'The response from the C4 server 

      'Build the query string 
      strQueryString = "username=" & c4USERNAME & "&password=" & c4PASSWORD & "&send

Powershell script that uses Microsoft.SqlServer.Management.Smo.Server need to use Sql Server Autheni

I have written a powershell script that uses Microsoft.SqlServer.Management.Smo.Server.  I have a couple of instances that are on different domains that I must use Sql Server authenication.  I am going to create a report user "sssmorpt".  What is the least a can grant this user to allow me to use Microsoft.SqlServer.Management.Smo.Server to get "$dbsize = $db.size - ($db.logfiles|measure-object -property size -sum).sum / 1024" for all databases in an instances?

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81
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