ForreachDB has been altered in our organisation, is this any good?

select '?'

as Databasename,* from sysobjects

where name = 'vw_MessageStatus_'

That worked grand, thanks for the quick reply!!!

🙂

No worries guys, just spent two hours and manually added the entire list in Studio, infinite monkeys + infinite typewriters = complete works of Shakespeare and all that, absolute...

Jeffrey Williams (6/16/2008)

---

So, what exactly are you looking for. SSMS is an application that connects to SQL Server. BIDS (Business Intelligence Development Studio) is also an application that...

Mate, I've had SS2K5 installed for a few months now!! Fully loaded!!

:ermm:

Thanks for that!

As for the 2K to 2K migration, if I use the wizards or script out the database completely, will my DTS packages also be migrated across to the...

I'm watching this one closely as I'm in pretty much the same boat.

Largely agree with Eric, however I am sceptical about the Copy-DB wizard, last time I used it (admittedly...

Cheers sweetheart! 🙂

JB

Much appreciated, but remember, I'm a newbie...what do I click to get...

Hi again, I've got the rewrite below, but what I'd like to do is to add a variable that allows the client to enter a start date and finish date,...

Hi Peso, that code worked beautifully!

This will be part of a subquery/join, I hope you can take a look when I've clarified requirement.

Jaybee

No probs guys, sorted out now, I may have cried "help" here before exhausting in-house assets!

🙂

Jaybee.

I suspect Openrowset is allowed, as cmdshell is.  Don't know how to test it though.

Your help is very welcome Gail, I look forward to trying your rewrite.

Cheers,

 

Jaybee.

Thanks, I'd appreciate any help on this, I'm completely null at scripting!  Toyed with the idea of 'Openquery' but I know even less about that, and it'd probably mean a...