I would probably audit failed logins as well so you can see who is trying to access the server in an unauthorized manner.

Also can you define unauthorized access? If...

Wayne,

Wouldn't using a linked server defeat the purpose of moving reporting db's off the ERP server? You'd still be putting much of the load on the ERP server. ...

Andy,

It sounds like the issue is that the parameter is not named date1. Have you verified the name and case of the parameter?

Something I like to do in a...

peter 82125 (4/4/2012)

---

Change tracking? SQL Audit? Extended events? Don't these things need to be enabled and therefore require a change to the database? Hopefully I'm wrong, but what I've seen...

I assume you mean the INSTEAD OF trigger worked?

sp_who and sp_who2 both return the column DBName.

With SQL Trace/Profiler you can add the Database_ID and Database_Name columns to the trace for the AuditLogin Event. Of course this will...

Stefan Krzywicki (4/4/2012)

---

Ever worked with someone who can't seem to handle answering more than one question in an email? I'll ask several related questions and receive an answer to one,...

Do you need to store the data or do you just need snapshots of the data?

You can create a trace to get the Audit Login event. Or you could...

When I'm talking with DB people when I hear fragmentation I always think Index Fragmentation because that's what we can control. When I'm with non-DB people I think physical...

I'd also recommend going to identical sizes and I'd recommend turning autogrow off and monitoring the space closely. If you do have dedicated drive space for tempDB I'd...

cfradenburg (4/4/2012)

---

There are a few different reasons to use stored procs. Plan reuse is one of them. Particularly on more complex queries the fact that it doesn't need...

Murphy'sLaw (4/4/2012)

---

Jack Corbett (4/4/2012)

---

The error is telling you that you have unicode characters in the source and you are losing them when converting to non-unicode. It isn't...

Are they using Entity Framework (part of the .NET Framework) or nHibernate?

I'm a big proponent of limiting data access to using stored procedures for the following reasons:

1. Security -...

You can get the same information by using the sys.master_files which returns data for ALL database and ALL files regardless of the database context you are working in. So...

The error is telling you that you have unicode characters in the source and you are losing them when converting to non-unicode. It isn't really truncating because of length,...