Viewing 15 posts - 37,321 through 37,335 (of 39,818 total)
Yepper, this is the case. Can cause frame of reference issues (like local paths).
It's a design decision. I run many from the server, but it can be like a program....
August 6, 2002 at 12:31 pm
No easy way. I've seen some complicated SQL (using count() and subqueries), but nothing I'd recommend. Any reason not to do it on the client?
Steve Jones
August 6, 2002 at 12:29 pm
I have had issues with the install, but that was early on. I know there are some Q articles about workarounds, but we experienced corruption and strange unreproduceable errors. Following...
August 6, 2002 at 12:27 pm
I think it's a matter of design. functions are usually reused in your code somewhere and can be cleaner than calling a stored procedure (like in a select statement). Otherwise...
August 6, 2002 at 12:22 pm
Your packages are in MSDB, restore this, not master.
Steve Jones
August 6, 2002 at 12:16 pm
Not bashing Fox, in fact, I used Visual Fox (first version) to rewrite a Fox for DOS app into Windows with a SQL 65 backend. It worked great, though in...
August 6, 2002 at 8:31 am
There are great explanations in Inside SQL Server for SQL 2000. Some are in tempdb, some are populated as you retrieve rows. Depends.
For your cursor, it is accepting default options,...
August 6, 2002 at 8:27 am
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
Viewing 15 posts - 37,321 through 37,335 (of 39,818 total)