ScottPletcher (8/19/2014)

---

You should be able to get the spreadsheet into a table by right-clicking on the database to load it into, selecting "Tasks", then "Import Data...", and go thru the...

Thanks everyone , changed and working without error.

ChrisM@Work (3/13/2014)

---

SELECT

EnqueueDate = CAST(m.EnqueueDate AS DATE),

m.Siteid,

s.[SiteID name],

Total = COUNT(*)

FROM MessageQueue m

INNER JOIN SiteID s

ON s.SiteID = m.SiteID

GROUP BY

CAST(m.EnqueueDate AS DATE),

m.Siteid,

s.[SiteID name]

ORDER BY m.EnqueueDate...

Chris

One last thing I hope you can help with.

My current query is :

SELECT EnqueueDate = CAST(EnqueueDate AS DATE), Siteid, COUNT(*) as Total

FROM MessageQueue

GROUP BY CAST(EnqueueDate AS...

Chris

Perfect , thanks very much.

Will work out now what is going on.

Appreciate the assitance

ChrisM@Work (3/13/2014)

---

MickyD (3/13/2014)

---

Hi everyone.

Can someone offers some advice on how to achieve this.

I need to count the number of records that exist for a distinct value in a table.

I.e....

Keith Tate (2/4/2014)

---

I am currently using Ola Hallengren's[/url] backup scripts for my backups and a custom SSIS package that I created to perform my restores and DBCC CHECKDB. The package...

Keith Tate (2/4/2014)

---

As Grant pointed out you really need to perform all of the actions together to have an idea of when the corruption occurred (what day). I always take...

thanks for updates.

All make sense.

Another thought....

I run my DBCC checks weekly , on Sunday evenings.

I run backups daily , and they are retained for 2 days on box then moved to tape.

So I can...

Thanks everyone.

Yes we do have backups, I will get one of them lined up.

thanks for advice.

I get this message when I try to create a new subscription before the wizard starts.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Synonym 'dbo.MSreplication_subscriptions' refers to an...

Thanks all will check and update when I have tested.

Robert klimes (10/3/2013)

---

it may be permissions. Does the agent service have permission to the sharepoint folder? if permissions are correct you could try the actual path instead of mapped drive....

Wow , thanks very much for quick response. Looks like just what I am after.