Viewing 8 posts - 46 through 53 (of 53 total)
The first thing that strikes me is that you are missing an AND between (Renewal.LastModified < @end) & (BodyartFacility.Status = @status) in the second WHERE clause.
September 10, 2011 at 9:55 pm
Steve Jones - SSC Editor (9/10/2011)
September 10, 2011 at 5:27 pm
Kalen Delaney's SQL Server Internals. In depth look across the database engine with plenty of scripts and examples. Solid stuff.
September 10, 2011 at 2:12 am
(IMHO) I went to university and studied a variety of ridiculously impractical things like philosophy, mathematics and computer science. I then completed a graduate diploma in IT at the local...
September 8, 2011 at 9:38 pm
Can you verify that the stored procedure does exist in msdb?
August 30, 2011 at 3:21 pm
Those logins look like the domain accounts setup for running the various SQL Services (engine, agent & full text).
Run sp_help_rev_login against the master database as this is dealing with logins....
August 30, 2011 at 6:50 am
You are not seeing a SID or a password because all of those logins are from Windows AD, rather than SQL Server logins. As long as the new server is...
August 29, 2011 at 11:02 pm
Have you looked at this kb?
August 29, 2011 at 4:59 pm
Viewing 8 posts - 46 through 53 (of 53 total)