Viewing 15 posts - 5,041 through 5,055 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2015 at 8:47 am
WHERE StateCodeName = 'Open' AND
(SalesStageCode = 1/* DISCOVERY */
OR SalesStageCode = 121370000 /* PROPOSAL */
OR...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2015 at 6:07 am
VIEW SERVER STATE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2015 at 4:27 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 11, 2015 at 10:39 am
Viewing 15 posts - 5,041 through 5,055 (of 49,552 total)