SQL SCRIPT to grant DBC_Execute to all user defined Stored Procs.This SQL SCRIPT is handy specially after Stored Procs are DROPPED & CREATED; often users dont mention the SQL to grant DBC_Execute permission to the Store Procs.This SQL SCRIPT will grant execute permission to DBC_Execute for all user defined Stored Procs. The SCRIPT can be […]
2004-10-03
213 reads
2004-10-01 (first published: 2004-02-16)
148 reads
This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a […]
2004-10-01
563 reads
This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]
2004-09-30
459 reads
A script was recently published (Last_Date_Of_Month) that returns the last day of a given month/year combination. I have simplified and improved on that script by eliminating the need to use a WHILE loop. This new script exploits the flexibility of the DATEADD function which allows you to assign negative numbers (thus effectively subtracting a given […]
2004-09-30
189 reads
2004-09-30 (first published: 2004-02-16)
105 reads
Two Method for Return the Count of Weekday between two date!
2004-09-30
343 reads
playyuer@Microshaoft.com inventhttp://www.Microshaoft.com2004-09-29 updatethere is NOT any relation with global variable: @@DATEFIRSTyou can set datefirst any value from 0 to 7 and result can not be affected!
2004-09-29
180 reads
This function returns the difference between dates in the HH:MM:SS format.
2004-09-27 (first published: 2004-03-08)
127 reads
2004-09-25
90 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Training the next generation
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers