is250sp (7/28/2011)

---

I can run this locally but it errors out on SQL Server when I run it with my account and the SQL Service Account. What does it mean?

OnError,DALWSQL500,NA\SQLAdminAcct,Send...

Thanks for posting back...I learned a new acronym too 😀

Nice job posting your question 🙂

The only thing I can come up with for this, and it is a guess, is that there is only one copy of the ADO...

Adam McArdle (7/27/2011)

---

Is is possible (using Profiler, DMVs or anything else) to see which cached plan has been chosen for a particular SP call?

The reason I'm asking is that I...

Some thoughts on how you will get performance close to what you had with a concrete version of tblPersons:

1) the indexes on sales and nonsales must exactly match each other,...

If you're going to be using...

David Benoit (7/28/2011)

---

opc.three (7/27/2011)

---

David Benoit (7/12/2011)

---

Great. I will follow-up later with a bit on subscriptions and the impact of removing them.

Let me know if you have any problems with...

patelmia (7/28/2011)

---

Hi opc.three,

Thanks for your reply. Do you have any sample peice of code which shows how to use object inorder to acheive this task.

my taks is I will get...

MysteryJimbo (7/28/2011)

---

I generally use this to generate the TSQL.

select 'exec sp_dropsubscription @publication = N''' + sp.name + '''' + ', @article = N''' + sa.name + '''' + ',...

WilliamD- (7/28/2011)

---

The two procedure calls you mentioned in the original question are the ones you need to call (and in that order). This is exactly what the GUI does...

I won't be much help with FTS except to do Google searches on your behalf 😀

This person was in the same boat as you: http://www.sqlservercentral.com/Forums/Topic678754-146-1.aspx

Re: FTS in general, the extent...

Any FTS helpers on The Thread have a second?

Upgrading from 2000 to 2005: http://www.sqlservercentral.com/Forums/FindPost1150240.aspx

patelmia (7/28/2011)

---

Thanks for your prompt reply.

You are correct spt_key in temptable is a uniqueidentifier column. Since there is no datatype as guid during variable creation I picked string. I...

Running the upgrade advisor against a full day's trace is a good call, especially if you have apps issuing embedded SQL...the more you can capture and analyze the better off...

mmohan.net (7/27/2011)

---

Hello All,

Here is the issue I’m facing.

My task is to get guid’s from database field and run few updates based on the guid values.

I had taken execute sql task...