benjamin potts | SQLServerCentral

benjamin potts

Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

RE: determining whether a directory exists? xp_dirtree, xp_subdirs ?

Thanks for the help guys

September 9, 2005 at 3:12 am

#588648
RE: running a stored procedure against all databases on a server

solved it thanks again Kenneth Wilhelmsson
exec sp_msforeachdb 'if exists(select * from master..sysdatabases where name = ''?'') use ?
if exists(select *
from ?..sysobjects...

September 6, 2005 at 5:52 am

#587726
RE: running a stored procedure against all databases on a server

thats great. works a treat!
one last thing though if someone has an idea....
there are other different types of databases on the server, ones that im not bothered about and these...

September 6, 2005 at 4:39 am

#587717

Viewing 3 posts - 1 through 4 (of 4 total)