Viewing 15 posts - 38,476 through 38,490 (of 39,720 total)
Haven't run into it, but no one is around when I run DBCCs. Haven't run dbcc dbrepair in a long time. I spoke with the developer from MS for DBCC...
January 25, 2002 at 1:09 pm
BTW, I don't really use App roles. Do you have a good reason for not just creating a role and assigning users to it?
Steve Jones
January 25, 2002 at 11:13 am
I think your app roles will need to cross databases and be setup for each databare. Not sure if you can have one app role that maps to others in...
January 25, 2002 at 11:10 am
The clusteered index is the key. Now in SQL 2000, the storage changed slightly for performance, but whether you search the clustered key (essentially data) or search the data, there...
January 25, 2002 at 10:11 am
Most people I know think my job is boring. Maybe bacause I am cautious and move slow. Anything I do wrong usually has more far reaching effects than something a...
January 25, 2002 at 10:08 am
Mind updating us? It's nice to have a followup so others who search these forums can see the resolution.
Steve Jones
January 25, 2002 at 10:02 am
There shouldn't really be much overhead. There will be security checks, but I prefer a second database for two reasons. Performance and Backups/Restore.
If you have a failure in the db...
January 25, 2002 at 10:00 am
I'd pipe the output of the execute results task to a file and search it. This is probably the best technique, though your search routine may be cumbersome.
I did a...
January 25, 2002 at 9:51 am
Yikes, I hate triggers. If you must, Brian's suggestion is easier, but ift may come back to haunt you if the requirements change.
Steve Jones
January 25, 2002 at 9:42 am
January 24, 2002 at 5:25 pm
January 24, 2002 at 3:53 pm
Identities are not good or bad in and of themselves. they do solve problems and in my experience, they can ease loads because I get data that does not have...
January 24, 2002 at 3:52 pm
user_name will be unique IF your users do not share passwords or machines. host_name has nothing to do with it. I can hard code "awarren" in the host_name parameter for...
January 24, 2002 at 3:50 pm
You can set a FK between them, but you would need to set a unique index on both tables to ensure that it is not a 1:many.
Steve Jones
January 24, 2002 at 3:48 pm
January 24, 2002 at 12:32 pm
Viewing 15 posts - 38,476 through 38,490 (of 39,720 total)