Showing posts with label build. Show all posts
Showing posts with label build. Show all posts

Wednesday, March 28, 2012

Latest build version?

Hi,

What is the latest patch level for SQL server 2000?

I am currently at this build level:

Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

How can I tell when microsoft bring out a new SQL server hotfix or patch?Check out http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37. I think that they keep the list updated, but I could not tell you how frequently.

Note that with some of the patches that come out, you have to patch the client tools as well as the server.

Regards,

hmscott

Hi,

What is the latest patch level for SQL server 2000?

I am currently at this build level:

Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

How can I tell when microsoft bring out a new SQL server hotfix or patch?

latest build number for Yukon

does anyone know what is the latest build number of yukon?
thanx..
Bhavtosh
Hi
April 2005 CTP, IDW14, v9.00.1116.08
Regards
Mike
"Bhavtosh" wrote:

> does anyone know what is the latest build number of yukon?
> --
> thanx..
> Bhavtosh
|||mike, thanx for prompt reply. just one more question:
"do u have any idea of the build versions of whidbey and yukon where
framework will going to be compatible?"
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> April 2005 CTP, IDW14, v9.00.1116.08
> Regards
> Mike
> "Bhavtosh" wrote:
|||Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
only comination supported. They have identical build numbers for the .NET CLR.
Regards
Mike
"Bhavtosh" wrote:
[vbcol=seagreen]
> mike, thanx for prompt reply. just one more question:
> "do u have any idea of the build versions of whidbey and yukon where
> framework will going to be compatible?"
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:
|||can u pls share the whidbey build version which is compatible with latest SQL
CTP IDW?
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
> only comination supported. They have identical build numbers for the .NET CLR.
> Regards
> Mike
> "Bhavtosh" wrote:
|||Hi
Beta 2 of Whidbey, as in the build that was released last Friday, and SQL
Server April CTP, that was released Monday.
http://weblogs.asp.net/denisb/archiv...18/402509.aspx
Please keep the Beta posts to the Beta newsgroups:
Regards
Mike
"Bhavtosh" wrote:
[vbcol=seagreen]
> can u pls share the whidbey build version which is compatible with latest SQL
> CTP IDW?
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:

latest build number for Yukon

does anyone know what is the latest build number of yukon?
thanx..
BhavtoshHi
April 2005 CTP, IDW14, v9.00.1116.08
Regards
Mike
"Bhavtosh" wrote:

> does anyone know what is the latest build number of yukon?
> --
> thanx..
> Bhavtosh|||mike, thanx for prompt reply. just one more question:
"do u have any idea of the build versions of whidbey and yukon where
framework will going to be compatible?"
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> April 2005 CTP, IDW14, v9.00.1116.08
> Regards
> Mike
> "Bhavtosh" wrote:
>|||Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
only comination supported. They have identical build numbers for the .NET CL
R.
Regards
Mike
"Bhavtosh" wrote:
[vbcol=seagreen]
> mike, thanx for prompt reply. just one more question:
> "do u have any idea of the build versions of whidbey and yukon where
> framework will going to be compatible?"
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:
>|||can u pls share the whidbey build version which is compatible with latest SQ
L
CTP IDW?
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
> only comination supported. They have identical build numbers for the .NET
CLR.
> Regards
> Mike
> "Bhavtosh" wrote:
>|||Hi
Beta 2 of Whidbey, as in the build that was released last Friday, and SQL
Server April CTP, that was released Monday.
http://weblogs.asp.net/denisb/archi.../18/402509.aspx
Please keep the Beta posts to the Beta newsgroups:
Regards
Mike
"Bhavtosh" wrote:
[vbcol=seagreen]
> can u pls share the whidbey build version which is compatible with latest
SQL
> CTP IDW?
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:
>

latest build number for Yukon

