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...

FYI i stopped and started my server to test this theory, and sure enough, any open databases had mdf/ldf's with a timestamp of when the server shutdown; some mdf's for...

I believe it is  because the files are open and being used, and are only closed when the server is stopped.

when the server stops it closes the files and the...

you could also solve this at the mailserver level...where a group called DBANotifications is created, and dba's are added to that group...then have the scheduled job send to the group...