Viewing 15 posts - 121 through 135 (of 322 total)
Friday fun...:-)
RBarryYoung (8/5/2008)
Antares686 (8/5/2008)
October 30, 2009 at 10:13 am
Thanks for the thought provoking article R, and 5 stars for a good read!
I've used the Temp In-Place method in the past. Sometimes to fix my own mistakes. I...
October 30, 2009 at 7:46 am
That explains a lot. Like
linked server "(null)"
It sounds like your OPENROWSET statement within the procedure isn't passing suitable credentials.
Check BOL for Linked Server Security and Delegates regarding double hops.
October 29, 2009 at 11:30 am
Ramon,
I told you I was confusing myself.
USE TEST
GO
CREATE PROCEDURE dbo.sp_ControlStock AS SELECT 'ONE', 'TWO', 'THREE'
GO
SELECT *
FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',
'exec TEST.dbo.sp_ControlStock');
GO
That works fine for me. Maybe you...
October 29, 2009 at 11:07 am
Ramon-218872 (10/29/2009)
I make some tests:
exec SGANPS.dbo.sp_ControlStock
It works
SELECT *
FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',
'SELECT *
FROM SGANPS.dbo.ARTICULOS');
It works
SELECT...
October 29, 2009 at 10:32 am
Do you get my point .... or have I missed yours?
Regards,
David.
Maybe both Dave. I thought the article was real good and gave it a good rating. The UDF would...
October 29, 2009 at 9:13 am
David McKinney (10/29/2009)
ruedifuchs (10/29/2009)
But since the stored procedure has to return a result set, what is the advantage over using a...
October 29, 2009 at 8:37 am
Paul Hunter (10/29/2009)
... You end up with database bloat because everything is stored in the database (storage makers love that) unless you use a product like...
The SP application...
October 29, 2009 at 7:57 am
We use MOSS 2007 for a Team site. 2 of our consultants set it up a couple of years ago with a minimum amount of pain. Neither had ever worked...
October 28, 2009 at 12:47 pm
cengland0 (10/28/2009)
Good...
October 28, 2009 at 12:13 pm
dmoldovan (10/27/2009)
Bob, Tom - please see http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/19/sql-tip-keep-your-presentation-logic-in-your-presentation-layer.aspx...
Both articles make good points, but note that I did say with some reporting applications. For instance it would be wasted time with a...
October 27, 2009 at 8:29 am
Toreador (10/27/2009)
Surely date formatting should normally be part of the presentation layer? I always return the whole datetime value and format it on the client, using their regional settings etc.
I...
October 27, 2009 at 6:47 am
SanjayAttray (10/26/2009)
Does any one uses mixed datetime styles in a single query like the above one ?I haven't seen any.
Probably not, but some readers no doubt will benefit from...
October 26, 2009 at 1:54 pm
Fatal Exception Error (10/19/2009)
How efficient will char be if you have throw an rtrim() in the where clause?
Not as efficient, but why would you want to use RTRIM in a...
October 19, 2009 at 7:14 am
If no special criteria other than length is specified I usually select varchar (yes, I'm a programmer). However given the fact that the data was to be used as "identifiers",...
October 16, 2009 at 12:29 pm
Viewing 15 posts - 121 through 135 (of 322 total)