Viewing 15 posts - 7,471 through 7,485 (of 9,728 total)
Paul White NZ (9/20/2010)
CirquedeSQLeil (9/20/2010)
I don't think anybody can catch steve. Remember - he controls the countsWhat ever are you suggesting? :blink:
He'll set us all to zero and make...
September 20, 2010 at 12:05 pm
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...
September 20, 2010 at 12:03 pm
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...
September 20, 2010 at 11:56 am
Look up "Execute AS" in Books Online. See if that will help you.
September 20, 2010 at 11:52 am
According to Books Online -> AWE, about AWE:
Support for AWE is available only in the SQL Server 2005 Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems
Relevant...
September 20, 2010 at 11:49 am
Jeff Moden (9/20/2010)
GilaMonster (9/20/2010)
*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,...
September 20, 2010 at 11:46 am
Steve, does that method work for regular procs? Not CLR or MDX code?
September 20, 2010 at 11:44 am
John Rowan (9/20/2010)
When you come back to visit Omaha, what restaurant do you look forward to the most?
There are several. I miss Grandmother's. That was a wonderful place... too bad...
September 20, 2010 at 11:41 am
You're very welcome. I'm so sorry it took so long and glad that you posted you were working out of that book.
September 20, 2010 at 11:37 am
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...
September 20, 2010 at 11:33 am
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...
September 20, 2010 at 11:28 am
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...
September 20, 2010 at 11:24 am
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...
September 20, 2010 at 11:21 am
John Rowan (9/20/2010)
September 20, 2010 at 11:13 am
Viewing 15 posts - 7,471 through 7,485 (of 9,728 total)