Viewing 15 posts - 2,716 through 2,730 (of 6,216 total)
I'd say your options are to put OS on two that are mirrored and use the other four for RAID5, or just put the whole thing on RAID5. Of the...
January 9, 2003 at 6:33 am
January 8, 2003 at 6:05 pm
EM probably pulling back a lot more info. You might try adjusting the timeout. Probably also want to profile just to make sure it is getting the connection to the...
January 8, 2003 at 6:04 pm
I like to use two books per exam, one Exam Cram if available, another by a different company. Our own Steve Jones co-authored one by Sybex, probably worth a look....
January 8, 2003 at 6:02 pm
Thats pretty interesting! We get some great questions on here, makes you realize how much there is to learn. Anyway, I can duplicate that behavior with the text box. I...
January 8, 2003 at 5:58 pm
It varies based on load for publications, have not seen any limits. The default settings for replication via the sql agent do have some limits for concurrent processes, can be...
January 8, 2003 at 12:11 pm
January 8, 2003 at 12:11 pm
Havent seen that. I use push almost exclusively these days. You're connecting as sysadmin?
Andy
January 8, 2003 at 11:21 am
January 8, 2003 at 11:20 am
You have to have a primary key, not an identity col. You can use a natural key, identity of course, a uniqueidentifier along with newid().
Andy
January 7, 2003 at 3:34 pm
The sids do get out of sync, but add/drop is more work than you need to do. Take a look at sp_change_users_login code to see, it just fixes the sid.
Andy
January 7, 2003 at 3:32 pm
NT logins will work, SQL logins may or may not - depends on whether the ID in sysxusers is the same on both servers. Quick fix is to run sp_change_users_login...
January 7, 2003 at 1:11 pm
I've got one of these and I realllllly hate it. Well, almost like it - we filter out pkeys beginning with certain chars, those chars are reserved for keys we...
January 7, 2003 at 9:20 am
You can limit their access to syscomments which will contain the text of the proc. The proc encryption is very breakable, only helps to deter casual looking - and as...
January 7, 2003 at 8:32 am
Thats new to me! I always code the params collection, never use refresh - you save a round trip and that is always worth doing.
Andy
January 7, 2003 at 5:05 am
Viewing 15 posts - 2,716 through 2,730 (of 6,216 total)