Query length

Hi,
Is length of sql query limited in MS_SQL Server ?
tia
plutonNot specific limitation I can think off ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:c7nj5p$kpm$2@.news.onet.pl...
> Hi,
> Is length of sql query limited in MS_SQL Server ?
> tia
> pluton
>|||250 MB and 1024 tables per SELECT, not limits you're very likely to run
into.
--
Jacco Schalkwijk
SQL Server MVP
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:c7nj5p$kpm$2@.news.onet.pl...
> Hi,
> Is length of sql query limited in MS_SQL Server ?
> tia
> pluton
>|||Hi,
> 250 MB and 1024 tables per SELECT, not limits you're very likely to run
> into.
Indeed. Thanks :)
pluton