is this code unique? or does each user start at 0000 each year

if so then you need to make a trigger for insert that uses something along the lines...

if anyone has any requests for tutorials on specific matters, we are preparing some material for new SQL DBAs and Oracle DBAs making the transition.

we would be happy to...

ok, load up enterprise manager.

it looks like we need to re-register the server on your tools

did you set an sa password at install time?

if so right click on your server...

is there a maintenance plan set up against the database? are there any sql agent jobs running?

if so do they coincide with the time that you get the error....

if you want a small VB app that can insert binary data into a field then email me at michaelv@quantix-uk.com

i'ev got a small app where you choose your database, table...

in SQL 7 you can use the writetext WITH LOG, in SQL 2000 this is ignored and is the same as the database recovery model.

so don't worry about point in...

this is definatley possible.

if you are using ASP pages on your web site then it's just a case of creating an ADO connector and command and then passing the...

is your database in simple mode? the database is proboably performing a checkpoint.

what standard of SQL ? ANSI? T-SQL?

what type of output do you want? text file?

why ot just use the isqlw.exe feature of sql server and the -i -o...

hmm,

i'v been playing with this and i've managed to send emails on my own installation of SQL server 2000.

I'm starting to think that there might be something in my...

depends on the table design, but as a rule i've always found that

(number of bytes per row)*10*(qty rows) gives a reasonable interpretation of what you might get.

it also depends...

yes, the exact syntax of the command is below

xp_sendmail @recipients='SQLSERVER@QUANTIX-UK.COM',@message='Backup sucessfull for database CE 90',@subject='Database backup'

i tried this in query analyser and retyped the whole line by hand to make...

Boost priority should only be used when the server is being used for multiple purposes (such as a web server and SQL server)

The boost priority will only affect the...

OK, have you tried also forcing the connection language settings in your ADO connection string ? this will overide your default language settings.

although i do agree, working in the...