Viewing 15 posts - 6,196 through 6,210 (of 6,210 total)
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...
July 9, 2001 at 7:53 pm
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...
July 9, 2001 at 7:50 pm
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...
July 9, 2001 at 7:44 pm
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.
July 9, 2001 at 7:41 pm
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...
July 9, 2001 at 7:39 pm
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:
July 6, 2001 at 10:24 am
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...
July 6, 2001 at 7:14 am
How about this one:
select convert(varchar(20), getdate(), 112)
July 5, 2001 at 4:07 pm
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...
July 5, 2001 at 4:03 pm
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.
July 5, 2001 at 8:42 am
A quick workaround be to grant the user select permissions on sysjobs in msdb, count using a select with ADO.
July 5, 2001 at 8:32 am
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...
July 3, 2001 at 6:22 pm
I will have to look at the fixlist - kinda big to remember it all! I haven't had much problem with email.
July 3, 2001 at 6:07 pm
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...
July 3, 2001 at 1:58 pm
What about if you try to send using xp_sendmail, does that work?
July 3, 2001 at 1:54 pm