InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 04:37:17 GMT20http://www.sqlservercentral.com/Forums/Topic1454235-2571-1.aspxGet 6 Free Wireless CCTV Camera Quotes for Wireless Surveillance Camera, Wireless CCTV Cameras System. [url=http://www.quotebean.co.uk/buying-services/cctv-cameras/help-to-buy-guides/wireless-cctv-cameras/]Wireless Security Camera[/url] in UK is a popular choice for businesses and organizations of all sizes.Fri, 17 May 2013 23:48:36 GMTyashitiyrhttp://www.sqlservercentral.com/Forums/Topic1436253-2571-1.aspxHi,Does anyone know why Azure does not include Analysis Services? Aside from available Reporting services, what are the alternatives to creating a DW if the source data is in Azure?ThanksWed, 27 Mar 2013 21:56:27 GMTLexahttp://www.sqlservercentral.com/Forums/Topic1385539-2571-1.aspxHello All,I am working on migrating our application on windows Azure, I have migrated our database on sql azure. but for one functionality I am facing issues with. in our application we create a sql jobs through the stored procedure by running the code like[code="other"]EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=@Name, @enabled=1, @notify_level_eventlog=2, -- This will delete the Job on Success. 0 null, 1 success, 2 fail, 3 always @notify_level_email=0, @notify_level_netsend=0, @notify_level_page=0, @delete_level=1, -- This will delete the Job on Success. 0 null, 1 success, 2 fail, 3 always @description=N'Bulk Update price for the User', @category_name=N'[Uncategorized (Local)]', @owner_login_name=N'SA', @job_id = @jobId OUTPUT[/code]Can you please help me to work with SQL Azure. Basically we are looking for solution where we can create the sql jobs through the sql script only like stored procedures.Thank you for your helpyatishFri, 16 Nov 2012 01:47:53 GMTyatish.patilhttp://www.sqlservercentral.com/Forums/Topic864462-2571-1.aspxhi, what is sql azure? i.e., is this related to sql server or other. Any Basic guidelines links plz provider.thanksThu, 11 Feb 2010 23:51:38 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1272681-2571-1.aspxHi All,Could any help me any way by which i can transfer/upload data of sql server 2005 not 2008 to sql azure?Regards,VijayMon, 26 Mar 2012 08:04:43 GMTk.vizayhttp://www.sqlservercentral.com/Forums/Topic1051921-2571-1.aspxAnybody know of a good alternative for a "tally table" on SQL Azure? Like most things useful, this is not supported on SQL Azure:[code="sql"]SELECT Number N FROM master..spt_values WHERE TYPE='P'[/code]Fri, 21 Jan 2011 23:46:39 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic1280728-2571-1.aspxIs the Azure reporting services RTM version released or is it still in CTP?ThanksTue, 10 Apr 2012 06:32:16 GMTsql_dba123http://www.sqlservercentral.com/Forums/Topic1234573-2571-1.aspxDear friends,I am having two different database like 'LiveDB' and 'MFDB'both are having a common table named 'TB_Transaction' now i need to select all record that exist in both databases.when i run the following query:select * from LiveDB.Dbo.TB_Transaction unionselect * from MFDB.Dbo.TB_Transactionthis gives an error.Reference to database and/or server name in 'livedb.dbo.tb_transaction' is not supported in this version of SQL Server.Plz tell me what is the alternate way to accomplish this task.Thu, 12 Jan 2012 02:03:28 GMTshubham.saxena67http://www.sqlservercentral.com/Forums/Topic1078252-2571-1.aspxDear All,Can any one help me to solve the below problem?Thanks in advance.I am using Common Table Expression (CTE) in sql server 2008 to fetch the hierarchy of the users. ;with child_user(user_id, created_by) as ( Select user_id, created_by from User_MAster where user_id= 1195union all select ro.user_id, ro.created_byfrom User_Master rojoin child_user cv on cv.user_id = ro.Created_by )select user_id, created_by from child_user CVWhen I executing the above query, I am getting an error message as displayed "Msg 530, Level 16, State 1, Line 1The statement terminated. The maximum recursion 100 has been exhausted before statement completion."After that I tried include the Option as below ;with child_user(user_id, created_by) as ( Select user_id, created_by from User_MAster where user_id= 1195union all select ro.user_id, ro.created_byfrom User_Master rojoin child_user cv on cv.user_id = ro.Created_by )select user_id, created_by from child_user CVoption (maxrecursion 32765);Even now I am getting same error message with "....maximum recursion 32765...."I had only two records in my master table related to the above user_id.BUt I am geting duplicate rows (32765 records).Please help me to solve the same.Thanks & Regards,Krishna Kumar PTue, 15 Mar 2011 05:53:22 GMTkrishnakumar.palchamyhttp://www.sqlservercentral.com/Forums/Topic1193887-2571-1.aspxI'm just curious if this would work.If I connect to SQL Azure using SSMS on my local machine and the C:\something\something.csv is on my local machine.[code="sql"]DECLARE @sql VARCHAR(255)DECLARE @path VARCHAR(255)DECLARE @filename VARCHAR(255)SET @path = 'C:\something\'SET @filename = 'something.csv'SET @sql = 'BULK INSERT dbo.Plans FROM ''' + @path + @filename + ''' ' + ' WITH ( FIELDTERMINATOR = '','', ROWTERMINATOR = '''', FIRSTROW = 2 ) 'PRINT @sql--EXEC (sql)[/code]Thu, 20 Oct 2011 10:33:27 GMTsmallmoneyhttp://www.sqlservercentral.com/Forums/Topic1136322-2571-1.aspxHi Would anybody be able to help identify a few good articles , etc on SQL Azure.I am looking for something that explains the internals and the basics.ThanksTue, 05 Jul 2011 03:55:54 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1071876-2571-1.aspxHi,I always worked with SQL server and never tried Azure yet. Day before i came up with a new design idea at work place. The idea is to develop a website that would connect Azure on the cloud. The data base will hold trivial data and this web site will allow users to play with it. The second phase of the design says late, this web site will allow users to access conpany's another application already exists on the cloud. So the questions are1) is it ok to have everything on the cloud with little traffic?2) can multiple application may interact with single application? how would they manage API's?3) Can we interact with multiple data providers at the same time, for example bloomberg,factset etc at the same with on the cloud?ThanksWed, 02 Mar 2011 06:39:31 GMTekant_alonehttp://www.sqlservercentral.com/Forums/Topic1069450-2571-1.aspxI am using the SQL Azure Data Sync at https://datasync.sqlazurelabs.com to sync a table between 2 Azure databases on different servers. The initial sync is working fine but I need to re-create due to the addition of a new column.I have deleted the sync group, tracking tabkle, triggers and sync stored procedures in the hub database. When I create a new sync group I am getting an error Invalid column name 'newCol'. This is a sync to a new empty database so I guess the problem is some left over metadata somewhere in the hub (or master) database?Any ideas how to solve this issue or how to re-create a sync when adding new columns?ThanksFri, 25 Feb 2011 01:51:38 GMTDB Danhttp://www.sqlservercentral.com/Forums/Topic1051920-2571-1.aspxAnybody know of a good alternative for a "tally table" on SQL Azure? Of course this is not supported on Azure!SELECT Number NFROM master..spt_values WHERE TYPE='P'Fri, 21 Jan 2011 23:43:38 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic841666-2571-1.aspxI use ADO.NET to connect to SQL Azure. The code worked verywell as a console application.But the code when run as a CLR Proc, threw the following errorA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The requested name is valid, but no data of the requested type was found.)Any pointers?ThanksMon, 04 Jan 2010 12:53:44 GMTharinarayan-414614