Forum Replies Created

Viewing 15 posts - 601 through 615 (of 1,409 total)

  • RE: Unable to Start SQL Server Agent Service with sa privileges

    Are you using the 'sa' SQL-account or are you using a Windows account with SQL sysadmin permissions?

    It could be your Windows account doesn't have permissions on the OS level to...

  • RE: Cannot enable Database Mail XP

    Kristen-173977 (11/25/2013)


    Thanks, you've saved me days of messing around looking for answers.

    Glad you've got it solved!

  • RE: Cannot enable Database Mail XP

    I'm sorry, i am running out of suggestions. Maybe someone else can shed some light?

    What if you reset the Mail XP's?

    EXEC sp_configure 'Database Mail XPs', 0

    GO

    RECONFIGURE

    GO

    EXEC sp_configure 'Database Mail XPs',...

  • RE: Cannot enable Database Mail XP

    Open SSMS and navigate to the Management subtree.

    Right click "Database Mail" and select "Configure Database Mail".

    Click [next] on the (optional) welcome screen.

    Make sure the option "Set up database mail by...

  • RE: MSDB-Job failed

    If you restore the MSDB from the resource you'll also loose all history-information about backups and restores. Also all jobs and jobhistory will be lost. All this information is stored...

  • RE: Cannot enable Database Mail XP

    Does the account you are using have enough permissions to use Database Mail? If possible, please try to send a mail using a sysadmin account.

    Use (parts of) the code below...

  • RE: SQL Query help

    The code gets a bit uggly to read but on first glance you only need to remove the " ) AS D " after the JOIN statement of the third...

  • RE: 2008 vs 2012 - Same Proc, different outcomes

    I'm not sure, but if I read your problem it looks like a limitation in XML-size. Maybe there is a property in SSRS (like there is in SSMS) to set...

  • RE: Robocopy

    Does it work if you change the sequence of the command parameters?

    ROBOCOPY D:\filetocopy E:\filetocopyto /MAXAGE:1 ^& IF %ERRORLEVEL% LEQ 1 exit 0

    If you are putting the above command in a...

  • RE: Change initial sixe of transaction log file

    Krishna1 (11/18/2013)


    why the initial size keeps changing?

    Most database actions are being logged, hence stored in the LOG file. The LOG file will grow when actions are being executed on the...

  • RE: SQL Query help

    Put both SELECT queries as sub-queries together in a wrapping query, joining them on the company and customer. In the wrapping query you can select the totals from each sub-query.

    SELECT...

  • RE: Alert when TempDB is growing rapidly

    You could setup a job to determine the TEMPDB size and runs every ten minutes. Store the values in a table and determine the increase between the runs. If the...

  • RE: How can I use output of a stored procedure dynamiclly?

    Can you confirm you actually put the generated time value inside the HTML file (and not only showing it)?

    Do you save the HTML file to disk with the GENERATE proc?...

  • RE: Update query with & without null values

    You could add an empty string to the parameters of the COALESCE function. That will update the value to an empty string if both the variable and the field value...

  • RE: Problem changing account for job execution

    If the job executes a stored procedure it is also possible that in the code of the stored procedure a "EXECUTE AS" is defined.

Viewing 15 posts - 601 through 615 (of 1,409 total)