2008-02-25 (first published: 2008-01-15)
911 reads
Scripting extended properties
I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]
2006-01-05 (first published: 2005-11-11)
1,221 reads
Blogs
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what...
Daily Coping 19 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Select "New Customer"
Hi , Has anyone tried to do this...I'm trying to select only "new customers"...
Get local server's alias in T-SQL
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Get local server's alias in T-SQL
Hello, I'm trying to determine if there's a way to get a server's alias...
Ask SSC