WayneS

Forum Replies Created

Viewing 15 posts - 5,326 through 5,340 (of 5,588 total)

RE: How to transfer the data from Excel to SQL2005

josephptran2002 (5/18/2009)
Hi All,
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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 18, 2009 at 12:22 pm

#996554
RE: Are the posted questions getting worse?

Lynn Pettis (5/15/2009)
Steve Jones - Editor (5/15/2009)
Well I showed Gail last year, but here I am
Nice and quiet.
Oh? When did you move to Virginia? You look like you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 15, 2009 at 1:54 pm

#995650
RE: Are the posted questions getting worse?

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 15, 2009 at 1:25 pm

#995624
RE: Are the posted questions getting worse?

Paul White (5/14/2009)
Bob Hovious (5/14/2009)
Hey Bruce and Paul... how is life in New Zealand? Where do you each live again? Bruce, you're on the North Island...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 15, 2009 at 1:14 pm

#995613
RE: Problems exporting to an Excel Named Range

Ramesh (5/14/2009)
How are you setting the named range in excel destination connection?
I think it should be set to "Command" and the command text should set to "SELECT *...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 14, 2009 at 1:43 pm

#994852
RE: Can you copy a sheet to a new sheet?

Phil Parkin (5/13/2009)
Your signature contains a link to posting best practices, yet your post does not follow them!
Are you referring to Excel when you talk about 'sheets'?
Is any data involved,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 14, 2009 at 8:13 am

#994557
RE: need help in looping records

Anjana (5/13/2009)
I would like to insert all these other records into other tables at same time or if possible can loop through and insert these records in?
Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2009 at 7:54 pm

#994239
RE: What's a strong password .. really ?

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2009 at 7:44 pm

#994236
RE: How to converT a decimal value to a varchar value

Have you tried using IMEX=1 in your driver?
see http://support.microsoft.com/kb/194124
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2009 at 11:55 am

#993952
RE: Can one monitor server monitor log shipping of multiple databases?

Dave Coats (5/13/2009)
Thanks Ken - I had the same question too. Your post confirmed my suspicion. But to me, this makes no sense. Log Shipping should set...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2009 at 10:57 am

#993907
RE: Understanding Execution Plans

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....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2009 at 7:59 am

#993735
RE: Understanding Execution Plans

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 12, 2009 at 2:53 pm

#993294
RE: Problems running SSIS 2008 package

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 10, 2009 at 10:31 pm

#991888
RE: Problems running SSIS 2008 package

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 10, 2009 at 9:39 pm

#991884
RE: Are the posted questions getting worse?

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 9, 2009 at 9:35 am

#991632

Viewing 15 posts - 5,326 through 5,340 (of 5,588 total)