generates an runs a select statement to convert all th olumns of a certain datatype in apirticular table to another datatype:eg all columns of type int to varchar etc the sp takes three parameters namely the table name, source data type and detination data type generates a select query ad executes it eg: exec ConvertTableTypes […]
2007-07-10 (first published: 2006-10-10)
217 reads
This script lists all the foreign keys ,the referenced and the referencing tables , along with the column information.
2007-07-09 (first published: 2006-10-04)
343 reads
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
209 reads
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
363 reads
I mark my SQL with a 'Todo' symbol whenever I decide something needs work, but I don't have the time to do it right away. So I wrote this usp so that I can get a quick list of stored procedures, function and views that need some extra work.It also comes in handy whenever you […]
2007-07-06 (first published: 2006-10-03)
318 reads
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
598 reads
Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]
2007-07-04 (first published: 2006-10-03)
159 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
115 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
461 reads
This script combines functionality of sp_helpindex and sp_spaceused to list all tables with individual indexes, their keys and description (sp_spaceused cannot do that) and size in MB per individual index (sp_helpindex cannot do that either). Feel free to use and modify as you see fit. Hope it can help.
2007-07-03 (first published: 2006-09-25)
2,677 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers