winston Smith (4/16/2012)

---

all attempts were run from the actual server.

When I say I remote in, I meant I'm now at home and so had to remote into the servers,...

winston Smith (4/16/2012)

---

Perry Whittle (4/16/2012)

---

winston Smith (4/16/2012)

---

I ran setspn -l server.domain and got a list of all SPN's for the server.

I then ran setspn -d MSSQLSvc/server.domain domain\serviceAccount to remove the...

sqldba_newbie (4/16/2012)

---

opc.three (4/16/2012)

---

Yeah, I was just making sure you were comparing apples to apples and not looking at something like SQL:StmtCompleted vs SQL:BatchCompleted or RPC:Completed. Now that we have that...

Who were you logged in as when you ran KLIST PURGE? The same account as the SQL Server service account?

Not sure which order you were doing what, but for the record the SQL Server service will re-register an SPN if it has rights to Active Directory (LocalSystem, NETWORK SERVICE...

EDIT: blah...site once again cross-posted a response to another thread for me

I think the upgrade wizard does want to reach out to the server to validate and update any metadata necessary to make the upgrade a success. You can open all...

Yeah, I was just making sure you were comparing apples to apples and not looking at something like SQL:StmtCompleted vs SQL:BatchCompleted or RPC:Completed. Now that we have that cleared up,...

George, You're a veteran. Why would you offer up a solution using a feature that has already been removed from the current version of the product?

From the article to which...

chewychewy (4/15/2012)

---

thanks. Seen the link. "Do not grant server permissions to the server public role".

However for my case here all those privileges were granted during default installation. Do u think...

As mentioned you have to enable the CLR at the instance-level but you can enable it on the instance and add a DDL trigger FOR the DDL_ASSEMBLY_EVENTS event group in...

Which readings in your OP go with which trace event?

I have not had good luck using the DTS Designer in SQL 2005. It was buggy and was a modal window (at least it used to be) so I resorted...

The...