Viewing 15 posts - 91 through 105 (of 338 total)
Thanks for the feedback mate
No index in table at all ( I click on index folder and nothing comes out )
Actually this is deadlock case as there are multiple...
August 23, 2016 at 7:47 pm
Thank you for the reply mate 🙂
No PK in this table . Why do you ask this question ?
August 22, 2016 at 9:40 pm
Thanks!!!
cheers mate
August 14, 2016 at 7:46 pm
Thanks guys for the response . Appreciate it
Apparently Service Pack 3 is the latest SP in SQL server 2008 if my understanding is correct !
Now I am thinking either...
August 11, 2016 at 10:00 pm
FYI .. temp db has different collation with database collation
August 4, 2016 at 5:33 am
Thx for the reply ! Really appreciate it .
Temp db has the same collation like server collation which is SQL_Latin××××××
I dont see any error log in sql tho...
I do check...
August 4, 2016 at 5:32 am
Thanks for the reply , yesterday I just created 1 user which is SQLMIRROR and when I created Mirroring I grant permission for that user ( as service account ).
So...
July 20, 2016 at 6:33 pm
Btw I just notice something when I run a query to see the permission level
SELECT EP.name, SP.STATE,
CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id))
AS...
July 19, 2016 at 6:36 pm
Thanks for the reply ..
I created endpoint with state STARTED .. i did telnet with this command from server B :
TELNET SERVERA 5022
And also i did telnet from Server...
July 19, 2016 at 5:21 am
So it means it is like changing Recovery model from FULL to SIMPLE because it will break the log backup chain so we can’t do Point in time Recovery ?
June 22, 2016 at 9:52 pm
Viewing 15 posts - 91 through 105 (of 338 total)