This script is used to disconnect all connections by a particular individual to a server. I use it when I have to disconnect somebody and they have too many processes to do it by hand. Normally, you can just connect the offending process, but if there are multiple processes that are causing a problem , […]
2004-03-08
2,821 reads
Found a version of this on the net. removed the loop and if/thens and made it a case statement 2004-03-11: Changed '@%@' to '%@%@%'
2004-03-08
422 reads
This function returns the difference between dates in the H:MM:SS format.
2004-03-05
261 reads
This sp will return the column names for a table(s) and form a "Select Statement" for a table(s). We can pass a table name as a parameter to display a "Select Statement" for that table.
2004-03-04
113 reads
2004-03-04
146 reads
This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]
2004-03-04
1,010 reads
This script creates a stored procedure that archives the sql server error log. It uses the startup parameters stored in the registry to locate the errorlog.1 file and then copies the errorlog.1 file to errorlog.log.
2004-03-02
338 reads
This Script takes any table wich contains rows with names and valus and converts it into a result set with the names as collumn names and the values as values.Just set @TableName,@vcName,@vcValue to the desired values.
2004-03-02
191 reads
For those site using SQL Server ids as opposed to Integrated security there may be instances where occasionally SQL Server logins might get 'orphaned'. That is the login is not a member of any server group that has general database access nor does that login have specific access to any particular database. Compile this proc […]
2004-03-01
281 reads
This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]
2004-03-01
1,285 reads
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Comments posted to this topic are about the item Getting the Object Code
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Being Mindful of Design Time
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers