Viewing 15 posts - 12,886 through 12,900 (of 22,214 total)
If you really want to lock down access, you could set the transaction level for the connections to serializable. That will block pretty much everything until a given transaction completes....
March 30, 2011 at 5:55 am
Welcome!
Remember, keep your hands and feet inside the vehicle at all times.
I think Jason's list over on Amazon covers most of the basics. The one thing I would add is...
March 30, 2011 at 5:51 am
Mikey01 (3/30/2011)
No 2 versions of the...
March 30, 2011 at 5:42 am
bitbucket-25253 (3/29/2011)
SOLVED A BEASTLY PROBLEM THAT WAS PLAGUING YOUR SERVERS FOR...
March 30, 2011 at 5:38 am
Hey guys,
I need a little help with remote access and encryption over here. I don't know squat.
March 30, 2011 at 5:37 am
DBANewbie (3/30/2011)
Thanks for your replies so far, i keen to learn as much as i...
March 30, 2011 at 5:36 am
It depends on the object. For example a heap table can have four, DatabaseID:FileID;PageID:Slot (or row). So, what kind of object are you looking at?
March 29, 2011 at 1:56 pm
Yes, they can run side-by-side. On my old desktop I had 2000, 2005, 2008 and 2008 R2 all running at once.
But, on a real server, with real users, they...
March 29, 2011 at 12:34 pm
Here's information on manipulating your connection string.
March 29, 2011 at 12:18 pm
awan-413156 (3/29/2011)
Set-up I: two SQL engines set up as cluster and all accessing DB files on a separate SAN drive. One SQL engines dies the other...
March 29, 2011 at 10:55 am
You can get that information, if you have both individual logins and your connection strings include the app that is connecting. If you're using a service login for the applications,...
March 29, 2011 at 10:41 am
DBANewbie (3/29/2011)
Out of interest; would you see it as a significant increase in risk to allow connections via enterprise manager considering that we already allow access via RDP?
You must have...
March 29, 2011 at 10:39 am
Yeah, it can work. But you have to use SQL logins as well as expose the server through the firewall. From a security standpoint, I don't like it. But is...
March 29, 2011 at 9:54 am
You could try going with a slightly different approach. Set up the views under a different schema and then grant the user SELECT access to that schema.
March 29, 2011 at 9:43 am
Have you look at locks and wait states to understand why it's doing this? You should be able to at least narrow down the problem.
App code or not (and I...
March 29, 2011 at 7:55 am
Viewing 15 posts - 12,886 through 12,900 (of 22,214 total)