Database

Code-Hunt wrote:

Please need suggestion from you guys.

Code-Hunt wrote:

now suppose if there is any power fluctuation like it's coming for 5 min and again going and so on.
So for this kind of situation, how to save the data or how to update the database each second.??

Code-Hunt wrote:

So for this kind of situation, how to save the data or how to update the database each second.??

Code-Hunt wrote:

Is it possible that at a time we update the client database also and server database also.?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

ASPnoob wrote:

Please point out why it does not work

Mycroft Holmes wrote:

the query designer

1. Using the SQL Server Configuration Manager, create an alias[^] pointing to the correct Server2 for the current environment. The alias name should be the same in all environments.
2. In SQL Server Management Studio, create a linked server[^] pointing to the alias you just set up.
3. In your stored procedure, load the data from the linked server.

select distinct xxid FROM CedarsLinkServer.CEDARS.dbo.SomeTestDemographic where recEndDate is null

Msg 7202, Level 11, State 2, Line 1
Could not find server 'CedarsLinkServer' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

--connects to and disconnects from the mysql online database
--example call to connect:
--dbo.LinkedServerConnect_SP @connect = 1
--example call to disconnect:
--dbo.LinkedServerConnect_SP @connect = 0

CREATE PROC dbo.LinkedServerConnect_SP 
(@connect as int)
AS 
BEGIN 

if @connect = 1
begin

	if not exists(select name from sys.servers where name = 'yadayada') 
  	begin	
		
		EXEC sp_addlinkedserver 'yadayada', 'MySQL', 'MSDASQL', Null, Null, 'Driver={MySQL ODBC 3.51 Driver};DB=yadayada;SERVER=mysql.yadayada.com;option=512;uid=yadayada;pwd=yadayada'

	end

end

if @connect = 0
begin

	if exists(select name from sys.servers where name = 'yadayada') 
  	begin	
		
		EXEC sys.sp_dropserver @server = 'yadayada', @droplogins = 'droplogins'; 

	end

end

end

GO