Viewing 15 posts - 5,041 through 5,055 (of 49,571 total)
You need to create the login with the same SID on each server. The login-to-user mapping is on SID, not name.
Get the script sp_help_revlogin from Microsoft (a search will turn...
August 12, 2015 at 8:55 am
What's the command line you're using to start SQL, and what's in the rest of the error log?
August 12, 2015 at 8:47 am
WHERE StateCodeName = 'Open' AND
(SalesStageCode = 1/* DISCOVERY */
OR SalesStageCode = 121370000 /* PROPOSAL */
OR...
August 12, 2015 at 8:45 am
It's nothing to do with the logins themselves or their permissions.
SQL can't contact a domain controller to verify the login token it was passed. Speak with your network/domain admin.
August 12, 2015 at 7:56 am
Because it doesn't check prior to inserting the second record. It checks prior to starting the insert. The way an insert works (has to work) is that the rows to...
August 12, 2015 at 7:03 am
It is not. By default public has VIEW ANY DATABASE (which means they can see the names, not that they have access to them) and CONNECT on all endpoints. That's...
August 12, 2015 at 6:07 am
Because people who don't know what they're doing write blog posts/articles showing what little they know (eg login forms with plain text passwords and SQL injection vulnerabilities) and they get...
August 12, 2015 at 3:00 am
In general you want to run CheckDB with the NO_INFOMSGS option. That removes all of the 'x rows in y pages in table z' messages, meaning the errors are very...
August 12, 2015 at 2:55 am
chuck.forbes (8/11/2015)
Does that sound like it's an unreasonably low amount of RAM, assuming for now that this is the only database that will live on this server?
Very hard to...
August 12, 2015 at 2:52 am
It's probably parameter sniffing. Google that term if you want to learn more on your own, if you want help fixing the problem please post the stored procedure here, along...
August 12, 2015 at 2:49 am
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
SQLRNNR (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
August 11, 2015 at 2:17 pm
My preference is one per VM. The resource and security separation you get from two instances on the same VM is limited. You can get much better separation by putting...
August 11, 2015 at 11:30 am
SQLRNNR (8/11/2015)
GilaMonster (8/11/2015)
SQLRNNR (8/11/2015)
GilaMonster (8/11/2015)
And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.Is it this?
Yup.
Other than possible 24...
August 11, 2015 at 10:55 am
SQLRNNR (8/11/2015)
GilaMonster (8/11/2015)
And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.Is it this?
Yup.
Other than possible 24 Hours of...
August 11, 2015 at 10:39 am
Viewing 15 posts - 5,041 through 5,055 (of 49,571 total)