its for a sr dba position with oracle and sql server, i've been doing more oracle than sql server, but i have good sql server skills, it just takes longer...

What's your actual experience with data processing? Work? School?

What experience and/or training have you had with MS-SQL?

What versions of SQL have you used? One of your posts indicated...

I guess I'm not understanding, So can you give me an example of a resolution

besides research and bring the database online i dont know what else?

whats the answer?

they are asking me, any good websites with good questions?

sql 2000

not working, in what database am i suppose to run this in?

error is Invalid object name 'sys.dm_db_index_usage_stats'.

but the trigger should only run when the first table is inserted into. So it has to wait til something happens

can you give examples of :

3. Get the last assigned customer prefix

4. Insert (as a set) the new customers, along with the correct customer prefix based on #2,...

i have an insert proc that runs nightly to check for new customers, and if it finds them it inserts them so the entity sequence table should be updated with...

two tables

Customers and EntitySequenceTest

Customers gets updated daily, and when new customerID's are added

the Entity sequence table column CurrentValue is set and when the new CustomerID is inserted...

is this correct

ALTER trigger [MyTrigger] on [dbo].[CustomersTest]

after insert

as

update dbo.EntitySequenceTest

set CurrentValue = EntityID + 1 * (select count(CustomerID) from dbo.CustomersTest)

do i need to take * out?

error Msg 245, Level...

You mean update instead of insert, remember the customer table has 33 as the (value) field already ?

ok what if five records are inserted, and i have another table customer value that reads this customertest table for the new records in the (custid) field and increments the...