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

Also state which columns you want to select.

- Only from table1 or from both tables ?

- How can you differentiate both result sets ?

I have a slight impression...

As Elliott W stated, it will not start a second instance of the job.

It will register a message in sqlagent.out that the job was already running. 😎

Keep in mind there is more to service broker than meets the eye !

First read a bit about it, so you know what it is all about and you...

:blink: that also goes for the minor changes in the pricing model(s) ...

if you ever succeed to pull out the needed data from your sqlinstance itself .....

:sick: