Any known problem or in future a problem in using database name with a space
in it.
Example "North Wind" or "MY DB"If you use a space in the name you must enclose all references to it in
square braces... ie [my db]... I prefer NOT to name dbs this way.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ilovesql" <ilovesql@.hotmail.com> wrote in message
news:O$kMq1zlDHA.1672@.TK2MSFTNGP09.phx.gbl...
> Any known problem or in future a problem in using database name with a
space
> in it.
> Example "North Wind" or "MY DB"
>|||By the way... If you include spaces, you may run into software that does NOT
use square braces, which means the software would not work against your db.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"ilovesql" <ilovesql@.hotmail.com> wrote in message
news:O$kMq1zlDHA.1672@.TK2MSFTNGP09.phx.gbl...
> Any known problem or in future a problem in using database name with a
space
> in it.
> Example "North Wind" or "MY DB"
>sql
Showing posts with label example. Show all posts
Showing posts with label example. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Database mirroring technical matters
Hello,
I would like to setup SQL 2005 database mirroring. Prior to this, I would
like to know if there are some technical prerequisites? For example, to do a
transactional replication, all tables need to have a primary key... Is there
the same kind of troubles with database mirroring?
How are handled the identity columns with mirroring when we make a recovery
after failure?
How are handled the triggers? Are they desactivated on the backup database?
Thanks a lot,
Eric.Mirroring doesn't work in the same way as replication. It is based on replic
ating the log records,
not re-generating the SQL statements from the log, like transaction replicat
ion does). Since *the
effect* of every modification is mirrored to the mirror database, it will be
in the very same shape
as the principal database. (Well, if you go async, you could lose some commi
tted transactions, but
that is a trade-off you have to think about.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"itparis" <itparis@.discussions.microsoft.com> wrote in message
news:842CEE8B-29E4-4A38-BA9F-7881406C8E97@.microsoft.com...
> Hello,
> I would like to setup SQL 2005 database mirroring. Prior to this, I would
> like to know if there are some technical prerequisites? For example, to do
a
> transactional replication, all tables need to have a primary key... Is the
re
> the same kind of troubles with database mirroring?
> How are handled the identity columns with mirroring when we make a recover
y
> after failure?
> How are handled the triggers? Are they desactivated on the backup database
?
> Thanks a lot,
> Eric.
I would like to setup SQL 2005 database mirroring. Prior to this, I would
like to know if there are some technical prerequisites? For example, to do a
transactional replication, all tables need to have a primary key... Is there
the same kind of troubles with database mirroring?
How are handled the identity columns with mirroring when we make a recovery
after failure?
How are handled the triggers? Are they desactivated on the backup database?
Thanks a lot,
Eric.Mirroring doesn't work in the same way as replication. It is based on replic
ating the log records,
not re-generating the SQL statements from the log, like transaction replicat
ion does). Since *the
effect* of every modification is mirrored to the mirror database, it will be
in the very same shape
as the principal database. (Well, if you go async, you could lose some commi
tted transactions, but
that is a trade-off you have to think about.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"itparis" <itparis@.discussions.microsoft.com> wrote in message
news:842CEE8B-29E4-4A38-BA9F-7881406C8E97@.microsoft.com...
> Hello,
> I would like to setup SQL 2005 database mirroring. Prior to this, I would
> like to know if there are some technical prerequisites? For example, to do
a
> transactional replication, all tables need to have a primary key... Is the
re
> the same kind of troubles with database mirroring?
> How are handled the identity columns with mirroring when we make a recover
y
> after failure?
> How are handled the triggers? Are they desactivated on the backup database
?
> Thanks a lot,
> Eric.
Database mirroring technical matters
Hello,
I would like to setup SQL 2005 database mirroring. Prior to this, I would
like to know if there are some technical prerequisites? For example, to do a
transactional replication, all tables need to have a primary key... Is there
the same kind of troubles with database mirroring?
How are handled the identity columns with mirroring when we make a recovery
after failure?
How are handled the triggers? Are they desactivated on the backup database?
Thanks a lot,
Eric.Mirroring doesn't work in the same way as replication. It is based on replicating the log records,
not re-generating the SQL statements from the log, like transaction replication does). Since *the
effect* of every modification is mirrored to the mirror database, it will be in the very same shape
as the principal database. (Well, if you go async, you could lose some committed transactions, but
that is a trade-off you have to think about.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"itparis" <itparis@.discussions.microsoft.com> wrote in message
news:842CEE8B-29E4-4A38-BA9F-7881406C8E97@.microsoft.com...
> Hello,
> I would like to setup SQL 2005 database mirroring. Prior to this, I would
> like to know if there are some technical prerequisites? For example, to do a
> transactional replication, all tables need to have a primary key... Is there
> the same kind of troubles with database mirroring?
> How are handled the identity columns with mirroring when we make a recovery
> after failure?
> How are handled the triggers? Are they desactivated on the backup database?
> Thanks a lot,
> Eric.
I would like to setup SQL 2005 database mirroring. Prior to this, I would
like to know if there are some technical prerequisites? For example, to do a
transactional replication, all tables need to have a primary key... Is there
the same kind of troubles with database mirroring?
How are handled the identity columns with mirroring when we make a recovery
after failure?
How are handled the triggers? Are they desactivated on the backup database?
Thanks a lot,
Eric.Mirroring doesn't work in the same way as replication. It is based on replicating the log records,
not re-generating the SQL statements from the log, like transaction replication does). Since *the
effect* of every modification is mirrored to the mirror database, it will be in the very same shape
as the principal database. (Well, if you go async, you could lose some committed transactions, but
that is a trade-off you have to think about.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"itparis" <itparis@.discussions.microsoft.com> wrote in message
news:842CEE8B-29E4-4A38-BA9F-7881406C8E97@.microsoft.com...
> Hello,
> I would like to setup SQL 2005 database mirroring. Prior to this, I would
> like to know if there are some technical prerequisites? For example, to do a
> transactional replication, all tables need to have a primary key... Is there
> the same kind of troubles with database mirroring?
> How are handled the identity columns with mirroring when we make a recovery
> after failure?
> How are handled the triggers? Are they desactivated on the backup database?
> Thanks a lot,
> Eric.
Sunday, February 19, 2012
Database Mail
Is it possible to configure Database Mail in SQL Server 2005 to process incoming messages? For example , if you wanted to insert a record into a message table every time a mail was sent to the address sample@.widgets.not and/or possibly process some additional notifications based on the content/subject of the message. If anyone could point me to any articles (assuming it's possible) I would appreciate it.
Thanks!
Database Mail only supports sending mail in SQL Server 2005.
Subscribe to:
Posts (Atom)