Regarding domain name for mirroring

Hi guys, may I know whether the domain name needed to be same for the principal server and mirror server in order to get a connection between both the servers and setting up mirroring section successful? Is it possible to use different domain name for both servers for setting up the mirroring section. Can someone share his/her idea or experience like how to setting up the mirroring section and the configuration for the windows before setting up. Thx and hope can get any assistance here.

Best regards,

Hans

Yes, Database Miroring can be setup across two different domains.Please look at the Books Online at http://msdn2.microsoft.com/en-us/library/ms177412.aspx for details.

Refresh selection in Query Analyzer?

I add a new table and I want to see it in my list, I can go to EM and refresh there but it appears I have to close QA in order to see the new table. Is there a refresh option in QA to see my new object?

thx,

Kat

Never Mind, I found it, use F5.

Kat

Referencing a Cell

In reporting services, is there a way to reference a cell?
I need to get an aggregate of the first column of a report. In order to do
it, I was thinking of hiding the value in the first row and then at the end i
will sum up the total of that value in the first row....
I'm wondering if I can resolve the problem by referencing the value of
another cell rather than doing the sum in this cell (like you can in Excel)
as reporting service wont let me....
Thanks for your response...!!Can you give us a laid out example of what you want to do and what you want
to sum?
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"SQLDBA" <SQLDBA@.discussions.microsoft.com> wrote in message
news:63FB27B1-9E10-4C4A-991B-AF54314A3AF2@.microsoft.com...
> In reporting services, is there a way to reference a cell?
> I need to get an aggregate of the first column of a report. In order to do
> it, I was thinking of hiding the value in the first row and then at the
> end i
> will sum up the total of that value in the first row....
> I'm wondering if I can resolve the problem by referencing the value of
> another cell rather than doing the sum in this cell (like you can in
> Excel)
> as reporting service wont let me....
> Thanks for your response...!!
>|||Hi,
You can use the below syntax to sum the values of two or more cells in the
same manner.
= ReportItems!textbox50.Value + ReportItems!textbox51.Value
But you may get some errors notifying that the cells are not in the same
aggregate group.
But from your explanation I guess that you can use Grouping and then use the
below syntax
=Sum(Fields!FieldName1.Value)
Eralper
http://www.kodyaz.com
"Mary Bray [MVP]" wrote:
> Can you give us a laid out example of what you want to do and what you want
> to sum?
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "SQLDBA" <SQLDBA@.discussions.microsoft.com> wrote in message
> news:63FB27B1-9E10-4C4A-991B-AF54314A3AF2@.microsoft.com...
> > In reporting services, is there a way to reference a cell?
> >
> > I need to get an aggregate of the first column of a report. In order to do
> > it, I was thinking of hiding the value in the first row and then at the
> > end i
> > will sum up the total of that value in the first row....
> >
> > I'm wondering if I can resolve the problem by referencing the value of
> > another cell rather than doing the sum in this cell (like you can in
> > Excel)
> > as reporting service wont let me....
> >
> > Thanks for your response...!!
> >
>
>

reference for newbie on trigger and store procedure

hi, good day, i new in trigger and store procedure, can someone please suggest some advice and reference material in order to mastering trigger and store procedure ? thank youstart with sql books online.

reduce trans log size; help needed

Hello,

I am hoping you can help me with the following problem; I need to process
the following steps every couple of hours in order to keep our Sql 2000
database a small as possible (the transaction log is 5x bigger than the db).

1.back-up the entire database
2.truncate the log
3.shrink the log
4.back-up once again.

As you may have determined, I am relatively new to managing a sql server
database and while I have found multiple articles online about the topics I
need to accomplish, I cannot find any actual examples that explain where I
input the coded used to accomplish the above-mentioned steps. I do
understand the theory behind the steps I just do not know how to accomplish
them!

If you know of a well-documented tutorial (Aside from Books Online (F1)),
please point me in the right direction.

Regards.First, create a backup device with whatever name you want. ( I assume you
know how to do this).
Might have to check the syntax on each of these but here goes

1. backup database [your_database_name] to [your_backup_device] with stats,
init
2. backup tran [your_database_name] to [your_backup_device]
3. dbcc shrinkfile 2,truncateonly
4. backup database [your_database_name] to [your_backup_device]

Step 3 above assumes that file 2 is the logfile for your database. You
might have to check this by issuing a select * from sysfiles (in query
analyzer) to make sure that file 2 is the log file.

Hope this helps.

Oscar...

> 1.back-up the entire database
> 2.truncate the log
> 3.shrink the log
> 4.back-up once again.
> As you may have determined, I am relatively new to managing a sql server
> database and while I have found multiple articles online about the topics
I
> need to accomplish, I cannot find any actual examples that explain where I
> input the coded used to accomplish the above-mentioned steps. I do
> understand the theory behind the steps I just do not know how to
accomplish
> them!

reduce trans log size; help needed

Hello,
I am hoping you can help me with the following problem; I need to process
the following steps every couple of hours in order to keep our Sql 2000
database a small as possible (the transaction log is 5x bigger than the db).
1.back-up the entire database
2.truncate the log
3.shrink the log
4.back-up once again.
As you may have determined, I am relatively new to managing a sql server
database and while I have found multiple articles online about the topics I
need to accomplish, I cannot find any actual examples that explain where I
input the coded used to accomplish the above-mentioned steps. I do
understand the theory behind the steps I just do not know how to accomplish
them!
If you know of a well-documented tutorial (Aside from Books Online (F1)),
please point me in the right direction.
Regards.| Hello,
|
| I am hoping you can help me with the following problem; I need to process
| the following steps every couple of hours in order to keep our Sql 2000
| database a small as possible (the transaction log is 5x bigger than the
db).
|
| 1.back-up the entire database
| 2.truncate the log
| 3.shrink the log
| 4.back-up once again.
|
| As you may have determined, I am relatively new to managing a sql server
| database and while I have found multiple articles online about the topics
I
| need to accomplish, I cannot find any actual examples that explain where I
| input the coded used to accomplish the above-mentioned steps. I do
| understand the theory behind the steps I just do not know how to
accomplish
| them!
--
You can create a job that executes the above steps every couple of hours.
You can define each of the above steps as actual job steps with the job.
You can use Enterprise Manager to create this job.
Hope this helps,
--
Eric Cárdenas
SQL Server support