Good point Lowell, I have seen that myself. He said he had restarted the services so assumed he had already done that.

You can also use set NEW_BROKER if the db...

can you actually ping the SMTP server from the SQL server box? Are you going through a firewall?

If service broker is running and you've set up the accounts and...

If you moved tables from the file group by rebuilding the clustered index to another file group that will not move any non-clustered indexes on the table(s). You'll have to...

I would probably use a cte, something like this:

;

with MostRecentCalls as (

select CustomerID, max(ID) as callID

from CustomerCalls

group by CustomerID

)

select a.CustomerID, a.CustomerName, ..., C.CallDate, C.CallerID, C.CallDuration, ...

FROM Customers a

...

Are you using the same login for testing the stored proc as that being used to execute the BCP command?

That's just how it works. You could use dynamic SQL to avoid the issue, but make sure you use try - catch to handle any run time permission/connectivity issues.

try it this way:

declare @execmd varchar(4000)

set @execmd = 'execute master..xp_cmdshell ''RENAME "D:\WebFiles\Web Update File Out\*** Update Files\RASS_ASR_ALL.txt" "' + @MyFileNametxt +'"'

exec(@execmd)

Good advice Steve. Too often I've found myself so caught up in work related and other issues to the detriment of being able to more fully appreciate and enjoy the...

Thinking time is important, but only by half. The other half is actually documenting the results of your thinking processes along with any conclusions you came up with.

change your severity to 11

I concur with perry that the pros and cons and pitfalls of virtualization need to be embraced by any well rounded DBA.

For HTML use "

" (that is lessThan BR greaterThan) for line break.

as expected the HTML line break was implemented literally in my reply. 🙂

I agree with your points Steve. Interestingly, I think this dovetails nicely into the "don't criticize the code" discussion. It seems easy to justify ("management made me do it...") release...

L' Eomot Inversé (11/17/2011)

---

sturner (11/16/2011)

---

I despise poorly written code and the reasons are many:

* usually consumes (wastes) precious resources (memory, CPU, I/O)

* exhibits poor concurrency

* poor scalability

* poor documentation

The typical...

majorbloodnock (11/17/2011)

---

That doesn't necessarily excuse the cludge, but it may not be the person who put it in who is ultimately at fault, and I refuse to damn someone...