Viewing 12 posts - 1,981 through 1,993 (of 1,993 total)
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...
MVDBA
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....
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
June 29, 2004 at 6:51 am
is your database in simple mode? the database is proboably performing a checkpoint.
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
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...
MVDBA
June 15, 2004 at 3:06 am
Viewing 12 posts - 1,981 through 1,993 (of 1,993 total)