Bulk insert will by default ignore constraints and triggers. If you want to check triggers and constraints when using bulk insert then you have to specify in a with clause...

Oops I obviously meant net send. Here have an example too

xp_cmdshell 'net send Bblogs big fluffy pupppies'

and just in case your trying to forget dos as well!

NET SEND {name |...

you could use xp_cmdshell and call netsend with it. Although again you'll need to have some way of picking the correct user or computer to send it to.

Dave

You could have a look at this

http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

Also do note there is a big difference in the way triggers are implemented to. So if you use them they will...

You have stopped the sql server services haven't you?

Use the service manager to check.

Cory

It's quite difficult with a lot of data to look through and find duplicate records. Have you tried a query of the form

SELECT PRIMARY_KEY

FROM TABLE

GROUP BY PRIMARY_KEY

HAVING COUNT(*) >...

You can get it to run on 2003 I had to do it to retrieve info from a very old database but i wouldn't advise running it for real.

I'd upgrade...

Ansi padding when set to on stops the trailing blanks in character values being trimmed when they are inserted into varchar columns, i think it does the same with vabinary.

Ansi...

The following articles will tell you how to do it

http://www.sqlteam.com/item.asp?ItemID=3331

http://www.sql-server-performance.com/rd_delete_duplicates.asp

There is also an article on technet about how to do this

Dave

Augusto

I'm assuming from what you've said that column a is not unique.

There is two differnt ways of doing this both involving triggers depending on what you require. Basically do you...

Peg

That wasn't what I meant. For your query as posted to return a result each Grade entry for each row would need to be K and 1 and 2...

Not sure what you're trying to achieve but don't you really mean this?

select school_code, grade, NoStudents, FinalSubmit from spring_2004_data

where

(grade='k' and ((NoStudents='N' and FinalSubmit='Y') or NoStudents='Y')) or

...

I've got jobs that rebuild the indexes on my user databases and a script for defragmenting them when they become too defragmented but it just whether this should be extended...

How much memory do you have in your server.

I dont believe dbcc perfmon will give an accurate cache hit ratio in configurations where AWE is enabled.

Have tried monitoring the server...

I'd put the logs on Raid 1 myself you don't really won't to lose them if a disk fails. Which they seem to be doing a lot more in recent...