Your question isn't entirely easy to answer. You're missing a few pieces. Like, were you creating clustered indexes in the first sequence, or non-clustered indexes? Secondly, did you change any...

It does sound like the log chain for the second database got broken by changes on the Primary server.

What's changed on the Primary server, second database? It would have been...

Look up "Execute AS" in Books Online. See if that will help you.

More details on the error message, please.

According to Books Online -> AWE, about AWE:

Relevant...

Jeff Moden (9/20/2010)

---

GilaMonster (9/20/2010)

---

*drum roll*

*trumpet crescendo*

... and I think I'll leave things here for a little while.

Edit: And as soon as i decide not to post for a few hours,...

Steve, does that method work for regular procs? Not CLR or MDX code?

There are several. I miss Grandmother's. That was a wonderful place... too bad...

You're very welcome. I'm so sorry it took so long and glad that you posted you were working out of that book.

I've had really bad experiences with ISNUMERIC() not functioning the way I expected it to. For some reason, every time I want to use it, I have to throw it...

First question: Is this a Windows account or a SQL account? That makes a difference.

If Windows, you need to find out from the AD people what Windows Groups this user...

The best I can think of is to use SSIS to write the object to a new file. I haven't done it before, but I'm guessing you'll need an OLE...

For those of us who can't install extra little stuff because of corporate restrictions, put everything you need to do inside a ForEach container. Then set the SSIS package running...

John Rowan (9/20/2010)

---

Yes, we have Omaha steaks...and in the airport too. Don't get me wrong, Omaha steaks has good steaks, but I don't think they can compete with an...

Yes, they do. Right before you get to the security checkpoint. They also have a brick-n-mortar store down on L...