Viewing 15 posts - 46 through 60 (of 282 total)
As i said in my first post i am able to open and create/write/delete files in \\mynetwork\yuvipoy\ path.
Unable only when i used sp_trace_create function.
March 13, 2015 at 7:59 am
It is in domain account.
I am logging as dbo.
What grant permission is needed here and where it is needs to be given ,to which service ??
GilaMonster (3/13/2015)
March 13, 2015 at 7:39 am
Hi Gailshaw,
This is the Dev server it is kept at the customer place i am trying to access only for few hour.
GilaMonster (3/13/2015)
March 13, 2015 at 7:23 am
During the execution time no other process is running.
Only the application with this statement is running.
i checked more than 50 times each time i see there is less time in...
July 23, 2014 at 4:07 am
As i said it is from application, it is not possible to run this query for every execution.
but my question is if it is cache then second query time should...
July 23, 2014 at 3:28 am
which option to go with
a)Reindex DB after huge delete or insert happened
b)Reindex DB and shrink some one month gape
c)Shrink and Reindex DB some 10 month gape
or better way...
June 24, 2014 at 6:22 am
tt-615680 (6/24/2014)
I wanted to create a job in SQL which would automatically shrink a Transactional log file or files when the transactional log backup gets to a particular size...
June 24, 2014 at 4:28 am
Stand alone is once the database is created and configured it is no longer in sight of developer.
Say it is been shipped to customer.
Database is in simple recovery model.
the database...
June 9, 2014 at 5:50 am
Lynn Pettis (5/23/2014)
The trace may have stopped but you still need to close it in order for it to release your trace file.
How to close the trace in order to...
May 26, 2014 at 7:16 am
Lynn Pettis (5/23/2014)
The trace may have stopped but you still need to close it in order for it to release your trace file.
Atcually i restarted my pc and also moved...
May 24, 2014 at 7:05 am
actually beyond 98 mb the trace stopped.
i mark the trace for 10 hour , it ran only for 7 hours which reached 98 mb after that there is no...
May 23, 2014 at 8:50 am
I switched on the trace of 10 hour since the hits are going to small in the database.After 98 MB it automatically stopped i dont know why?
It has passed 10...
May 23, 2014 at 3:09 am
I am using express edition so there is no profiler to load the trace file 🙁
May 23, 2014 at 2:41 am
on newsequentialid() below is the table fragmentation level
- Scan Density [Best Count:Actual Count].......: 92.33% [17644:19110]
- Logical Scan Fragmentation ..................: 38.06%
- Extent Scan Fragmentation ...................: 7.83%
is this ok?
this one was with...
May 22, 2014 at 4:59 am
If i ran this query after deleting records i am able to see the transaction information
DBCC PAGE (RH_USER700, 1, 274, 3) WITH TABLERESULTS
checked after 4 hour still the same.
what does...
May 22, 2014 at 4:26 am
Viewing 15 posts - 46 through 60 (of 282 total)