Thanks Wayne this wasn't exactly what I was looking for but your suggestion sparked another thought in my head and that was to use a delimiter other than a comma. ...

No I didn't thanks this seems to give me what I need.

Thanks very much I knew there had to be a simpler way.

Hi Alzdba,

When you say use UNC in stead if it is mapped can you explain a little more.  Do you mean preface the mapping location with UNC i.e. \\UNC\myserver\myshare\...?

Thanks Peddie -- I may fire you an email from time to time if you don't mind.

Appreciate the offer Peddie -- Can SSIS be used with SQL Server 2000 -- my organization has not upgraded to 2005 and I don't suspect they will until the next...

Hi MohammedU,

Please educate me what is SSIS?

Please provide an example -- I tried using it but I think I am using it incorrectly.

Thanks John exactly what I wanted -- do you have a script that provides the names of all tables in a database and the sizing i.e. table_1, 1gig ect.

Hi John,

I want to do this simply to keep my database cleaned up in an automated way.  You bring up a good point about the danger of deleting something required...

Thanks for all your help -- Wow

Thanks Lynn you almost got it right but I was able to figure it out correct syntax is as follows:

select subs_no from some_table where  isnumeric(some_column) = 0

Reverse logic nice

Thanks Lynn you almost got it right but I was able to figure it out correct syntax is as follows:

select subs_no from some_table where  isnumeric(some_column) = 0

Reverse logic nice

Are my expectations of faster speed with a stored procedure incorrect in this instance?  Are there additional things I need to keep in mind when moving manually run code in...

Hi Ninja,

You gave me a clue to my issue when you said post the full sp code, I think my problem is in my use of go's i.e.

Create Proc Pchurn2

as

if...