Is SQLServer Errorlog showing any extra info regardnig dbmail ?

If not, post your dbmail ddl

You've been pointed to the solution 😎

But, what's the reason you want to detach all databases without actually stopping the SQL instance ?

BOL states:

ComputerNamePhysicalNetBIOS

NetBIOS name of the local computer on which the instance of SQL Server is currently running.

For a clustered instance of SQL Server on a failover cluster,...

as you know usage of xp_cmdshell is to be avoided.

We don't use xp_cmdshell out of sysadmin context, but I believe you can grant it by altering settings for sqlagent.

SQLAgent properties...

Did you try to design your form row based.

I'm not an access specialist, but I've done some access 2003 things and didn't have issues with that.

I used a...

ZeeAtl (2/22/2010)

---

Kathi,

A question I have is this about removing BUILTIN\Administrators from Security->Logins on SQL Server [2005] instance.

If I remove this account from Logins, but the domain users remain as Local\Administrator...

Should come to something like this.

SELECT T1.col1

, T3.col3

FROM T1

inner join T2

ON 1...

KISS !!

Just use an alert to launch the job !

Have a look at my little article "help to tighten use of cmdshell or sp_start_job"

http://www.sqlservercentral.com/scripts/Miscellaneous/31032/

This way, you get all...

If you really need to intervene ... use a ddl trigger

If you only need a notification, you might consider the asynchrone path.

example ddl trigger :

create TRIGGER [ddlDatabaseTriggerNonSA]

ON DATABASE...

Did you try his ?

UPDATE E

SET oprefno = R.ReturnValue

from dbo.#Encrypt E

, @ResultSet R

where E.ccno = @ccno

and R.ReturnValue is not null

Maybe even...

Check out %SystemRoot%\Cluster\CluAdmin.exe

it has a command line version ...

Topic "Managing a server cluster from the command line" at Technet:

http://technet.microsoft.com/en-us/library/cc779044%28WS.10%29.aspx

We are using sql server event notifications to capture the audit_login events.

cfr: http://www.sqlservercentral.com/articles/Administration/64974/

This works fine on all our servers, except for one that has +50 logins per second.

If you want...

there is also notification services which allows your application to cache the data locally and only refresh it when it receives a notification message from sqlserver.

I'm not a .net specialist,...

Lamprey13 (2/17/2010)

---

Jeffrey Williams-493691 (2/17/2010)

---

And I would disagree with shrinking a database if you are setting it to read only. Why would you fragment the indexes then set the database...

Just keep in mind extending a file is an expensive operation for your system.

Depending on your db usage, 50% free space may be desired state because of processing needs.

How many...