Viewing 15 posts - 1 through 15 (of 37 total)
yes it is
May 14, 2021 at 3:30 pm
yes its windows login
May 14, 2021 at 3:11 pm
no.. the data file and log files are stored on separate drives. 170 GB from sp_helpdb (db name) query and 160 approx from the mdf location right click properties)
May 6, 2021 at 4:32 pm
when I use sp_helpdb I get file size of 170GB. but when I go to the location where the mdf is placed it shows 160 GB
May 6, 2021 at 3:54 pm
did you try proceeding with the default name and later change it to service account
March 30, 2021 at 8:26 am
thank you everyone for your help its completed.
June 26, 2020 at 5:19 pm
Thank you everyone for your help. Here is what I'm looking for :
1. How do I take backup
2. How to patch frequently as per the patch releases (monthly/...
May 9, 2018 at 6:10 am
what kind of permissions should i give him
June 2, 2017 at 9:45 pm
the person who can see all process is the DBA, while the other person who can only see his process logs in using SQL Authentication with dbo permissions
June 1, 2017 at 10:02 pm
Thank you for your reply, let me explain further...
When i run sp_who2 active I see all process, but when the other person runs sp_who2 active he gets to see...
June 1, 2017 at 8:52 pm
im not getting any errors
May 5, 2017 at 5:00 am
Hi Thom
Thank you for your prompt reply... but there is time lag between the two restarts
April 22, 2017 at 9:37 am
thank you all for your help on resolving this
April 22, 2017 at 9:14 am
Viewing 15 posts - 1 through 15 (of 37 total)