Viewing 15 posts - 61 through 75 (of 112 total)
Allocation contention on PFS,GAM,SGAM pages of the tempdb data file should be monitored during the pick load time. just in case of any contention on those pages additional tempdb...
August 8, 2012 at 5:10 pm
the signal wait indicates the time the thread has been waiting just for CPU but the wait_time_ms is the time the process has been waiting for CPU PLUS...
August 8, 2012 at 2:13 pm
you should specify the fill-factor for an index based on the number of inserts,updates on the index key(s) and the size of the index key(s) the more inserts on...
August 8, 2012 at 1:31 pm
it is set by default.the server role is set to sysadmin so it should have full permission on every database
it's realy confusing me:crazy:
August 3, 2012 at 3:07 pm
General Tab:Nothing specific just the windows group name for the windows authentication
Server Role Tab:No other setting for the login but set the sysadmin server role
User Mapping:nothing set
Securables : nothing set
August 3, 2012 at 2:07 pm
all I'm saying is with using SSMS at the moment.
the error state logged in the error log is 40
in this blog :http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
it says that "Other error states...
August 3, 2012 at 12:50 pm
Tanx David but
the user Z is not a member of any other group .the interesting thing is that the error thrown to the user differs from the error loggeg in...
August 3, 2012 at 12:34 pm
ya I restarted the SQL Sever service . It's so confusing for me because even with creating a new win group login and adding the user Z to that group...
August 3, 2012 at 12:05 pm
No interestingly it is not logged!! bu when i drop the login for user Z and keep the login for the group the error
is changed:
Login failed for user 'MyDomain\Z'....
August 3, 2012 at 12:03 pm
I had done it at the first place the default database is already set to master even when I set the default database to any other database again the users...
August 3, 2012 at 11:47 am
Error 4064 'cannot open user default database' I ran checkdb on master , every thinh seems to be working properly over there
August 3, 2012 at 11:20 am
I created the login with sysadmin server role. With the last sentences I mean for example when I add a login for win user mydomain\z the z user can connect...
August 3, 2012 at 9:54 am
I tried that but it didn't work. Even created a new windows group and created a new login in sql for that same problem!!
August 3, 2012 at 9:46 am
There was a database named X . This was the default database for a login named Y . This login was a windows group login. User Z is a windows...
August 3, 2012 at 12:54 am
Viewing 15 posts - 61 through 75 (of 112 total)