I've always found that the best method is nearly always to PULL the data to the detination rather than PUSH it from the source.

with that in mind the Access import/link...

the problem here is that you have placed an auto number in the companies table and defined it as the primary key.

a primary key is defined as the entity that...

if you want to keep up with the latest service pack versions download the micorosft baseline security analyser.

it's free and will tell you all hotfixes and service packs that are...

out of interest is it quicker?

all you are doing here is replicating what the SQL server is doing....

if you are using ADO.net then you can send the query and return a recordset.

the ado recordset...

this should help

select xys from mytable where datepart(dd,mytable.datefield)=datepart(dd,getdate()) and datepart(mm,mytable.datefield)=datepart(mm,getdate())

Cheers

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,...

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...