My worst was working with the legacy Filemaker system at my old job. They were using an old version of the system that couldn't be upgraded and had been...

Please send us the query you are running that is generating nulls, you mentioned you were querying sys.tables and sys.columns so I'm very curious how you are getting nulls.

What is the query you are using, I'm kind of curious how you're getting nulls?

Yes, the CIO finally agreed with me that I could not do my job without sysadmin... although for some strange reason the 3rd Party company might still insist on doing...

Luis Cazares (7/1/2016)

RonKyle (7/1/2016)

To that I always reply that no user should...

Site

When Wells Fargo first started doing online banking their default user name was in fact SSN, for years, originally I don't...

Thank you very much for your comments, they are very helpful. One little point is that in a data warehousing situation you honestly believe that we're going to add referential...

Ed Wagner (6/17/2016)

Hugo Kornelis (6/17/2016)

crookj (6/17/2016)

Ed Wagner (6/17/2016)

ThomasRushton (6/17/2016)

Ed Wagner (6/16/2016)

Luis Cazares (6/16/2016)

Ed Wagner (6/16/2016)

crookj (6/16/2016)

djj (6/16/2016)

Ed Wagner (6/16/2016)

ZZartin (6/16/2016)

Luis Cazares (6/16/2016)

Ed Wagner (6/16/2016)

Igor Micev (6/16/2016)

Revenant (6/16/2016)

Grumpy DBA (6/16/2016)

Ed Wagner...

Beef

Yes, you go back to the data source and figure out whether it's a % or $.

One possibility would be to grab the max identity value out of the target table on the linked server before running your insert. Then run the insert without the...

What kind of authentication is the developer planning to use for that application?

Don't you have to restart the SQL Service for the new max memory setting to take affect?

Do you have the target set up as a fixed width file?