OT: SQL 2008 LA Launch in February

Who's going besides me?
I'd like to meet as many of you as I can, so I'm getting in at 6p the night
before and staying for the post-launch festivities that night...
Shame they slipped the true release date :( Better to be right than right
now I guess...
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.Hi Kevin,
I live in Los Angeles so I will be attending the launch event too. See you
there.
Ben Nevarez
"Kevin3NF" wrote:
> Who's going besides me?
> I'd like to meet as many of you as I can, so I'm getting in at 6p the night
> before and staying for the post-launch festivities that night...
> Shame they slipped the true release date :( Better to be right than right
> now I guess...
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>|||Cool...
My kid tried to beg her way onto this trip...like a teenager wants to hang
out with a bunch of SQL dudes...:)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Ben Nevarez" <bnevarez@.no.spam.please.sunamerica.com> wrote in message
news:D14EE7E9-E18D-44D5-898D-AF2FCE4E0C7A@.microsoft.com...
> Hi Kevin,
> I live in Los Angeles so I will be attending the launch event too. See you
> there.
> Ben Nevarez
>
>
> "Kevin3NF" wrote:
>> Who's going besides me?
>> I'd like to meet as many of you as I can, so I'm getting in at 6p the
>> night
>> before and staying for the post-launch festivities that night...
>> Shame they slipped the true release date :( Better to be right than
>> right
>> now I guess...
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>|||I've tried to find out how much this events costs. Any clues?
Thanks
"Kevin3NF" wrote:
> Who's going besides me?
> I'd like to meet as many of you as I can, so I'm getting in at 6p the night
> before and staying for the post-launch festivities that night...
> Shame they slipped the true release date :( Better to be right than right
> now I guess...
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>|||$0 for the event itself...its a sales/marketing promotion for Microsoft.
Hotels, travel and some meals are on you...
http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
Thinking about coming out?
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...
> I've tried to find out how much this events costs. Any clues?
> Thanks
> "Kevin3NF" wrote:
>> Who's going besides me?
>> I'd like to meet as many of you as I can, so I'm getting in at 6p the
>> night
>> before and staying for the post-launch festivities that night...
>> Shame they slipped the true release date :( Better to be right than
>> right
>> now I guess...
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>|||Thanks Kevin. No I was just wondering, as here in Oz the same event is
US$180. I had a sneeking suspicion that once again us Aussies are getting
ripped. Oh and we apparently get trial (Visual Studio) and CTP (SQL Server
2008) software not "Promotional" versions as you guys get, which I assume
are Not for Resale versions.
"Kevin3NF" wrote:
> $0 for the event itself...its a sales/marketing promotion for Microsoft.
> Hotels, travel and some meals are on you...
> http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
> Thinking about coming out?
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
> news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...
> > I've tried to find out how much this events costs. Any clues?
> >
> > Thanks
> >
> > "Kevin3NF" wrote:
> >
> >> Who's going besides me?
> >>
> >> I'd like to meet as many of you as I can, so I'm getting in at 6p the
> >> night
> >> before and staying for the post-launch festivities that night...
> >>
> >> Shame they slipped the true release date :( Better to be right than
> >> right
> >> now I guess...
> >>
> >> --
> >>
> >> Kevin3NF
> >> SQL Server dude
> >>
> >> You want fries with that?
> >> http://kevin3nf.blogspot.com/
> >>
> >> I only check the newsgroups during work hours, M-F.
> >> Hit my blog and the contact links if necessary...I may be available.
> >>
> >>
> >>
> >>
> >>
>
>|||Were getting CTP as well, since the rtm won't be ready yet :)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
news:8FF6852C-2136-40CF-A5DC-63823929F6D0@.microsoft.com...
> Thanks Kevin. No I was just wondering, as here in Oz the same event is
> US$180. I had a sneeking suspicion that once again us Aussies are getting
> ripped. Oh and we apparently get trial (Visual Studio) and CTP (SQL Server
> 2008) software not "Promotional" versions as you guys get, which I assume
> are Not for Resale versions.
> "Kevin3NF" wrote:
>> $0 for the event itself...its a sales/marketing promotion for Microsoft.
>> Hotels, travel and some meals are on you...
>> http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
>> Thinking about coming out?
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
>> news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...
>> > I've tried to find out how much this events costs. Any clues?
>> >
>> > Thanks
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> Who's going besides me?
>> >>
>> >> I'd like to meet as many of you as I can, so I'm getting in at 6p the
>> >> night
>> >> before and staying for the post-launch festivities that night...
>> >>
>> >> Shame they slipped the true release date :( Better to be right than
>> >> right
>> >> now I guess...
>> >>
>> >> --
>> >>
>> >> Kevin3NF
>> >> SQL Server dude
>> >>
>> >> You want fries with that?
>> >> http://kevin3nf.blogspot.com/
>> >>
>> >> I only check the newsgroups during work hours, M-F.
>> >> Hit my blog and the contact links if necessary...I may be available.
>> >>
>> >>
>> >>
>> >>
>> >>
>>|||Yes of course ... silly me. IT's VS I'm really after but we do get Windows
Server 2008 Enterprise which may be useful for some.
"Kevin3NF" wrote:
> Were getting CTP as well, since the rtm won't be ready yet :)
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
> news:8FF6852C-2136-40CF-A5DC-63823929F6D0@.microsoft.com...
> > Thanks Kevin. No I was just wondering, as here in Oz the same event is
> > US$180. I had a sneeking suspicion that once again us Aussies are getting
> > ripped. Oh and we apparently get trial (Visual Studio) and CTP (SQL Server
> > 2008) software not "Promotional" versions as you guys get, which I assume
> > are Not for Resale versions.
> >
> > "Kevin3NF" wrote:
> >
> >> $0 for the event itself...its a sales/marketing promotion for Microsoft.
> >> Hotels, travel and some meals are on you...
> >>
> >> http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
> >>
> >> Thinking about coming out?
> >>
> >> --
> >>
> >> Kevin3NF
> >> SQL Server dude
> >>
> >> You want fries with that?
> >> http://kevin3nf.blogspot.com/
> >>
> >> I only check the newsgroups during work hours, M-F.
> >> Hit my blog and the contact links if necessary...I may be available.
> >>
> >>
> >>
> >> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
> >> news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...
> >> > I've tried to find out how much this events costs. Any clues?
> >> >
> >> > Thanks
> >> >
> >> > "Kevin3NF" wrote:
> >> >
> >> >> Who's going besides me?
> >> >>
> >> >> I'd like to meet as many of you as I can, so I'm getting in at 6p the
> >> >> night
> >> >> before and staying for the post-launch festivities that night...
> >> >>
> >> >> Shame they slipped the true release date :( Better to be right than
> >> >> right
> >> >> now I guess...
> >> >>
> >> >> --
> >> >>
> >> >> Kevin3NF
> >> >> SQL Server dude
> >> >>
> >> >> You want fries with that?
> >> >> http://kevin3nf.blogspot.com/
> >> >>
> >> >> I only check the newsgroups during work hours, M-F.
> >> >> Hit my blog and the contact links if necessary...I may be available.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

OT: SQL 2008 LA Launch in February

I've tried to find out how much this events costs. Any clues?
Thanks
"Kevin3NF" wrote:

> Who's going besides me?
> I'd like to meet as many of you as I can, so I'm getting in at 6p the night
> before and staying for the post-launch festivities that night...
> Shame they slipped the true release date Better to be right than right
> now I guess...
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>
$0 for the event itself...its a sales/marketing promotion for Microsoft.
Hotels, travel and some meals are on you...
http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
Thinking about coming out?
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...[vbcol=seagreen]
> I've tried to find out how much this events costs. Any clues?
> Thanks
> "Kevin3NF" wrote:
|||Thanks Kevin. No I was just wondering, as here in Oz the same event is
US$180. I had a sneeking suspicion that once again us Aussies are getting
ripped. Oh and we apparently get trial (Visual Studio) and CTP (SQL Server
2008) software not "Promotional" versions as you guys get, which I assume
are Not for Resale versions.
"Kevin3NF" wrote:

> $0 for the event itself...its a sales/marketing promotion for Microsoft.
> Hotels, travel and some meals are on you...
> http://www.microsoft.com/heroeshappenhere/events/los-angeles/default.mspx
> Thinking about coming out?
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
> news:224F77F0-D581-4937-8987-6ECC506D2689@.microsoft.com...
>
>
|||Were getting CTP as well, since the rtm won't be ready yet
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
news:8FF6852C-2136-40CF-A5DC-63823929F6D0@.microsoft.com...[vbcol=seagreen]
> Thanks Kevin. No I was just wondering, as here in Oz the same event is
> US$180. I had a sneeking suspicion that once again us Aussies are getting
> ripped. Oh and we apparently get trial (Visual Studio) and CTP (SQL Server
> 2008) software not "Promotional" versions as you guys get, which I assume
> are Not for Resale versions.
> "Kevin3NF" wrote:
|||Yes of course ... silly me. IT's VS I'm really after but we do get Windows
Server 2008 Enterprise which may be useful for some.
"Kevin3NF" wrote:

> Were getting CTP as well, since the rtm won't be ready yet
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Pete" <phayward_delete@.delete_bigfoot.com> wrote in message
> news:8FF6852C-2136-40CF-A5DC-63823929F6D0@.microsoft.com...
>
>

os_oa* run exe written in vb6

I need to launch an exe application written in VB6 from stored procedure or
trigger. I know I have to use os_oa* but I cannot find any document to help
me build one. Many examples that I found have something to do with com but I
only have exe. I know this is not the way to go but I was told to do it. Can
any one help me by pointing me in the right directions? I know nothing about
this so I am learning from scratch for os_oa*.
The exe was developed to run silent in the background with no user
interface.Search for xp_cmdshell in BOL, it may be useful.
Francesco Anti
"UGH" <nospam@.noSPam.com> wrote in message
news:eRxL9tFaFHA.1368@.tk2msftngp13.phx.gbl...
>I need to launch an exe application written in VB6 from stored procedure or
>trigger. I know I have to use os_oa* but I cannot find any document to help
>me build one. Many examples that I found have something to do with com but
>I only have exe. I know this is not the way to go but I was told to do it.
>Can any one help me by pointing me in the right directions? I know nothing
>about this so I am learning from scratch for os_oa*.
>
> The exe was developed to run silent in the background with no user
> interface.
>|||Do you mean sp_oa* ' If so, here is everything you need:
1. Compile your VB6 class into a DLL. You better have good error handling in
it otherwise you risk crashing your SQL Server.
2. Place that DLL into the WIN32 directory on your SQL Server, and REGISTER
it on your SQL Server by using RegSvr32.exe
3. Call methods of your VB6 class/dll from any stored procedure, using
something like the following (some of the names have been changed to protect
the innocent):
BEGIN
blah blah blah
DECLARE @.Object int -- holds a reference to your object instantiated
from the vb6 class.
SET @.MethodToCall = 'CalculatePayment(' + @.RatePercent + ', ' +
@.RateIncrease + ', ' + @.Months + ', ' + @.Fees + ')'
--Instantiate an instance of our DataConversion class and put it's
reference in @.object
EXEC sp_OACreate 'Your_VB_Class.DataConversion', @.object OUT
--Run the CalculatePayment method of our DataConversion class - and
place it's output into @.Return
EXEC sp_OAMethod @.object, @.MethodToCall, @.return OUT
-- Destroy the instance of our DataConversion class now that we're
done with it.
EXEC sp_OADestroy @.object
blah blah blah
END
4. Any time you need to upgrade your VB6 DLL, be sure to Unregister the old
one (using RegSvr32.exe... -U), then replace the old DLL with the new one,
and then register the new one like in step 2 above. No need to restart your
SQL Server.
That's it - really quite straight-forward, actually.
-HTH
"UGH" <nospam@.noSPam.com> wrote in message
news:eRxL9tFaFHA.1368@.tk2msftngp13.phx.gbl...
>I need to launch an exe application written in VB6 from stored procedure or
>trigger. I know I have to use os_oa* but I cannot find any document to help
>me build one. Many examples that I found have something to do with com but
>I only have exe. I know this is not the way to go but I was told to do it.
>Can any one help me by pointing me in the right directions? I know nothing
>about this so I am learning from scratch for os_oa*.
>
> The exe was developed to run silent in the background with no user
> interface.
>|||Hi,
Use the following :
EXEC xp_cmdshell 'your vb program.exe'
you want to grant the right to execute xp_cmdshell to the SQL login
LimitedUser.
You'll need an NT account to execute the program. Here's the script:
use master
go
xp_sqlagent_proxy_account N'SET'
, N'<mydomain>'
, N'<ntuser>'
, N'<ntuser's password>'
go
-- retrieve the proxy account to check that it's correct.
xp_sqlagent_proxy_account N'GET'
go
-- grant database access in master
sp_grantdbaccess 'LimitedUser'
go
grant exec on xp_cmdshell to LimitedUser
go
Thanks,
Tarek ghazali
"UGH" <nospam@.noSPam.com> wrote in message
news:eRxL9tFaFHA.1368@.tk2msftngp13.phx.gbl...
>I need to launch an exe application written in VB6 from stored procedure or
>trigger. I know I have to use os_oa* but I cannot find any document to help
>me build one. Many examples that I found have something to do with com but
>I only have exe. I know this is not the way to go but I was told to do it.
>Can any one help me by pointing me in the right directions? I know nothing
>about this so I am learning from scratch for os_oa*.
>
> The exe was developed to run silent in the background with no user
> interface.
>