This procedure can search all columns in one or all tables for a specified string. Prints out the TableName.ColumnName that the string is found in...-- Example Calls-- EXECUTE spFindTextInColumns MyTable, 'tcart' --search a specific table-- -- EXECUTE spFindTextInColumns default, 'tcart' --search all tables BUG FIX : (2003/01/20) Changed SELECT @columnName […]
2003-01-09
972 reads
Use the sp_MSforeachtable stored procedure to run the sp_spaceused stored procedure for every table in a database
2003-01-08
123 reads
One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server. The initial transfer of users and passwords was performed by the sp_help_revlogin script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. The difficulty with this script was once the users are in place, you cant sync changed […]
2003-01-08
162 reads
This UDF will return the checksum for a SP or UDF to help tracking changes to the code.Example:print dbo.OBchecksum('hello')
2003-01-07
177 reads
This script can be used to display the number of rows of all the tables in a database.
2003-01-02
330 reads
You can use it when you want to generate a script which can insert data row by row.
2002-12-31
422 reads
This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements. The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]
2002-12-26
225 reads
This script uses sysobjects and sysindexes to ID all tables in a database that are indexed, and/or clustered. It then runs through per table all of the indexes and runs DBREINDEX with their fillfactor. This eliminates having to maintain a list of all indexes and having code fail when it tries to modify indexes that […]
2002-12-19
1,796 reads
Yee Haa, as if we couldn't annoy our users more with message boxes, emails, and other friendly pop ups ;P here comes the net send. Has a test for success to determine if the send worked. If an invalid name is entered it can take a bit to fail, so don't use this from a […]
2002-12-18
348 reads
These are little more than wrapper functions for xp_regread and xp_regwrite, but lets them be callable from views, if you desire to do so.
2002-12-18
194 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers