look at the metadata that is returned from eXEC sp_tables_ex MyAlienServer

it should return a list of items, and you could potentially drill down from there.

briancampbellmcad (6/13/2016)

---

I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names/:

SELECT 100.00, 54215 UNION ALL

SELECT 125.00, 53252 UNION ALL

SELECT 110.00, 63225...

because there is a one to many relationship between charges and payments, you cannot join the tables directly, i think you need to join the summerization of those tables instead....

twin.devel nailed it, and...

Sean Lange (6/10/2016)

---

yay! everyone gets a ribbon for interviewing!

post a new thread with details about what you are trying to do;

you'll get the...

Translate.google.com (Swedish detected)

---

About the company

RGP is an international consulting company that offers qualified consulting services in Finance & Accounting, Human Capital, Information Management and Supply

Chain. We help our customers to...

you need to have an explicit ORDER BY in your query. otherwise, it's coincidence or a crapshoot.

SQL server does not have a concept of order in a table.

SQL will...

i would guess your user is a sysadmin, by mistake or due to mutliple roles.

easy to check:

select IS_SRVROLEMEMBER('sysadmin','mydomain\lowell')

GilaMonster (6/8/2016)

---

Don't try to modify a system object (sys.server_triggers), just query the tables directly (and you don't need that conversion function, so omit the lines that use it). sysschobjs is...

import wizard is probably dropping and recreating the tables;

the existing table says NOT NULL,

but whatever the wizard creates allows nulls.

pretty easy to check, compare the table definitions.

saved to file? i am pretty sure you need a system...

TexasJohn (6/8/2016)

---

Nope. C,D & E only. So there are two things going on here. The catalog is wrong and the DSN file Schedule64 was saved to the...

mapped drives like the z: drive are per user.

if you run xp_fixeddrives, do you have a Z:\ drive?

Welsh Corgi (6/8/2016)

---

I am getting a Primary Key Violation when Loading a Table.

I queried the source table and there is only one record with value of the primary key.

This does...