not sure why you'd want to lock a table up, but I would do it with a transaction.

one of the HINTs you can use is to exclusively lock a table:

From...

interesting;

i used the default trace and my own DML trace to see what it was doing.

the code you posted executes and created a stored procedure.,

the procedure gets encrypted, so...

was this post just a way to infect a computer by executing code you don't know what it does?

i know once wayne identified it, you got it, but here's an example of what i tested as a result of reading this thread:

SELECT

A.NAME,

STR(CAST(SUM(SIZE)...

server side traces using sp_trace_create are low impact and a good way to track recent changes.

when you create a trace, there is an expectation that you only keep X number...

MS is bringing you kicking and screaming into a more secure password structure. there may be ways around it, but they made it a lot harder to leave systems unsecure.

here's...

in my case, i do all my calculations in the SQL, instead of in the report....

so my SQL would have one more field, that has this for the calculation:

(A_Rev_TY/B_Rev_TY) /...

are you going to provide any more information?

The more detail you give us, the more we can offer suggestions...it looks like your post is just a venting because you...

Thanks to kruti's insight, i think i see your problem.

your datasource makes no sense to anyone, so noone can really help.

I'm assuming that this is a list of names/family members,...

I may be mis-understanding the question, but INSERT is really well explained in Books On Line;

if the table exists, it simply

INSERT INTO TABLENAME(columnList)

select columnlist from someTable

to create thetable "on...

find any column that has been tied to a rule:

select

object_name(syscolumns.id) as tablename,

syscolumns.name as columnname,

object_name(syscolumns.domain) as RuleName,

syscomments.TEXT as RuleDefinition

from syscolumns

inner...

if you can make them use a stored procedure, you can use EXECUTE AS, so it runs under sa even though they invoke it;

is it more likely the users just...

the between looks fine, but the rest of your WHERE statement has me puzzled:

where delivery_date BETWEEN '04/15/2009' and '04/22/2009'

and driver = e.emp_cd

and (driver = 'ATK' or '%' =...

glad it worked for you!

I know i was surprised way back when when i found out views could be updated; I always thought of a view a s read only...

lame example, but it all works:

USE TEMPDB

CREATE TABLE MyContacts(contactid int identity(1,1) not null primary key,ContactName varchar(30),OTHERFIELD INT)

insert into MyContacts(ContactName)

SELECT 'Bugs Bunny' UNION ALL

SELECT 'Homer Simpson' UNION ALL

SELECT...