it took a while for this one to soak in. I read the requirement a couple of times, and kept thinking it's gotta be possible by using the stored...

the above advice is not correct. you can connect to a...

doh i'm sorry; i jumped to conclusions and thought the question was "how to assign/deny permissions to a role" ; Lemme test a couple of thoeries and i'll post the...

something like this example might help.

I'm creating 3 roles...one that is almost-but-not-quite-admin, one for regular users, and a third to explicity deny deletion rights.

i then assign various users to those...

no, my point was indid=1;

in my case the difference between the totals was 3x the number of rows, but 6 times the mb size:

SELECT SUM([# of Pages]) as NumPages,

Sum([# of...

dynamic results means dynamic SQL. there's no other way to do it.

if you only have read access, you could not create a stored procedure to run dynamic sql anyway, right?

basically,...

SQLRecon is a good tool that finds installs and instances, and tests them for a lot of security holes like blank passwords, etc.

i think it's this WHERE statement:

WHERE indid >= 2 and indid = 1 would include the clustered index of each table, and certainly makes a huge difference when i ran...

to add to what Greg said, SQL server keeps a pointer for each TEXT field;

SQL server will try to store each fields data stuffed into a TEXT datatype in a...

passwords or logins?

pretty much no matter what you do, you will not be able to see passwords...it's a huge security hole if you could create a trace or trigger and...

without seeing your script, here is a common issue:

if you ALTER a table by adding a column, and then try to INSERTfeaturing that new column , an error is raised...

it's the nature of the beast; the Just-In-Time Compiler, after a restart, has to recompile any pages and put them into memory.

First time the web page is accessed, it compiles...

not sure if this is what you are after, but I often use fiddler to test web pages and see what data is being passed back and forth when...

preventing relaying to outside emails is a very common mailserver setting; my mail server will not allow relaying unless you AUTH with username and password;

the server can also allow relaying...

i think seeing a function called multiple times is normal.

wouldn't this WHERE statement:

WHERE master.sys.fn_varbintohexstr(job_id) = substring(program_name, 30, 34))

be needed to be called one time for each row in sysjobs because...