Yes. Lots.

A script was posted to this forum:

http://www.sqlservercentral.com/scripts/contributions/622.asp

This is not perfect code. If you want it to work in all cercumstances, you'd have to take into account the datatype of each column and exclude identity columns....

declare @latestID int

select @latestID = IDENT_CURRENT('tbl_users')

quote:

---

When you say you can't telnet, what are you getting?

Just a blank screen (nothing seems to come back) or connection refused/could not...

There's no automatic way. You'll have to build a client that will retrieve the image, change the format and then update the database.

quote:

---

I need the swap the value of the column 3 whith other row how do i do this .

---

quote:

---

But Telnet is also a terminal program. So using the terminal program telnet to 1433/tcp won't be affected if a network engineer...

If you use update locks, you should be OK. You can test this by putting in a very long loop in your SP, so that it takes several seconds...

quote:

---

When storing an image into a BLOB field, also insert its extension into a separate column so that when you reconstruct the...

Delete MainTable

From MainTable, #TempTable

Where MainTable.Column = #TempTable.Column

Glad that we cleared that up.

No. Read committed is just a little more restrictive than read uncommitted. It doesn't allow dirty reads, but it doesn't guarantee repeatable reads either. In other words,...

You can assign the processadmin role to allow your user to kill a process. If the user is also db_owner or a member of dbcreator, he can put the db...

quote:

---

The Second SELECT query IS usually NEEDED in a Master-Detail Front-End Type

---

A second query may...

I still have no idea what you said.