you're mis-spelling the title in your query somehow. make sure it is exactly what it is in the database, that there are no hidden characters in the field and, if...

I'll leave 2 GB memory for the OS

And stop truncating your logs manually

John Bates (5/27/2008)

---

At first glance, I tend to disagree. I don't always know which features will be used in the long-term on a new SQL Server. So I install AS,IS...

one other approach is to give it a default value, then drop the default constraint.

i'll use windows authentication and create AD groups. grant access to groups not individual accounts

i'd add index to filename with a generous fillfactor, say 70. and i'd rebuild indexes at least weekly.

did u test performance with index?

u already know the advantages. here are the disadvantages:

- u become somewhat disconnected from the day to day goings on

- u may start to be overlooked -- out of sight...

create a sql server agent job to execute the dts.

or in EM just right click job and click "schedule" which will create the job for u.

what field(s) is ix_tablename on? need to make sure no dupes (including source and existing rows in destination) in that field (or fields) including nulls.

New - Intermediate level:

SQL Server 2000 Administrators Pocket Handbook from Microsoft

touches on all phases of administration

Intermediate to Advanced

SQL Server 2000 Performance and Tuning handbook by Ken England.

this is an indespensable...

sometimes it is valid to put custom SPs in master or msdb.

suppose you want an sp to be globally accessible? put it in master, prefix it sp_ all set. yes...

or

SELECT @@version

may be able to help of u post what u have

here's an SP. problem making a function is the need for dynamic sql, but maybe this wlll get u going in the right direction

Create Proc usp_objName

@object_id int,

@db_id smallint

AS

Declare...