Does sqlagent has sysadmin rights?

Allows a member of the sysadmin fixed server role or db_owner fixed database role to impersonate another user.

<IMG style="MARGIN-LEFT: 0em" height=11 alt="" src="mk:@MSITStore

sp_grantdbaccess grants access to a database

Use sp_grantlogin to reverse the effects of a previous sp_denylogin that has been executed for a Windows NT user.

Use sp_addlogin to allow a SQL Server...

Work Table? You mean a table to dump all your information in for further processing?

With which tool you see <binary> (EM?)

I see the different values with query analyzer.

Since sa is a systemadministrator, they have full access (no permission checking).

If normal accounts are used you can make views

CREATE VIEW ABC AS

SELECT ... FROM ...

WHERE entry.USER_ID= SUSER_SID

WITH...

SCHEMABINDING:

Binds the view to the schema. When SCHEMABINDING is specified, the select_statement must include the two-part names (owner.object) of tables, views, or user-defined functions referenced.

Views or tables...

Any scheduled jobs?

If you know it happens every hour, you could set up a trace for it in sql profiler.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp

lngResult = SQLConfigDataSource(0, _

                                           ODBC_ADD_SYS_DSN, _

                                           "SQL Server", _

                                           "DSN=" & JDS_DSN_name & Chr(0) & _

                                           "Server=" & JDS_Server_name & Chr(0) & _

                                           "Database=SvCvMarketing" & Chr(0) & _

                                           "UseProcForPrepare=Yes"...

there is a setting ANSI_NULLS ON/OFF

ANSI_NULLS ON -> left join (NULL=NULL) =false

ANSI_NULLS OFF -> left join (NULL=NULL) =TRUE

RTRIM('ABCD ') strips off trailing whitespace

http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx

Trace flag 2861 causes SQL Server to cache query plans for trivial queries that have a cost of zero or close to zero. SQL Server typically won't cache plans...

The restrict in the JOIN is preferred since it limits the amount of rows the where clause has to process. (like a virtual table)

They do give the same results at...

This is quite simple using the INSERTED (containing updated values) AND DELETED table (containing deleted values)

CREATE TRIGGER TR_UPDATE_ART_INSERT_TO on ARTTABLE

FOR UPDATE /*only updates*/

AS

SET NOCOUNT ON /*reduce unnecessary roundtrip to client*/

INSERT INTO...

SELECT CLASS_ROOM FROM CLASS MyCLASSES WHERE

EXISTS /*return every matching classroom if there is a related class that fullfills the condition; added CM.CLASS_ID=MyCLASSES.CLASS_ID*/

(

SELECT CLASS_ID FROM CLASS_MODULE CM WHERE YEAR = @YEAR AND...

A reason for sucking up additional nt extents instead of using the available place could be the original fillfactor of an index.

If you had an original table with an index...