Monday, March 12, 2012

Problem of TimeOut

Hi,
After restoration of my database, I need to rebuil my views.
The query I use needs 7 mn to build it and it cannot be fulfilled.
I've set the querytimeout parameter to 0 (unlimited) and I've allocated
physcical memory to the server.
What else can I do?
Thanks
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.orgWhat is the error you are getting?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
Hi,
After restoration of my database, I need to rebuil my views.
The query I use needs 7 mn to build it and it cannot be fulfilled.
I've set the querytimeout parameter to 0 (unlimited) and I've allocated
physcical memory to the server.
What else can I do?
Thanks
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org|||[Microsoft][SqlServerODBCDriver]Timeout expired
I have already set the timeout of the driver to the maximum value.
Thank you for your help I really need it :)
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> What is the error you are getting?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> Hi,
> After restoration of my database, I need to rebuil my views.
> The query I use needs 7 mn to build it and it cannot be fulfilled.
> I've set the querytimeout parameter to 0 (unlimited) and I've allocated
> physcical memory to the server.
> What else can I do?
> Thanks
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
>|||Are you using ADO? If so, you will have to set the CommandTimeout property
of your Connection or Command object.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
[Microsoft][SqlServerODBCDriver]Timeout expired
I have already set the timeout of the driver to the maximum value.
Thank you for your help I really need it :)
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> What is the error you are getting?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> Hi,
> After restoration of my database, I need to rebuil my views.
> The query I use needs 7 mn to build it and it cannot be fulfilled.
> I've set the querytimeout parameter to 0 (unlimited) and I've allocated
> physcical memory to the server.
> What else can I do?
> Thanks
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
>|||The query is directly done on the server :(
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> Are you using ADO? If so, you will have to set the CommandTimeout property
> of your Connection or Command object.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> [Microsoft][SqlServerODBCDriver]Timeout expired
> I have already set the timeout of the driver to the maximum value.
> Thank you for your help I really need it :)
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > What is the error you are getting?
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > After restoration of my database, I need to rebuil my views.
> > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > I've set the querytimeout parameter to 0 (unlimited) and I've allocated
> > physcical memory to the server.
> >
> > What else can I do?
> >
> > Thanks
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> >
> >
>
>|||Using Query Analyzer?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
The query is directly done on the server :(
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> Are you using ADO? If so, you will have to set the CommandTimeout property
> of your Connection or Command object.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> [Microsoft][SqlServerODBCDriver]Timeout expired
> I have already set the timeout of the driver to the maximum value.
> Thank you for your help I really need it :)
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > What is the error you are getting?
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > After restoration of my database, I need to rebuil my views.
> > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > I've set the querytimeout parameter to 0 (unlimited) and I've allocated
> > physcical memory to the server.
> >
> > What else can I do?
> >
> > Thanks
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> >
> >
>
>|||With Query Analyzer it works...
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> Using Query Analyzer?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> The query is directly done on the server :(
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > Are you using ADO? If so, you will have to set the CommandTimeout
property
> > of your Connection or Command object.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > [Microsoft][SqlServerODBCDriver]Timeout expired
> >
> > I have already set the timeout of the driver to the maximum value.
> >
> > Thank you for your help I really need it :)
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > What is the error you are getting?
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > After restoration of my database, I need to rebuil my views.
> > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > I've set the querytimeout parameter to 0 (unlimited) and I've
allocated
> > > physcical memory to the server.
> > >
> > > What else can I do?
> > >
> > > Thanks
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||So, from which application did it not work? :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:#hiQ8lg2DHA.2000@.TK2MSFTNGP11.phx.gbl...
With Query Analyzer it works...
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> Using Query Analyzer?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> The query is directly done on the server :(
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > Are you using ADO? If so, you will have to set the CommandTimeout
property
> > of your Connection or Command object.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > [Microsoft][SqlServerODBCDriver]Timeout expired
> >
> > I have already set the timeout of the driver to the maximum value.
> >
> > Thank you for your help I really need it :)
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > What is the error you are getting?
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > After restoration of my database, I need to rebuil my views.
> > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > I've set the querytimeout parameter to 0 (unlimited) and I've
allocated
> > > physcical memory to the server.
> > >
> > > What else can I do?
> > >
> > > Thanks
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||When I click "Return all rows" in Sql Enterprise manager
--
Yannick Lejeune
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: O51ioug2DHA.2180@.TK2MSFTNGP12.phx.gbl...
> So, from which application did it not work? :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:#hiQ8lg2DHA.2000@.TK2MSFTNGP11.phx.gbl...
> With Query Analyzer it works...
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> > Using Query Analyzer?
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> > The query is directly done on the server :(
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > > Are you using ADO? If so, you will have to set the CommandTimeout
> property
> > > of your Connection or Command object.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > > [Microsoft][SqlServerODBCDriver]Timeout expired
> > >
> > > I have already set the timeout of the driver to the maximum value.
> > >
> > > Thank you for your help I really need it :)
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> message
> > de
> > > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > > What is the error you are getting?
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > >
> > > > After restoration of my database, I need to rebuil my views.
> > > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > > I've set the querytimeout parameter to 0 (unlimited) and I've
> allocated
> > > > physcical memory to the server.
> > > >
> > > > What else can I do?
> > > >
> > > > Thanks
> > > >
> > > > --
> > > > Yannick LEJEUNE - MVP C#
> > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > c/o EPITA (French Computer Engineering School)
> > > > http://www.3ie.org
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||I found :
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q247/0/70.ASP&NoWebContent=1
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> a écrit dans le message de news:
%23WdPE$g2DHA.2208@.TK2MSFTNGP12.phx.gbl...
> When I click "Return all rows" in Sql Enterprise manager
> --
> Yannick Lejeune
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: O51ioug2DHA.2180@.TK2MSFTNGP12.phx.gbl...
> > So, from which application did it not work? :-)
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:#hiQ8lg2DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > With Query Analyzer it works...
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> > > Using Query Analyzer?
> > >
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> > > The query is directly done on the server :(
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> message
> > de
> > > news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > > > Are you using ADO? If so, you will have to set the CommandTimeout
> > property
> > > > of your Connection or Command object.
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > > > [Microsoft][SqlServerODBCDriver]Timeout expired
> > > >
> > > > I have already set the timeout of the driver to the maximum value.
> > > >
> > > > Thank you for your help I really need it :)
> > > >
> > > > --
> > > > Yannick LEJEUNE - MVP C#
> > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > c/o EPITA (French Computer Engineering School)
> > > > http://www.3ie.org
> > > >
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> > message
> > > de
> > > > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > > > What is the error you are getting?
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > After restoration of my database, I need to rebuil my views.
> > > > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > > > I've set the querytimeout parameter to 0 (unlimited) and I've
> > allocated
> > > > > physcical memory to the server.
> > > > >
> > > > > What else can I do?
> > > > >
> > > > > Thanks
> > > > >
> > > > > --
> > > > > Yannick LEJEUNE - MVP C#
> > > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > > c/o EPITA (French Computer Engineering School)
> > > > > http://www.3ie.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>|||Gotcha! See if this helps:
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:#WdPE$g2DHA.2208@.TK2MSFTNGP12.phx.gbl...
When I click "Return all rows" in Sql Enterprise manager
--
Yannick Lejeune
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news: O51ioug2DHA.2180@.TK2MSFTNGP12.phx.gbl...
> So, from which application did it not work? :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> news:#hiQ8lg2DHA.2000@.TK2MSFTNGP11.phx.gbl...
> With Query Analyzer it works...
> --
> Yannick LEJEUNE - MVP C#
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> > Using Query Analyzer?
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> > The query is directly done on the server :(
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > > Are you using ADO? If so, you will have to set the CommandTimeout
> property
> > > of your Connection or Command object.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > > [Microsoft][SqlServerODBCDriver]Timeout expired
> > >
> > > I have already set the timeout of the driver to the maximum value.
> > >
> > > Thank you for your help I really need it :)
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> message
> > de
> > > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > > What is the error you are getting?
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > >
> > > > After restoration of my database, I need to rebuil my views.
> > > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > > I've set the querytimeout parameter to 0 (unlimited) and I've
> allocated
> > > > physcical memory to the server.
> > > >
> > > > What else can I do?
> > > >
> > > > Thanks
> > > >
> > > > --
> > > > Yannick LEJEUNE - MVP C#
> > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > c/o EPITA (French Computer Engineering School)
> > > > http://www.3ie.org
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>|||That article is a little doubtful, I'll have to double check it. Did you try
my site?
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
news:ebuwwAh2DHA.1908@.TK2MSFTNGP10.phx.gbl...
I found :
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q247/0/70.ASP&NoWebContent=1
--
Yannick LEJEUNE - MVP C#
Directeur Institut d'Innovation informatique pour l'Entreprise
c/o EPITA (French Computer Engineering School)
http://www.3ie.org
"Yannick LEJEUNE [MVP]" <yannick@.3ie.org> a écrit dans le message de news:
%23WdPE$g2DHA.2208@.TK2MSFTNGP12.phx.gbl...
> When I click "Return all rows" in Sql Enterprise manager
> --
> Yannick Lejeune
> Directeur Institut d'Innovation informatique pour l'Entreprise
> c/o EPITA (French Computer Engineering School)
> http://www.3ie.org
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message
de
> news: O51ioug2DHA.2180@.TK2MSFTNGP12.phx.gbl...
> > So, from which application did it not work? :-)
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > news:#hiQ8lg2DHA.2000@.TK2MSFTNGP11.phx.gbl...
> > With Query Analyzer it works...
> >
> > --
> > Yannick LEJEUNE - MVP C#
> > Directeur Institut d'Innovation informatique pour l'Entreprise
> > c/o EPITA (French Computer Engineering School)
> > http://www.3ie.org
> >
> >
> > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
message
> de
> > news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
> > > Using Query Analyzer?
> > >
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > > Is .NET important for a database professional?
> > > http://vyaskn.tripod.com/poll.htm
> > >
> > >
> > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > news:u8OQzxf2DHA.2308@.TK2MSFTNGP11.phx.gbl...
> > > The query is directly done on the server :(
> > >
> > > --
> > > Yannick LEJEUNE - MVP C#
> > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > c/o EPITA (French Computer Engineering School)
> > > http://www.3ie.org
> > >
> > >
> > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> message
> > de
> > > news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
> > > > Are you using ADO? If so, you will have to set the CommandTimeout
> > property
> > > > of your Connection or Command object.
> > > > --
> > > > HTH,
> > > > Vyas, MVP (SQL Server)
> > > > http://vyaskn.tripod.com/
> > > > Is .NET important for a database professional?
> > > > http://vyaskn.tripod.com/poll.htm
> > > >
> > > >
> > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > news:%23jzFikf2DHA.2428@.tk2msftngp13.phx.gbl...
> > > > [Microsoft][SqlServerODBCDriver]Timeout expired
> > > >
> > > > I have already set the timeout of the driver to the maximum value.
> > > >
> > > > Thank you for your help I really need it :)
> > > >
> > > > --
> > > > Yannick LEJEUNE - MVP C#
> > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > c/o EPITA (French Computer Engineering School)
> > > > http://www.3ie.org
> > > >
> > > >
> > > > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le
> > message
> > > de
> > > > news: uZPM7gf2DHA.3140@.tk2msftngp13.phx.gbl...
> > > > > What is the error you are getting?
> > > > > --
> > > > > HTH,
> > > > > Vyas, MVP (SQL Server)
> > > > > http://vyaskn.tripod.com/
> > > > > Is .NET important for a database professional?
> > > > > http://vyaskn.tripod.com/poll.htm
> > > > >
> > > > >
> > > > > "Yannick LEJEUNE [MVP]" <yannick@.3ie.org> wrote in message
> > > > > news:ea61RPf2DHA.1272@.TK2MSFTNGP12.phx.gbl...
> > > > > Hi,
> > > > >
> > > > > After restoration of my database, I need to rebuil my views.
> > > > > The query I use needs 7 mn to build it and it cannot be fulfilled.
> > > > > I've set the querytimeout parameter to 0 (unlimited) and I've
> > allocated
> > > > > physcical memory to the server.
> > > > >
> > > > > What else can I do?
> > > > >
> > > > > Thanks
> > > > >
> > > > > --
> > > > > Yannick LEJEUNE - MVP C#
> > > > > Directeur Institut d'Innovation informatique pour l'Entreprise
> > > > > c/o EPITA (French Computer Engineering School)
> > > > > http://www.3ie.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>

No comments:

Post a Comment