Viewing 15 posts - 376 through 390 (of 3,061 total)
jitendra.padhiyar (4/4/2012)
So it is not possible to add primary key on any populated table? or i need to another coulumn which will not allow null vaules ?
A Primary Key is...
April 6, 2012 at 9:54 am
Joy Smith San (4/6/2012)
After restarting the service, SQL server agent was stopped with "Agent XPs disabled" next to it and I was...
April 6, 2012 at 8:23 am
_nzrdb6 (4/3/2012)
I'm an average Joe DBA looking after 50 instances across London, Paris and New York. In London and NY SSIS is used for ETL but in Paris the...
April 3, 2012 at 4:58 am
Z1024 (4/1/2012)
PaulB-TheOneAndOnly (3/31/2012)
Z1024 (3/31/2012)
As you can see, this is a very common problem on at least SQL Server, Oracle and MySQL and the usually recommended solution worked fine.
mmmhh... not really,...
April 2, 2012 at 4:32 pm
dba_stephanie-b (4/1/2012)BTW, do not let anyone convince you that an export using exp/imp (which are now deprecated) or data pump, constitutes a backup. It does not 😉
It is merely...
April 2, 2012 at 5:41 am
Z1024 (3/31/2012)
As you can see, this is a very common problem on at least SQL Server, Oracle and MySQL and the usually recommended solution worked fine.
mmmhh... not really, are you...
March 31, 2012 at 5:04 pm
Welsh Corgi (3/31/2012)IMHO it would be better to purge the records loaded via the incremental load as opposed to having a script doing a compare.
Agreed.
It is usual for jobs...
March 31, 2012 at 3:03 pm
I do not think this is as straigh forward as posted.
If - as it appears to be - branches are running structural identical databases on their own then not all...
March 31, 2012 at 1:55 pm
Welsh Corgi (3/30/2012)
Any ideas would be greatly appreciated.
It all depends on the design and how the architect decided to track changes - I have seen cases where the DWH does...
March 31, 2012 at 1:47 pm
opc.three (3/30/2012)
March 30, 2012 at 1:54 pm
aitchkcandoo (3/30/2012)
Please tell me what key phrases will lead me to more information about why some tables contain FKs that reference PK in the same table. Is...
March 30, 2012 at 1:47 pm
Contact your SQL Server DBA and ask him/her if your credentials are good to execute such storedproc.
March 30, 2012 at 11:42 am
davidshephard (3/30/2012)
Could not find ddo.member-update (Stored Procedure)...
March 30, 2012 at 11:28 am
Charmer (3/30/2012)
PaulB-TheOneAndOnly (3/30/2012)
Yes. Try dynamic sql.Gimme an example Please...
Nothing beats vendor's documentation 🙂 check here: http://support.microsoft.com/kb/175850
March 30, 2012 at 8:23 am
pallavi.unde (3/30/2012)
can we apply update cascade on all field of table.. so that if i update any value from parent it will be updated in child table also ???????
No.
March 30, 2012 at 8:20 am
Viewing 15 posts - 376 through 390 (of 3,061 total)