Sorry we didnt get back to you in time. If you're connecting to a server via Query Analyzer to do the restore, it's pretty much like you're standing in front...

If you're familiar with DMO you can manage logins (and a lot of other stuff) that way - the object model pretty much maps to Enterprise Manager. If you just...

Does sound like prepared procs. Mostly went away with SQL 7. Been awhile, but I think the box in the dsn dialog is grayed out. Might take a look at...

I havent seen anything quite like that, but how about this:

1) Script the tables you want to copy into a new db.

2) Use the designer to build your package.

3) Edit...

I suspect this is a DCOMCFNG problem. I've run into a couple similar (but not DTS) situations recently that have me scatching my head. Been doing some reading, but haven't...

Unless you're short on disk space, I wouldnt sweat the size. Definitely keep auto grow on. We had a recent thread along similar lines:

http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=499&FORUM_ID=5&CAT_ID=1&Topic_Title=Recommended+TempDB+Size&Forum_Title=Administration

Andy

I would guess that you've got a value that SQL can't translate to a date. Try making a separate col that is a datetime, then update it with the contents...

How about this one:

select convert(varchar(20), getdate(), 112)

returns 20010705

Andy

Duplicating ALL the functionality of EM might take some time! Doesnt BMC sell a web based admin product? I use PCAnywhere from home to office workstation, if needed I can...

Take a look at the convert statement. Using a style of 121 will give you yyyy-dd-dd, just replace out the dashes and you're there.

Andy

A quick workaround be to grant the user select permissions on sysjobs in msdb, count using a select with ADO.

Andy

Jay, I dont know, but we'll try to get someone looking! Give us a day or two. Are you using SQL 7 or 2k? If you're in a hurry, you...

I will have to look at the fixlist - kinda big to remember it all! I haven't had much problem with email.

Andy

The SQL2K resource kit has chapters on converting from Access, Sybase, and Oracle to SQL. I wouldnt say that writing such a tool couldnt be done, but porting apps is...

What about if you try to send using xp_sendmail, does that work?