Forum Replies Created

Viewing 15 posts - 226 through 240 (of 612 total)

  • RE: SSIS in SQL 2016

    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.

  • RE: CU or SP - What to do? What to do?

    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...

  • RE: tempdb errors

    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...

  • RE: tempdb errors

    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...

  • RE: SSIS Excel import error

    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...

  • RE: Best way to automate running adhoc scripts?

    Jeff Moden (12/5/2016)


    kevaburg (12/5/2016)


    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...

  • RE: BULK INSERT failing.

    FortyEightK (5/23/2013)


    Bump!

    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...

  • RE: Best way to automate running adhoc scripts?

    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?

  • RE: Unable to restore a database on a new instance

    Guðjón Kr. Sigurðsson (12/5/2016)


    To eliminate the TDE is causing problems we have removed it

    USE [master] ;

    GO

    -- remove tde

    ALTER DATABASE [VoruhusGagna] SET ENCRYPTION OFF ;

    GO

    -- monitor the progress

    SELECT [percent_complete],...

  • RE: log file growth

    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...

  • RE: slower queries using linked server

    Phil Parkin (10/6/2016)


    Lynn Pettis (10/6/2016)


    If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across...

  • RE: script in SSMS works fine, but in agent job fails?

    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...

  • RE: log file growth

    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...

  • RE: Disk space report

    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...

  • RE: What methods are available to push data from many sites to another site ?

    kevin_nikolai (11/30/2016)


    Currently we have a web service which pushes some information from many sites into data-warehouse on another site.

    Are there any other methods I could use to achieve same result...

Viewing 15 posts - 226 through 240 (of 612 total)