Simon Sabin


sp_ServerStatus

Have you ever wanted to check that a server exists before using it. Here is a solution that use SQLDMO from within TSQL to get the status of a SQL Server service. It also works for 2000 instances. I have named it sp_ServerStatus for it to be based in master.This returns the status integer and […]

2002-11-14

583 reads

sp_xml_PrepareDocumentFromColumn

Do you want to use OPENXML with an xml document in a table, this procdure will do it for you.Pass in the SQL that will return the column of data, it will return the document handle which can then be used with OPENXML.ExampleDROP TABLE TabCREATE TABLE Tab (doc ntext)INSERT INTO Tab VALUES ('' + REPLICATE('' […]

2002-11-14

511 reads

Function and SP to find if file/directory exists

This function and stored procedure can be used to easily identify if a file, directory or parent directory exist. It wraps the functionality of xp_fileExist but gives easy access to the directory and parent directory exist values.To use it the function pass in the file or path and either 'IsFile', 'IsDir' or 'HasParentDir' it will […]

1.33 (3)

2002-11-13

2,876 reads

Blogs

Nerd Journey Podcast with Nick Korte

By

I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey....

Daily Coping 18 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a configurable SSMS script

By

Several times over the last few weeks I’ve gotten a request to create a...

Read the latest Blogs

Forums

Hostage Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hostage Data

Multiplying Vectors in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiplying Vectors in R

Hidden Pitfalls with INNER JOIN and NOT IN Operators

By MMartin1

Comments posted to this topic are about the item Hidden Pitfalls with INNER JOIN...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers