Viewing 15 posts - 3,616 through 3,630 (of 18,926 total)
Tom.Thomson (8/8/2011)
Ninja's_RGR'us (8/8/2011)
Jeff Moden (8/8/2011)
Tom.Thomson (8/8/2011)
Lynn Pettis (8/8/2011)
Obviously anything I have to say is going to be taken the wrong way.
Well, after your earlier reply followed by this which read...
August 8, 2011 at 8:11 am
Tom.Thomson (8/8/2011)
Lynn Pettis (8/8/2011)
But I should also say I'm not the one that ordained myself, it was many of the others here on ssc based...
August 8, 2011 at 8:08 am
How big are the datafiles (not the backups, but the restored files)? Express can't go above 4GB in 2K5.
Does the serer have permissons to write in that folder?
August 8, 2011 at 8:01 am
GilaMonster (8/8/2011)
Ninja's_RGR'us (8/8/2011)
Not to be too anal here, but you can't really add NC indexes, you can only add NC constraints.
And a unique constraint is enforced by a unique...
August 8, 2011 at 7:59 am
Jeff Moden (8/8/2011)
Tom.Thomson (8/8/2011)
Lynn Pettis (8/8/2011)
Obviously anything I have to say is going to be taken the wrong way.
Well, after your earlier reply followed by this which read one after...
August 8, 2011 at 7:37 am
can you post the xml version of the report here. Maybe we can dig something up in there.
Also could it be coming from a sub-report or something like that?
August 8, 2011 at 7:36 am
Not to be too anal here, but you can't really add NC indexes, you can only add NC constraints. I've had cases where constraints just were not what I...
August 8, 2011 at 7:35 am
Actually I wouldn't only correct it but I'd probably build a second job (once you've proven the code works with minimal impact).
the second job would be 1.5-2M pages min (or...
August 8, 2011 at 7:29 am
Now that's a catch 22. Nice story Collin : http://www.sqlservercentral.com/Forums/Topic1155970-391-1.aspx
August 8, 2011 at 7:20 am
nairdeepa (8/8/2011)
Thanks..that field in Action expression is empty..i dont know where else to look
It always looks empty. Put your moust over it and hit the ... button. There's...
August 8, 2011 at 7:10 am
Rhox (8/8/2011)
Yes you're right 🙂I'm busy to change the script to be confirm with the 'standard' names here... (and changing the extention bak to trn to avoid misunderstandings... 🙂
Of course,...
August 8, 2011 at 7:06 am
HTH.
Just thought that you might also want to search for sp_MSforeachdb and also sysdatabases. That way you trap all the looping processes which you'd be missing right now.
Let us...
August 8, 2011 at 7:00 am
Check this out...
If you hit a big hurdle, let us know maybe we'll be able to help further.
August 8, 2011 at 6:51 am
I actually ran this on our prod server here and I got no complaints. Now keep in mind that our server is really "under" utilized. It's rare to...
August 8, 2011 at 6:47 am
My "worst" scenario here is that I had a long proc using a splitter function (table variable) to process a series multi-select filter.
The usual run had a total of 50M...
August 8, 2011 at 6:41 am
Viewing 15 posts - 3,616 through 3,630 (of 18,926 total)