you don't fiddle with image/binary fields at the SQL server level usually; you do it an an application level, like with VB, VB.NET, Delphi, whatever.

Here's the code as an example...

AUTH is the command to send a username and password to the mail server in order to use the SMTP service; it's required, because otherwise the server is wide open...

if a backup of a database was created on SERVER A, and Restored on SERVER B, you would find that behavior...all users in the db are "orphaned";

i'd guess that if...

the ports are actually saved in the registry, and not in the database; that's because a service advertises the server instance where the databases reside, so the OS needs the...

since he posted to this forum, I kind of assumed he was talking about SQL 2000; I've got an instance of 2005 as well, but I haven't used it enought...

I'd venture a guess that one of the fields in the insert statement is receiving data that is longer than the field; for example if QuikJournal was defined as 200...

ISQLW accepts command line parameters. start>>Run isqlw /?  will give you the list; then simply create a shortcut like isqlw.exe -s[localhost] -dmaster -Usa -Ppassword

instead of comma delimited, can you use INSERT INTO TABLEXXX instead?

if you can,Narayana Vyas Kondreddi has an excellent procedure to do that that he has shared: http://vyaskn.tripod.com/code.htm#inserts

yes; my original post about sp_MSdependencies is the solution;

create table #Hierarchy (

objectType    int,

objectName    varchar(50),

objectOwner   varchar(50),

CreationOrder int,

IsSchemaBound int)

insert into #Hierarchy (objectType,objectName,objectOwner,CreationOrder)

EXEC sp_msdependencies @intrans = 1

select * from #Hierarchy

update #Hierarchy set...

might be a better way, i did it this way because of the decimal point:

declare  @SomeValue        money

Set @SomeValue=740002.64

select right( '0000000000000' +  CONVERT(varchar,convert(int,(@SomeValue * 100))),13) AS FinalAnswer

select right(REPLICATE('0', 13) +  CONVERT(varchar,convert(int,(@SomeValue...

does this work?

change the last statement at the end to the following:

set @myAreaCode ='SELECT top 5 @myAreaCode = @myAreaCode + ISNULL(AreaCode,'') + ',' from @stage'

set @myAreaCode ='''

SELECT...

the normal Caveats for this question: you should do this at the presentation layer, whether it is an app or a web page, because it's easier.

here's one way to do...

I was under the impression that you could exec any size command like this:

DECLARE @sql1 nvarchar(4000),

@sql2 nvarchar(4000),

@sql3 nvarchar(4000),

EXEC sp_executesql @sql1 + @sql2 + @sql3, N'@hDoc int, @p_blnTracking bit,...

hope what i posted was helpful.

assuming that one machine can run as many instances as you want, but only 5 users, this might get you started:

in my poor example below, you can see that the...