Additional Articles


Technical Article

Schemas in ADO.NET 2.0

When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.

2004-09-06

853 reads

Technical Article

Script to transfer logins to second server

Modification of DR_Script_Logins.sql by Bruce Canady.Puts out a script to add new logins or change the password of existing logins.I insert the output into a table in my production-db.   insert database.dbo.login_table exec master.dbo.dr_script_loginsThat way its backed up with the data, and the logins can be restored anywhere by the script i added at the […]

5 (1)

You rated this post out of 5. Change rating

2004-09-03 (first published: )

2,521 reads

Technical Article

Search for text in procedures and show context

This script will search for text within stored procedures and udf's. As a bonus, it will also diplay a user-configurable number of lines from each stored proc to show the search text "in context" so you can tell if it is something you need to deal with without having to open every proc manually.

You rated this post out of 5. Change rating

2004-08-30 (first published: )

248 reads

Technical Article

Bulk Insert proc to try out ur optimization skills

This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as […]

You rated this post out of 5. Change rating

2004-08-26 (first published: )

201 reads

Blogs

A Conversation That Refused to End: What We Learned from Our First Event in Zurich

By

On May 8, 2025, we hosted our first official event in Switzerland at Prime...

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

Read the latest Blogs

Forums

Are Data Breaches Inevitable?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are Data Breaches Inevitable?

The Internals of Writing a Page

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Internals of Writing a...

How to Safely Remove a SQL Server Data File Without Downtime

By shukla.chandan12

Comments posted to this topic are about the item How to Safely Remove a...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers