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...

We are running a number of SQL Server instances on VMWare with no problems. Most are dev/test/QA systems, but we do have some production systems also, and we are...

You could at try to roll forward all the way to the end of the last log file, and then run DBCC CHECKDB to see if if there is any...

You can get this information with the PSINFO utility available on the link below.

http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx

Sample command and output:

psinfo \\MyServerName -D disk

PsInfo v1.73 - Local and remote system information viewer

Copyright (C) 2001-2005...