xp cmdshell: 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...

quote:

> 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

quote:

> 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

quote:

> 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

quote:

> news: uZPM7gf2DHA.3140@.tk2msftngp13.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

quote:

> 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

quote:

> news: uZPM7gf2DHA.3140@.tk2msftngp13.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...

quote:

> 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

quote:

> news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
property[QUOTE]
message[QUOTE]
> de
allocated[QUOTE]
>
>

|||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...

quote:

> 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

quote:

> news: eaZsVof2DHA.536@.tk2msftngp13.phx.gbl...
property[QUOTE]
message[QUOTE]
> de
allocated[QUOTE]
>
>

|||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...

quote:

> 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

quote:

> news: ei5t41f2DHA.2032@.TK2MSFTNGP09.phx.gbl...
message[QUOTE]
> de
> property
> message
> allocated
>
>

|||I found :
http://support.microsoft.com/defaul...&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...

quote:

> 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

quote:

> news: O51ioug2DHA.2180@.TK2MSFTNGP12.phx.gbl...
message[QUOTE]
> de
> message
>

Tuesday, March 20, 2012

Problem of TimeOut

No comments:

Post a Comment

xp cmdshell

Blog Archive

About Me