Hi there A1_Technology_geb,

show me what you have so far and I will try to give you some pointers.

regards

GermanDBA

Hi there,

it worked fine. Many thanks

Hi Jack,

yes the list is on the exchange server. The name of the dist. list has spaces though. Is that a problem? How do I have to...

Hi deepti811,

I will write an example again to show you what you need to do:

--Step 1

exec xp_cmdshell 'copy d:\templates\sales.xls d:\export\sales.xls'

--Step 2

insert into OPENROWSET(

...

Hi there,

here is the code - anonymised (sp?) of course.

As said in a previous post, this was written a long time ago when I had just learned how to write...

Count me in too.

Default is no, if I have to add a flag to the server startup parameters it is NOT default :ermm:

I want my point for getting it right!...

Hi there,

If I understand correctly, you want to export information into one excel file with multiple sheets.

The way I have done this is as follows:

1. Create an empty Excel file...

Hi there,

I wanted to do the same thing and managed to find this great little explanation on the interweb: http://www.databasejournal.com/features/mssql/article.php/10894_3331881_1

Please be aware that these methods of "speaking" to txt, csv...

Hi,

thanks very much so far. The information and explanations supplied are clear and understandable. I thought that select 1 would be quicker, now I know! 😎

Thanks again!

GermanDBA

Hi,

The point about which index is used seems a bit superfluous to me because the remaining part of the select is what makes the server choose the index.

If I perform:...

Hi sram24_mca,

I'm not too sure what you mean. You read through the scripts and wanted an explanation of what they do? I thought that the comments in the...

Hi Homebrew,

Sorry, I think you misunderstood.... sarcasm is not an easy thing to display when writing on a message board.

I only meant that I made the mistake of not activating...

Hi Scott,

now I see where you're coming from.

I can only suggest this approch to the Project Lead, see what he says.

"Incompatible requirements" is the best phrase that I have read...

Hi Scott,

The replication is used for two reasons:

1. To offload live reporting onto a separate machine.

2. To use the replicated data to create our fact tables in the Datawarehouse.

The first...

Hi again,

just a quick update about this.

The job ran successfully last night, the replication paused and ran again after the fact table generation completed. All in all the system...