Robert Davis

  • Interests: Poker, computers, reading/writing horror fiction

Technical Article

Check and Set Default file Locations with TSQL

Checks the default file locations for your data and log files. If not set, it sets them to the specified values. This is written for a SQL 2005 default instance. Registry paths may be different for SQL 2000 or named instances.The script can be easily modified to update it if the current value is set […]

(2)

You rated this post out of 5. Change rating

2007-01-01 (first published: )

894 reads

Blogs

SQL Server sa Account Security: Rename, Disable & Best Practices

By

SQL Server sa Account Security: Rename, Disable & Best Practices In...

Stanford Emerging Technology Review 2026 Report is out

By

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...

How I Troubleshoot a Slow SQL Server Live

By

No two SQL Server environments are alike. A fix that resolves a performance issue...

Read the latest Blogs

Forums

Are You Working More Hours?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Working More Hours?

Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

A Limited Startup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Limited Startup

Visit the forum

Question of the Day

A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics
What does this do?

See possible answers