sc queryex "servicename"

and check column STATUS

Did you read my post ?  

Just want to point out that there are extra Parenthesis here and should be removed :

--SELECT @CourseCount = COUNT(DISTINCT(Course_ID)  FROM @EventOpsList

--SELECT @CourseCount =...

This is the right syntax:

update t set uid =  s.password

 from tbl_sample_conf_samp_test t join pwtable_test s

 on s.orcsampleid = t.orcsampleid

I knew it!  

Melanie,

You have duplicate IDs on your tables. You either get rid of the duplicates or find a way to uniquely Identify the passwords!

Just check  orcsampleid on BOTH...

The limit is in FILE SIZE not in number of records!!

It can not handle a DB File bigger than 2GB! (you can alwas have more DB files though

This kind of problems tend to be found at MSDE level not at Standard/Enterprise Level. Anyway you shouldn't be doing this on a "normal" sql server often

Is this on MSDE ?

Well dts DOES supports .bas files just double click on EM the package and select PACKAGE SAVE AS and on Location select Visual basic file!

How about:

INSERT INTO snbat011_app_clnt

     (entr_cd,

      app_id,

      clnt_id,

      clnt_type,

      clnt_frst_name,

      clnt_mid_name,

      clnt_lst_name,

      clnt_gender)

SELECT

  @EntrCode, @AppId, @ClientId, @FirstName, @MidName, @LastName

 , CASE WHEN @FormType =...

the index in the computed column is a way of materialize the data and not calculate it on the fly. IT will definetly speed things up even if it is...

yes diagrams in Enterprise Manager (not Mangler)

PDF writer : Price: $19.95

Erwin: Price: $3,995.00

ER Studio: could...

Correct!

If if using Windows authentication the linked server would have to be set up after you have Account delegation in place which implies a bunch of other things and on...