network profile
| bio | website | movingsql.com |
|---|---|---|
| location | New Jersey | |
| age | 55 | |
| visits | member for | 1 year, 1 month |
| seen | May 13 at 16:43 | |
| stats | profile views | 56 |
coder & programmer of many defunct languages...
|
Apr 24 |
answered | Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001 |
|
Apr 24 |
comment |
Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001 What version of SQL Server? |
|
Apr 23 |
comment |
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Show us the OPENROWSET code. |
|
Apr 17 |
revised |
Executing Child packages without using master package edited tags |
|
Apr 17 |
comment |
How does SQL Server generate a query execution plan that adds up to 6,000%? @RichardTheKiwi That's basically all the ShowPlan visualizer is doing anyway, it just gets it wrong sometimes. |
|
Apr 17 |
comment |
How does SQL Server generate a query execution plan that adds up to 6,000%? I'm gonna say "Bug"? |
|
Apr 17 |
comment |
How to optimize a query that's running slow on Nested Loops (Inner Join) We'll need to see the rest of the query plan. |
|
Apr 17 |
awarded | Yearling |
|
Apr 11 |
comment |
Individual queries run on 10ms, with UNION ALL they are taking 290ms+ (7.7M records MySQL DB). How to optimise? How are you measuring the run-time of your queries? |
|
Mar 6 |
comment |
SQL Server 2005 upgrade service pack via command line OK, I figured out how to request a Moderator to move it... |
|
Mar 6 |
comment |
SQL Server 2005 upgrade service pack via command line Yes, but I cannot do it myself, and I don't know how to request it. I can vote to close it with a recommendation to migrate it to there, or you could re-post it. |
|
Jan 28 |
comment |
Primary filegroup is full SQL Server 2008 What are the expansion settings for the files in this database? Please be explicit. |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Describe "they cannot read from the database" explicitly please. What exactly happens? |
|
Jan 3 |
answered | SQL Server drop and create all users in every DB |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Either in your Domains, Windows Groups, or the SQL Server-principals that are controlling server access. This is also what you're leaving out of your descriptions. |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Its this statement: "I have 500 user's that, through there dsn, should be able to access a database, if the are assigned read/write to the DBNAME->Security->User list." that we need spelled out: 1) show us the DSN, 2) what do you mean by "assigned read/write"? |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB OK, that whole business needs to spelled out for us, because it's not clear what's going on. Edit you original post to add this information: specifically, what are the Windows, Server and Database level principals, roles and/or groups that should be granting the user's access to the database. Use a single User/Login as an example, but be explicit about all of the pieces (because I strongly suspect that that is where the problem is). |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB OK, chat's out, we'll do this here... Do these users have windows logins that are registered on the SQL Server as "Logins" (i.e., server level principals)? |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB It's easy enough to automate auto_fix, I just didn't think that it works on Window logins? |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB @Damien_The_Unbeliever: I don't think that you can use sp_change_users_login works on Windows accounts, does it? |
