Specifying the owner for objects will have a greater effect with greater concurrent usage when the user calling the object isn't the owner. The reason being you see the SP:Cache...

To some this may be a pointless technique... but understanding how it works can mean the difference between understanding how a vendor's product is storing information and how it isn't....

If the user is a member of the db_owner role that should be sufficient. Is the user connected to the correct database in question Is the user trying anything unusual...

I have not tried this. However, in a SQL Server 2000 cluster, when you go to install another instance, it requires a new virtual name. If there is already a...

Please don't cross post. Most of the forum users (like me) tend to read all the categories. See my reply in the other thread on this topic.

I traded some emails with the Apex SQL guys and Ivan Erceg, Apex SQL's server architect, pointed to a few blog postings from the Apex SQL site:

http://www.apexsql.com/blog/2006/02/recovery-with-apexsql-log-2005-part-1.htm

Edit: I went back and read BOL.

Okay, I see what you mean. In setting alerts via error #, there's no text about what it will fire on and what it...

No, not by default.

Your ability to connect to SQL Server depends on what logins the DBAs have authorized within SQL Server. These logins can be SQL Server based, Windows...

There is no way to notify the user. The second operation will wait for the first to complete but will provide no notice back to the client.

I always copy and paste into notepad first.

Behavior for a default instance and named instance are totally different.

For a default instance, the server is assumed to be listening on tcp/1433. Therefore, if a default instance is installed...

Are you copying and pasting code?

If you can do a pull, say nightly, then they can search against the DB fairly quickly and you can use an outside script to use all of the relevant...

True, but it doesn't give him the datatype he's looking for.

Okay, I'm going to look at it from a different perspective since my "day job" is a directory services administrator. First question, where does the list of first name/last name...