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...

what is...

please check this link out

http://msdn.microsoft.com/en-us/library/ms175840%28v=sql.90%29.aspx

anthony.green (2/21/2012)

---

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

are you using Exchange? has the servers IP been granted the nessesary access on the...

SQLKnowItAll (2/21/2012)

---

Yes, but this is a 2008 forum and we should still use the tools given to us for the time being. I...

yes that is correct

sp_msforeachdb will execute the query depending on the number of databases you have, so if you have 5 databases it runs the query 5 times.

strange how you...