mw112009 (1/5/2017)

---

Select top 100 TimeStamp

FROM MHPAPP2.PROVIDERSYSTEM.DBO.AddressGeoCode;

I get the error

Msg 7325, Level 16, State 1, Line 1

Objects exposing columns with CLR types are not allowed in distributed queries....

ramana3327 (1/5/2017)

---

Hi,

We have SQL job scheduled to run in the midnight. Due to the space issue it failed 2 days. After that we added more space but we noticed that...

You would add those permissions to the account in Active Directory.

Sue

Another thing you may want to do is for the response on the alert, you could execute a job that just queries sys.databases to see what the log_reuse_wait value is....

Stuart Davies (1/5/2017)

---

As the title says - I think I'm answering my own question, but periodically I see the front page of the the forums have some pink borders around...

halifaxdal (1/5/2017)

---

I am on 2008R2, trying to update an existing table (70M rows) with a new ID as primary key.

I do have the timeout setting as 0 which presumably...

brianmsbc (1/3/2017)

---

New to this board.... not sure if Access SQL is discussed here, but I need this answer to be resolved for Access SQL.

I have a field that has...

mandavli (1/3/2017)

---

I tried giving library url , some how when deploying process adds / in the beginning.

and deployment fails saying

Error rsInvalidItemPath : The path of the item '/ http://servername/..'...

Rin Sitah (1/4/2017)

---

Hi SSC,

Just a quick question about that proc sp_clean_db_free_space.

When I run it across a database it does take a long time.

If I stop the proc before its finished,...

I usually use Process Monitor to see who/what is accessing the...

If what you want is to extract the service pack files to some specific location, you can execute the service pack exe from the command line and use something along...

Doesn't...

nancy_iles (12/30/2016)

---

I successfully applied 2008R2 SP3 to the Analysis Services and shared services. After the install, I rebooted the computer. Now, I am trying to apply SP3 to the database...

Thanks for getting back and posting that. Now we can see what you are actually executing.

So I used the set statements you originally posted and was able to get...

ramyours2003 (12/29/2016)

---

I need to recommend tempdb files how many needs to created , can nay suggest to recommend how many files needs to be there or else...