|
Thank you Colin Angus Mackay!
there was very good idea ?can you send me one sample like the subject i want?
|
|
|
|
|
|
Thank you Colin Angus Mackay!
there was very good idea ?can you send me one sample like the subject i want?
rohollahmahmoodiany@yahoo.com
|
|
|
|
|
Seeing the previous thread reminded me of a problem I'll face in a few days. I'm using MSDE (later it will be scaled up to SQL Server, but not for the time being) and I'll need to schedule an automatic backup (and of course, be able to restore it.) 
I've seen BACKUP FROM and RESTORE TO T-SQL commands, but I tried them and couldn't restore the database.
Also, how should I schedule them? Just an SQL script? or should I write a little app that executes those commands using ADO.NET? Also, is it a must that they be run from the machine running the server?
Most of all, I'd like to know how it's done in the real world.
Any pointers or tips are appreciated!!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
With SQL Server, you can create a maintence plan with the enterprise manager, the scheduling is handled by the SQL Server Agent Service. I'm not sure if MSDE has this same service, it might have?
Thats pretty much the process we've used to manage our databases.
|
|
|
|
|
Dan_P wrote:
I'm not sure if MSDE has this same service, it might have?
AFAIK, SQL Server Agent is present in MSDE, but I think I'll have to create the backup plan by hand. I remember seeing an article in MSDN but I can't find it.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi,
I backup my SQL server database to deploy it to another computer. But i don't know that how to restore it on the other computer. What r the steps.
Kindly help me in this regard.
Bye
EsHbAn BaHaDuR
|
|
|
|
|
* Copy the backup file on to the other computer
* In Enterprise Manager, open the tree on to the SQL Server instance running on the other computer (you may have to register the other SQL Server with your local Enterprise Manager if it is not already there - alternatively go to the Enterprise Manager on the other computer)
* Right click on the databases folder icon in Enterprise manager and select All Tasks-->Restore Database
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
You went to Action/All Tasks/Backup Database to back it up, just underneath Backup Database, it says Restore Database. 
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
How get error description (message) associated with @@Error
When i use the FORMATMESSAGE function it's allways returns NULL.
Any ideas ???
------------------------------------
To study, study and only to study
|
|
|
|
|
You can lookup the sysmessages table with the errorID
|
|
|
|
|
However how can i know the details of the error such where it occurs in which line. I need something like i get in sql query analyzer.
------------------------------------
To study, study and only to study
|
|
|
|
|
I'm trying to bind a picture box to my access 2002 Db in vb.net
Here is my code
Dim b As Binding = New Binding("Image", dsComics, "comiclist.ComicCover")<br />
AddHandler b.Format, AddressOf ConvertPicture<br />
Me.picCover.DataBindings.Add(b)<br />
<br />
<br />
<br />
Public Sub ConvertPicture(ByVal Sender As Object, ByVal e As ConvertEventArgs)<br />
Dim b() As Byte = e.Value<br />
Dim ms As MemoryStream = New MemoryStream<br />
ms.Write(b, 0, b.Length)<br />
Dim bmp As Bitmap = New Bitmap(ms)<br />
ms.Close()<br />
e.Value = bmp<br />
<br />
<br />
End Sub
The line in bold is where it bombs, any ideas
BINARY
BINARY
|
|
|
|
|
What is the error message ?
|
|
|
|
|
An unhandled exception of type 'System.ArgumentException' occurred in system.drawing.dll
Additional information: Invalid parameter used.
BINARY
|
|
|
|
|
Are you sure it doesn't bomb on ms.Close().
The docs for the Bitmap(Stream stream) constructor say:
You must keep the stream open for the lifetime of the Bitmap object.
|
|
|
|
|
It may bomb there as well but I haven't gotten that far
BINARY
|
|
|
|
|
Hello,
I have the following stored procedure:
DECLARE @@Cuenta int;
SELECT @@Cuenta = COUNT(*) FROM Recibos_Reimpresiones GROUP BY ID_recibo HAVING (ID_recibo = @ID_recibo);
SET @@Cuenta = @@Cuenta + 1;
INSERT INTO dbo.Recibos_Reimpresiones (ID_recibo, Reimpresion, ID_sesion, FechaHora)
VALUES (@ID_recibo, @@Cuenta, @ID_sesion, GETDATE())
UPDATE Recibos
SET Reimpresiones = (@@Cuenta)
WHERE (ID_recibo = @ID_recibo)Basically what it's trying to do is to get the number of reprintings from the Recibos_Reimpresiones table. If should contain no rows (for a receipt) if it has only been printed once.
When I try to reprint a receipt, a record should be added to this table, stating the number of receipt, and the reprinting number (the first reprinting being one.) Also, the reprint count in the receipt record in Recibos should be updated.
But when I try to run this stored procedure, I get an error saying that the Reimpresion field of the Recibos_Reimpresiones table does not allow NULLs and that the record could not be inserted. That means that @@Cuenta is NULL, and it should be an integer.
So, anyone knows what's happening here? Does COUNT(*) return NULL instead of 0 if no records are present? Ideas on how to fix it?
Thanks!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
You're assuming too much here. I'd be running the first two lines, and then see what your count value is. No, COUNT does not return NULL for 0. Figure out what the count value is, then figure out what the value of your variable is ( I don't see how they could differ ), then keep adding a line at a time, and check to see what each line is doing.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Actually it was returning NULL. So, I fixed it adding this:
IF @@Cuenta IS NULL
SET @@Cuenta = 0;
SET @@Cuenta = @@Cuenta + 1;and now everything works as expected.
At the time I had not a single record in the table, but now that I have some records, I try with a receipt number that has not been reprinted, and it still returns NULL.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Luis Alonso Ramos wrote:
GROUP BY ID_recibo HAVING (ID_recibo = @ID_recibo);
This looks a bit odd to me. When looking for a single return value with an aggregate I've never used a GROUP BY because that is likely to return multiple values. Of course, the HAVING clause will reduce that back to one or zero results.
It would be better to say:
SELECT @@Cuenta = COUNT(*)
FROM Recibos_Reimpresiones
WHERE ID_recibo = @ID_recibo because this is guaranteed to return exactly one result every time, even if there are no records. This would mean that you could get rid of your IF statement that checks if @Cuenta is NULL
Does this help?
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Colin Angus Mackay wrote:
This looks a bit odd to me.
I'm using Access to design most of my stored procedures, and using GROUP BY is the only way I know of using aggregate functions with Access UI (of course, you can always write the SQL code yourself.)
But as this project I'm working in right now grows, I'm writing more and more complex stored procedures, mainly thanks to your teachings here!! thanks!
I just tried your code and it seems to work fine. Thanks again!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
|
i fail to install mysql coz of this
how to solve this??
make all-recursive
make[1]: Entering directory `/root/mysql-3.23.54a'
Making all in include
make[2]: Entering directory `/root/mysql-3.23.54a/include'
make all-am
make[3]: Entering directory `/root/mysql-3.23.54a/include'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/root/mysql-3.23.54a/include'
make[2]: Leaving directory `/root/mysql-3.23.54a/include'
Making all in Docs
make[2]: Entering directory `/root/mysql-3.23.54a/Docs'
make all-am
make[3]: Entering directory `/root/mysql-3.23.54a/Docs'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/root/mysql-3.23.54a/Docs'
make[2]: Leaving directory `/root/mysql-3.23.54a/Docs'
Making all in readline
make[2]: Entering directory `/root/mysql-3.23.54a/readline'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/root/mysql-3.23.54a/readline'
Making all in libmysql
make[2]: Entering directory `/root/mysql-3.23.54a/libmysql'
source='libmysql.c' object='libmysql.lo' libtool=yes \
depfile='.deps/libmysql.Plo' tmpdepfile='.deps/libmysql.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o libmysql.lo `test -f libmysql.c || echo
'./'`libmysql.c
rm -f .libs/libmysql.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF
.deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF
.deps/libmysql.TPlo -o libmysql.o >/dev/null 2>&1
mv -f .libs/libmysql.lo libmysql.lo
source='net.c' object='net.lo' libtool=yes \
depfile='.deps/net.Plo' tmpdepfile='.deps/net.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o net.lo `test -f net.c || echo './'`net.c
rm -f .libs/net.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c net.c -MT net.lo -MD -MP -MF .deps/net.TPlo
-fPIC -DPIC -o .libs/net.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c net.c -MT net.lo -MD -MP -MF .deps/net.TPlo -o
net.o >/dev/null 2>&1
mv -f .libs/net.lo net.lo
source='password.c' object='password.lo' libtool=yes \
depfile='.deps/password.Plo' tmpdepfile='.deps/password.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o password.lo `test -f password.c || echo
'./'`password.c
rm -f .libs/password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c password.c -MT password.lo -MD -MP -MF
.deps/password.TPlo -fPIC -DPIC -o .libs/password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c password.c -MT password.lo -MD -MP -MF
.deps/password.TPlo -o password.o >/dev/null 2>&1
mv -f .libs/password.lo password.lo
source='get_password.c' object='get_password.lo' libtool=yes \
depfile='.deps/get_password.Plo' tmpdepfile='.deps/get_password.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c -o get_password.lo `test -f get_password.c
|| echo './'`get_password.c
rm -f .libs/get_password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c get_password.c -MT get_password.lo -MD -MP -MF
.deps/get_password.TPlo -fPIC -DPIC -o .libs/get_password.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. -O3 -DDBUG_OFF -c get_password.c -MT get_password.lo -MD -MP -MF
.deps/get_password.TPlo -o get_password.o >/dev/null 2>&1
mv -f .libs/get_password.lo get_password.lo
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -rdynamic -o
libmysqlclient.la -rpath /usr/local/mysql/lib/mysql -version-info
10 libmysql.lo net.lo violite.lo password.lo get_password.lo
errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo
my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo
my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo
mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo
typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo
mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo
my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo
default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo
charset.lo hash.lo mf_iocache.lo my_seek.lo my_pread.lo mf_cache.lo
my_gethostbyname.lo my_port.lo getopt.lo getopt1.lo getvar.lo my_lib.lo
strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo
strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo
strcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo
strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl -lm
rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.*
.libs/libmysqlclient.*
gcc -shared libmysql.lo net.lo violite.lo password.lo get_password.lo
errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo
my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo
my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo
mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo
typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo
mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo
my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo
default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo
charset.lo hash.lo mf_iocache.lo my_seek.lo my_pread.lo mf_cache.lo
my_gethostbyname.lo my_port.lo getopt.lo getopt1.lo getvar.lo my_lib.lo
strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo
strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo
strcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo
strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lnsl -lm
-Wl,-soname -Wl,libmysqlclient.so.10 -o .libs/libmysqlclient.so.10.0.0
(cd .libs && rm -f libmysqlclient.so.10 && ln -s
libmysqlclient.so.10.0.0 libmysqlclient.so.10)
(cd .libs && rm -f libmysqlclient.so && ln -s libmysqlclient.so.10.0.0
libmysqlclient.so)
ar cru .libs/libmysqlclient.a libmysql.o net.o violite.o password.o
get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o
my_create.o my_delete.o mf_tempfile.o my_open.o mf_casecnv.o my_read.o
my_write.o errors.o my_error.o my_getwd.o my_div.o mf_pack.o
my_messnc.o mf_dirname.o mf_fn_ext.o mf_wcomp.o typelib.o safemalloc.o
my_alloc.o mf_format.o mf_path.o mf_unixpath.o my_fopen.o my_symlink.o
my_fstream.o mf_loadpath.o my_pthread.o my_thr_init.o thr_mutex.o
mulalloc.o string.o default.o my_compress.o array.o my_once.o list.o
my_net.o charset.o hash.o mf_iocache.o my_seek.o my_pread.o mf_cache.o
my_gethostbyname.o my_port.o getopt.o getopt1.o getvar.o my_lib.o
strmov.o strxmov.o strnmov.o strmake.o strend.o strnlen.o strfill.o
is_prefix.o int2str.o str2int.o strinstr.o strcont.o strcend.o
bchange.o bmove.o bmove_upp.o longlong2str.o strtoull.o strtoll.o
llstr.o ctype.o dbug.o
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la
libmysqlclient.la)
make[2]: Leaving directory `/root/mysql-3.23.54a/libmysql'
Making all in client
make[2]: Entering directory `/root/mysql-3.23.54a/client'
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include
-I./.. -I.. -I.. -O3 -DDBUG_OFF -fno-implicit-templates
-fno-exceptions -fno-rtti -c -o mysql.o `test -f mysql.cc || echo
'./'`mysql.cc
/bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF
-fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysql
mysql.o readline.o sql_string.o completion_hash.o
../readline/libreadline.a -lncurses ../libmysql/libmysqlclient.la -lz
-lcrypt -lnsl -lm
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti
-rdynamic -o .libs/mysql mysql.o readline.o sql_string.o
completion_hash.o ../readline/libreadline.a -lncurses
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -Wl,--rpath
-Wl,/usr/local/mysql/lib/mysql
mysql.o(.text+0x189c): In function `com_source(String*, char*)':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory `/root/mysql-3.23.54a/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/root/mysql-3.23.54a'
make: *** [all] Error 2
|
|
|
|
|
I have three tables:
- Article
- Album
- linkArticleAlbum
I want get a list of all the albums and also have some way of determining whether it is linked to the currently selected article.
What I WANT to do is something like
SELECT
linkArticleAlbum.Article,
Album.ID,
Album.Title
FROM Album LEFT JOIN linkArticleAlbum ON linkArticleAlbum.Album = Album.ID
WHERE linkArticleAlbum.Article = 7 OR linkArticleAlbum.Article IS NULL
Here's what my sample data looks like
Album
------
| ID |
1
2
3
Article
-------
| ID |
7
8
9
linkArticleAlbum
------------------
| Article | Album
7 1
8 1
9 2
As you can see, I won't get a record with Album 2 since my WHERE clause eliminates it.
I'm stuck. Advise anything, including a redesign of my DB. I've apparently done something stupid and my murky brain can't figure it out right now.
········ to die is gain ········
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
