137 reputation
18
bio website
location London, United Kingdom
age
visits member for 2 years, 11 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 soul and becoming a full-time commercial software developer around 2011.


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
asked Another BCP Export [Fail]ure
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
awarded  Scholar
Nov
20
accepted SELECT Data Set Using Stored Procedure with BCP Error
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...
Nov
20
asked SELECT Data Set Using Stored Procedure with BCP Error
Sep
28
answered Managing SQL Server MDF and LDF file size
May
1
awarded  Supporter
Apr
16
awarded  Student
Apr
16
asked Cannot Check if the Access Database Engine is Installed and Configured
Apr
16
answered Access Linked Server error “The provider did not give any information about the error.”
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.
Jan
19
asked Creating a New Database Across a Network with SQL Server 2008 R2