Viewing 15 posts - 37,336 through 37,350 (of 39,818 total)
The scripts you use to recreate logins on other boxes. I'd script it rather than using EM.
If you don't have these, and you can get at the old master, you...
August 5, 2002 at 10:30 am
Sounds like it might be corrupt. Can you drop it? Create a different table?
Steve Jones
August 5, 2002 at 10:28 am
You increase the size of the device and then add another segment to the db.
Forget the syntax, but EM will do this for 6.5
Steve Jones
August 5, 2002 at 10:26 am
August 5, 2002 at 10:20 am
I'm sure Exchange can do this, but that would be some complicated scripting on the Exchange side. Try Admin911 (mitch Kupcheck) or Swynk and see if they've got something.
Steve Jones
August 5, 2002 at 10:17 am
Is SQL Server running under a domain account? That is what needs rights to access the backup drive.
Steve Jones
August 5, 2002 at 10:15 am
If you want logins you will, but I'm not sure that SQL 2000 will work there. If you're moving database, save your login scripts and then just restore/attach them back...
August 5, 2002 at 10:13 am
Not that I know of unless there is one in the script libary here. Try searching.
Steve Jones
August 5, 2002 at 10:11 am
Didn't get through the white paper, but did look at 3 of their sample apps. All look the same. Not sure there's anything great here.
Steve Jones
August 5, 2002 at 9:48 am
thanks for the comments. I know I needed a refresher (which got me writing).
Steve Jones
August 5, 2002 at 9:46 am
Haven't seen too many that work well. There was one called My Little SQL or something like that, but I didn't try it.
Here's one for MySQL:http://anse.de/mysqlfront/
Another for MySQL, Postgres, Oracle:
...
August 5, 2002 at 9:45 am
It must rollback a transaction, so it may have been stuck. I'd bet that it would have eventually killed the process, but I have seen things hang and a reboot...
August 5, 2002 at 9:40 am
There are extended stored procedures that link SQL Server to mail (the xp_startmail, xp_sendmail, etc.).
Some of these include the ability to read mail and you can process the items...
August 5, 2002 at 9:37 am
Try restoring with no log. I'm surprised it wants so much temp space, but it may be a check of x times the size as a just in case.
Steve Jones
August 5, 2002 at 9:35 am
sp_dropserver
sp_Addserver <new name>,local
will rename the server
Steve Jones
August 5, 2002 at 9:22 am
Viewing 15 posts - 37,336 through 37,350 (of 39,818 total)