-- display orphaned users

EXEC sp_change_users_login 'Report'

-- drop a user

sp_droplogin webuser1

--- fix a user

EXEC sp_change_users_login 'Auto_Fix', 'webuser1'

if i re-read what you asked for right, here is one possible solution:

SELECT a.Name, b.ActualName [Name_Actual], b.NameID [Name_ID],

a.name2, c.ActualName [Name2_Actual], c.NameID [Name2_ID]

FROM TableA a

LEFT JOIN...

are nameid and actualname ints too?

and anything is possible... but need more info to give you a solution...

is their a common column, like do is theredo name and nameid match?...

you could do it within the dts package using t-sql and doing a bulk load

you can get a dir listing and load the appropriate file right in

i wondered the same thing, whats the application for this...

what happens in sql2k5 when you add 4 rows and deleted the second one. are the last 2 reordered so i...

i agree, temp tables are not the enemy (cursors are!)

referencing the temp table should be the simplest option here. i have dealt with some pretty hairy SP's and always been...

it would be more secure within the vpn

using a remote server through a website is fine to, just creates an extra layer to manage and keep secure.

We use a website...

but that only works where you have an identity column, or some type of numeric id...

you could addapt something like this for other cases:

SELECT *

FROM

Employee...

try this...

select * from employee where employeeid % 2 = 0

select * from employee where employeeid % 2 0

do they have a vpn? do they have any way to connect to their network when their off site?

if so, once their connected it should work fine...

you may need to...

i have vb.net 2003 that reads files in, checks for proper syntax, drops old object, and loads new object.

our app reads a directory tree, displays them in a grid, and...

what is the data type of the column?

a timestamp column could be used

what exactly are you trying to do? read in a template to generate a SP to then load into the SQL Server?

we read files and load them onto our server...

why not use the bulk insert within tsql to perform this, then it wouldnt matter if there were 4 or 5 columns as long as the table you read into...

you can load data this way and then test to figure out the format and then load it into the final table

or, name the files to include some kind of...