Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.
2001-07-05
3,522 reads
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,866 reads
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
2001-06-18
5,424 reads
2001-06-15
7,465 reads
In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.
2001-06-13
8,286 reads
Anyone that has ever forgotten a WHERE clause in an UPDATE or DELETE syntax still has the bruises. Log Explorer 2.0 has a way of reversing your mistakes by peering into the transaction log and rolling back transactions. This, week Brian Knight reviews this product.
2001-06-11
7,752 reads
XP_FILEEXIST gives you the ability to find files and directories. Find out how else you can use it in this article.
2001-06-08
20,660 reads
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
2001-06-01
8,419 reads
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,795 reads
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,075 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers