I would start by running resetting the suspect flag using: sp_resetstatus [ @DBName = ] 'database'.  Then run DBCC CHECKDB on all of your databases to see how big the...

How about this one?

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

It appears that the statement is attempting to minimize processor and I/O contention by taking advantage of multiple processor threads and disk spindles.  They are not mentioning that for this...

create table #newtable (

 [Month] int,

 users int,

 Cumlative int)

declare @count int, @users int, @key int

SELECT @Count = 0, @users = 0, @key = 0

SELECT @key =...

Have you tried user_name(user_id()) ?  This works for me.  When logged in using SQL Server authentication, this returns my SQL Server user login name. 

I too came from the days of using Windows perfmon.  I know use Spotlight instead and I think it is well work the money.  Not only do you get basic...

The Microsoft KBase that Yelena posted outlines all of the permissions and rights that a non-administrator account needs to run SQL Server.  I know you said that the items from...

Kory,

The BuiltIn/Administrators account within SQL Server exists so that a member of the Windows Administrators group can login to SQL Server.  It is not related to the Windows account...

There is quite a few things to consider when initially sizine hardware for a database server.  Try this one for starters: http://www.sqlservercentral.com/columnists/bknight/sizingadatabase.asp

You should not need to use a cursor.  Just do :

'UPDATE <AuditTable>

SET <audittable.column name> = inserted.<column>

FROM <AuditTable>,Inserted

WHERE <AuditTable Key> = Inserted.<Key>

It looks like you have duplicate records.  Are you checking existing data upon creation?  I assume that Order_ID is a unique, primary key on Orders?  How is OrderStatus keyed?

This may help:

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

You could declare a variable of whatever datatype spSystemSP would return, then assign that variable to the results of spSystemSP and include that variable in your select. 

Example:

declare @spResults int

set...

So are you looking for the T-SQL syntax to initialy populate this new column?  I would write a case statement to check and see where all of your ag values...

I'm not really sure what you are asking for?  Are you looking at renaming the Ag column to Grp and converting the data over?  Or is Grp going to be...