When considering concurrent users of a database I go with number of SPIDS as this is the number of connections open to the database at the time. However if you...

SQLAgentCmdExec has nothing to do with a called package that is under the right of the user.

Depending on the users rights they may have created the table but under there...

Also if you are INSERTING, UPDATING, or DELETING multiple records at a time you will have to look thru the records in either the inserted and/or the deleted tables either...

There are several factors that influence this. One of the major is where is the restore coming from local file backup or from tape. Also, how much data changes and...

It would be great but you cannot use TEXT as the data type for a variable except when used for INPUT/OUTPUT with a stored procedure, however as for OUTPUT no...

I haven't seen the issue with SA not working when the account was pulled unless your EM was cnfigured to use the trusted connection. Usually you can get around by...

Ok, first the General tab is the installed version of SQL (english language version in this case). The language for users when created is based on the Server settings default...

Also, try restore to another database from a previous backup to see if the same thing exists.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

I do laugh at the last thing about DBA's lasting longer. find where I work and a few other large corps around here that the job title DBA is...

Actually, I believe if you right click the table in EM you will get a script of the table and all it' s related items except triggers that you can...

Sorry without your code and the fact you never stated which was the left table I incorrectly assumed it was the remote table not the local. However, with a linked...

About the only way is for someone to truncate the table or do a delete from. As this is the first time you may need to check with Profiler to...

It most likely boils down index decisions. For example if the clustered index is on the column you are joining to then the query manager may decide to use the...

Depends on what code is in the .BAT, most likely it references osql or isql thru command line so you would execute under the OS enviroment thru cmd or by...

There are dozens of factors that cause the query engine to make certain decissions. Generally it looks at the index with the most unique values and may consider the WHERE...