Hi Steve

Sorry, and yes if I have a for each loop container, I will need to check each file before I process it

thanks Yarhad

Thanks steve for your reply.

the situation is this...

I have xml files that I import everyday and when the file size is say 1kb,

the file structure doesn't match the destination...

Hi John,

Thank you for your reply.

It worked!

Adding "c:\program files\7-zip\7z.exe" to the .bat file changed the directory.

Thanks once again

Yarhad

Thanks john for your reply.

I am compressing the .bak files using sql server.

I was trying to add all the compressed .bak files to one zipped location and then copy it...

Phil, Thanks a billion!

GilaMonster (10/9/2012)

---

Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you...

Ok, let me start again.

you know when you check the sql server logs, you can see things that happened in the database

e.g alter recovery mode, database backup, database restore, sql...

Sorry SQl server logs

So How to I locate the activity. ie for example when a database is backed up, one can see the activity logged in the activity log.

How come I can see...

Thanks SSChampion,

for the info. Infact the database will grow as time goes by and the main reason I was thinking of shrinking is that

I thought it would affect the...

Thank you very very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Have you considered compressed backup?

[/quote]

Hi Ten Centuries and Hall of Fame,

the backup already has compression turned on.

Please forgive me if I seem daft, but I am new to this...

If I...

SSC-Addicted,

Once again (From the deepest corner of my heart!)

Thanks

SSC_Addicted,

Thanks you very much for your reply.

Today is the first I am coming across CTE and what it can and be used for.

Thanks a whole lot

I am going to research...

Thanks!!

I read the white paper and it was there in black and white

'Data is encrypted in the cipher block chaining (CBC) encryption mode. The encrypted database files that are...