mirror access

Can you access a database mirror via sql while it is being mirrored to,
not after failover?Hi,
Create a Snapshot on the mirrored database and Query the snapshot.
Thanks
Hari
SQL Server MVP
"anightintheparishilton" <tj@.realmlist.com> wrote in message
news:1155944106.329642.209720@.i42g2000cwa.googlegroups.com...
> Can you access a database mirror via sql while it is being mirrored to,
> not after failover?
>sql

mirror access

Can you access a database mirror via sql while it is being mirrored to,
not after failover?Hi,
Create a Snapshot on the mirrored database and Query the snapshot.
Thanks
Hari
SQL Server MVP
"anightintheparishilton" <tj@.realmlist.com> wrote in message
news:1155944106.329642.209720@.i42g2000cwa.googlegroups.com...
> Can you access a database mirror via sql while it is being mirrored to,
> not after failover?
>

MIME attachment blocked

We send reports via subscription and the attachments are blocked by
Mailsweeper saying "Invalid base64". It seems that the server encodes the
attachment wrong so it's blocked by mailsweeper. In notepad the "extra"
character is visible. I encoded an attachment locally and no extra characters
displayed. Not sure how to start. Is Reporting Service causing the error
because mails sent via outlook express are going throught. I know Reporting
Service uses the built-in CDO capabilities to send mails but I have no idea
where to start.It's solved with Service Pack 2. It's not mentioned there as a bug fix but I
believe it was fixed regarding the problems they had with Lotus notes domino
Server.
cheer
"Joachim" wrote:
> We send reports via subscription and the attachments are blocked by
> Mailsweeper saying "Invalid base64". It seems that the server encodes the
> attachment wrong so it's blocked by mailsweeper. In notepad the "extra"
> character is visible. I encoded an attachment locally and no extra characters
> displayed. Not sure how to start. Is Reporting Service causing the error
> because mails sent via outlook express are going throught. I know Reporting
> Service uses the built-in CDO capabilities to send mails but I have no idea
> where to start.

Military time

How do I format a DateTime to Military time?
--
Message posted via http://www.sqlmonster.com>How do I format a DateTime to Military time?
If you mean the "normal" 24-hour time format (that the whole world
except the US uses by default - *not* just the military!) :
string sTime = YourDateTime.ToString("HH:mm");
Marc
================================================================Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch

Migration from Oracle 7.34 to SQL 2000

I'm attempting to move a database which currently exists on an old Oracle
7.34 instance and tried to use Data Import via DTS to SQL 2000.
The Oracle database consists of views, indexes,packages,triggers as well as
tables structures. I tried DTS using both the ODBC and OLE for Oracle and
only tables and data came over correctly.
Views it appears were converted into tables. Indexes not at all.
I'm using the Oracle 9.2 client on my workstation.
Any ideas on how I might be able to convert this database over from Oracle?
thks
You'll have to move the code, views, etc manually
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Jack Snow" <mrbrew5510@.hotmail.com> wrote in message
news:tea_c.4190$lv3.2047604@.news4.srv.hcvlny.cv.ne t...
> I'm attempting to move a database which currently exists on an old Oracle
> 7.34 instance and tried to use Data Import via DTS to SQL 2000.
> The Oracle database consists of views, indexes,packages,triggers as well
as
> tables structures. I tried DTS using both the ODBC and OLE for Oracle and
> only tables and data came over correctly.
> Views it appears were converted into tables. Indexes not at all.
> I'm using the Oracle 9.2 client on my workstation.
> Any ideas on how I might be able to convert this database over from
Oracle?
>
> thks
>

Migration from Oracle 7.34 to SQL 2000

I'm attempting to move a database which currently exists on an old Oracle
7.34 instance and tried to use Data Import via DTS to SQL 2000.
The Oracle database consists of views, indexes,packages,triggers as well as
tables structures. I tried DTS using both the ODBC and OLE for Oracle and
only tables and data came over correctly.
Views it appears were converted into tables. Indexes not at all.
I'm using the Oracle 9.2 client on my workstation.
Any ideas on how I might be able to convert this database over from Oracle?
thksYou'll have to move the code, views, etc manually
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Jack Snow" <mrbrew5510@.hotmail.com> wrote in message
news:tea_c.4190$lv3.2047604@.news4.srv.hcvlny.cv.net...
> I'm attempting to move a database which currently exists on an old Oracle
> 7.34 instance and tried to use Data Import via DTS to SQL 2000.
> The Oracle database consists of views, indexes,packages,triggers as well
as
> tables structures. I tried DTS using both the ODBC and OLE for Oracle and
> only tables and data came over correctly.
> Views it appears were converted into tables. Indexes not at all.
> I'm using the Oracle 9.2 client on my workstation.
> Any ideas on how I might be able to convert this database over from
Oracle?
>
> thks
>