to see all users, you need to grant view server state permissions.

grant VIEW SERVER STATE to TheRightRole;

also, you'd get an error if you try to use * and also schemabind a view:

CREATE VIEW v_YOURTABLE

WITH SCHEMABINDING

AS

SELECT * FROM YOURTABLE

Msg 1054, Level 15, State 6, Procedure...

yes.

if the view is not schema bound, if you created the view with select *...that gets compiled to a select featuring the actual columns at the time of creation.

you can...

Agreeing with Elliot here;

i've seen numerous posts here requesitng the same thing.

AFAIK the biniaries that are the core service and stuff must be installed on the %systemdrive%, with no...

conceptually, i understand now; it'd a STDEV of the 6 values, right?

if you can provide a set of commands for some sample data

CREATE TABLE ...

and also

INSERT INTO...

we could show...

the SQL server function STDEV takes a column name;

it sounds like you want the STDEV of 6 columns in a specific row, or a

all values ?

if it's the 6 columns...

do you have a logon trigger that is sending an email message or logging to a table in MSDB or something?

the UPDATE() function is really misleading;

With "UPDATE(xyzID) " for example,

a lot of people interpret that to mean "If Column (xyzID) changed".

actually SQL interprets it as "If the column xyzID was...

Not without having something in place first; SQL doesn't keep track...

It depends on what you want to do;

it sounds like creating a event notification for AUDIT_BACKUP_RESTORE_EVENT might work, depending on what you are doing.

I've played with that for automatically running...

SQL server does not have windows passwords. what happens is SQL server checks the token Windows passes from Integerated security to see if you have access. SLq assumes that...

doh! i see that now!

something like this?

CREATE TABLE [dbo].[ATTACHMENTS] (

[ATTACHMENTID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

[NAME] ...

Anything wrong with having an "AllAttachments" table, and then a multiple linking tables that join the desired tables keys together?

So for example, if i decided to add an attachments ...

Along Eugene's lines of code review, I've found that a very high percentage of table designs have the first column or the first few columns actually define a primary key...