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 @user-id=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...

Basically, the excel file needs to have a column header for every column fromt he query: davids example had 3 columns:

so this command worked perfectly:

INSERT INTO

OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Book1.xls',...

Wayne the lack of information is exactly why all data should be in a single database; In my opinion, related items go in the same database, period. I would rather...

the grid view of Query Analyzer returns results in tab delimited format; you can cop and past results directly into excel from that;

search SSC for excel and you'll see plenty...