thanks, so I guess the first should be the original table it is updated.

and the secondline of rows affected should be always mean the rows affected in the ...

Thanks, I will add set nocount on.

but does the first statement line of rows affected means the address table. Not the history table?

Thanks

Thanks for the information.

Yes, I agree install different versions of Visual studio could cause all kinds of issues. esp, after unintall and then reinstall.

Hope microsoft make all these simple to...

I copied 5 dll files from another 2008 instance in the C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8 folder to my computer.

Then SSIS BI 2008 works, and I also tested data...

I have the same error. And now I have sql server 2012 data tool BI installed. 2012 works, but 2008R2 doesn't work.

I want to keep both BI tools on...

Thank you, I do repair the BI using installation media for SQL server 2008.

But it is still not working after repair. same error message when I add a new package...

thanks,

I checked there is no one else open the file, I even rename it to a different to try it,

It still got the same error.

So since I searched online a...

I run the above script in managment studio on the sql server, its result is

1mydomain\mysqlsvs --This is my sql server service ccount

2NULL

3NULL

4myfile.txt

5NULL

So this means it does have access...

Lowell,

I tried to setup a proxy account, but still same error. Also our SQL server service account is already a domain account and has access to the share. but still...

Thanks, Lowell,

Is it the same thing comparing what you said:

http://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/

Thanks,

Thanks, got it.

We are here not enable TDE, also read from online:

Encrypted data compresses significantly less than equivalent unencrypted data. If TDE is used to encrypt a database, backup compression...

Thanks I just wonder if it is good to setup compression at server level or in the indivual backup like maintenance plan or T-SQL backup?

Thanks Tom for the recommendations. It is good to know from your experience.

I will note down and give it a try.

Thanks Chris, that is very helpful information.

I will use as a reference when I do my work.

Thanks

Thanks, Chris, I will probably go the same route if I found more stored procedures that use temp db or table.

A couple of questions for you,

When you generate the...