Azure sp_execute_remote / Cross Database query in Sql Azure.

Cross database query is not allowed in Sql Azure. Rather Azure has applied a different logic to use the same. Please check my article before proceeding with "sp_execute_remote " http://an-it-solution.blogspot.in/2017/01/sql-azure-select-from-another-database.html You need to create a SP in "DbCustomers" with the name of "LogEvents_Insert" which will be called by following query. The below...

Share:

Sql azure select from another database / Cross Database connection

Cross database query Sql Azure Azure cross database query performance sql azure select from another database reference to database and/or server name in is not supported in this version of sql server. All the above statements are reference to the issue we face while shifting data from Sql Server to Azure Database. While using Sql Server (Any version) we can reference any database with in Sql...

Share:

How to add Primary Key and Auto Increment on different fields of MySql

 Normal code generated by MySql:- CREATE TABLE `categorymaster` (   `CategoryID` int(11) NOT NULL AUTO_INCREMENT,   `Category` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` int(11) DEFAULT NULL,   PRIMARY KEY (`Category`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; In the above data...

Share:

How to create User Login in Sql Server 2005/2008

How to create User Login in Sql Server 2005/2008 Note - You must be a member of "system admin" to create a new user or database. Following is the steps to create user login in database for database level security :- Step 1 . Open Sql Server >> Enter User Name >> Enter Password >>...

Share:

How to Expose/Access Sql Server to Internet

Task - Expose Sel Server to Internet or Remote Access via IP OS - Windows Server 2008 R2 Sql Version - Sql Server 2008 R2 To expose the server to internet we need open port for sql server (default port is 1433) To open a port in the Windows firewall for TCP access 1. On the Start menu, click Run,...

Share:

Server Application Unavailable IIS Error

Generally the cause of Server Application Unavailable is the .net framework. Error Snapshot For ex. one of our site is in version 1.1 and the recently added site is in 2.0 or later or any other different versions running on the IIS. How to Resolve:- We need to create a new application pool on the...

Share:

How to make a site default on IIS 6 Windows Server 2003

While setting up an new Web server with Windows Server 2003 and IIS 6. I have to set up my own custom domain (for ex. myname.com) as the default site on IIS. Means if I will run the server from IP my custom domain has to run. The process is so, easy we need to setup few things in custom site. Right...

Share:

Windows Event Starting up database DatabaseName

Configuration:- Windows Server 2003 R2 32 bit Sql Express 2008 R2 While checking for server event as a part of maintenance we a information which is occuring after every 1-10 seconds the information is Event "Starting up database DatabaseName" We found the solution and implemnted the same. You need...

Share:

How to set focus on Table row using Javascript

We are developing Application for Google Smart TV and all is going well. We are using Table, Div or some other elements which cannot be focused on using .focus() of java script. We have used Table to show data in one of our page. Our target is to set the focus on first element of table i.e. first row. We tried different solutions suggested on web but nothing worked. All the posts are suggesting...

Share: