Viewing 15 posts - 1,876 through 1,890 (of 7,502 total)
it states:
The owner (WIN-69WL56MFLQH\Administrator) of job Integrity Checks.Subplan_1 does not have server access.
Change the job owner to SA !
( this would be the only case one uses sa with sqlserver...
July 14, 2011 at 6:55 am
Jim Murphy (7/14/2011)
Koen Verbeeck (7/14/2011)
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly*...
July 14, 2011 at 2:23 am
just to add to the replies ...
1) of course. Your operator is ">=" !
You should alter it with a ">=" and "<" ( between can have issues...
July 14, 2011 at 1:21 am
Have a look at:
- How to: Shrink a Database (SQL Server Management Studio)
July 14, 2011 at 1:10 am
SQLBOT (7/13/2011)
...I think this means that each cluster needs a drive letter, but you can mount as many mount points on that drive as you want....
Indeed.
All luns need to be...
July 14, 2011 at 12:04 am
kapfundestanley (7/13/2011)
..failing without giving a clear error message.....
Please post all error information you can.
- Errorlog file of sqlserver
- MP log ( if you configured it)
even if it seem worthless, post...
July 13, 2011 at 8:30 am
FWIW maybe this way can also be given a try if you have a larger volume of data to process.
As shown in the script it is based on Adventureworks for...
July 13, 2011 at 6:55 am
Mark-101232 (7/13/2011)
ALZDBA (7/13/2011)
Very nice solution Mark. :smooooth:I hope OP understands the performance impact.
Yep, I suspect there's a fast way to do this without having to group by a concatenated string....
July 13, 2011 at 3:23 am
Very nice solution Mark. :smooooth:
I hope OP understands the performance impact.
July 13, 2011 at 3:10 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked for!...
July 13, 2011 at 2:51 am
Define Group1, Group2 and Group3. What are the cryteria ?
Are there any other groups ?
Is your grouping dynamic ?
July 13, 2011 at 2:50 am
FWIW I just signed up to Google+ 🙂 Just to see what it's all about.
Let's see... facebook, LinkedIn, Twitter, G+, the fora .... It's gonna need a FTE...
July 12, 2011 at 1:30 am
NULL means unknown value for this column on this row.
You'll have to determine - based on your knowledge of your data system - how to interpret it for your case.
If...
July 11, 2011 at 12:32 am
We use mount points on almost all of our clusters because of that reason.
We haven't experienced issues with it over the years.
However, you need to take into account you need...
July 10, 2011 at 6:47 am
Tom.Thomson (7/8/2011)
ALZDBA (7/8/2011)
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep in...
July 9, 2011 at 2:23 pm
Viewing 15 posts - 1,876 through 1,890 (of 7,502 total)