Unfortunately no. IE will pass to the last one used or viewed (viewed doesn't always work exactly rigth) unless you are able to set your email app to "Open...

That had to be Read/Write at the time SP3 was installed. When it tries to upgrade it checks this.

I have no issues myself. Can you provide more code to the point of where the A number is finally generated?

As for TEMPDB, generally SQL does a fine job on it's own deciding this so I wouldn't worry unless you start to see issue that can be traced to TEMPDB.

Not...

I would say luck, however could have been an issue.

With BETWEEN the smallest value should be first and the largest after the AND. They don't express that in the documentation...

I have had this happen on 2 machines I have. In both cases it is te machines with .NET framework installed just before problem began. Have not had time to...

quote:

---

quote:

---

I may be showing my age, but anybody ever hear of an old product...

That should be the options to make publications or database visible on the Active Directory system for your network. You must be part of an Active Directory Service (similar to...

Odd, I have run the example and never had an issue.

Try scripting out the job and post here. Might be something in the settings, but nothing I can think of.

There is a known issue with XP and this.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;323280

Actually the part about wrapping in a dynamic string is not correct. I just tried your example code from the beginning subing my table, column and a valid value and...

quote:

---

Finding the tables is easy

select sc.name 'Column', so.name 'table'

from syscolumns sc

inner join sysobjects so on so.id = sc.id

where...

Are the users doing major tasks. If the lock is there for a large update and the user disconnects then the update has to rollback. Look at the last statement...

You will need to use at least a WHILE loop or a CURSOR to get the data properly. However, if you need to perform this often I would add a...