Viewing 15 posts - 76 through 90 (of 180 total)
nanonerd - Tuesday, January 30, 2018 1:23 PM...meaning that the DB is not accessible while it cleans itself up?
No. But it...
January 30, 2018 at 7:59 pm
SQL Server will rollback the transaction as it always does.
January 30, 2018 at 12:42 pm
If you have many reports to be generated for a mixed group of users,...
January 29, 2018 at 3:06 pm
January 29, 2018 at 2:55 pm
luissantos - Friday, January 26, 2018 4:46 PM... when i create my credit...
I wonder what that does mean... anyway I spot the mistake:
try...
January 29, 2018 at 1:49 pm
...However, if the intended tasks were simple, I prefer a self-contained XML method where I...
January 29, 2018 at 1:23 pm
Don't...
January 25, 2018 at 8:18 pm
Yep. The only option is to expand disk drives on the destination server. Also If you have a drive which is big enough on the destination server and you can move...
January 25, 2018 at 5:33 pm
Hi,
If that is not in a database you can't use t-sql. Because your files on disk you can use windows explorer advanced search with file content enabled -
January 25, 2018 at 1:33 pm
Hi,
Check this out - https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters and http://bidshelper.codeplex.com/wikipage?title=SSIS%20Performance%20Visualization&referringTitle=Home
January 25, 2018 at 1:27 pm
adisql - Tuesday, January 23, 2018 1:49 PMyes i trying in server itself . but the error is same.
Check the security...
January 23, 2018 at 3:05 pm
adisql - Tuesday, January 23, 2018 11:42 AMyes MS SQL Server Agent service account has rights on that shared folder.
Can you logon...
January 23, 2018 at 1:38 pm
thesqlme - Monday, January 22, 2018 8:29 PMDoes this work for databases encrypted using TDE as well?
Yes, that method works with TDE and I...
January 23, 2018 at 1:12 pm
Does the MS SQL Server Agent service account has rights on that shared folder?
January 22, 2018 at 3:59 pm
I would check:
1. Do you have enough space in physical memory for the log buffer?
2. Are there any long running transaction which is in the rollback pending state?
3....
January 22, 2018 at 3:45 pm
Viewing 15 posts - 76 through 90 (of 180 total)