Viewing 15 posts - 226 through 240 (of 612 total)
You can also download SSDT directly from Visual Studio 2015 Community if you have it installed.
The install process installs only the Services, not the Software.
December 8, 2016 at 4:43 am
The majority of our databases reside on a 3-node Standard Cluster under SQL Server 2014. Initial patch testing is done on a machine for exactly that purpose.
We believe in...
December 7, 2016 at 7:37 am
Thom A (12/6/2016)
kevaburg (12/6/2016)
Edit: Now I have read the post above you could change the Insert to read:
insert into tbl_errorlog EXEC sp_readerrorlog 0, 1, 'TempDB';
Good idea Thom!
If you're going...
December 7, 2016 at 7:27 am
I would suggest the majority of the information you need can be read directly from the SQL Server logfiles. These can be read directly using sp_readerrorlog
.
A possible solution might...
December 6, 2016 at 6:06 am
When I understand this correctly the Job doesn't work when run from a SQLAgent Job. Have you checked that the SQLAgent Service account has access to the share on...
December 5, 2016 at 12:10 pm
Jeff Moden (12/5/2016)
kevaburg (12/5/2016)
December 5, 2016 at 10:01 am
FortyEightK (5/23/2013)
Just thought I'd add my two-penneth as I was getting this exact error today and this was the first post I found on a search.
The BULK INSERT is performed...
December 5, 2016 at 7:10 am
Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped into a folder?
December 5, 2016 at 6:58 am
Guðjón Kr. Sigurðsson (12/5/2016)
USE [master] ;
GO
-- remove tde
ALTER DATABASE [VoruhusGagna] SET ENCRYPTION OFF ;
GO
-- monitor the progress
SELECT [percent_complete],...
December 5, 2016 at 6:48 am
To make things easier you could have a script that runs on a schedule and records data that will be stored in a permanent table. I use the following:
--HOLDING...
December 2, 2016 at 11:17 am
Phil Parkin (10/6/2016)
Lynn Pettis (10/6/2016)
December 2, 2016 at 6:40 am
butcherking13 (12/1/2016)
I actually got it to work, but what I did was remove the user from the "Run as user" in steps property on advanced tab. Thanks!
Thanks for sharing the...
December 2, 2016 at 6:16 am
ramyours2003 (12/2/2016)
i need a report to find the log file growth in GB on weekly basis for the last month , can any one help on this ...
There are...
December 2, 2016 at 6:12 am
Jeff Moden (11/18/2016)
kevaburg (11/17/2016)
Jeff Moden (11/16/2016)
kevaburg (11/16/2016)
Hi,
exec xp_fixeddrives;
This returns the amount of free space on your local drives. It is a good place to start....
Regards,
Kev
It's really not. It...
December 2, 2016 at 6:06 am
kevin_nikolai (11/30/2016)
Are there any other methods I could use to achieve same result...
December 2, 2016 at 5:58 am
Viewing 15 posts - 226 through 240 (of 612 total)