This article shows the message number for various violations. You can then set up an alert of one or more of these message numbers that will send an email...

You should only have to re-initialize the entire subscription if, for some reason, it is marked for re-initialization. That could be because of an extended period during which transactions...

I believe that, in SQL Server 2005 and 2008, alter table commands are replicated to the subscribers for transactional replication. I believe that re-initializing the subscription actually drops and...

You can also define logging to a database in the package itself. I find that useful for troubleshooting errors.

If users connect to the application using their Windows login, you could filter the Profiler trace on login and limit the results. Then someone could submit transactions and you...

I noticed that this seems to involve Dynamics NAV, so I thought I'd throw in my two cents about collation and NAV. We are implementing NAV 2009 and have...

If you can create the connection in the package and it tests ok, there shouldn't be any issues.

This may be related to an issue that I've seen in SS 2008 where non-sysadmin users need to be added as users in msdb in order to browse databases in...

I stand corrected and am happy to find out about this before we have to migrate this functionality to a new 64 bit server. Does anyone know if they...

We have a couple in a SQL Server 2005 environment. I'm going to try to attach a sample script. All we do with the linked servers is access...

I've been exposed to the quirks of third-party software more than I have in any other position. The most irritating issue so far has been applications that have requirements...

I don't have a degree. I was just thinking this morning that it's been 25 years since I went to a technical school for mainframe programming, which I actually...

It looks like the job may be associated with a maintenance plan. Try to find that and delete the maintenance plan first. That may also delete the job.

There are also products that allow for object-level recovery without restoring the database too. We use LiteSpeed and I've tested that functionality and it works fine.

Steve,

The link for the 'Look for Jobs' didn't work. Thanks.