Viewing 15 posts - 5,326 through 5,340 (of 5,588 total)
josephptran2002 (5/18/2009)
it gives me a syntax error:
"Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component...
May 18, 2009 at 12:22 pm
Lynn Pettis (5/15/2009)
Steve Jones - Editor (5/15/2009)
Well I showed Gail last year, but here I amNice and quiet.
Oh? When did you move to Virginia? You look like you...
May 15, 2009 at 1:54 pm
Lynn Pettis (5/14/2009)
Well, since we are showing about where we all live, here is where I live.
Now I see why you're running off to the desert all the time.
Well, I'm...
May 15, 2009 at 1:25 pm
Paul White (5/14/2009)
Bob Hovious (5/14/2009)
May 15, 2009 at 1:14 pm
Ramesh (5/14/2009)
I think it should be set to "Command" and the command text should set to "SELECT *...
May 14, 2009 at 1:43 pm
Phil Parkin (5/13/2009)
Are you referring to Excel when you talk about 'sheets'?
Is any data involved,...
May 14, 2009 at 8:13 am
Anjana (5/13/2009)
Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno,...
May 13, 2009 at 7:54 pm
The stronger a password is, the more resistant it is to being hacked.
A good mix of numbers, lowercase letters, uppercase letters and special characters would make it extremely difficult for...
May 13, 2009 at 7:44 pm
Have you tried using IMEX=1 in your driver?
May 13, 2009 at 11:55 am
Dave Coats (5/13/2009)
May 13, 2009 at 10:57 am
GilaMonster (5/12/2009)
WayneS (5/12/2009)
Most index scans that are still going on appear to be over a range of the index, not the entire index.
Index scans always read the whole index....
May 13, 2009 at 7:59 am
RBarryYoung (5/8/2009)
Wayne, questions:2) Have you used the time statistics to confirm if the QP estimates per statement are accurate (i.e., is the last statement really 75% of the run-time).
With the...
May 12, 2009 at 2:53 pm
Here are other issues that I've run into, and I haven't been able to figure out a solution for. Any help is appreciated.
I can probably do all of this with...
May 10, 2009 at 10:31 pm
WayneS (5/8/2009)
"CREATE TABLE 'Summary' ('Month' NVARCHAR(9),
'Base1' NVARCHAR(20),
'Retained1' NVARCHAR(20),
'Percent1' NVARCHAR(20),
'Base2' NVARCHAR(20),
'Retained2' NVARCHAR(20),
'Percent2' NVARCHAR(20),
'Base3' NVARCHAR(20),
'Retained3' NVARCHAR(20),
'Percent3' NVARCHAR(20)
)"
Well, I've found out that contrary to many articles on the internet, and even some on...
May 10, 2009 at 9:39 pm
Florian Reischl (5/9/2009)
I learned much more about SQL Server in the last few month than in the last three years.
I have to agree. And it all due to people like...
May 9, 2009 at 9:35 am
Viewing 15 posts - 5,326 through 5,340 (of 5,588 total)