That depends on how the application is set up in terms of updating the tables. If it is based on Windows Authentication and the updates are being done as...

You should also see the machine name (hostname) associated with the login. As long as they do not remote into a generic server, having the machine name you should...

Assume you have a table with the definition of

create table x (i varchar(200))

and in it is a single row

insert x

select '60 / 2'

Now if you create your report with the...

This is the perfect case of only giving users select permissions (as the other reply said, db_reader) on tables and encapsulating all DML within stored procedures and having the application...

We have had a similar issue with MSDTC on a two node cluster with SQL 2000. To get it to work, sometimes it has been as easy as just...

winston Smith (1/7/2009)

Ah, gotcha.

The optimiser would be correct in thinking that Region_No returns less rows than Member_no so it is correct. Thanks for the help here, much appriciated.

as per my...

Great article.

What drives me insane about issues like this one (and I have had to create comma delimited files far too often through SQL) is that you never...