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
626 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,173 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,288 reads
Script for finding matching patterns using regular expressions syntax.Created by Eva Zadoyenezadoyen@ssd.com06/20/2002
2002-06-20
898 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
714 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
538 reads
There are various utilities for scripting MS SQL Server objects : Tables , Procedures , Functions .... etc ...Small piece of code that will allow you to script all jobs from your SQL Server using SQL DMO object.
2002-06-17
1,352 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
528 reads
This script will create a procedure to list all databases on the server (except tempdb), the last time the database was backed up (database backup, not log backups), and a comment which could be customized. For my purposes, I flag any database which hasn't been backed up in the last week. This provides a quick […]
2002-06-14
3,184 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,080 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers