This was exactly the reason I no longer use maintenance plans for anything.  I have found them to be flacky and hard to handle.  I had noticed this exact problem...

Many to Many  relationships are often implemented by the use of a junction table.  In Lowell's example you could create a Order table with the customerid and ProductId as the...

We are just starting to look at Microsoft System Center Operation Manager 2007 (MOM) So far its looks good but we are just beginning. 

We are just starting to look at Microsoft System Center Operation Manager 2007 (MOM) So far its looks good but we are just beginning. 

Have you checked out the thread at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=176962

See http://www.sqldbatips.com/showcode.asp?ID=4  I use the script often and it works great.

here is one script, that works if you create a linked server to the server you want to copy the logon from:

-- Setup a linked server called impserver from which...

What if process 87 uses WITH NO_LOCK while 117 and 112 are doing their stuff?  Is this an option?  It does sound odd.  ARe you running the latest Service Pack?

I'm not sure... but it appear that both 112 has an IX -(intent Exclusive lock) lock on the table.  Process 87 wants a shared lock, but it can't share if...

Why is SOX preventing you from editing the job? 

Replace the line

DTSRun /~Z0x746C6215E6EBA199A6637D129B20672C845F62849F98141FC14858C32D7F0A313BB17632AD81D25B5CCE62058B9115ECF504B8E7DF27F92CA9AF6FF5F389F62D78BF6543026EE0FDCD6A212C577BBFD49B65260AF45D828B48E71BD7AC1C450B87C760D1961ED9B63F2CAC7124DDF882D5038D

with

DTSRun /S "(local)" /N "Import Package" /E

I can't see any difference in creating the DTSRUN...

If you are asking how to execute a dts package from a SQL job you use the DTSRUN utility.  Information on this can be found in Books Online. 

Have a look at this discussion thread and examples:  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=10482

I have a really, really long rollback in progress.  I haven't checked it for a couple of weeks so I signed on again and executed the KILL nn with statusonly...

You should be able to get the media only for reporting Services from the place where you purchased SQL Server (media only is a nominal fee)  Reporting Services is part...

Anything that has to do with file level access.  For example you decide to move the mdf or ldf files to a different drive.  Or you need to make a...