Viewing 15 posts - 36,976 through 36,990 (of 39,461 total)
You do or do not want to trim spaces?
ltrim() - trims left
rtrim() - trims right.
Steve Jones
August 5, 2002 at 3:38 pm
nah, it's a horrible idea using sa for connections.
change the pwds, pick up your phone and chastise the users. Make them change the account.
Steve Jones
August 5, 2002 at 3:36 pm
I would expect some improvement, but I'm not sure how significant that will be.
It's not likely that you will have any issues, so it won't hurt.
Steve Jones
August 5, 2002 at 1:42 pm
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
Viewing 15 posts - 36,976 through 36,990 (of 39,461 total)