Ok i got this working,hope this would help someone.

For SP's i haven't tried this because WSUS has the capability to deploy SP's.

For CU's, you can make use of PowerShell 2.0....

Oki should had provid more details on this.my goal here...

Lowell (2/15/2012)

---

most likely a permissions issue.

to run a cumulative update, you need to be an administrator ont he amchine...

xp_cmdshell does not run as the logged in user...it runs under whatever...

Jeff Moden (2/10/2012)

---

Indexes don't have to be used to be valuable. Having, for example, a unique index where that index is never used might tempt you to drop it....

I did some research and found two different things. Basically i want to install a SP from management studio on the same server where i am running the script.

BOL...

mmartin1 (12/30/2011)

---

Hi

So from your latest post, I gather you have a synonym to a remote table? That is, it points to a table on another database in the same machine...

SqlMel (12/18/2011)

---

Hmmm... I don't think the SSIS option will be best for you since you stated before that data latency shouldn't exceed 5 seconds.

You can't actually implement database mirroring since...

Roddy.CAMERON (12/19/2011)

---

Hi

I'm slightly puzzled by the issues you may be having with replication. I've used it for years with both Sybase and SQL Server and it's very robust and generally...

ALZDBA (12/16/2011)

---

Maybe you can also use a DTS/SSIS solution to pull over new data every x time, unless your systems need is actually real time or near time.

Did you consider...

sqldba_newbie (12/11/2011)

---

Thanks.That would give me some idea but i...

Eric M Russell (12/15/2011)

---

It seems in my previous example, I misplaced the option (hash group). Below are...

Roust_m (2/2/2009)

---

No, this is not what I want. I don't want a manual process, I want automatic. E.g. a job running every night and scripting all the jobs...

Eric M Russell (12/15/2011)

---

sqldba_newbie (12/15/2011)

---

Eric M Russell (12/15/2011)

---

sqldba_newbie (12/14/2011)

---

sqldba_newbie (12/14/2011)

---

Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when...

Eric M Russell (12/15/2011)

---

sqldba_newbie (12/14/2011)

---

sqldba_newbie (12/14/2011)

---

Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a...

sqldba_newbie (12/14/2011)

---

Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea what...