Automatically Running Stored Procedures at SQL Server Startup
I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?
2008-09-11
3,855 reads
Additional Articles
Managing SQL Server Database and Application Metadata
Unless you are the Database Administrator or the Application Analyst for a particular database you are usually oblivious to the naming conventions of the databases that support the applications you rely upon daily. This is why it is important to have the metadata repository in place to provide that translation when the need arises.
2008-09-11
2,992 reads
Benefits and limitations of using synonyms in SQL Server 2005
A SYNONYM is new to SQL Server 2005. It is a way to give an alias to an already existing or potential new object. It is just a pointer or reference, so it is not considered to be an object.
2008-09-10
5,600 reads
Terminate User processes in SQL Server
This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.
2008-09-10
4,612 reads
SQL Server 2008 Capture DML Changes Using Change Data Capture
In this article Ashish continues to explore the Change Data Capture feature in SQL Server 2008. This article demonstrates how to track DML changes
2008-09-09
1,817 reads
What is SQL Server
This refresher on SQL Server examines when to use a database as well when not to, along with some of the key terms used with SQL Server.
2008-09-09
3,025 reads
Database Mirroring Automating Failover for Multiple Databases
Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure the mirrored server takes over for this one database, but all other databases remain functional on the primary server.
2008-09-08
4,007 reads
Accessing SQL Server Databases with PHP
This paper discusses how to use several of these features by closely examining parts of the Example Application in the SQL Server 2005 Driver for PHP product documentation in MSDN. This paper assumes that the reader is familiar with programming in PHP, that the reader has a computer that meets the System Requirements listed for using the driver, and that the AdventureWorks example database is installed from CodePlex.
2008-09-05
4,942 reads
Should I Use a UNIQUE Constraint or a Unique Index in SQL Server?
I am modifying a table and I need to add a column that must be defined as being unique. I see that SQL Server allows you to define a UNIQUE constraint on a column but I also see that you can create a unique index on a column. Which one should I use?
2008-09-05
8,319 reads
Administrator & Monitoring Change Data Capture in SQL Server 2008
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008
2008-09-04
2,481 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers