Viewing 15 posts - 3,196 through 3,210 (of 3,232 total)
How about this one?
http://support.microsoft.com/default.aspx?scid=kb;en-us;325349
November 14, 2005 at 11:01 am
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...
November 14, 2005 at 10:29 am
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 = min(month) FROM <tablename>
WHERE month > @key
While...
November 14, 2005 at 9:58 am
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.
November 14, 2005 at 9:08 am
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...
November 11, 2005 at 3:02 pm
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...
November 11, 2005 at 2:13 pm
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...
November 11, 2005 at 1:55 pm
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
November 11, 2005 at 11:27 am
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>
November 11, 2005 at 11:12 am
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?
November 9, 2005 at 8:54 am
November 7, 2005 at 9:54 am
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...
November 1, 2005 at 3:08 pm
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...
November 1, 2005 at 2:53 pm
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...
November 1, 2005 at 2:40 pm
SQL Server does not provide a tool to view the contents of the transaction log (that I am aware of). There are third party tools that will do this for...
November 1, 2005 at 2:37 pm
Viewing 15 posts - 3,196 through 3,210 (of 3,232 total)