So satisfying when you can improve things like that, well done.

Re1 (11/26/2015)

---

Hi,

The source query is taking very much time to produce the data.

below is a sample query used in source component.

tbl_documents table is having 700 rows and tbl_documentdetails...

John Mitchell-245523 (11/26/2015)

---

Have you tested the individual components of the flow to see where the bottleneck is? How long does it take to run the query locally? How...

Hehe,...

As an alternative, could you restore it with the same name and then

exec sp_renamedb

?

TomThomson (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

Alvin Ramard (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

The spam problem is tough. Believe me, no matter what we do, people will find ways around...

I've suggested this before, but I'll do so again as the spam is driving me mad at the moment.

1) Apply additional rules to new users (< 100 posts, say)

Additional Rules...

With in excess of 600 posts, you really ought to know how to post questions by now.

Please take a look at the best-practice link for advice.

Hi Jon

Just because a database has been created does not mean that CREATE TABLE scripts cannot. On the contrary, if the database did not already exist, you would find it...

Views do not...

GilaMonster (11/24/2015)

---

Happens if the and [ /code] are on the same lime. Put a new line...

I just don't understand what you mean by 'where should I put the message?'

Why do you need to 'put it' anywhere?

If you need it on a Winform, put it into...

Thank you, SSC, for helpfully encoding my 'less than' symbol 😀

dt.Rows.Count < 0

If no rows are returned, the count would equal zero, surely? What makes you think that it would be less than zero?

Sean Lange (11/23/2015)

---

Phil Parkin (11/23/2015)

---

cmc123 (11/23/2015)

---

Hi,

can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .

UPDATE...