no one said cursors are bad and should not be used, i have done lots of loops with cursors

and i also wanted to know how this code can be changed...

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

yes your absolutely right I agree table variable is a overhead for this query,

but for any other large queries I can use this method slightly...

Sean Lange (11/21/2014)

---

Damian-167372 (11/21/2014)

---

Two issues here. This doesn't do the same thing as what you posted. The second...and bigger issue is that a while loop is going to be slower...

ok this what i have come up.. so you can do it

DECLARE @tbl_var TABLE( servername varchar (100 ), ...

so your saying you cant loop it through that record set for each server in that server_list table?

Sean Lange (11/21/2014)

---

Thanks, yes...

well you got my answere hope its clear now

Luis Cazares (11/21/2014)

---

What do you think this is? A pizza?

WHILE @@FETCH_STATUS...

ok this is what i do

DECLARE @server_namevarchar(200)

Declare cr cursor for

SELECT server_name FROM dbo.Tbl_ServerList

Open cr

Fetch cr into @server_name

WHILE @@FETCH_STATUS = 0

begin

SET @cmd = 'select *...

is there a way we can do this in WHILE Loop?

this query will just go into a stored procedure only, no functions or any other method.

Thanks,

how about having a seperate server to handle all the FTP upload and download stuff and then SQL server access a shared folder on that server over the network?

Hi

what about open transactions on memory (pages in buffer pool). If that's not taken into consideration, when you attach the database or files on the remote location, you may...

http://kb.mediatemple.net/questions/889/Sending+or+viewing+emails+using+telnet

did you try with [] like

SELECT [ROLE] FROM dbo.Mgr_List_Role WITH (nolock) WHERE id = 'xxx15119'

the Role is a keyword may be that's giving a time out

may be you can try some telnet commands to send an email first and see if there is any ports are blocked to access the smtp server from your server.