Viewing 15 posts - 37,636 through 37,650 (of 39,720 total)
You'll find some threads here, but I'd backup to disk and then to tape. Use NT permissions (on NTFS drives) to manage the security and lock it down based on...
June 14, 2002 at 12:41 pm
June 14, 2002 at 12:39 pm
June 14, 2002 at 12:34 pm
I wrote a loop that looked for duplcates (using COUNT and HAVING COUNT(*) > 1) by name or other criteria. Then issue a SET ROWCOUNT 1 and a DELETE for...
June 14, 2002 at 12:31 pm
Not surprising. They ran lots of internal stuff(payroll, accounting, etc.) on an AS/400 for a long time. Supposed to be converting to 2000 with Great Plains.
I suspect there are still...
June 14, 2002 at 12:29 pm
No, started building one, but it was a pain. Not sold on Extended properties yet, maybe in Yukon.
Steve Jones
June 14, 2002 at 12:27 pm
I use the same account for server and Agent. Cuts down on errors related to security and config. However, I use different accounts on each server/instance. Named to conform to...
June 14, 2002 at 12:24 pm
I use Andy's solution to "loosely couple" steps together from different jobs. Allows them to be linked, but not at a success or failure level.
Steve Jones
June 14, 2002 at 12:22 pm
Haven't used it. Tested, but haven't found a good reason to do it. It's mainly for desktop installs (why it was developed). I tend to try to build things that...
June 14, 2002 at 12:20 pm
Yes, when the SELECT is finished, the shared lock should drop.
IS this not happening? Can you provide more details about what is happening?
Steve Jones
June 14, 2002 at 12:18 pm
Don't have the setup, but there should be no issue as long as your PC has the horsepower. I run (and have run) both 7 and 2000 personal editions and...
June 14, 2002 at 12:17 pm
When you SELECT (without a hint), as Antares mentioned, a shared lock is placed on the data. The lock could be row, page, or table (or others), but basically prvents...
June 14, 2002 at 12:10 pm
Logins are stored in master with a SID. Users are stored in teh db and map back to a login. If you restore the db, the logins are not created...
June 13, 2002 at 4:21 pm
The order is:
1. write the changes to the log
2. Write the changes to the data
if the server shuts down between 1 and 2, then
a. commited transactions (as marked in the...
June 13, 2002 at 4:18 pm
I tend to use drop/create so I can track when a procedure is changed. I do include the security statements in the drop/create script.
If you use alter, you will not...
June 13, 2002 at 4:17 pm
Viewing 15 posts - 37,636 through 37,650 (of 39,720 total)