Activity overview
Latest activity by Ericgagne
Specify NULLS count below 1%
I am generating a 500,000 records table to simulate POS data over a 8 months period.
I need random nulls in that table to simulate bad data sent by the POS System but setting a 1% null count on eac...
Hi Eddie,
Thanks for the reply. Unfortunately it's not an option for me to change my values after synchronizing. The destination table has triggers on these columns that make sure the values exists in their corresponding master tables.
The sripts will abort if I don't change the values before running them. / comments
Hi Eddie,
Thanks for the reply. Unfortunately it's not an option for me to change my values after synchronizing. The destination table has triggers on these columns that make sure the values exis...
Replacing Values
Hello,
I'm synchronizing tables from 2 different databases that were used in different companies. I need to be able to change the value in one of the columns with a fixed value instead of the valu...
Thanks for the reply Peter. I thought it was something like that since it stopped working when I changed from a shate to the E drive.
There is a simple workaround however as it seems that what SQL Backup really needs for this to work is a UNC, but not necessarily on a remote machine.
I changed "E:\SQL Backup Copies" to "\\ServerName\E$\SQL Backup Copies" in my job and it works fine now. / comments
Thanks for the reply Peter. I thought it was something like that since it stopped working when I changed from a shate to the E drive.
There is a simple workaround however as it seems that what SQL...
Can network copies be on a local drive ?
Hello,
The server onto which I was pushing copies died and we had to put them somewhere else so I changed my jobs to use a local drive.
Backups are put in I:\SQLBackups and network copies are put i...