Jeff, good thing to think about. In my case i'm the only one who use this.

In one word. Thank you for the lesson Wayne.

When its al finished i will come back to this topic.

Kind regards,

André

BCP is very cool.

Guys with your information and information from Ray Wong i created a function with a loop.

This works.

But i told you about the table who needs to update...

I use BCP now with a view with headers via a select, its looks very good.

But its intereseting to know more options.

I need the output in *.csv but i can concatenate the output.

Good idea to, i tried something else with a loop, come back on it today.

Thanks guys.

Hi Wayne,

Your right about that.

Mostly i report back, i'm new, but its nice to close with the final result.

Kind regards,

André

Thanks guys, i'm gonna test a bit for the best solution.

Solution found:

DECLARE @cmd VARCHAR(2048);

SET @cmd = --'bcp [myTestNativeData] out "/myTestUniNativeData-N.csv" -U<admabo> -N -T -t","';

'bcp "select * from [Staedion Test].[dbo].[Staedion$Werknemer Afdeling]" queryout C:\TEST.txt -S S-EMPACC -U admabo -N -T -t","';

EXEC...

this is the result:

DECLARE @cmd VARCHAR(2048);

SET @cmd = 'bcp [myTestNativeData] out "C:\myTestUniNativeData-N.csv" -U<admabo> -N -T -t","';

EXEC xp_cmdshell @cmd

But now i get the following error:

The system cannot find the...

It looks like the space in the DB causes the problem, this works only now i have to play with the right user name:

DECLARE @cmd VARCHAR(2048);

SET @cmd = 'bcp...

Yeah i know, you get diskpaging. But the Ms Dynamics NAV enviroment where the writing goes, has no problem.

Altrhough a good thing to inspect.

We are looking now in page handling...

Thanks. I found the SSRS report webservice and i did the following things:

- changed sql server service user to a domain svcUser.

- Authorized the user groups to my reports.

- Authorized...

During the day the performance gets worse. And with a Ctrl-R or F5 (refresh) it looks like perfomance increases.

Thats why we have limited the cache settings in IE8 and we...

Ok you guys, you helpt me a lot.

1.

select definition + CHAR(13) + CHAR(10) + 'GO' + CHAR(13) + CHAR(10)

from sys.sql_modules

left outer join sys.objects

on sys.sql_modules .object_id = sys.objects.object_id

where sys.objects.type='V'

2.

Export grid...

Lol. I'm a forum newbie i see. I mostly search for solutions myself. But i see you can learn much from some solutions.

Thanks. I work in SQL2005 but i have...