Viewing 15 posts - 37,231 through 37,245 (of 39,720 total)
August 6, 2002 at 8:15 am
I suspect you mean script the database.
From EM, right click the database, select Generate SQL Script.
You probably want to script the db and all objects, including indexes and roles (you...
August 6, 2002 at 8:14 am
Tend to agree with Andy, though I might make 2 RAID 1s, one for logs, one for OS, SQL system, backups, tempdb. RAID 4 for the other 4 for data.
Steve...
August 5, 2002 at 3:45 pm
Fox runs on DBase format files.
can it be better in a query? Yes. definitely not more scalable or robust.
FYI, a text file might be better in some cases, not not...
August 5, 2002 at 3:39 pm
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
Viewing 15 posts - 37,231 through 37,245 (of 39,720 total)