[thanks Alamir i will test your kindly suggestion

Luis Santos]

try to install MDAC 2.7 and its SP in your Application language on any client machine (which has any O/S).

if it doesn't...

Hello

I am sorry but i make a mistake in my question:

I need to use Named pipes to connect to an SQL SERVER instead of TCP/IP but everytime i open...

Hello

I am sorry but i make a mistake in my question:

I need to use Named pipes to connect to an SQL SERVER instead of TCP/IP but everytime i open...

Thanks for your useful help

I hope that all people that work with SQL SERVER count on you for many years because in my opinion this is the best community to...

Thanks you for your help, but i have 2 questions:

In this case my tape volume always growing and i can´t save espace in their, and also if i use the...

Hello

I would like to thank you for all your suggestions.

Best regards

Luis Santos

Hello again

Like you said Greg i want to make a batch file in DOS to run The script that i am write but i don´t know how can write correctly...

Hello again

The version of MSDE is 8.00.8194

just a little correction because my LOG volume is Ok, but is my MDF file that have a big volume.

Best regards

Luis Santos

Many thanks for your help, i will try your sugestion

bye

Luis Santos

obrigado (that's mean thank you in portuguese)

good weekend

Luis Santos

Hello

i´am very grateful for your friendly helps, my T-SQL works very well.

i´d like to now if it is possible with an select statement build a crosstab query like in access...

Hello Deuce

i´am very grateful they work very well.

if when i use this kind of subquery and i need to make a group by statement by aliases i must use always...

hello again Steve

i test your example but all the time i have the same erro

line 11 :incorrect sintaxe near 'article'

i don´t know if i forget ')' or it´s a problem...

Hello again !

Thanks Steve,i will test your suggestion

See you

Best regards

Luis Santos

Ok i think its a good solution, but i need the TSQL script for creating my temp table.

Could you send me this?

Best regards

Luis Santos

Thanks for the feedback. It appears that...