SQL Server's Reporting Services comes with some pre-built reports to be able to monitor who is doing what with your Reporting Services Server. You can find these reports in the \Extras\Execution Log Sample Reports folder on the product CD-ROM (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp). One of the reports is titled "Todays Reports" (Todays Reports.rdl/pToday Dataset). It should show the […]
2005-01-27 (first published: 2005-01-07)
890 reads
This is a very cool time saving ActiveX Script, run manually from within DTS Designer, that generates date and sequence named backups of the package into the specified development and backup folders. Don't ever lose work again.
2005-01-26 (first published: 2005-01-08)
101 reads
I have found that I can add wildcard support to the Advanced Search Stored Procedure submitted by jgroseth (Posted: 07/02/2004) here:http://www.sqlservercentral.com/scripts/contributions/1201.aspby simply modifying "charindex( c.string," to "patindex('%' + c.string + '%'"I did this to take varying whitespace into account since SQL server does not care about whitespace, for example "INSERT INTO DATABASE_MYTABLE" could have any […]
2005-01-25 (first published: 2005-01-10)
513 reads
Here's a short script to generate a random alphanumeric string based on newid(). The procedure takes in length (@len) which determines the key length. Length must be between 8 and 32. Result is returned in an output parameter. A test script is supplied.
2005-01-24 (first published: 2005-01-10)
1,280 reads
Desc : This SQL statement will provide script for backup all your jobs.Remark : Grow-up 'maximum characters per column' (for 8192) and disable 'print column headers' in 'tools' / 'options'
2005-01-21 (first published: 2005-01-11)
1,056 reads
