I've narrowed the problem down. It's something with the Exchange server I use. I was using a domain address (ie. mail.mycompany.com) as the 'Server name' under Database Mail's...

Perry's solution didn't work either. It fixed the error, but the function just returned the input. I ended up concocting a custom function to do the job. ...

There is no validation option in any of the steps

Try this:

CREATE FUNCTION dbo.testfunction (@input varchar(500))

RETURNS varchar(500)

BEGIN

DECLARE @output AS varchar(500)

DECLARE @i AS int

SET @i = 1

SET @output = ''

WHILE @i <= LEN(@input)

BEGIN

IF ASCII(SUBSTRING(@input, @i, 1)) BETWEEN 65 AND 90 OR...

The restart fixed it. Gracias

It was a DB backup operation that took much longer than usual (1 hr vs. 5 + hrs.). I stopped the process and it has been in "Kill/Rollback" mode...

Thanks Michael. I was hoping to avoid the restart, but it looks like there are no alternatives. I've never restarted a server before. Any things to watch...

The rollback has been going on for a day now so I assume it is stuck. Any watchouts that need to be done when restarting the server? Also,...

How do you check if a particular DB is running low on resources?

i tried adding the use statement. It looks like the same problem as before. The script runs endlessly on

It's not a hardware issue. The server cluster hosts multiple databases. This is the only database having problems

Can't find the "Catalog" table. Does your script require an add-on?

I wasn't specifying the database to use. I explicitly designated the DB to use in the session and the names reappeared

Hi Kevin,

Is there a reason why you would need to drop the nonclustered indexes after truncating a table and before inserting new data to prevent fragmentation? I am under...

Inserted an ORDER BY on the non-clustered indexes. Fragmentation improved a little bit, but still looking at 50%-90% per index