Bit tricky as you have no identifer on the rows

SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2 ORDER BY Col1, Col2) AS RowNumber,

Col1, Col2

INTO #TEMP

FROM

DuplicateRcordTable

TRUNCATE TABLE DuplicateRcordTable

INSERT INTO DuplicateRcordTable (Col1, Col2)

SELECT...

Perry Whittle (1/29/2013)

---

anthony.green (1/29/2013)

---

Many thanks for that, as I have not worked with mount points before (well not to my better knowledge) I was un aware of that, added to...

Its just a table we have in our monitoring database which contains the list of email addresses for different alerts.

So you just need to replace it with the email addresses...

What is the browser that the TV uses?

If it not IE, you will be limited on functionality as MS only test their products with their products, so SSRS is only...

This is something I knocked up to do the job.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [DBCC].[InsertCheckDBDetails]

AS

BEGIN

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10)...

SSRS Diagnostic Reports - http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/

Deploy it to your SSRS report manager then use the Report Queries report.

That would indicate that your account cannot enumerate if the services are started or not, which would relate to why you cant see them in SSCM.

What permissions does your account...

opc.three (1/26/2013)

---

Win32_LogicalDisk will work in most cases but know...

Going off the base price list for Oracle, a processor license for Oracle Standard is $17,500 a processor. Now they detail that a processor is determined by the number...

Are you familiar with fractions of time?

10th of a second

100th of a second

1000th of a second

etc.

Well a nano second is 1 billionth of a second.

So time is actuate to 100...

Full script including data from the excel sheet for anyone who would like consumable sample data.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TB_WORK_ORDER_AGVEN](

[ORDER_DATE] [char](8) NOT NULL,

[COMMIT_NO] [char](4) NOT NULL,

[BODY_NO]...

Try ROWTERMINATOR of '','+CHAR(10)+''', will need to build it dynamic, might be getting confused as relates to line feed carrage return

DECLARE @bulk_cmd varchar(1000);

SET @bulk_cmd = 'BULK INSERT Table

FROM...

Prices will vary depending on your agreement with MS and what plan you are on, eg Select aggreement, EA aggreement, Open Value, EAP etc etc.

Base price on NL without software...

Synonyms can be created for the following types of objects:

Assembly (CLR) Stored Procedure

Assembly (CLR) Table-valued Function

Assembly (CLR) Scalar Function

Assembly Aggregate (CLR) Aggregate Functions

Replication-filter-procedure

Extended Stored Procedure

SQL Scalar Function

SQL Table-valued Function

SQL Inline-table-valued...

Service account changed?

Service account password expired?