does anyone know what is the latest build number of yukon?
--
thanx..
BhavtoshHi
April 2005 CTP, IDW14, v9.00.1116.08
Regards
Mike
"Bhavtosh" wrote:
> does anyone know what is the latest build number of yukon?
> --
> thanx..
> Bhavtosh|||mike, thanx for prompt reply. just one more question:
"do u have any idea of the build versions of whidbey and yukon where
framework will going to be compatible?"
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> April 2005 CTP, IDW14, v9.00.1116.08
> Regards
> Mike
> "Bhavtosh" wrote:
> > does anyone know what is the latest build number of yukon?
> >
> > --
> > thanx..
> > Bhavtosh|||Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
only comination supported. They have identical build numbers for the .NET CLR.
Regards
Mike
"Bhavtosh" wrote:
> mike, thanx for prompt reply. just one more question:
> "do u have any idea of the build versions of whidbey and yukon where
> framework will going to be compatible?"
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:
> > Hi
> >
> > April 2005 CTP, IDW14, v9.00.1116.08
> >
> > Regards
> > Mike
> >
> > "Bhavtosh" wrote:
> >
> > > does anyone know what is the latest build number of yukon?
> > >
> > > --
> > > thanx..
> > > Bhavtosh|||can u pls share the whidbey build version which is compatible with latest SQL
CTP IDW?
thanx
bhavtosh
"Mike Epprecht (SQL MVP)" wrote:
> Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
> only comination supported. They have identical build numbers for the .NET CLR.
> Regards
> Mike
> "Bhavtosh" wrote:
> > mike, thanx for prompt reply. just one more question:
> > "do u have any idea of the build versions of whidbey and yukon where
> > framework will going to be compatible?"
> >
> > thanx
> > bhavtosh
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> > > Hi
> > >
> > > April 2005 CTP, IDW14, v9.00.1116.08
> > >
> > > Regards
> > > Mike
> > >
> > > "Bhavtosh" wrote:
> > >
> > > > does anyone know what is the latest build number of yukon?
> > > >
> > > > --
> > > > thanx..
> > > > Bhavtosh|||Hi
Beta 2 of Whidbey, as in the build that was released last Friday, and SQL
Server April CTP, that was released Monday.
http://weblogs.asp.net/denisb/archive/2005/04/18/402509.aspx
Please keep the Beta posts to the Beta newsgroups:
Regards
Mike
"Bhavtosh" wrote:
> can u pls share the whidbey build version which is compatible with latest SQL
> CTP IDW?
> thanx
> bhavtosh
> "Mike Epprecht (SQL MVP)" wrote:
> > Beta 2 of Whidbey with April CTP of SQL Server are compatible and are the
> > only comination supported. They have identical build numbers for the .NET CLR.
> >
> > Regards
> > Mike
> >
> > "Bhavtosh" wrote:
> >
> > > mike, thanx for prompt reply. just one more question:
> > > "do u have any idea of the build versions of whidbey and yukon where
> > > framework will going to be compatible?"
> > >
> > > thanx
> > > bhavtosh
> > >
> > > "Mike Epprecht (SQL MVP)" wrote:
> > >
> > > > Hi
> > > >
> > > > April 2005 CTP, IDW14, v9.00.1116.08
> > > >
> > > > Regards
> > > > Mike
> > > >
> > > > "Bhavtosh" wrote:
> > > >
> > > > > does anyone know what is the latest build number of yukon?
> > > > >
> > > > > --
> > > > > thanx..
> > > > > Bhavtosh

Latest Build

Morning~
What is the latest build of SS2K5 and where may I inquire as to a link to
where I may download it.
Currently running SP2 build 3042
--
Thanks ...
J. KuschThe latest build I know of is 3175, a cumulative package including several
hotfixes. You can get the hotfix through PSS if you open a case and can
demonstrate that your environment has symptoms that at least one of the
hotfixes address.
http://support.microsoft.com/kb/936305
The latest *public* build I know is 3152. Unless you are directly affected
by one of the problems fixed as of 3175, this is the one I recommend
obtaining... since publicly available hotfixes are generally much "safer"
and tested than those that can only be obtained through PSS to fix specific
problems.
http://support.microsoft.com/kb/933097
--
Aaron Bertrand
SQL Server MVP
"Jay Kusch" <JayKusch@.discussions.microsoft.com> wrote in message
news:78B0C5D4-FE38-4AFA-A3BC-9194EA79E1C6@.microsoft.com...
> Morning~
> What is the latest build of SS2K5 and where may I inquire as to a link to
> where I may download it.
> Currently running SP2 build 3042
> --
> Thanks ...
> J. Kusch|||I requested Build 3175 thru /kb/936305 but they told me the hotfix for
platform x86 is unavailable? I apply SP2 on active node of SQL Server 2005
Std active/passive, one instance. an error popup says "A recently applied
update, KB921896, failed to install" but installation completed and when
select @.@.version, it says "9.00.3042.00" which is SP2. Database Engine is
the only thing installed, all is working fine except when I start configuring
DBMail and received "activation failure". After searching online, MSDN forum
says Build 3175 will fix this along with Maintenence Plan that's also broke
by applying SP2. Can someone please tell me how can I obtain Build 3175?
Thank you in advance for your help.
"Aaron Bertrand [SQL Server MVP]" wrote:
> The latest build I know of is 3175, a cumulative package including several
> hotfixes. You can get the hotfix through PSS if you open a case and can
> demonstrate that your environment has symptoms that at least one of the
> hotfixes address.
> http://support.microsoft.com/kb/936305
> The latest *public* build I know is 3152. Unless you are directly affected
> by one of the problems fixed as of 3175, this is the one I recommend
> obtaining... since publicly available hotfixes are generally much "safer"
> and tested than those that can only be obtained through PSS to fix specific
> problems.
> http://support.microsoft.com/kb/933097
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Jay Kusch" <JayKusch@.discussions.microsoft.com> wrote in message
> news:78B0C5D4-FE38-4AFA-A3BC-9194EA79E1C6@.microsoft.com...
> > Morning~
> >
> > What is the latest build of SS2K5 and where may I inquire as to a link to
> > where I may download it.
> >
> > Currently running SP2 build 3042
> > --
> > Thanks ...
> >
> > J. Kusch
>
>|||Maybe this link helps:
http://sqlserverbuilds.blogspot.com/
--
Ekrem Ã?nsoy
"Li" <Li@.discussions.microsoft.com> wrote in message
news:07EE0796-C500-41B6-9D0F-6907285376FF@.microsoft.com...
>I requested Build 3175 thru /kb/936305 but they told me the hotfix for
> platform x86 is unavailable? I apply SP2 on active node of SQL Server
> 2005
> Std active/passive, one instance. an error popup says "A recently applied
> update, KB921896, failed to install" but installation completed and when
> select @.@.version, it says "9.00.3042.00" which is SP2. Database Engine is
> the only thing installed, all is working fine except when I start
> configuring
> DBMail and received "activation failure". After searching online, MSDN
> forum
> says Build 3175 will fix this along with Maintenence Plan that's also
> broke
> by applying SP2. Can someone please tell me how can I obtain Build 3175?
> Thank you in advance for your help.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> The latest build I know of is 3175, a cumulative package including
>> several
>> hotfixes. You can get the hotfix through PSS if you open a case and can
>> demonstrate that your environment has symptoms that at least one of the
>> hotfixes address.
>> http://support.microsoft.com/kb/936305
>> The latest *public* build I know is 3152. Unless you are directly
>> affected
>> by one of the problems fixed as of 3175, this is the one I recommend
>> obtaining... since publicly available hotfixes are generally much "safer"
>> and tested than those that can only be obtained through PSS to fix
>> specific
>> problems.
>> http://support.microsoft.com/kb/933097
>> --
>> Aaron Bertrand
>> SQL Server MVP
>>
>>
>> "Jay Kusch" <JayKusch@.discussions.microsoft.com> wrote in message
>> news:78B0C5D4-FE38-4AFA-A3BC-9194EA79E1C6@.microsoft.com...
>> > Morning~
>> >
>> > What is the latest build of SS2K5 and where may I inquire as to a link
>> > to
>> > where I may download it.
>> >
>> > Currently running SP2 build 3042
>> > --
>> > Thanks ...
>> >
>> > J. Kusch
>>sql

