The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.
2002-01-15
1,177 reads
This script refines the one submitted by pochinej. It returns the data in table format instead of table by table.
2002-01-07
767 reads
I created this SP for use with our morning DW builds. I use it to manage the execution of multiple jobs. It first starts up to a configureable number of jobs, monitors these jobs until one (or more) complete, and then starts additional jobs as needed. If any jobs fail, it will run the "transaction […]
2002-01-06
233 reads
This is simple Sql command to send Message to users connected in Windows NT Environment. The Xp_cmdshell stored procedure can be used along with WinNT net send command.
2002-01-06
540 reads
I'm posting this job script because it gets used by my scheduler script. It simply enumerates through each database on the server, and then executes a DBCC SHRINKDATABASE. The only wrinkle here is that I have it do a quick check to make sure that certain jobs are not already running.
2002-01-04
1,177 reads
I've included this job script, because it is used by the scheduler scripts that I've also posted. This job is a little more involved than most may need... It first checks to see if certain jobs are running. Is so, it waits for a while, and then checks again. After that it drops the existing […]
2002-01-04
1,139 reads
I created this script in an attempt to better automate many different jobs that run each morning, as part of a datawarehouse build. I use it to not only tell me what jobs are currently running (so that I can manage how many I would like to run at a time), but what happened to […]
2002-01-03
1,276 reads
Here is a port from the Oracle's TRANSLATE function to T-SQL. It gets three arguments: a string to be searched, a string with a set of characters to be found and replaced, and another set of characters as the replacements. Example: SELECT dbo.TRANSLATE('ABCDE', 'BD', 'CE') It will return 'ACCEE'.
2002-01-03
479 reads
Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review!
2002-01-02
3,686 reads
For all tables in the current database, it will script the DBCC command to reset the identity seed to 1 for all columns using them. Very handy for data migration.
2002-01-01
844 reads
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, Our old server is on its last legs, and I'm transitioning to a...
Comments posted to this topic are about the item Docker Advice for SQL Server...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers