Viewing 15 posts - 7,456 through 7,470 (of 9,725 total)
Please post whether or not Rich's solution helps you out. It looks interesting.
September 21, 2010 at 6:06 am
Cath Trimble (9/21/2010)
SQL Server 32 bit can't use more than 4GB of memory.
Here's someone who's proved SQL Standard 32bit can use more than 4GB on a 32bit OS:...
September 21, 2010 at 6:05 am
jboudinot (9/20/2010)
set the date column to not null, then it will use the default if you don't supply any data for that column
I've never seen that work.
Every time I've set...
September 21, 2010 at 5:54 am
Then keep doing the tests one at a time until you find out which part of your method changed so much that it's taking 4 hours to do.
September 20, 2010 at 12:32 pm
The error message complains about an OLE DB error. I didn't think Excel used OLE DB to connect. But you're getting the queries to run when you're sysadmin?
What's the security...
September 20, 2010 at 12:29 pm
Do all the objects have to move?
If yes, then do the following in OFF hours:
1) Backup the database
2) Restore to the other drive with a slightly different name (MyDBDup)
3) Take...
September 20, 2010 at 12:22 pm
For a moment, I thought our abused poster found another sock puppet. Given the font mistake and bad grammar...
http://www.sqlservercentral.com/Forums/Topic971846-357-1.aspx
September 20, 2010 at 12:19 pm
Steve Jones - Editor (9/20/2010)
I'm hoping to get out to Omaha. Sounds like a good place for a SQL event... 😉
If there's a SQL event there, I'm so a part...
September 20, 2010 at 12:16 pm
What service pack are you using? SP1 (pre-hot fix) had issues with maintenance plans. If you're using it, you should upgrade to the latest service pack and see if that...
September 20, 2010 at 12:14 pm
Paul White NZ (9/20/2010)
Brandie Tarvin (9/20/2010)
He'll set us all to zero and make himself look like the Answer God!
That's an awesome idea for next April 1.
He should also change all...
September 20, 2010 at 12:11 pm
Okay, the best way to figure this out is to try Part A of both methods and time them. I'm betting this is where the problem is. Because you're creating...
September 20, 2010 at 12:10 pm
Did it work before?
Have the permissions on the Share folder, where the file resides, changed?
September 20, 2010 at 12:07 pm
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
Viewing 15 posts - 7,456 through 7,470 (of 9,725 total)