Does uid.test_sp exist in the database NorthWind? And does uid has execute permissions on uid.test_sp?

Have a look at

http://www.sqlservercentral.com/articles/DTS/dtsandglobalvariables/2266/

There they assign values to global variables.

Wow, megajoins.

Do the joinable fields used in the query have an index? (the id fields)

Do the queryfilter fields have an index?

A:

Perhaps an index on T1.OWNER_EMP_ID and an index on...

If it needs to be clustered, always add the "clustered". Defaults can change over time.

You could look for some spacemonitoring-scripts.

A basic loop across the tables and

the stored procedure sp_spaceused might work also.

*edit*

have a look at http://www.sqlservercentral.com/scripts/tables/62545/

There is the deny right that overrules allow. If an user is member of a role which has deny update on table X, the user can't update it even when...

Doesn't AWE require fixed memory instead of dynamic allocating?

Up to date with servicepacks (sp4 has an AWE bug fixed by a hotfix)

Please share your solution

Can you give an example of phone1 and phone2 and the desired result?

Wild guesses:

update members

set [mobile]=phone1 + 'separator' + phone2

where ...

update members

set mobile=firstmatch

from members

inner join

(

select memberid,

CASE PHONE1 like ......

Seems like an ODBC-function.

Is it one table in particular? If so, there might be a corruption problem.

Does the servicepack level of em matches the service pack of the sql server?

Be aware that em...

--sample data

create table reservations

(

RESNO int

,ROOMNO int

,CHECKINDATE datetime

, CHECKOUTDATE datetime

)

insert into reservations

select 1,1,'20080101','20080201'

insert into reservations

select 2,1,'20080301','20080401'

insert into reservations

select 3,1,'20080115','20080116'

insert into reservations

select 4,1,'20071201','20091201'

--gives conflicts

--res1= usually minimum reservation

--res2= usuallymaximum reservation time

select res1.*,res2.*

from reservations...

update mytable

set column1=value1

,column2=value2

,column3=value3

where pkid=recordtoupdateid ?

Have a look at the audit & performance tuning articles on

http://www.sql-server-performance.com/articles/audit/main.aspx

I don't have much experience in Oracle but you could start with the migration documents of Microsoft

to sql server

2000: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true

2005: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx