Yes, you invoke the approle is vague, but purposeful. Put yourself in the position asked. If you are testing an application role, how would you invoke it? ...

Joshua - Read the whole question. It clearly states that you invoke the approle. How do you do that? You use sp_setapprole, therefore you are setting everything...

I did, and here is the question again with emphasis added.

"You are testing an application role in SQL Server 2005. You connect with SSMS, invoke the role, and then execute...

Joshua Perry (3/19/2008)

---

The answer is absolutely wrong. You can't use sp_unsetapprole because the cookie was never set using sp_setapprole. If you activate the app role before setting the...

Consulting? Involves a level of self-confidence and self-promotion that escapes me. I do some, for non-profits, for free. They love that they can write me off at...

The DBCC INDEXDEFRAG command is fully logged. There are several things you could do. The first question, however, is what is the current recovery model of the database?...

Not having the DDL for your table or any sample data, I came up with this:

select

sum(case when LastUpdate >= dateadd(dd, datediff(dd, 0, getdate()), 0) and LastUpdate...

Are you doing any data transformations in the direct move to the tmpTable from the MUMPS system, or is it a straight transfer?

😎

jburkman (3/19/2008)

---

Post #1, so I'll try to make it a good 'un.

I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking to...

Taking the code posted be Jeff, here is one example of well formatted code.

CREATE TABLE [dbo].[ih_hist] (

[ih_nbr] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

...

Jeff,

I did get a favorable reply to my PM. Not to go into details, but in my reply back I did point the OP to your article on how...

Well, there is always hope. I've learned a lot more through this site, and some of that is from you. I think I try harder on some things...

Based on the OP's last posting, he might not see the posting after his. I dropped him a PM trying to explain some of our opinions and the reasoning...

True, but is the SQL Server 2005 database still around or was it temporary, for development? If it is sourcing the data for the SQL 2000 database then all...

Here is my thoughts. If it is for school, the OP should do as much of the work as possible. If they get stuck, ask for help to...