am i wrong, or is this just a simple file does not exist error?

i realize you probably changed some values for the example, but is there really a \\server1?

in...

i bet he wants the column in a specific location for this reason:

in our shop, business rules state the PK columns are always the first columns of the table;

if the...

this might help you out:

replace NTDomain** with your real domain name, otherwise domain users will not be fixed, only SQL login users.

the sid for sa /dbo on all machines everywhere...

paste the exact error you are getting; there's way to many possibilities to diagnose it at this point;

there's a huge difference between connecting directly from a laptop to your SQL...

i'd have to agree with you, with the exception of referencing PK's:

select * from sysobjects where xtype <> type

XTYPE of 'PK' <> TYPE of 'K' was the only difference i...

this will create the delete/truncate statements to be used  in Foreign key hierarchy order, so it never fails: note that it screws with every table, so any lookup tables or...

oops i hadn't thought of that aspect;

i'll look at it again; in your case, is the RTF stored in a TEXT or an IMAGE field?

OK I've created a complete solution for this:

I created a vb6 executable which takes command line paramters for RTF_File_In and TXT_File_Out.

it takes the RTF file contents and sends the plain...

The Public role that every login has read rights to all tables in master; you cannot remove the public role from master either,as i remember.

brian kelly cited some specific resources...

you'll either need to use dynamic SQL, which should generally be avoided, or use a if-then-else statement like so:

dynamic SQL:

@sql='SELECT * FROM TABLENAME ORDER BY ' + @sort

EXECUTE(@SQL)

Logical parameters.

create procedure...

my file format is as follows with the syntax i used previously; my username and password are on the same line. not much of a difference; googling for "ftp -n...

i would use a different logic and return the userid regardless of whether it existed previously or not:

--assuming proc has the @UserId parameter

select @UserID=username from Employees where username = @username

if...

i don't know if this will help you, but this is how I scripted out the ftp object from vb6:  i notice i'm using two other parameters: "ftp -n -v...

Remi,

by object to object dependencies, do you mean  for example if i had a view or stored proc that was dependant on another view? I would think you would be right...you'd...

if you alter a view to make it use it's same definition, wouldn't sysdepends get updated with the correcct dependancies?

i would think that simply altering all views would 'refresh' the...