Viewing 15 posts - 76 through 90 (of 389 total)
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...
...and your only reply is slàinte mhath
November 4, 2009 at 5:09 pm
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 your only reply is slàinte mhath
November 4, 2009 at 5:01 pm
And how many rows do you have in the table? Maybe snapshot transaction isolation level would be something to consider?
Regards
Piotr
...and your only reply is slàinte mhath
November 4, 2009 at 4:54 pm
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...
...and your only reply is slàinte mhath
November 4, 2009 at 4:48 pm
Good point, I forgot about this 🙂
If it is not an Enterprise edition, perhaps partitioned view could be also an option.
Piotr
...and your only reply is slàinte mhath
November 3, 2009 at 3:02 pm
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...
...and your only reply is slàinte mhath
November 3, 2009 at 1:59 pm
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...
...and your only reply is slàinte mhath
November 3, 2009 at 1:40 pm
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,...
...and your only reply is slàinte mhath
October 24, 2009 at 5:28 pm
Thanks 🙂
Piotr
...and your only reply is slàinte mhath
October 23, 2009 at 12:31 pm
This would be SQL 2008 Grant 😉
Regards
Piotr
...and your only reply is slàinte mhath
October 23, 2009 at 12:16 pm
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...
...and your only reply is slàinte mhath
October 23, 2009 at 11:18 am
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...
...and your only reply is slàinte mhath
October 23, 2009 at 11:05 am
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...
...and your only reply is slàinte mhath
October 23, 2009 at 11:00 am
TheSQLGuru (10/23/2009)
...I do probably 50-60% of my billable time sitting in my office at home.
May I ask how it is organized then? Do you have access to the...
...and your only reply is slàinte mhath
October 23, 2009 at 10:53 am
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...
...and your only reply is slàinte mhath
October 22, 2009 at 4:29 pm
Viewing 15 posts - 76 through 90 (of 389 total)