Find a string in Procedures, Triggers, Constraints, Defaults, Functions, and Views. First off this will not work for any items that have the WITH ENCRYPTION remark in them. With this is can pose a string such as 'INSERT' against all the 'P'rocedures to get a return of which Procedures have an INSERT statment in them […]
2002-02-21
1,714 reads
If you've ever been stuck having to write stored procedures to support an application, check this script out. This script will automatically generate seperate parameter driven select, insert, delete, and update stored procedures. Simply call these stored procedures from your application, passing parameters. This stored procedure requires only one parameter; table name. Creates scripts with […]
2002-02-21
336 reads
That is a good script but with a little problem. It shows 1 less table than in the schema. Its not a script from me so I have not changed the contributor's name.The only change is I have made is moved FETCH NEXT statement at the end of the loop and removed IF @@FETCH_STATUS = […]
2002-02-18
161 reads
The following batchfile demonstrates how to use Windows command extension to extract the values of sp_spaceused for each table in the database. The output of sp_spaceused itself contains strings that do not get easily analyzed. The batch file extracts the numbers and outputs the sizes for each table in the database.Copy the batchfile to a […]
2002-02-18
2,287 reads
If you've ever needed a convenient and quick way to convert/validate what could possibly be a mm/yy or mm/yyyy date to mm/dd/yyyy (date of month is 01) check out this custom function. Eg: select dbo.datemy('04/02') outputs smalldatetime '2002-04-01 00:00:00'. Select dbo.datemy('04/2002') outputs the same smalldatetime '2002-04-01 00:00:00'.
2002-02-15
876 reads
You can effectively rename a user account but as this is messing wit the system tables I would suggest dropping and adding the user back. But for those of you who really want to know how here it is.First off I tested this and it works fine renaming a user. However this is directly modifying […]
2002-02-14
928 reads
Have you ever wanted to have SQL note a failure on a step, yet continue running the job. I found it to be annoying that you have to fail (and end) a job in order to send a message to an operator. I have processes that run at off times, I want to know when […]
2002-02-13
2,302 reads
This is a simple function I use to get the month/day/year of a datetime value.Usage:Select mydb.dbo.udfmmddyyyy(Getdate()) Note: This is easily modified for British/Australian date format.
2002-02-11
1,167 reads
Since SQL Server stores time as a full datetime value, I use this script to return just the time part formatted as hh:mm:ss.Usage:Select mydb.dbo.udfHHMMSS(Getdate())
2002-02-11
919 reads
I occasionally need to return a month and year but would like the month as a 3 letter abbreviation instead of a number. This is useful for reports.Usage:Select mydb.dbo.udfmmm_yyyy(Getdate())
2002-02-11
995 reads
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
Comments posted to this topic are about the item The AI Bubble and the...
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers