Saggy (2/17/2012)

---

Date2/17/2012 8:59:07 PM

LogDatabase Mail (Database Mail Log)

Log ID7

Process ID6836

Mail Item ID3

Last Modified2/17/2012 8:59:07 PM

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server...

thanks, its an animated gif, but some reason the animation is not happening.

what have you tried, whats not working and what errors are you getting?

take a look at "sp_change_users_login" and "alter user"

The error says authentication, so take a look there first.

bad username and password?

SMTP server allows the SQL server to send SMTP mail?

using no authentication when SMTP needs authentication?

ask your SMTP...

Firewall blocking SMTP port?

SMTP server not allowing your IP to send mail?

AntiVirus blocking mass mail?

Authentication?

The error says authentication so check you mail server authentication and ensure that user has access...

I would use version control software like TFS giving each change of the package a version number allowing you to get a specific version out of source control

if you can do side by side then this is by far the best approch to upgrading.

you could do side by side now, but would mean you need to create...

Messy but works

DECLARE @Date DATETIME

DECLARE @Tab TABLE (Y VARCHAR(4), M VARCHAR(2), D VARCHAR(2), T VARCHAR(11))

SELECT @Date = DATEADD(HOUR, DATEDIFF(HOUR, 0, GETDATE() ), 0)

INSERT INTO

@Tab

SELECT

DATEPART(YEAR,@DATE),

DATEPART(MONTH,@DATE),

DATEPART(DAY,@DATE),

CASE DATEPART(HOUR,@DATE)

WHEN 00 THEN '00:00:00 AM'

WHEN...

just wondering, do you know where iteration capacity and individual capacity is stored in the warehouse so we can see if a iteration or person is over or under estimate...

http://support.microsoft.com/kb/307487

if you cant shrink the file it means something is using the space, find out what, kill the session drop the object etc then shrink the file

i wouldnt shrink tempdb...

first thing I would look at is what caused tempdb to grow, index rebuilds being done in tempdb, excessive sort operations, increased number of temp tables table variables etc.

shrinking the...

yep through powershell, there is a variable at the top for the servername, think its set to localhost as default in the script.

make sure you have c:\temp directory as well...

baabhu (2/16/2012)

---

Hi Bhuvanesh,

I am not trying to reclaim the space. But I am just curious what will happen if the empty space is available in the data files. As...

I'm pretty sure this cannot be done, as I believe you have to restore the filegroup back to the original database it was backed up from, as I had an...