yes of course... but... can you create them (somehow) in a disabled state?

Mark!!!

You rock bro!

Many thanks!

wow.... cool! thanks!

oops... need the initial code to create sp_FindCode

i see...

i couldn't do that before cause i 'migrated' them over with the wizard.

now having looked over the 'open' selection more closely i see that it's

looking for a .dts package....

wait a minute... 2008 does not support that feature any longer?

oh no! that was my diamond in the rough.

so even if i install the dts designer, and runtime...

found this for the 2005 feature pack, but

couldn't find any thing for the above mentioned

files just yet.

From SQL Server 2005 Feature Pack:

SQLServer2005_ADOMD.msi Microsoft ADOMD.NET

msxml6.msiMicrosoft Core XML Services (MSXML) 6.0

DB2OLEDB.exeMicrosoft...

just need a quick list of what they are all used for:

SQL2005 Enterprise CD\Tools\Setup

msxml6.msi

OWC11.MSI

sqlncli.msi

SqlRun.msi

SqlRun_Tools.msi

SqlServer2K5_BOL.msi

SQLServer2005_BC.msi

SqlSupport.msi

SqlWriter.msi

sqlxml4.msi

vs_setup.msi

SQL2005 Enterprise CD\Servers\Setup

msxml6.msi

OWC11.MSI

sqlncli.msi

SqlRun.msi

SqlRun_AS.msi

SqlRun_DTS.msi

SqlRun_NS.msi

SqlRun_RS.msi

SqlRun_SQL.msi

SQLServer2005_BC.msi

SqlSupport.msi

SqlWriter.msi

sqlxml4.msi

i'm having trouble actually setting this up.

don't suppose there is a quick 'how-to' out there written specifically

for setting up a linked server to informix? i've got a user account...

thanks for the example! i see whats happening now.

i can see how it gets the name using each object id i

have in the parens, but i guess there's...

so just as a test... i'll run a query against sysobjects with only

the name and id.

select name, id from master..sysobjects

i can then get the id to appear just as the...

excellent script... would be almost perfect if it had

an smtp send statement built in

can a script be written to read through each server's SQL Logs, then return which

servers backups experienced a failure?

i'm looking for the same type of solution without adding an additional...

so by using a scheduled task i can parse the filename,

and move the files based on that?

for example: what if all files are named: MyFile2007050800.txt

scheduled task will be able...

excellent answers!!

thanks for the break-down too.

thanks for the response.

here is what i'm running. with text as output: CTRL+T

it simply lists all databases and their corresponding size.

------------------------------------------------

set nocount on

declare @counter smallint

declare @counter1 smallint

declare @dbname varchar(100)

declare @size...