most of the time just restarting the sqlserver service will solve your problem. (depending on the number of operations it needs to rollback)

Reason: at startuptime of a db, all uncomplete...

your statement

ALTER AUTHORIZATION ON consultant.DimConsultantStatus TO dbo;

just tells the system the object consultant.dimconsultantstatus is owned by dbo.

you should use

ALTER SCHEMA dbo TRANSFER consultant.DimConsultantStatus;

GO

Check bol.

Since the title is "where to start" ...

Start using aliasses everywhere to avoid confusion.

(occurs especialy after query maintenance !)

select name

from table1 a

where not exists(select 1 from table2 T2...

varun-jha (12/24/2007)

---

No Dear iam not anger but table('sys.trigger') you specified is not exists

on any databases so how i can get the infornation when the table you specified in the code...

I wouldn't advise to tamper with it, but you might want to script proc [sys].[sp_settriggerorder]

SELECT *

FROM sys.triggers

WHERE parent_ID = OBJECT_ID('HumanResources.Employee')

SQLExpress will at most use 1 Gb of ram

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

- did you perform full dbmaintenance after setup ?

(dbcc dbreindex , sp_updatestats, dbcc updateusage)

- -- checkdb with content-re-eveluation

DBCC CHECKDB (0)...

The log-file can only shrink until the last log-chunck in use.

You'll force it to shrink manualy.

http://support.microsoft.com/kb/q256650/ is for sql7, but also works on sql2000

the refs will clarify it in detail, but ...

- in short a schema is nothing else than a logical rack for objects.

All objects must be member of one...

if you want to completely get rid or the usage of the identity property, you'll have to generate drop/create table statements !!

Keep in mind, that there is a purpose for...

- There shouldn't be an order-dependency in the triggers !!

- sp_settriggerorder allows you to set the First and Last trigger.

(check BOL)

Thanks for yoru replies.

- Indeed the goal is to offload the applications from the db server.

- the spn's should be ok for now as we've set it up using a...

- with sp2 at least implement up to Cumulative Update 2 to fix the first issues with sp2.

We have installed Cumulative update package 4 for sp2.

- I also advise to...

Now .... unleash the beast :w00t::smooooth:

btw: No problems overhere after switching db_level...

- IMO this post is placed in the wrong forum (discuss content posted by BockWoody ??)

- Start with MS SQL2005 upgrade advisor (analysis your sql2000 db)

- fix the problems it...

Indeed, domain service accounts are in use.

The SSIS service account has been granted privileges on MSDB.

My windows account has sysadmin auth at the db-server (sqlserver).