What information messages are you looking to log? Do you have any examples?

If you're trying to log every time a process completes successfully, than you could modify your stored procedures...

Thanks koshikei!

You can install & use Reporting Services on a non-domain computer, but you won't be able to use Windows Authentication to manage access from other computers.

Instead, you can use...

I'm assuming you want a cursor to dynamically create Integrated Security Logins from existing SQL Logins by concatenating the domain name to the username.

If that's case, you should be able...

I would suggest that you also wrap the logging into another stored procedure. That way you can reuse it over & over in your code.

Plus if you ever need to...

Good point.

Here's the modified version (finally got around...

I'd say that there's an argument for the fact that we are a meritocracy. That is of course counting interpersonal skills as a merit too. Although, since interpersonal skills can...

Better use a TRY/CATCH block! 😛

That's an excellent...

If you're SQL Server is running on Windows Server 2008 or Server 2008 R2, you also have the option of configuring services to start "Automatically (Delayed Start)". This should effectively...

chrism-787002 (2/3/2010)

---

... Dashboards impress me. Give me tools that can reveal a lot of interconnected information about performance. That's the kind of tool that I can do with...

Obviously a database with 65,000+ tables is going to take longer than a few seconds... I don't work typically work with databases that large. Most of my work is integrating...

chrism-787002 (2/3/2010)

---

I'm unimpressed. I wrote a simple TSQL script to search for text strings across all tables in a database and it took a lot less than a week.

This...

Yeah, I work for a relatively small company (15 employees) so we don't always have the option to pick & choose who gets to work when. Fortunately though, everyone is...

I agree with Steve. However, I think whenever it's feasible, companies should offer time and a half (i.e. overtime rate) and the option for employees to work on holidays. This...

As Steve mentioned, Microsoft does offer "Works With" & full certification for most of their products: