I wouldnt expect it to change in sp2. The problem becomes, how would SQL "know" that starting the agent was the right thing to do? If you had just stopped...

First create and test a function that does what you need, maybe something like this:

IF EXISTS (SELECT *

FROM sysobjects

WHERE ...

I can offer a starting place. Take a look at sp_spaceused to determine the amount of space - typically you would open a cursor and run this proc once per...

The sql to create the table you are trying to drop the column from. We can recreate on our machines, see if we have the same issue.

Andy

Seems like there was a Wrox book that covered DTS and DMO together for SQL7?

Andy

How about trying it on a different machine? Sounds like there is something wrong with your EM install and not SQL itself.

Andy

I generally recommend (along with most of the rest of the crowd here) to avoid object ownership - I have all my objects owned by dbo. In my experience the...

I use linked servers quite a bit, never seen this particular issue (or much of any other!). Have you checked MSDN to see if an Q articles? What are the...

We're not having problems with 250. 8g of RAM helps to be sure, and not all are active on any given day, probably anywhere from 60-80. I think the only...

Have you tried unregister/reregister the server in EM? Try creating a different sql login and using that, or maybe just using an existing one

Andy

You must be using SQL7? I'll have to check, don't have BOL for 7 here.

Andy

There is a web add on for SQL7 that provides some xml ability, been quite a while since I looked at it! I think it was in the form of...

I'd double check that statistics are current - run sp_updatestats. It's the number one reason people complain about performance after an upgrade. Next thing to check would be are you...

Wouldnt you just want to include the typeid in the question table? Would it make sense that a question could exist in both types?

Andy

By serializing, I mean that you need to have a way to either run step 1 that accesses the file, then ONLY when it is done run the next step....