if you do

select * from msdb.dbo.sysmail_account

do you see the email address in either the email_address or replyto_address columns?

Got a little but further with this today.

Ran a trace against one instance and noticed the the nodes where trying to login with SQLCMD, so I took a look at...

it would help if we had sample tables, data and what you have tried so far along with what you want the expected result set to be.

if you could provide...

with cte1 as

(

SELECT

ROW_NUMBER() over(partition by peter order by peter) as row_num,

Peter, max(mike) AS mike, steve

FROM ATable

group by peter, steve

)

select * from cte1 where row_num = 1

might be worth...

sejal p gudhka (2/22/2012)

---

Thanks Andrew.......

I got that a.size from sys.database_files stores file size in terms of 8-KB Pages and multiplying that by 8192 is to convert it into KB. So...

sejal p gudhka (2/22/2012)

---

Hi All,

I have a automated script that does Shrinking of the log files in the database. I am not able to understand the logic on how it...

yep i've looked through that already

as its state 11 the login can login but nothing after that, the only thing I can think of is...

if its not 1433 then it must be a named instance, so you will need to enable browser or use the named instance port number to connect

to add

there are no windows scheduled tasks, no linked servers, no ssis packages which span nodes in the cluster except for the management data warehouse data collectors, but this was...

is it a named instance? is the sql browser service started? can you connect by specifing the port on ssms

eg server\instance,1433

anthony.green (2/21/2012)

---

seems like the smtp server is not accepting your IP as an...

have you checked SMTP server is allowing your SQL server to send mail - speak to your email administrator, if using MS Exchange, SMTP Mail Relay requires the IP of...

viduvs (2/21/2012)

---

This was a discussion going on with my previous manager. So I am digging into the policy.

Let's say I have 4 SQL Server R2 Std per processor licenses with...

you should be ok to just continue as normal if the capacity is being increased it should have minimal impact on SQL as I've had to increase data drives on...

In the licencing quick reference you can only move running instances of Enterprise or Data Centre so Standard has to be static on one server and cannot move across the...