Viewing 15 posts - 37,426 through 37,440 (of 39,511 total)
If DBCC does not work, check the script library. there is a script I posted that will help you. This has to do with virtual log files within your one...
June 14, 2002 at 3:22 pm
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
Viewing 15 posts - 37,426 through 37,440 (of 39,511 total)