Sounds like a DNS name resolution error to me. The DNS record for A0002 still probably resolves to the old IP address. What ip address does A0002 resolve...

You can query the msdb.dbo.sysjobactivity table.

If you are really using SQL Server 2005, I strongly suggest you move to using sp_send_dbmail. There are just way too many things that can go wrong when using...

I actually disagree with Bruce on this one, sorry Bruce. If you use GetDate(), SQL Server uses the locale of the SQL Server and if you set an explicitly...

I'd use a server-side trace. Here is the BOL Link and an here's an article[/url] on SSC.

Nice job Mike. Sometimes we think we are doing things in order, but it really is a shotgun approach. This can help us have a plan.

Yeah, but it was published on April 1st and in the April 1st newsletter.

That actuallly makes sense as NULL's are also treated as equal in primary key's as well.

IN 2005 and 2008 you could use a LOGON TRIGGER and check the application name, but be aware that this can be passed as part of the connection string so...

Using stored procedures means you do not have to grant access to the tables and, IMO, this is better for security than allowing direct able access.

My favorite help desk call was when the Paper Mill I worked out was shut down for maintenance so many areas had no power. Then I got the call,...

Check out this article[/url]. It doesn't have a script, but it does have a link to a utility that you may find useful. You can also check out...

If your datasource is SQL Server 2005 or greater you can add that column to your dataset using the ROW_NUMBER() function. See ROW_NUMBER() in BOL. The syntax would...

Are you deploying the datasource as well?

Can you post an example of what you want the report to look like (just text with the detail and total lines)? It sounds like you want to add...