I doubled check and BOL does say " [ @body= ] 'body' Is the body of the e-mail message. The message body is of type nvarchar(max), with a default...

try this

select SUBSTRING(EmailCOL, 1,CHARINDEX('@', EmailCol)-1) AS email from tableA

I look for two things is

CPU: this number can be argued as well, under 50% is good lower is even better and if higher then I look at CPU...

here is one approach....

give them reader access

then use the following script to give them exec SP right to all non system related SP and grant view...

http://www.mssqltips.com/tip.asp?tip=1203

---good luck

USE

GO

/****** Object:...

This is not very easy to track down, since the maintenance task creates an SSIS packasge in the background. You will see that in the error.

My best suggestion is to...

in that case follow this http://www.mssqltips.com/tip.asp?tip=1070

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE @fileDate...

From my experience we were required to keep track of a few thing

1. who was given access to the which DB

2. what they were given access to

3. kept track of...

cant really see why it is blowing up but here is a work around...create a back job(s) to run using the following

--db example

BACKUP DATABASE [te_content] TO DISK =...

someone found this answer on another forum....but it does make since...hope it helps..let us know

"problem due to MS SQL creating a temporary table based on my Insert Statement using the...

also read up on Extended events....

SQL Server 2008 Extended Events - high performance eventing system

They are the new low level, high performance eventing system in SQL Server. They use...

Peformance data collector - can this be a good replacement for other third party tools like IDera --- is nothing close to any of the third party vendors....needs more improvement...

try this.....http://windows.microsoft.com/en-US/windows-vista/Open-a-port-in-Windows-Firewall

oneline rebuilds does not work on standard edition, only enterprise edition!

in order to rebuild the index it needs to create locks....anytime you rebiuld you are dropping and rebuilding the index...

try this....i have had issues on several servers from diff companies 2005 and 2008 think its a bug

here is the work around

run this ---

select DB_ID() --- get the id of...

can you post the statement?