tracmonali (7/28/2011)

---

well it is a test server and not in use. So didn't take it offline nor put it in single user mode.

My Q is that the weekly backup used...

zlthomps (7/28/2011)

---

opc.three (7/28/2011)

---

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...

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...