This may not be the exact way SQL Server does it, but it's similar enough to understand what's going on: SQL Server is going through the INSERT to the point...

This looks to be the problem:

quote:

---

Step Error Description:Could not save; currently locked by another user.

---

You...

I've changed IPs without too much trouble before. If you aren't using a virtual server, SQL Server binds to the IP address of the system on the port specified. The...

I think I first saw the job table as a suggestion from Steve or Andy. They deserve the credit.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

I also haven't seen the sa not being able to connect in EM, but I believe there is a thread where someone else is seeing it. I can't reproduce the...

I wouldn't rely on a hack to get around this issue. At some point Microsoft should address the issue and then the process breaks. Of course, don't ask me to...

quote:

---

At times I get irritated with the religious fervor groups get into about how superior their "thing" is compared to the other...

The use of @@IDENTITY has issues which go beyond what you've described here. @@IDENTITY will return back the last identity value inserted by that connection, whether the user did it...

Another consideration is ActiveX scripting. If you can do it using VBScript, JScript or some other scripting language installed on the system (like PerlScript), you can extend SQL Server via...

Going out on a limb, it sounds like a memory leak. This is the only operation going on? How is it tied to SQL Server?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

quote:

---

the job is owned by another user (say 'job-dba') as the users connecting to the server by the application (these all belong...

Outlook or a MAPI client is not required for SQL Mail, so long as the MAPI .dlls are there. What is[/is] required and why the MAPI client is usually installed...

The short answer is no. If you do this through Enterprise Manager, it creates a new table, migrates the data, drops the old table, and renames the new table to...

They yanked you out of the local administrators group and you not can't connect?

Were your NT user accounts granted logon rights to SQL Server through another group or by individual...

Very much so, especially since the DSN works and installing a relatively new version of MDAC does not. This one of those weird sorts of cases where you may want...