Viewing 14 posts - 1,981 through 1,995 (of 1,995 total)
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...
June 29, 2004 at 7:54 am
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...
June 29, 2004 at 7:46 am
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...
June 29, 2004 at 7:38 am
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....
June 29, 2004 at 7:21 am
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...
June 29, 2004 at 7:09 am
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...
June 29, 2004 at 7:05 am
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...
June 29, 2004 at 6:51 am
is your database in simple mode? the database is proboably performing a checkpoint.
June 29, 2004 at 6:16 am
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...
June 29, 2004 at 6:07 am
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...
June 28, 2004 at 7:28 am
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...
June 28, 2004 at 7:09 am
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...
June 25, 2004 at 8:17 am
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...
June 15, 2004 at 3:18 am
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...
June 15, 2004 at 3:06 am
Viewing 14 posts - 1,981 through 1,995 (of 1,995 total)