Yeah, sorry, I forgot: "CREATE APPLICATION ROLE..." is the preferred way to add an AppRole in SQL 2005.

MrBaseball34 (8/19/2008)

---

I ran the DB Tuning Advisor on this and a couple other tables and it recommended 0 changes.

...

I KNOW that something needs to be done to this table as...

I was thinking along similar lines, vladan.

It seems to me that the OP was confabulating two contradictory requirements in PRNG's (Pseudo-Random Number Generators), the "Uniform Coverage" requirement and the "Long...

Thanks, Mohamed. I got the idea for this question because I keep making this mistake myself.

Any chance...

Ah, this is one of the worst dialog sequences in SQL Server:

1) In SSMS, right-click on the user's name in the database and select properties

2) select the "Securables" pane, click...

psangeetha: As I recall it, here is the procedure:

1) Create AppRole in the App DB. Remember the Role name and password.

2) Give the user Connect-only access to the DB:

...

avamin: That is how you limit an app to SProcs. To force user to only use the app you need something like AppRoles or Certificates.

These are two independent...

Glad I could help. (eventually) 🙂

Carl Federl (8/19/2008)

---

Jeff, regarding the benchmark method you are using, found a curious situation.

If this SQL is run, statistics time reports duration and cpu of of zero:

set statistics time on

insert...

great article, Jeff!

OK, here is how you want to do this:

Declare @ZeroRows as int

Declare @MultiRows as int

--First Insert any non-matching rows into Zero_tbl

Insert into Zero_tbl

Select *

From toprotect_tbl P

...

blnbmv (8/19/2008)

---

A) if there are any toprotect_tbl rows with 0 tree_tbl rows matching?

explanation: I want to insert these records into some other T1 table where the matching records...

Try this:

Declare @sql AS varchar(8000)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ '['+COLUMN_NAME+'] = Replace(['+COLUMN_NAME+'], ''"> <!--'', '''')

,'

From...

OK, that's the SQL Server 2000 thing.

Change "varchar(max)" to "varchar(8000)" (and hope it fits).