If would be easier to help you with your query if you posted the code for it.

The LIKE operator is meant for use with character data, not numbers. Also, float is a very poor choice to use as an identifier.

This would be the best way...

Try this code:

declare @handle1 binary(20)

declare @handle2 binary(20)

--select * from sysprocesses

declare @handle1 binary(20)

declare @handle2 binary(20)

selecttop 1

@handle1 = a.sql_handle,

@handle2 = b.sql_handle

from

master..sysprocesses a

join

master..sysprocesses b

on a.blocked = b.spid and a.spid <> b.spid

where

a.blocked <> 0

if...

Sometimes you just have to step up and tell them you have a better plan. Most bosses would be grateful to have someone that keeps them from making a...

Another approach is to setup a new server, move the databases to that, and rename the new server to the old server name when you are ready. By restoring the...

I would recommend just adding another array to the system, create an new partition and format it, and then create new database files in the existing filegroups on the new...

This is really a hardware question about your particular hardware, not a SQL Server question.

That said, I have my doubts about it, and I wouldn’t want to try it on...

The answer is yes.

You can create a stored procedure with EXECUTE AS 'user' that creates the view, and grant them execute permission on the stored procedure. It would not be necessary to...

As Jeff said, you can guess, but the amount of time it takes is also dependant on the other activity on the system, especially activity on the table you are...

select

Replaced = replace(Mycol,'%','')

from

(

Select MyCol = 'XXX%BB%KKK'union all

Select MyCol = '%zzzKKK'union all

Select MyCol = 'XXXDDDBBKKK'

) a

where

a.MyCol like '%^%%' escape '^'

Results:

Replaced

----------------------

XXXBBKKK

zzzKKK

(2 row(s) affected)

Not to mention that the OP...

In your SQL Statement, did you specify the database where the stored procedure is located?

If not, it will execute in the context to your default database, which is usually master.

Did you set the database context correctly?

Jim Russell (1/10/2008)

---

Jeff, once I thought there was at least one more exception to the rule:

"Each new query window creates it's own connection or "session" to the database."

From a...