Browse by Tags

CLR Stored Procedures - handling security on SQL Server side

Published 24 July 8 3:52 AM | SSQA.net

Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework...

Filed under: sql server, security, clr, .NET, code, practices, peverify

A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service

Published 15 May 8 1:9 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A System.InvalidOperationException exception may occur when you try to use a Visual...

Filed under: sql server, kba, .NET, 2003, visual studio, native web services

New and Modified Knowledge Base article for SQL Server 2005 Reporting Services

Published 8 May 8 3:31 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server...

Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode

Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

Published 15 January 8 2:9 AM | SSQA.net

Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error: A connection was successfully established with the server, but then an error occurred during the...

Filed under: sql server, microsoft, download, error, 2008, ctp, .NET, visual studio, system state, protocol, connection, framework

Installing SQL Server X64 on a 64-bit Operating System - problem with .NET framework package

Published 12 September 7 9:40 AM | SSQA.net

I have had problem when installing SQL Server 2005 on one of the 64-bit server, the error was: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. So as per the message...

Filed under: sql server, package, server, error log, directory, x64, .NET, distributed, client tools

ASP.NET & MSDN - How Do I series

Published 17 July 7 8:18 AM | SSQA.net

Speaking of ASP.NET, MSDN is now offering the ASP.NET "How Do I" video series , with dozens of videos designed for all ASP.NET developers, from the novice to the professional. If you are new to ASP.NET, you can learn the basics of how to create...

Filed under: sql server, msdn, .NET, howdoi, asp.net

.Net framework 3.5 beta1 - get now for new features

Published 17 July 7 8:15 AM | SSQA.net

If you are building on the new features in the .NET Framework 3.0, such as Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), and Windows CardSpace, you'll want to preview the The .NET...

Filed under: application, sql server, performance, windows, .NET

Using table-valued functions (TVF) in SQL Server

Published 29 June 7 3:13 AM | SSQA.net

I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular...

Filed under: sql server, performance, memory, function, tvf, feature, table-valued, .NET