Does the proc fail with error or does the proc succeed but the email does not get sent?

If proc fails, provide error. If email does not get sent, check dmail...

The linked server definition has mapped Active directory logins or the option "B made using the Login's current context" is specified and you are logged in to the server with...

That's good to know that just changing a VARCHAR(10), let's say, to a NVARCHAR(10) might lead to concatenating some of the data. And it's also good to know that the...

I don't see any reason why the data would be affected.

CREATE TABLE dbo.test(data varchar(10));

INSERT INTO dbo.test

VALUES('test data');

ALTER TABLE dbo.test ALTER COLUMN data nvarchar(10);

SELECT *

FROM dbo.test;

DROP TABLE dbo.test;

if you...

Why would you be able to used this? You have six weekly files which will encompass one months worth of logs. you just need to loop through your logs and...

You could calculate the difference between the max and min times of all error logs in the past month.

here is an example

CREATE TABLE #current(logdate datetime,

ProcessInfo varchar(10),...

Beatrix Kiddo (1/8/2014)

---

So you're saying that DBCC CHECKDB has been run on database 'dbname*' since 29 Dec 2013? Was it successful?

* Is this just one database in your log, or...

Lowell (1/3/2014)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

You can either give the account that started sql agent permissions to the folder or use SQL Server Agent Proxies.

Is WINNTDOM\sqlserveragent the SQL agent account?

numeric and decimal are functionally equivalent.

http://technet.microsoft.com/en-us/library/ms187746.aspx

this sounds like a kerberos issue. I would check if the proper SPN is created and whether the SSRS service account has delegate permissions

have a look at this article

I would suggest looking at the UPPER, LOWER, and SUBSTRING functions.

getting another log...

Maybe you should brush up on your google skills:-D

https://www.google.ca/search?q=sql+server+point+in+time+recovery&oq=sql+server+point+&aqs=chrome.2.69i57j69i65j0l4.5522j0j4&sourceid=chrome&espv=210&es_sm=93&ie=UTF-8

Wayne.Emminizer (12/16/2013)

---

It used to work though when I was running the packages in 2008R2 with MSDB instead of 2012 and the Package Store.

These initial packages are updating lookup tables. ...