anu.suresh.hema (4/22/2011)

---

Hi,

I am kind of new to SQLServer and my question involves query timeout in stored procedures.I have a stored procedure that uses "WAITFOR DELAY " and sleeps for say,10...

It will be very difficult to help if you do not provide more information. Please have a look through this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

That will certainly work. If you're on 2008 you'll want to use sqlcmd which should also let you do the same thing. osql is a SQL 2000 tool and AFAIK...

PS I agree with Stefan, favor stored procedures over embedded SQL. There is a section in the article from my previous post that shows an example using a stored procedure...

dianaansari (4/21/2011)

---

I do not know if I am in the right thread, but I am having a SQL issue.

When I debug my web-page it shows me this error:

Must declare...

Ninja's_RGR'us (4/21/2011)

---

Syed Jahanzaib Bin hassan (4/21/2011)

---

can you prove this?

Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so

http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP |...

toddasd (4/21/2011)

---

In the BOL for SET ROWCOUNT, it says

SET ROWCOUNT overrides the SELECT statement TOP keyword if the rowcount is the smaller value.

SET ROWCOUNT is ignored in INSERT, UPDATE,...

Ninja's_RGR'us (4/21/2011)

---

Syed Jahanzaib Bin hassan (4/21/2011)

---

Start the SQL Server Browser service from the

CONTROL-PANAL ->Administrative Tools -> Services

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

I formed a habit from the beginning to explicitly grab one row when...

It's only evidence if someone else quotes you 😀

Clarification please:

"server address" = explicit IP address?

Can you log in using server_name\instance_name?

ip_address\instance_name ?

server_name,port_number ?

You're very welcome 🙂

sqluser1 is a database user associated to the login...so if you do...

Sure, you can use it just like a table...with INSERT INTO, or even as a SELECT INTO.

Well put Steve. Love field involved in a minor (in the grand scheme) mishap, and then your reaction, how appropriate 🙂