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

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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!

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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',...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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?...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • 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.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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