sadly not, although table valued functions are fine in 2000

and doesn't this catch so many people out !!

just as an observation I'd look at the subscriber and the network connections, I would imagine latency would not be part of the replication process as such. ( I'm assuming...

actually I'd advise applying the 2187 post sp4 rollup too, I'm told there were some problems with sp4 that are fixed in the rollup ( which also includes the awe...

if your EM is on a client install  make sure you've applied the latest sp. I often find everyone patches servers but don't patch client tool installs only - this...

seems the new fix broke something else !! Personally I never use maint plans , I roll my own, now I know this was a good decision all those years...

Sorry Todd, it's just this gets posted so much I'm surprised a search didn't pull something up. I have to agree that finding the correct question is always difficult, what...

I'm not totally sure what you're asking ( never used Perl ) but you might want to check out sp_executesql in BOL.

stock answer - check the logs. Did you have dts package logging turned on ?

I'll echo Al, if you're moving databases about it's always a good move to run through at least a statistics update and a dbcc updateusage. I'll sometimes rebuild all indexes...

Hmmm .. that's a shame I just used the eval to prove deferred updates and I was impressed with the product. Mind you I was only wanting to examine the...

I've never found the names show, capture the object id and then join back to get the name, or use object_name(id) if only one database

never done this, I either use mapi or smtp mail ( talking sql 2000 here - 2005 is different )  xp_sendmail only works with mapi as far as I know,...

There are just so many posts on this for as long as I can rmember. Please read up BOL for admin of sql server or at least buy a good...

you should normally connect using integrated security which does require any user account details. You should be able to connect using sa. on a workgroup you add a user to...