Viewing 15 posts - 36,481 through 36,495 (of 39,903 total)
May 9, 2003 at 10:02 am
You can schedule the script or program using SQL Agent. Set the job step up as an Operting System command.
Alternatively, you can run a task using the AT command or...
May 9, 2003 at 10:01 am
We do this all the time for EOL servers and use the method that Allen mentioned. We perform the following:
1. Run full backup from source machine, restore on new machine....
May 9, 2003 at 10:00 am
Glad it helped.
BTW, an update: I spoke with someone on the internet who has done more testing and my inference that xp_msver was being called for @@Version is incorrect. There...
May 8, 2003 at 3:24 pm
May 8, 2003 at 3:21 pm
1. no
2. you can "fake" this by storing them in a table and using @@spid to track them to a user.
Steve Jones
May 8, 2003 at 3:17 pm
Not sure why'd you'd want program files. Easily installed on any servers. The important data is in the data backups.
Steve Jones
May 7, 2003 at 4:53 pm
EM looks through the table and scripts out all object changes that need to be done.
and you're welcome.
Steve Jones
May 7, 2003 at 4:11 pm
Sorry to hear that Chris, hate days like that.
I can't believe MS left you hanging. I've had a few calls that ran over 24 hours and I was transferred from...
May 7, 2003 at 9:34 am
It can be through a script, but you need to know what you want. Which tables/views/procs need which rights, select, insert, update, delete, execute?
Also, I'd use Roles for this, not...
May 7, 2003 at 9:32 am
In Enterprise Manager, Expand the Management folder, then right click SQL Agent and select start. Should start. If not, post back with the error (check SQL log and Event logs)
Steve...
May 7, 2003 at 9:24 am
sp_rename [ @objname = ] 'object_name' ,
[ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]
Steve Jones
May 6, 2003 at 10:38 am
I do not think so. You can export the logins and detach the databases, uninstall and the attach the databases.
Steve Jones
May 6, 2003 at 10:08 am
Haven't seen this one. Is this with NT Auth or SQL Auth?
Steve Jones
May 5, 2003 at 5:04 pm
Viewing 15 posts - 36,481 through 36,495 (of 39,903 total)