I created a Group for "RDCB Computer Objects".

In "Properties>Member" entries Name:RDCB01 & RDCB02 how did the get there?

http://social.technet.microsoft.com/wiki/contents/articles/10393.rd-connection-broker-ha-sql-permissions.aspx

I Inserted into DNS Manager under mysite.com a Host called...

How do you find the SQL Login in SQL Server manager?

http://social.technet.microsoft.com/wiki/contents/articles/10393.rd-connection-broker-ha-sql-permissions.aspx

I have installed "SQL Server 2012" on the first install of "ws 2012". In my RD...

In 2012 R2 in server "WIN-1" I have installed a copy of SQL Server 2012. I have added RDSCB into DNS Manager with a IP Address one up from...

Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"

How do you create "RD Connection Broker having write permission to sql database"?

I am trying to get my head around this Foreign Key stuff.

I have a table: Employees with a column: DepartmentID.

I have another table: Departments with a column: ID that is...

I took out one end; and it still does not work.

Here is my whole program. Before the If works fine.

CREATE PROCEDURE [IncCondense] (@datetime DATETIME, @latin INT) AS

DECLARE @max-2 INT, @min-2 INT, @col3 INT;

INSERT INTO allcount (datetime,Latin)...

OK

Where is the error coming from in CONVERT

from Microsoft site:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] );

data_type is DATETIME

length is 8 because I...

If I take out"

CONVERT (DATETIME, @datetime , 120);

The error says:

CREATE P*****

Is there something wrong with:

CREATE PROCEDURE [IncMaxallcount] (@Latin INT) AS

Then we can concentrate on CONVERT.

Error code:

Is there something wrong with:

CREATE PROCEDURE [IncMaxallcount] (@Latin INT) AS

DECLARE @max-2 INT, @min-2 INT, @col3 INT,@datetime DATETIME;

I tried to use the keyword "CONVERT" to get form "120" or

yyyy-mm-dd hh:mm:ss

The time is in 24hour time.

SET @datetime = Getdate();

CONVERT (DATETIME, @datetime , 120);

It did not work. Any suggestions?

from

Sorry,

Will this work:

DECLARE @datetime DATETIME;

SET @datetime = Getdate();

CONVERT (@datetime , 120);

Is this how you would do it?

DECLARE @datetime DATETIME;

SET @datetime = Getdate();

CONVERT (datetime , 120);

Could conditional do something like this:

CREATE PROCEDURE [IFTHEN] AS

DECLARE @max-2 INT, @min-2 INT;

@min-2=MIN(idt)

,@max=MAX(idt)

FROM test;

BEGIN --PROC

SELECT CASE ((@max-@min)>50000)

THEN

---Execute more SQL commands---

ELSE

---Execute some more SQL...

I went to my 1and1 server. Clicked on MS SQL then Stored Procedures. Selected New Procedure. I copied and pasted the SQL code into the box. Hit Create.

Error:

...