It does a full installation of the...

It looks like the steps you mentioned are correct. From my point of view only one thing is missing:

Before applying the servicepacks I would shut down the Sharepoint sites and...

A LOGIN is used to gain access on the instance-level, but (default) not on the database-level. You need to create a USER within the database and connect this to the...

This can also be solved with the PIVOT function:

if OBJECT_ID('tempdb..#temp') is not null

drop table #temp

create table #temp (userid int, picture varchar(50))

insert into #temp values(1, 'picture1.gif')

insert into #temp values(1, 'picture2.gif')

insert into...

If you can ping the IP-address without the corresponding cluster resource being...

rajborntodare (6/11/2013)

---

I agree with u but exactly happened is this

Out of 4 IP address from 4 different application,

one gets pinged but i can not bring that online.

other 3 doesn't...

please provide an update of all actions you have done since the last post:

- have you checked if perhaps the IP-address is allready in use?

- have you rebooted (if business...

The INSERT statement is not related to the filegroup. The creation statement of the table determines in which filegroup the object is placed. The...

You should...

You are confused about the CASE statement. In this case it does NOT calculate a new value (i.e. 3 - 2 = 1) but it assigns a new value...

Try this (assuming there are default no negative OrderTypes):

select top(1)

oh.OrderType

from OrderHandsets oh

where oh.OrderId = co.OrderId

order by

case oh.Ordertype

when 3 then -2

...

You can also create a function which accepts a single parameter and returns the start of the week for that parameter. You can call this function using CROSS APPLY with...

If you want to have a resultset (multiple valies) into a single variable, you need to declare is as a table variable.

It could also be possible to create a (global...

duplicate post, reply to http://www.sqlservercentral.com/Forums/Topic1462994-391-1.aspx

I'm not sure it this is what you want.

Select DISTINCT

DATENAME(MONTH, dtePostedToWebsiteDate) as Month

,Year(dtePostedToWebsiteDate) as Year

From dtlVacancyPostAudit

Where bitPostToWebSite = 1

GROUP BY dtePostedToWebsiteDate

ORDER BY 2, 1