it sounds to me like there's a server wide or database trigger tracking DDL changes, but the auditing table hasn't been granted rights to teh users doing DDL, so it...

and a basic example of the trigger:

CREATE TRIGGER TR_UPDATE_EXAMPLE ON SOMETABLE

FOR UPDATE

AS

BEGIN

UPDATE SOMETABLE

SET LastModifedUserName = SUSER_NAME(),

LastModifedDate = GETDATE()

FROM INSERTED

WHERE SOMETABLE.PKID = INSERTED.PKID

END

I have this saved as a handy auditing snippet;

all these variables are available in 2008 and above, so if you have an audit table, just include some columns for the...

here's a couple of examples i made from another forum post.

this one was just a basic example, where something normally done by a sysadmin, can be delegated tro a...

As you are discovering,...

this site has the most comprehensive list of attributes you can query that i've ever tripped over:

http://www.rlmueller.net/UserAttributes.htm

specifically, his excel spreadsheet has a ton of stuff:

http://www.rlmueller.net/References/Schema.xls

i searched for "locked" and "enabled"...

ahh "bin packing" was the keyword; I've got a lot of saved scripts, could't remeber the label for it.

I wrote a script i wrote long ago, but my version...

definitely non sequential/gaps are involved;

i'm trying a mini tally table and n-1 transactions, but i keep thinking i...

looks like a simple grouping problem..is this homework?

SELECT

Col1,

MAX(Col2),

MAX(Col3),

MAX(Col4),

MAX(Col5),

MAX(Col6)

GROUP BY Col1

i'm thinking that you need a case statement plus a min, ot get a status/status indicator.

you cannot use alphabetical order of the statuses, because In Progress comes before Initial

maybe change...

the row counts are already materialized in one of the system tables, so if you query that, it will be boatloads faster than querying each table individually:

Select

...

there's no need for a cursor on this, but I think youa re right, you will need to pivot the rows to columns;

is there a fixed number of answers for...

here's the script I mentioned that blindly builds the SQL statements to create indexes on any foreign keys that do not have indexes on them yet;

any peer review would be...

i like all the examples so rar, but make sure you search for <table without the ending > tag.

if the table has a class, a css style or even older...

Steve Hendricks (9/28/2012)

---

In re: "it's the selectivity of the data that is what the SQL engine uses to determine whether to use an index or not."

For SELECTs that would be...