Blogs about: Sql 2000
Featured Blog
SQL Server – Find Field Value in Database
The following is a SQL Script that can be run in a database to return all tables and columns where a particular value is present. This can be used for strings or values with a small modification. Thi… more →
BraveWord
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
fisherpeter wrote 1 week ago: msdn seems to have a reasonable description of the problem here. However my SQL Server log does not … more →
Delete Duplicate Rows
melissasuciadi wrote 1 week ago: There are some cases when you need to do cleanse on your duplicate data. Below I provide some way to … more →
How to get an empty table from a sql query in VB 2005 (.net) without timeouts
fisherpeter wrote 2 weeks ago: Its simple – write a select that guarantees the return of nothing. You will need to know your … more →
bcp and brackets [x_x].[dbo].[T_TableName] SQLState = 37000, NativeError = 4060
fisherpeter wrote 2 weeks ago: Bizarrely the format [x_x].[dbo].[TableName] in the BCP command gives SQLState = 37000, NativeError … more →
Global Cyber News Bits, September 3, 2009 from CommunityDNS
CommunityDNS wrote 3 months ago: Provided by CommunityDNS, the information in this post consists of news items in the security-based … more →
SQL Server Versions
sqlserversolutions wrote 4 months ago: Version Release Sqlservr.exe SQL 2008 SQL Server 2008 Service Pack 1 2007.100.2531.0 SQL Server 2008 … more →
When Execution Plans Go Bad
adamgrande wrote 5 months ago: I have decided to (finally) do a technical article… This was one of the ‘promised things … more →
Viewing The SQL Error Log
Jack wrote 5 months ago: The error log – the first place you should look to diagnose issues and errors within SQL Serve … more →
Formatted date in SQL Server 2008
rishka wrote 6 months ago: Found an interesting article about Formatted date in SQL Server 2008 in the http://www.databasejourn … more →
NTEXT vs NVARCHAR(MAX) in SQL 2005
Bilal wrote 6 months ago: I recently profiled a sproc that makes heavy use of the TSQL SUBSTRING function (hundreds of thousan … more →
MS SQL Paging records using Stored Procedure and DataGrid custom paging
Manager wrote 9 months ago: Data grid with custom paging Demo Source: Download (C# asp.net 1.1) Create Store Procedure in North … more →
SQL Server – Find Field Value in Database
BraveWord wrote 11 months ago: The following is a SQL Script that can be run in a database to return all tables and columns where a … more →
Working with files and the FileSystemObject
BraveWord wrote 11 months ago: By Darren Green Version 7.0/2000 Level Intermediat The ability to work with files gives us great fle … more →
How can I check if a file exists?
BraveWord wrote 11 months ago: By Darren Green Version 2000 Level Intermediate Checking for the existence of a file before trying t … more →
Global Variables and SQL statements in DTS
BraveWord wrote 11 months ago: By Darren Green Version 7.0+/2000 Level Advanced For those fortunate enough to have SQL 2000, using … more →
Global Variables and Stored Procedure Parameters
— 2 comments
BraveWord wrote 11 months ago: By Darren Green Version 2000 Input Parameters One of the benefits of the SQL Server 2000 is that the … more →
SQL Interview Questions
BraveWord wrote 11 months ago: What are two methods of retrieving SQL? What cursor type do you use to retrieve multiple recordsets? … more →
Microsoft Warns of SQL Attacks
Ajay Matharu wrote 11 months ago: Just days after patching a critical flaw in its Internet Explorer browser, Microsoft is now warning … more →
Permissions
Karlo Bartels wrote 1 year ago: Last week I ran into some permission problems while running a change script on a client’s acce … more →
