--First Day of this Month

select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

vamsikrishnacheruku (3/10/2014)

---

hai i want to get the first date and weekday of every month in a year .

1/jan/2014, monday

...

Group? I assume it is windows security group in AD.

We use "Be made using the login's security Context" without any issue..... Or you may forget to create SPN?

raulggonzalez (1/17/2014)

---

Stuart Davies (1/17/2014)

---

raulggonzalez (1/17/2014)

---

Thanks for the question, but I have to disagree with one of the answers.

I have a number of offline databases in one of my servers and...

kevinsql7 (7/5/2012)

---

Thanks Perry. I have another question related to adding the SP for the SQL Server 2008 R2 Client Tools.

For SQL Server 2008 R2 SP 1, I have found the...

I usually SELECT those "to-be-deleted" rows to check first.... if nothing wrong, then delete.

I don't think Microsoft fixed this issue with the hotfix. We had a SQL2005 with SP2 still having this issue.

After...

My $.02: The SCHEMA_NAME function can only be used in current database. Using sys.schemas will be...

As others mentioned, we can only guess.

From your query, why you use "UNION" and "DISTINCT" at the same time? You can use "UNION ALL" and "DISTINCT". It may save you...

It will create the stat automatically after creating an index.

If no parameter after sp_updatestats, it will update ALL the stats within that database.

Another point is if you drop the sp, the associated permission is dropped as well. You have re-grant. 😉

insert into Case_Review

values

(220, 1, 'Proposed', '2012-04-17 12:01'),

(220, 2, 'Proposed', '2012-04-17 12:02'),

(220, 3, 'Proposed', '2012-04-18 14:37');

Here is the error message:

Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection.

---- Figure out...

My 2c:

Yes, it is possible. And, it is called Merge (?)

What I can think of is that every branch has its own locationID and unique. So, when you merge...

Even if it is a push subscription, you still can query the job history on Distributor, like,

SELECT a.*

FROM msdb.dbo.sysjobhistory a

INNER JOIN msdb.dbo.sysjobs b ON a.job_id...

Here is the code (not exactly) for you start with:

SELECT @i = max(dbo.val(RowNum)), @Date = Max(Real_Date_Time)

FROM tblMedsOverrides

INSERT INTO TempTblCode4Overrides

SELECT CAST(@i + ROW_NUMBER OVER (ORDER BY a.Real_Date_Time) AS nvarchar) + 'M'...