Friday, May 24, 2013

[SQL 2012] AlwaysOn in a forest

[SQL 2012] AlwaysOn in a forest

AlwaysOn in a forest

Posted: 24 May 2013 12:34 AM PDT

The requirements for AlwaysOn state that WSFC that contains your replicas needs to be in the same domain. Does this mean the same AD domain Forest or subdomain? Would I be able to have a replica in x.domain.com and y.domain.com?Thanks!

Application Error at Terminal server

Posted: 23 May 2013 07:20 PM PDT

Dear Team, We are recieving an error while using Application through Terminal Service. Operating on which we have configured terminal serverO/S Windwos Server 2008R2 ENT Edition. As per our analysisif same DB server with MS SQL 2012 is used by connecting the application placed locally then no issue occurs.PLease see the error through given URL.[b]http://tinypic.com/r/2r4s9zd/5[/b]RegardsNaveed

Creating a Custom Function (Scalar)

Posted: 23 May 2013 04:25 AM PDT

Hey guys - I'm trying to create a custom Function in SQL 2012 (by following an example in a book) and it's not working. I'm hoping someone can help.This is my custom function. No errors. It executes fine. Simple right?**********************************CREATE FUNCTION fncNotAvailableDisplay (@strInputString varchar(50))RETURNS varchar(20)ASBEGIN If @strInputString IS NULL SET @strInputString = 'Not Available' RETURN @strInputStringEND**************************When I try to use it in a query, I get an error.SELECT Address1, Address2, fncNotAvailableDisplay(Address3) FROM Customers[i]'fncNotAvailableDisplay' is not a recognized built-in function name.[/i]I am using it within the same database. Thoughts??
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog