What's the Query or Stored procedure that's running? Complex views quite often show this behaviour!?

I've just switched back to a usual temp table now ... profiled the sproc in question, and am not getting an recompilations (which is why i usually go for variables...

Cheers Remi

This statement's about the only thing that may make sense :

"Table variables do not maintain statistics like temporary tables can. Statistics cannot be created on table variables through automatic...

Now did we REALLY need to know that Steve "Plays Santa" on his wife's b'days!??

The results may be slightly unexpected, but if you look at "View Resolution" in BOL, it might explain what SQL Server is actually doing! Remember that a View isn't a...

MS Clusters are MS Clusters, and there's not much more u can say! When a failover occurs, there's usually so much it has to do that some single thing may...

"SQL Server sys. admin. account "sa" is required to run some functions and replacing this with a named admin account which should have the same access rights as "sa" just...

oh ... so its OUR fault now!??

yeah yeah ... that's what we tell our users as well!?????

yeah yeah .... that's what we tell our users as well!?

Contrary to the usual, i've managed to find the issue on the net faster than someone at SQL Central can post a reply!? lol

the following gives a basic description of...

The problem is that u have a text node on first menu_ID item, but then have child elements as well

<Menu_ID>002

<MenuTable>

 <Sub_Menu>

   <Menu_ID> 00201 </Menu_ID>

   <Menu_ID> 00202 </Menu_ID> 

   <Menu_ID> 00203 </Menu_ID> 

  </MenuTable>

 </Sub_Menu>

</Menu_ID> 

This isn't good practice when...

lookup the STUFF() function in BOL! Should do the job for u!

I think the first question is Why WOULDN'T they be logged into their workstations???

Secondly, has the SQL Server been published to the Active Directory or summat like that??

just try not to hit a port that's standard to summat else (can usualy find standard port lists on the web!). Last time i set one up, i put in...