Rename sa, create a new "sa" account, track all attempts to log into it?

One would think that most hackers that are attempting to hack a SQL server would try...

If you only need to worry about co-ordinating SQL jobs, then SQL Sentry is a very good tool. If you have to also co-ordinate between other systems we use...

Without regard to optimization.... I would do it this way:

Select * from v_staffTrainingDetails where expiry_date >= DATEADD(mm,-2, getdate())

I actually use a TSQL script that picks up any new database added to the server (and creates the subfolder needed). Backs them up to a share on a...

Or don't use the maintenance plans to backup SQL and only save the date in the file name. That way don't need linked servers as long as the restore runs...

I just did an upgrade from 2005 to 2008 (not R2). The biggest problem we had was to be able to verify that every application would work (57 databases,...

For backups take the advice earlier and try LiteSpeed and Hyperbac. Remember to try restores too.... I backup about 500 GB to a remote server in <...

pwalter83 (3/29/2012)

---

Jeff,

Actually I would need some help at this point. Anders...

Dang.

Last time I tried to get users to clean up data, it was more mess than what we started with! 🙂

Granted, we feed the data from Cobol created data....

Should have everything you need.

Just sum on the converted to minute columns however you want it summed, then add the values together.

I guess what you really want here is the...

If that works, can I come work for you? 🙂

Performance however becomes, uhm, bad, from my...

Try this. Tested on SQL 2008 (10.0.4000). Might not be optimal, but makes it readable.

create function dbo.fcn_ConvertTimeToMinutes(@Time Time)

returns int

begin

declare @r int;

select @r = substring(CONVERT(varchar(5),...

I'll see if I can test it with a date as a parameter. Honestly I couldn't find a single place that I use this with a parameter, so it...

bensala (4/2/2009)

---

the issue is with your SQL service not able to "lookup" the AD account... Here is the cmd that DBMail runs:

EXEC sys.xp_logininfo

@acctname = 'Domain\User'

If this command kicks back...