This script will set the Logging properties for a group of DTS packages. To run this script stand-alone, you'll need to set 6 variables. sSvr, sDb, sUid, sPwd, iSec and sPkgMatch. If you use this script in a DTS package, you can assign the values from Global Variables. The sPkgMatch variable is used as a […]
2003-12-01
460 reads
This script generates an HTML report on the status of all jobs on a specific SQL Server instance. The report consists of several sections: a summary report of jobs that have passed, failed, been cancelled, or whose status is unknown; a detailed report of the status of each job.The script is designed to be included […]
2003-12-01
950 reads
Word can do that. Why SQL not? Sometimes I want to see every space, horizontal tabulation, line feed or carriage return. It can help to write well formated store procedures.
2003-11-28
402 reads
this procedure takes a character, tablename and columnname as input-parameter; on execution it removes the given leading character from the table-column - as well as leading blanks. small and easy but very helpful.
2003-11-27
178 reads
I pieced this script together from solutions I found on this and from Brian Knight's excellent book. It creates 3 tables: - tblDriveLogs. Collects free drivespace info for each drive for each time the script is run. - tblIndexLogs. Collects info on spaceused for each index and table. Please note that when only af single […]
2003-11-26
927 reads
This "script" truncates all user tables in a database (except dtproperties). It uses sp_msforeachtable stored procedure which cycles through each table in the database and performs the same query on each. Its useful in a number of different scenarios
2003-11-24
306 reads
2003-11-20
300 reads
This script creates a temp table of all the tables in a database and loops through a cursor to truncate them.
2003-11-20
324 reads
Persons Names,Addresses or any other master information if not entered with proper case . I mean if some records are with All caps ,some with all small or any other combination.You may be able to convert this data to proper case. Which will help you to show it in better looks on websites or in […]
2003-11-19
551 reads
This script starts in the master database, and then goes to each USER database and creates the DDL for each USER table in every database. You can then save the results or copy them to a new query window to run on another server.
2003-11-14
547 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers