Viewing 15 posts - 601 through 615 (of 1,409 total)
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...
December 3, 2013 at 7:53 am
Kristen-173977 (11/25/2013)
Thanks, you've saved me days of messing around looking for answers.
Glad you've got it solved!
November 25, 2013 at 8:40 am
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',...
November 25, 2013 at 6:23 am
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...
November 25, 2013 at 3:38 am
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...
November 25, 2013 at 2:21 am
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...
November 25, 2013 at 2:03 am
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...
November 20, 2013 at 8:32 am
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...
November 19, 2013 at 8:48 am
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...
November 19, 2013 at 7:22 am
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...
November 19, 2013 at 5:19 am
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...
November 19, 2013 at 4:53 am
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...
November 18, 2013 at 2:52 pm
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?...
November 18, 2013 at 10:30 am
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...
November 18, 2013 at 5:56 am
If the job executes a stored procedure it is also possible that in the code of the stored procedure a "EXECUTE AS" is defined.
November 18, 2013 at 4:33 am
Viewing 15 posts - 601 through 615 (of 1,409 total)