Windows Azure SQL Database is a cloud-based relational database from Microsoft. It is a different version that traditional SQL Server.

learn more… | top users | synonyms

0
votes
2answers
177 views

Access 2003 (SQL Server 2000) migration to SQL Azure

As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
3
votes
1answer
983 views

Azure SQL Administrator Can't Access Master Database

I created an SQL server and database. I can log in to the database manage page with my administrator account, and manage the database I created, but when I try to look at the master database, it says: ...
0
votes
1answer
104 views

Bidireccional synchronization between a local Sql Server 2005 database and a SQL Azure database using Sql Data Sync

I need to synchronize an Sql Server 2005 database in an SQL Azure database. In other posts I've read that I can do this using Sql Data Sync but I don't know if SQL Data Sync can make the ...
-1
votes
1answer
668 views

Conditionally INSERTING columns into Table

using SQL Azure and like to insert a data to a table using dynamic Query. No of columns in select statment is dynamic. It will be based on some conditions. Ex: Salary, Code. How can I create a ...
6
votes
0answers
876 views

SQL-08S01 error in FreeTDS/Azure when executing stored proc for a few minutes from Linux (but not from Windows)

I get this error on Linux (Ubuntu and CentOS) when executing a stored proc from Perl/DBI/ODBC/FreeTDS to SQL Azure: [unixODBC][FreeTDS][SQL Server]Read from the server failed (SQL-08S01) I don't ...
2
votes
0answers
58 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
2
votes
0answers
138 views

How do I back up and restore a SQL Azure database?

How do I back up and restore a SQL Azure database? For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account ...
1
vote
0answers
31 views

Creating SQL Azure login for single database

I want to create separate logins for each database we create on a SQL Azure database server which only have read / edit permissions for a single database and do not have drop permissions, and to ...
0
votes
0answers
22 views

MS Azure hard disk setup on a virtual machine

I plan to setup a SQL server on Azure to run several database for web applications. The idea is to setup a virtual network in Azure, then create one SQL server and many virtual machines for web ...
0
votes
0answers
18 views

Azure database copy seems stuck in a loop

I am attempting to refresh a database using CREATE DATBASE name AS COPY OF server.name. After executing the copy statements, I run the following to track the progress: DECLARE @yup INTEGER PRINT ...
0
votes
0answers
15 views

Azure Copy Database Failed

We have four different environments: DEVINT, TEST, STAGE, and PROD, each on their own Azure SQL Database server. I can copy a database between any two of these, using the command CREATE DATABASE mine ...
0
votes
0answers
110 views

Sql Azure: The session limit for the database is 8000 and has been reached

I am getting following exception in SQL Azure, my SQL Server database is a web version, and I am getting this error in SQL Server Management Studio (when connecting). Also this is happening when ...
0
votes
0answers
23 views

Unknown _TransactionIndex table in Azure SQL Database

Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}" It has 1 column, Id, that contains 8 GUIDs. Couldn't find any information about this ...
0
votes
0answers
71 views

Azure SQL VM Can't import dacpac from Azure SQL Database export

When attempting to set up an Infrastructure as a Service POC for our business, I am encountering problems importing the database exported from our Azure SQL Database implementation. I'm getting ...