Hi,

You might try the default trace - there is a chance it was not disabled. Check this query:

select * from sys.traces where is_default = 1

If you have this trace, there...

Hi,

Just curious - do these developers and programmers have db_ddladmin role membership on production system?

If they use Windows authentication, the sp_change_users_login will not work.

Maybe permissions set on production database are...

And how many rows do you have in the table? Maybe snapshot transaction isolation level would be something to consider?

Regards

Piotr

Hi,

I wrote a simple test and it seems to be working for me, please run it in your environment:

create login test with password='test123'

go

use testdb

go

create user utest from login test

go

--add user...

Good point, I forgot about this 🙂

If it is not an Enterprise edition, perhaps partitioned view could be also an option.

Piotr

Hi,

There is a checkbox "Connect to SQL Server to obtain default settings for the additional configuration options" on the second page of the "Create a New Data Source to SQL...

I agree, partitioning seems to be the least resource consuming approach. I would though create 31 partitions for sliding window. Then I would set up a job to move the...

Hi,

The Visual Studio is a 32 bit application. There are two options you could try. Either install 32 bit version of the Oracle OleDb driver or right click the solution,...

Thanks 🙂

Piotr

This would be SQL 2008 Grant 😉

Regards

Piotr

We have two destinations usually: one with Data access mode - fast load. It is configured to redirect error output to the second, that saves rows in the same table...

This is because empty string is not a NULL, and your constraints accept empty strings. If you showed us your XML and also table schema, we might be able to...

The truncation occurs because data that you are trying to fit into a column are longer than this column. Check mappings in the SSIS, especially data types. Check what is...

May I ask how it is organized then? Do you have access to the...

On top of that, I would consider storing notes in table C, and removing them from A and B. This would save a log of creepy logic and some space...