This script allows you to dynamically alter all the tables in your database. In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)
2002-07-04
762 reads
This script search the active database for the stringyou're looking for.It searhes with in Table Names, Table Columns, Views, SP's, Triggers, Indexes and System Tables.Enjoy it ...
2002-07-03
520 reads
It's not a SQL book and the code examples are in Java, but there is a lot to like about this book. What is refactoring? How would you find it useful? Read the review to find out!
2002-07-02
3,524 reads
Script for finding matching patterns using regular expressions syntax.Created by Eva Zadoyenezadoyen@ssd.com06/20/2002
2002-06-20
855 reads
2007-10-02 (first published: 2002-06-20)
15,463 reads
Microsoft reported BUG :ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E .When you execute the ListAvailableServers method of the SQLDMO.Application object from an ASP page, the following error message may occur: Microsoft SQL-DMO (0x800A000E) [SQL-DMO]Not enough storage is available to complete this operation. However, there is some solution to get SQL servers using Client […]
2002-06-19
495 reads
TSQL:Procedure to Lookup JobsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases scheduled tasks or jobs as they are now called.Here […]
2002-06-16
486 reads
I was looking over internet trying to find a SP or UDFto replace string accourences in the Text fields, I didn'tfind any so I created ths trigger, may be it will be usefull as example. Be aware on the big documents it can be time consuming.All it does is replacing < and > substrings of […]
2002-06-14
544 reads
I wrote this for the developers because they were always asking me to find all of their stored procedures that did X.It scans through the syscomments text in each database looking for the requested string. User must have read access on the syscomments and sysobjects tables in each database.
2002-06-14
1,009 reads
Returns a single row with a single column containing a comma-separated list of the field names for a specified table. I find this very useful when doing INSERT statements where I have to list out each field being inserted. I simply bind this proc to a hotkey and use the hotkey to get the comma-separated […]
2002-06-12
1,274 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
We want to setup a gateway db to host stored procedures which use tables...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers