Click here to Skip to main content
15,845,308 members

Comments by kishorekke (Top 14 by date)

kishorekke 2-Apr-14 11:14am View    
Thanks for the replay. Actually this is working in my machine but it is giving error on remote server. I have given everyone full permission also. Could you please suggest me wat needs to do.
kishorekke 31-Mar-14 10:07am View    
Everyone full control
kishorekke 25-Jul-12 3:59am View    
first connect to your server2 then write a procedure in ur server2 like below

@server = 'SERVER1',
@srvproduct = 'sqlserver',
@provider = 'SQLOLEDB',
@datasrc = '12.228.0.0' -- Server IP Address

--Create Login Credentitals to The Patron Server
EXEC Master.dbo.SP_ADDLINKEDSRVLOGIN 'SERVER1', 'false', null, 'sa', 'sa'

--Create RPC to Server
EXEC Master.dbo.sp_serveroption @server='SERVER1', @optname='rpc', @optvalue='true'
EXEC Master.dbo.sp_serveroption @server='SERVER1', @optname='rpc out', @optvalue='true'

-- Your query
SELECT * FROM SERVER1.TempDB1.dbo.Source1 S1 INNER JOIN SERVER1.TempDB1.dbo.Source2 S2 ON S1.ID=S2.ID


--Delete the Server link and Login Credentials
EXEC Master.dbo.sp_dropserver 'SERVER1', 'droplogins'
kishorekke 17-Jul-12 8:52am View    
Hi friend thanx for your solution. I want always focus on the popup.
if i use ..
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "var Mleft = (screen.width/2)-(760/2);var Mtop = (screen.height/2)-(700/2);window.open( '39;your_page.aspx?InvoiceID='" + strInvoiceID.ToString();+"', null, 'height=700,width=760,status=yes,toolbar=no,scrollbars=yes,menubar=no,location=no,top=\'+Mtop+\', left=\'+Mleft+\'' ).focus();", true);

This is working in IE9.0 but getting error in IE8.0
Please suggest me, it should work on ie8 also.
Thanks
Kishore
kishorekke 13-Jul-12 7:38am View    
except the above statement.. everything is fine in your procedure