You can also license SL Server per user, and then it doesn't matter how many processors the server has, just the number of users/devices that are accessing the data. ...

I can't answer your last question, but with regard to licensing of SQL Server, it is based on physical processors (or sockets if you will).

If you have a dual-processor server...

IE 7. I use IE 7 at home with no problems.

Personally, I think it has something to do with the our network or some piece of hardware used on...

Perhaps we should take their approach, and ask Steve to close this thread as well. I do have to admit I liked reading...

I think it really depends on where you want to go career wise. Your choices offer different career paths, one being more system/network related the other Database-centric.

Why are you allowing users to write SQL directly against the database any way? Such access should be through an application or API (such as stored procedures).

Thanks for the feedback.

LeeM (7/10/2009)

---

We have many instances and I have found the following issues:

1. It does use more system resources than one instance: you have two sets of system databases including tempdb...

How about posting the code you are working with and the table structure of your logging table. A little hard to provide good advice when we are basically shooting...

Let us know if it helps.

Lowell (7/10/2009)

---

first, let me thank you for the CREATE TABLE and INSERT code; it helps enourmously. way to go!

here's one way to do it; here i'm assuming the column is...

Possibly, but the original request actually asked how to remove the 10th character. What if the character to be removed from the 10th position...

Look up the STUFF function in BOL (Books Online, the SQL Server Help System). Based on the description of your problem, this is just what you need.

select stuff('PQ19188PFHAA',10,1,'')

Actually, Jack, I should have been more specific. I'd still have a regularly scheduled t-log backup process running. The Alert would just run that job outside its normal...

I see someone has already shown a method, but I still want to post my code (as attachment to avoid frustration on my part).

Please pay close attention to the setup...