The display of the images are horrible. Can't follow along.

The following columns it is capturing are:

TextData

BinaryData

DatabaseID

TransactionID

LineNumber

NTUserName

NTDomainName

HostName

ClientProcessID

ApplicationName

LoginName

SPID

Duration

StartTime

EndTime

Reads

Writes

CPU

Permissions

Severity

EventSubClass

ObjectID

Success

IndexID

IntegerData

ServerName

EventClass

ObjectType

NestLevel

State

Error

Mode

Handle

ObjectName

DatabaseName

FileName

OwnerName

RoleName

TargetUserName

DBUserName

LoginSid

TargetLoginName

TargetLoginSid

ColumnPermissions

LinkedServerName

ProviderName

MethodName

RowCounts

RequestID

XactSequence

EventSequence

BigintData1

BigintData2

GUID

IntegerData2

ObjectID2

Type

OwnerID

ParentName

IsSystem

Offset

SourceDatabaseID

SqlHandle

SessionLoginName

PlanHandle

The following events that is captured on the trace is:

53) cursor open. how often used ?

79) missing column stats. Is this OK to have...

a Custom trace.

thank you. That confirms what I thought.

Thanks for the answers. I was trying to get around by not using the Distinct in the select statement. That is the reason i used the Where exist...

I was working from home pretty much whenever I wanted to for 2 years till they hired a new manager and I was switched to this 'new manager'. From...

The user requires Excel format.

Also, we have another box which is Windows 2008 R2 server 64 bit. It has Microsoft Office Professinal Plus 2007 installed, but no Microsoft...

you say:

"But, SQL Server does jump through hoops if you don't qualify the schema name. Meaning the engine will check the user's schema first and then the dbo schema. This...

The link that says that it will cause recompilation if you don't qualify the storeproc with a dbo

is

http://support.microsoft.com/kb/243586/

that account is a domain account. The sql service and sql agent are both running the same domain account that has SA privilege.

The proxy account is set up using...

Thank you Gail. The Original_function worked very well.

Thank you for your reply. I am not too familiar with Notification and Service Brokers which they seem so Foreign to me. But I will try to look...

I finally solve my own problem luckily without calling Microsoft which would have charged an arm and a leg (It did took a while for me to solve this one!).

I...

Grasshopper, the excel file is on the same box as the sql server box.

The sql service agent account is a Domain\account that also has sa privilege and is a Domain...

I am using EXCEL in 64bit.

I am trying to import Excel into sql 2005 table.

It runs well in SSIS.

I read the posts, I set the run64bit (or something like that)...