In Microsoft SQL Server 2000, you receive one of the following error messages: Error message 1 Error = -2146828197 (800A005B) Error string: Object variable or With block variable not set Error source: DSO Error message 2 Error = -2147417848 (80010108) Error string: Object Invoked has dis
Tag: sql server
Making good use of Sysforeignkeys table — Part 2 Check Table Relation
(Jeffrey Yao) When I sometimes have to review the design of a database which has been survived for a long time with various DBAs / developers adding a few tables here, modifying some columns there, and deleting some constraints anywhere, I must say I always try to find as many problems as possible a
Book Review: In the Trenches with SQL Server & .NET
(Danny Lesandrini) The Hypnerotomachia Poliphili (pronounced Hip-ner-AH-toe-mak-ee-a Poh-LI-fi-ly) is an ancient text that is the subject of a da Vinci Code style best seller named Rule Of Four. This obscure text, completed in 1499, is clearly the work of someone versed in multiple disciplines;
Stop SQL Injection Attacks Before They Stop You
(Paul Litwin) Armed with advanced server-side technologies like ASP.NET and powerful database servers such as Microsoft SQL Server, developers are able to create dynamic, data-driven Web sites with incredible ease. But the power of ASP.NET and SQL can easily be used against you by hackers mounting a
Restoring a SQL Database
(Muthusamy Anantha Kumar) When we create a backup maintenance plan with one Full backup and transaction log backups for every 15 minutes, it is sometimes necessary to restore the FULL backup and all the corresponding transactional backups sequentially. This may happen if the production box goes down
Backup Scenarios for successful SQL Server Restores and Recovery
(Bilal Ahmed) The intent of this document is to explore various backup scenario plans for SQL servers and come up with a recommendation to successfully restore them when the need arises. Database Administrators (DBAs) typically spend most of their time working on configuring and monitoring backu
Introduction to Expressions on Workflow
(Allan Mitchell) SQL Server 2005 gives us loads of flexibility in our workflow management to decide how and if the following task should be executed. In this article we are going to introduce you to one of those ways and that is putting an expression into the workflow constraint itself.
Anatomy of a Performance Solution
(Kalen Delaney) I get a lot of nice feedback about my columns and classes, but some people ask me why they should bother learning how SQL Server works. I study internals often just for a deeper understanding of my favorite software and for the experience of learning something new. But many of my rea
sp_who_3 : An Enhanced and Efficient Version of sp_who
(Narayana Vyas Kondreddi) As you probably know, there’s a system stored procedure called sp_who, that provides information about current Microsoft SQL Server processes and users. Output of this stored procedure can be used for troubleshooting performance problems and blocking issues. Microsoft a
SQL Server Health and History Tool (SQLH2)
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used.