Latest Build

Morning~
What is the latest build of SS2K5 and where may I inquire as to a link to
where I may download it.
Currently running SP2 build 3042
--
Thanks ...
J. KuschThe latest build I know of is 3175, a cumulative package including several
hotfixes. You can get the hotfix through PSS if you open a case and can
demonstrate that your environment has symptoms that at least one of the
hotfixes address.
http://support.microsoft.com/kb/936305
The latest *public* build I know is 3152. Unless you are directly affected
by one of the problems fixed as of 3175, this is the one I recommend
obtaining... since publicly available hotfixes are generally much "safer"
and tested than those that can only be obtained through PSS to fix specific
problems.
http://support.microsoft.com/kb/933097
Aaron Bertrand
SQL Server MVP
"Jay Kusch" <JayKusch@.discussions.microsoft.com> wrote in message
news:78B0C5D4-FE38-4AFA-A3BC-9194EA79E1C6@.microsoft.com...
> Morning~
> What is the latest build of SS2K5 and where may I inquire as to a link to
> where I may download it.
> Currently running SP2 build 3042
> --
> Thanks ...
> J. Kusch

Latest Build

Morning~
What is the latest build of SS2K5 and where may I inquire as to a link to
where I may download it.
Currently running SP2 build 3042
Thanks ...
J. Kusch
The latest build I know of is 3175, a cumulative package including several
hotfixes. You can get the hotfix through PSS if you open a case and can
demonstrate that your environment has symptoms that at least one of the
hotfixes address.
http://support.microsoft.com/kb/936305
The latest *public* build I know is 3152. Unless you are directly affected
by one of the problems fixed as of 3175, this is the one I recommend
obtaining... since publicly available hotfixes are generally much "safer"
and tested than those that can only be obtained through PSS to fix specific
problems.
http://support.microsoft.com/kb/933097
Aaron Bertrand
SQL Server MVP
"Jay Kusch" <JayKusch@.discussions.microsoft.com> wrote in message
news:78B0C5D4-FE38-4AFA-A3BC-9194EA79E1C6@.microsoft.com...
> Morning~
> What is the latest build of SS2K5 and where may I inquire as to a link to
> where I may download it.
> Currently running SP2 build 3042
> --
> Thanks ...
> J. Kusch

Friday, March 9, 2012

Largest string for execute

Hello there
I have function that build sring to execute.
The function create string on 6000 characters size.
Because it's size i had to build it with two strings
How can i execute this size of string?
any help would be usefulYou should be able to execute strings like this:
declare @.sql1 varchar(8000),@.sql2 varchar(8000)
set @.sql1=dbo.your_udf(para1)
set @.sql2=dbo.your_udf(para2)
exec(@.sql1+@.sql2)
-oj
"Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
news:OKCY8OSAFHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello there
> I have function that build sring to execute.
> The function create string on 6000 characters size.
> Because it's size i had to build it with two strings
> How can i execute this size of string?
> any help would be useful
>