Generates a VB6/ADO procedure prototype, procedure call, and ADO Command Object Parameters.Append calls. To use, simply set the @spname variable equal to the name of your stored procedure, run, and cut and paste the output into you VB program. The generated code may require some slight modifications, but this should save you a lot of […]
2002-07-04
1,090 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
533 reads
You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]
2002-07-02
1,113 reads
An Improved version of GetFileInfo that now includes the space utilization of each datafile. Provides more detail per file. Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server. A cursor is used to get the information from each database. The […]
2002-06-28
585 reads
This SQL2000 function accepts a delimited list of values as a string and the character you want to use as a delimiter.The function then splits these out and returns them as a table.The function assumes that the input string will contain unique integer values.Useage: - SELECT Id FROM fnSplit('1,2,3,4' , ',')
2002-06-27
602 reads
This script organizes information about the database files on the server. A cursor is used to get the information from each database. The information is reported in Megabytes, including the next allocation from disk. No bells and whistles...and if I can find how dbcc showfilestats works I will add the amount of space used in […]
2002-06-24
1,137 reads
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job.
2002-06-20
4,271 reads
Script for finding matching patterns using regular expressions syntax.Created by Eva Zadoyenezadoyen@ssd.com06/20/2002
2002-06-20
872 reads
This script can be divided into two parts one at the beginning of the script and the other at the end of a script. It parses the getdate() and runs datediff to give you an easy to read info on the time taken to execute a script. It is easy to get this info from […]
2002-06-20
690 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
509 reads
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
Comments posted to this topic are about the item Collecting Data Is Hard
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers