Once you kill a process it will not go away until it has rolled back any uncommitted transctions. During this time when you view the process you will see...

If the slow part is when you move the data (item 2) you can try using a data pump in a DTS package. That could make moving the data...

Try this:

SELECT LEFT(fullname,CHARINDEX(' ', fullname, 1) - 1) AS fname,

SUBSTRING(fullname,CHARINDEX(' ', fullname, 1) + 1, LEN(fullname)) AS Lname

FROM tablename

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and...

I don't think you can set priority levels for stored procedures.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.

If the ahoo.com is always at the beginning and always the same length then something like this should work:

UPDATE tablename SET email = RIGHT(email,len(email) - 8)

WHERE LEFT(email,8) = 'ahoo.com'

Robert W....

I think this will work fine as long as you always have 8 digits. Such that the date 1/1/2002 shows as 01012002 and not 112002 and the time for...

Replication is usually set to update changes more frequently than DTS and will comence every time a change is made if that is how you set it up.

However, I believe...

That is the setting that must be changed in order to delete the login from sysxlogins.

Here is the T-SQL command that will set that setting to allow you to delete...

If the login is appearing it has to be somewhere. You can try looking in sysxlogins in the master database. If you don't find it there then you...

Where I work we have 3 major programming departments. One is SQL, another is Cold Fusion for our web site, and the last is VB for our researchers. ...

We used maintenance plans on servers that used SQL Server 7.0 with SP 1 and later with SP 2 before upgrading to SQL Server 2000.

The only problem I remember having...

You can do it like this:

order by

case when x = 1 then col1

when y = 1 then col1

end,

case when x = 1 then cols

end

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading...

Glad to have been of service.

Robert W. Marda

SQL Programmer

bigdough.com

This might work for you after you modify it a bit more:

DECLARE @numcols tinyint,

@count tinyint,

@cmd varchar(200),

@tblname varchar(50)

SET @tblname = 'test'

SET @cmd = 'CREATE TABLE ' + @tblname + '(colid int...

If the intent of this section is to run something like this:

INSERT INTO tablename

EXEC SERVERNAME.DATABASENAME.dbo.spGetEvents @param1

It is failing because it is actually executing this:

EXEC SERVERNAME.DATABASENAME.dbo.spGetEvents @param1

INSERT INTO tablename

You would...