137 reputation
18
bio website
location London, United Kingdom
age
visits member for 2 years, 9 months
seen Sep 22 at 13:33

My background is in theoretical/mathematical physics [MPhys/PhD], I was a Senior Computational Fluid Dynamics Analyst in the nuclear/defence industry before selling my sole and becoming a full-time commercial software developer around 2011.


Jan
11
comment How to Find the Foreign Key Associated with a Given Primary Key
The simple answer is that I want both and the accepted answer gives me means to do this...
Jan
11
comment How to Find the Foreign Key Associated with a Given Primary Key
I need all of the constraint information for any given column (if any). I want to construct a database class that holds all the information for a given database. This class structure database.table.column.constraints will then be used to get the matches between different columns on PK/FKs. Clearly some columns will have FKs only and in this case I also want to retrieve the PK information of the corresponding key; some will have only PKs and then I want the reverse. Some of course can have both. Sorry if this also does not answer you question.
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
I am creating a script genrator for QlikView. To generate the script I need the constraints and the ascociated links.
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
Thanks for your time Aaron. Much appreciated.
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
Thanks again. When I can bounty this I will do...
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
Thanks very much for your time here. It is most appreciated. Where can I get one of those posters!? It looks like you might be able to use INFORMATION_SCHEMA.KEY_COLUMN_USAGE? This is making me feel very weak!
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
Ps. I am going to bounty this so you can have some rep!
Jan
10
comment How to Find the Foreign Key Associated with a Given Primary Key
That is absolute quality. I have been hacking around with a three teir JOIN simalar to the 1st, 2nd and 4th above. Great to see an answer like this - so difinitive! Now, two additonal things if I may be so bold. How do you find out about the poentail links between such system table and thus easyly come up with the above? or is it experience? Exending this to include the actual PK name is also not obvious to me - could you extend the answer to include this please?
Nov
20
comment Another BCP Export [Fail]ure
I have ammended the stored proceedure as above. But I am still getting an error that is documanted here connect.microsoft.com/sqlserver/feedback/details/584001/bcp can you offer any ideas as to a resolution? Thanks again.
Nov
20
comment Another BCP Export [Fail]ure
+1, I had taken this out of context in my own mind! Thanks, but how the hell do I get a self contain SP that will allow me to build the correctly order field list if not with TmpTables? Man, this stuff drives me round the bend... Again, thanks for your time.
Nov
20
comment SELECT Data Set Using Stored Procedure with BCP Error
Why? Basically, the SP is casting Empty.Strings to nulls to get around BCP putting the ASCII CHAR(0)/Nul character in the output file. Running SELECT * FROM [2BSHAEOS]..[B1A]; as the query works. I think you are right and this is occuring due to the fields specified in the format file being of an incorrect order as the fields output by my SP - this goes from bad to worse! You should see the SP that creates the .fmt file!!
Nov
20
comment SELECT Data Set Using Stored Procedure with BCP Error
I have not tried that @StuartMoore. I will attempt to do that now...
Jan
19
comment Creating a New Database Across a Network with SQL Server 2008 R2
@jl01 What is meant by a domain account in this context?
Jan
19
comment Creating a New Database Across a Network with SQL Server 2008 R2
@ShawnMelton I did. I navigated to CShare on VAION from VIAOE where on VAIOE I was logged in as 'Administrator'. This account is the one SQL Server was installed with and has full privleges as far as SQL Server goes. The account that was currently logged in on VAION when attempting the above was also the 'Administrator' account which has the same password as the one I was using on VAIOE. What do you mean by domain account in the above?
Jan
19
comment Creating a New Database Across a Network with SQL Server 2008 R2
Share on the top level directory will pass (and is set to pass in this case) all privileges down the hierarchy to subfolders and files. In light of this, your advice will not help me here. Thanks very much for your time.