Reg: Table data changes auditing

Hi,

I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.

One way is i have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write.

Is thesre any other way to find the updated,inserted tables when data is changing from application.

Regards

Hanu

hi,

You may get more help posting it in

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

SQL Server Database Engine forum

Although i maybe wrong

Good luck

Matt

reg: ssis

i m new to ssis, pls give me any e-books and some basic ideas about it.

The web has plenty of resources. You could start by looking at Books On Line and the toturial:

http://msdn2.microsoft.com/en-us/library/ms141767.aspx

http://msdn2.microsoft.com/en-us/library/ms169620.aspx

sql

Reg: SqlServer Data Type

Hi
Can you please explain the difference between Text and nText data type in
SqlServer and at what situation we have to use this.
Siva.ntext is national text and it is used for storing unicode data.
text is used for storing non-unicode data
ntext occupies twice the size for storing the same data as in text
ntext supports all characters defined in unicode standard.|||and this is from BOL.. if you had not already seen it.
Using Unicode Data
The Unicode specification defines a single encoding scheme for most
characters widely used in businesses around the world. All computers
consistently translate the bit patterns in Unicode data into characters usin
g
the single Unicode specification. This ensures that the same bit pattern is
always converted to the same character on all computers. Data can be freely
transferred from one database or computer to another without concern that th
e
receiving system will translate the bit patterns into characters incorrectly
.
One problem with data types that use 1 byte to encode each character is that
the data type can only represent 256 different characters. This forces
multiple encoding specifications (or code pages) for different alphabets suc
h
as European alphabets, which are relatively small. It is also impossible to
handle systems such as the Japanese Kanji or Korean Hangul alphabets that
have thousands of characters.
Each Microsoft? SQL Server? collation has a code page that defines what
patterns of bits represent each character in char, varchar, and text values.
Individual columns and character constants can be assigned a different code
page. Client computers use the code page associated with the operating syste
m
locale to interpret character bit patterns. There are many different code
pages. Some characters appear on some code pages, but not on others. Some
characters are defined with one bit pattern on some code pages, and with a
different bit pattern on other code pages. When you build international
systems that must handle different languages, it becomes difficult to pick
code pages for all the computers that meet the language requirements of
multiple countries. It is also difficult to ensure that every computer
performs the correct translations when interfacing with a system using a
different code page.
The Unicode specification addresses this problem by using 2 bytes to encode
each character. There are enough different patterns (65,536) in 2 bytes for
a
single specification covering the most common business languages. Because al
l
Unicode systems consistently use the same bit patterns to represent all
characters, there is no problem with characters being converted incorrectly
when moving from one system to another. You can minimize character conversio
n
issues by using Unicode data types throughout your system.
In Microsoft SQL Server, these data types support Unicode data:
nchar
nvarchar
ntext
Note The n prefix for these data types comes from the SQL-92 standard for
National (Unicode) data types.
Use of nchar, nvarchar, and ntext is the same as char, varchar, and text,
respectively, except that:
Unicode supports a wider range of characters.
More space is needed to store Unicode characters.
The maximum size of nchar and nvarchar columns is 4,000 characters, not
8,000 characters like char and varchar.
Unicode constants are specified with a leading N: N'A Unicode string'.
All Unicode data uses the same Unicode code page. Collations do not control
the code page used for Unicode columns, only attributes such as comparison
rules and case sensitivity.|||SivaprakashShanmugam a écrit :
> Hi
> Can you please explain the difference between Text and nText data type in
> SqlServer and at what situation we have to use this.
NTEXT is encoded as UNICODE wich use 2 byte per chars
TEXT is encoded as ASCII wich use 1 byte per chars
This mean :
1) the amount of data is double while using NTEXT so the perfs whyle
retrieving data will be slower
2) only NTEXT an be use simultaneously by many alphabets like latin,
gr, cyrilic, hebrew, japanese, chinese...
A +

> Siva.
Frédéric BROUARD, MVP SQL Server, expert bases de données et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************

Reg: Query Performence

Below query output results time taking very much.

SELECT NON EMPTY

{[Measures].[Score]} ON COLUMNS,

NON EMPTY {

(DESCENDANTS({[Organisation].[Organisation].&[36]},0),

[Question].[Type Id].[Category Id],

[Question].[Type Description].[Category Description],

[Question].[Short Description].[Short Description]

)}

HAVING [Measures].[Points]>0 ON ROWS

FROM (SELECT [Assignment].[Id].&[1] ON COLUMNS

FROM [Sample])

Total 7 dimensions 2 measure groups

Fact Table : 18,000,00 Records

Dimensions: 2000 Records

[Organisation].[Organisation] having 9 levels

like

Level1

Level2

LEVEl3

Is there any solution to improve the query performence.Any steps to inreasing performence of cube. Please help me. this is urgent for me

Could you please rewrite your query in terms of AdventureWorks?

Reg: Exporting to CSV Format

Hi,
Is there any facility to restrict the dataset not to display the textbox
more than once when exporting to CSV format,when textbox value displays group
value(text).
Many ThanksPlease ignore this one.
prasad
"VP" wrote:
> Hi,
> Is there any facility to restrict the dataset not to display the textbox
> more than once when exporting to CSV format,when textbox value displays group
> value(text).
> Many Thanks
>
>
>|||Hi,
I want to create a CSV or comma delimited file from four MSSQL databases
running on one server. Can anyone assist me?
"VP" wrote:
> Hi,
> Is there any facility to restrict the dataset not to display the textbox
> more than once when exporting to CSV format,when textbox value displays group
> value(text).
> Many Thanks
>
>
>

Reg: Duplicates Removing Problem

I have Data like below

TableA

Col1 Col2 Col3

1 'Test One' 4/7/2007

1 'Test One-1' 4/7/2007

2 'Test' 4/7/2007

3 'Test Three' 4/7/2007

3 'Test Three-1' 4/7/2007

3 'Test Three-2' 4/7/2007

I need to delete the duplicate records[Latest record has to be remaining like that] from above table. i need the out put like below

Col1 Col2 Col3

1 'Test One-1' 4/7/2007

2 'Test' 4/7/2007

3 'Test Three-2' 4/7/2007

If any body know the solution please help me.

Regards

Hanu

You'll want something along the lines of:

SELECT Col1, MAX(Col2), MAX(Col3)

FROM Table

GROUP BY Col1

However, you will probably come into problems with the Col2 values as on character MAX finds the highest value in the collating sequence which may or may not be accurate.

To do latest record, you'd be better off using something like a datetime field (with time) and then something like this.

SELECT t.Col1, t.Col2, t.Col3

FROM Table t

INNER JOIN (SELECT Col1, MAX(Col3) AS Col3

FROM Table
GROUP BY Col1) AS Mx

ON t.Col1 = Mx.Col1 AND t.Col3 = Mx.Col3

Hope this helps!

|||

Unless you expand Col3 to a full datetime datatype column, including the time, there is no way, as you have presented the data, to determine which row of data is the 'Latest record'.

Or you could add an IDENTITY column to the table. Or some what to determine sequence of rows.

Currently, you have none.

|||I think it's worth mentioning that the results of the query richbrownesq suggested are not guaranteed to be in the original table, as MAX(Col2) and MAX(Col3) could come from different rows of the table.

If you have a column, say dateInserted, from which you can determine which row is "latest," you can do this in SQL Server 2000 [not tested in a repro]

SQL Server 2000

delete from t
where exists (
select * from t as t_copy
where t_copy.Col1 = t.Col2
and t_copy.dateInserted > t.dateInserted
)

In other words, delete all rows that are superseded by a later row for the same Col1 value.

In SQL Server 2005, it may be more efficient to do this:

SQL Server 2005

with t_ranked as (

select
*,
rank() over (
partition by Col1
order by dateInserted desc
) as rk
from T
)
delete from T_ranked
where rk > 1

Both solutions will leave multiple rows for a single Col1 if they are tied for latest dateInserted value.

Steve Kass
Drew University
http://www.stevekass.com
|||

Arnie Rowland wrote:

Unless you expand Col3 to a full datetime datatype column, including the time, there is no way, as you have presented the data, to determine which row of data is the 'Latest record'.

Or you could add an IDENTITY column to the table. Or some what to determine sequence of rows.

Currently, you have none.

On the contrary Column2 shows the chronology.

I'll post the query later. I'm in the middle of something right now.

Adamus

|||

Technically there are not duplicates with the exception of col1 + col3. Col2 makes the record unique

To get the desired resultset, grab the right(max) from Col2 (if one exists) and group Col1

Adamus

|||

While that 'may' be true, when handling the data, whether using MAX() or [ ORDER BY ], there will be significant ambiguity when the count gets up to 'Test Three-10'.

How would you 'easily' determine the sequence of the following (without having to parse)?

'Test Three-1'

'Test Three-10'

'Test Three-11'

'Test Three-2'

'Test Three-3'

'Test Three-4'

'Test Three-5'

'Test Three-6'

'Test Three-7'

'Test Three-8'

'Test Three-9'

|||

Arnie Rowland wrote:

While that 'may' be true, when handling the data, whether using MAX() or [ ORDER BY ], there will be significant ambiguity when the count gets up to 'Test Three-10'.

How would you 'easily' determine the sequence of the following (without having to parse)?

'Test Three-1'

'Test Three-10'

'Test Three-11'

'Test Three-2'

'Test Three-3'

'Test Three-4'

'Test Three-5'

'Test Three-6'

'Test Three-7'

'Test Three-8'

'Test Three-9'

You cannot avoid parsing when dealing with strings nor should you resort to the 'easy' and quick.

Adamus

|||

Arnie Rowland wrote:

...there will be significant ambiguity...

As an FYI there is no ambiguity in uniqueness regardless of datatype. Just because a string scares you, doesn't mean you should coin it ambiguous.

Adamus

|||

Adam

It would better demonstate a desire to helpfully contribute to the forums were you to offer constructive suggestions to solve the OP's problem.

As I indicated earlier, Col2 provides no way to determine the chronology of data added to the database. The nature of the data may lead one to 'assume' a sequence, but, as indicated earlier, as the data is presented, it is not possible to determine if 'Test Three-2' is entered BEFORE or AFTER 'Test Three-2' -therefore impossible to determine which is the 'latest record'.

You are making assumptions on the OP's data that are not justified.

|||

Arnie Rowland wrote:

Adam

It would better demonstate a desire to helpfully contribute to the forums were you to offer constructive suggestions to solve the OP's problem.

As I indicated earlier, Col2 provides no way to determine the chronology of data added to the database. The nature of the data may lead one to 'assume' a sequence, but, as indicated earlier, as the data is presented, it is not possible to determine if 'Test Three-2' is entered BEFORE or AFTER 'Test Three-2' -therefore impossible to determine which is the 'latest record'.

You are making assumptions on the OP's data that are not justified.

Arnie,

While I continue to feel that you resorting the path of least resistance, there still remains a logical progression and association with the OP's table and desired resultset. I would think it is insulting not helpful to the OP to suggest his question has no solution without modifying the table.

Yes, adding an identity field is the obvious choice, but again this might not be an option.

Working with the data "provided," there is a solution. Where is the assumption?

Adamus

|||

Arnie Rowland wrote:

It would better demonstate a desire to helpfully contribute to the forums were you to offer constructive suggestions to solve the OP's problem.

Arnie said = "No Solution"

Adamus said = "Here's the solution"

Please revisit the thread to determine who is being constructive and who is being argumentative.

Thanks,

Adamus

|||

Arnie Rowland wrote:

You are making assumptions on the OP's data that are not justified.

Arnie, you are not making assumptions when working with the data provided.

You, on the other hand, are assuming that the table can be altered.

With the provided information, if you do not see a pattern, I'm not sure how you can help.

Adamus

Reg: Datawarehouse records delete problem

Hi

Iam using SQl server 2005 Integration Service to transfer the data from Source Data Base to Datawarehouse DB. Here my main problem is after trnsfering the data from main Data Base to datawarehouse DB. If any records is delete from main database, how can we delete same records in Datawarehouse DB. If I want to delete any record in the datawarehouse that record mapped with some other tables [Foriegn Keys].

Regards,

Hanu

You should review the Project REAL ETL best practices (http://download.microsoft.com/download/4/1/f/41f09116-19b3-40fe-9d54-d1e9b7af9e82/ProjectREAL_ETLDP.doc) - the section on Slowly Changing Dimensions maybe helpful.sql

Reg: Datawarehouse records delete problem

Hi

Iam using SQl server 2005 Integration Service to transfer the data from Source Data Base to Datawarehouse DB. Here my main problem is after trnsfering the data from main Data Base to datawarehouse DB. If any records is delete from main database, how can we delete same records in Datawarehouse DB. If I want to delete any record in the datawarehouse that record mapped with some other tables [Foriegn Keys].

Regards,

Hanu

You should review the Project REAL ETL best practices (http://download.microsoft.com/download/4/1/f/41f09116-19b3-40fe-9d54-d1e9b7af9e82/ProjectREAL_ETLDP.doc) - the section on Slowly Changing Dimensions maybe helpful.

Reg: Crystal report pie chart

Hi,
I am using VS.NET2002, Cr 9.1.I created one Report in which i am using pie chart.The problem is that i am getting report on development m/c but when i am running same exe on client m/c it is showing all other text object except Chart (i.e date,page no etc.)

Do i need to put any particular dll or file related to chart on client m/c

any help will be appreciated.....

Regards,
RiteshHi,
I got the solution on other forum.I copied the file sscsdk80.dll to client m/c and it did the trick.........

Ritesh|||Thanks for sharing the solution :)

Reg: ADOMD Connection With multi language support

I have a SQL Server AS 2005 Database with multi language support. Through Analysis Service browser if i change the language iam getting the selected language data.

In My web application by using ADOMD I need to fetch different languages data. How can get the different languages data?

In the Sql Server Reporting Sevice also i need get the different languages data.If any body knows about this can you please help me.

Regards

Hanu

Moving the thread to the more appropriate forum.|||

Try setting the Locale Identifier connection string property to the numeric identifier of the locale whose language you want to see. For instance, if you connect to the Adventure Works cube with Locale Identifier=1036 then you'll see the French translation of the cube.

HTH,

Chris

Reg. scatter chart in reporting services

We are working with scatter chart in reporting services.we need to divide the chart into quadrants.We can use VB code in reporting services.Can anyone let me know the VB code to divide that into quadrants and coloring the quadrants

Thanks in advance

Subha

Can you give me sample data ,the example what you are showing now and what you want to show?|||

RED ORANGE GREEN BLACK

This is our requirement.The Scatter chart should be divided into 4 quadrants and

The quadrant backgrounds need to be colored as shown.

This is a quadrant analysis plot of Location versus Index Value

Thanks

Subha

|||Hey Subha Did you got the solution of your problem i also need same solution

REG. RESTORE DATABASE FROM SQL 2005

I am facing problem while restoring database:
"An excepting occured while executing a Transact-SQL statement or batch.
Too many backup device specified for backup or restore; only 64 are
allowed
*** Sent via Developersdex http://www.codecomments.com ***
sham,
Since BACKUP DATABASE only supports 64 backup devices, you should not need
more than 64 to restore. If you paste in your RESTORE command here, maybe
it will be apparent what is wrong.
RLF
"sham kulkarni" <sham252664@.gmail.com> wrote in message
news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>I am facing problem while restoring database:
> "An excepting occured while executing a Transact-SQL statement or batch.
> Too many backup device specified for backup or restore; only 64 are
> allowed
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Russel, I think the OP tries to restored sql server 2005 database on sql
server 2000 version
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
> sham,
> Since BACKUP DATABASE only supports 64 backup devices, you should not need
> more than 64 to restore. If you paste in your RESTORE command here, maybe
> it will be apparent what is wrong.
> RLF
> "sham kulkarni" <sham252664@.gmail.com> wrote in message
> news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>
|||Uri,
I did not think that of that possibility. Of course, if that is the case,
then it certainly will not work. But that is a strange message to get in
this case. I would have expected something like this:
Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.
RLF
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxQBlqFJIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Russel, I think the OP tries to restored sql server 2005 database on sql
> server 2000 version
>
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
>
sql

REG. RESTORE DATABASE FROM SQL 2005

I am facing problem while restoring database:
"An excepting occured while executing a Transact-SQL statement or batch.
Too many backup device specified for backup or restore; only 64 are
allowed
*** Sent via Developersdex http://www.codecomments.com ***sham,
Since BACKUP DATABASE only supports 64 backup devices, you should not need
more than 64 to restore. If you paste in your RESTORE command here, maybe
it will be apparent what is wrong.
RLF
"sham kulkarni" <sham252664@.gmail.com> wrote in message
news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>I am facing problem while restoring database:
> "An excepting occured while executing a Transact-SQL statement or batch.
> Too many backup device specified for backup or restore; only 64 are
> allowed
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Russel, I think the OP tries to restored sql server 2005 database on sql
server 2000 version
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
> sham,
> Since BACKUP DATABASE only supports 64 backup devices, you should not need
> more than 64 to restore. If you paste in your RESTORE command here, maybe
> it will be apparent what is wrong.
> RLF
> "sham kulkarni" <sham252664@.gmail.com> wrote in message
> news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>|||Uri,
I did not think that of that possibility. Of course, if that is the case,
then it certainly will not work. But that is a strange message to get in
this case. I would have expected something like this:
Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.
RLF
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxQBlqFJIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Russel, I think the OP tries to restored sql server 2005 database on sql
> server 2000 version
>
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
>

REG. RESTORE DATABASE FROM SQL 2005

I am facing problem while restoring database:
"An excepting occured while executing a Transact-SQL statement or batch.
Too many backup device specified for backup or restore; only 64 are
allowed
*** Sent via Developersdex http://www.developersdex.com ***sham,
Since BACKUP DATABASE only supports 64 backup devices, you should not need
more than 64 to restore. If you paste in your RESTORE command here, maybe
it will be apparent what is wrong.
RLF
"sham kulkarni" <sham252664@.gmail.com> wrote in message
news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>I am facing problem while restoring database:
> "An excepting occured while executing a Transact-SQL statement or batch.
> Too many backup device specified for backup or restore; only 64 are
> allowed
>
> *** Sent via Developersdex http://www.developersdex.com ***|||Russel, I think the OP tries to restored sql server 2005 database on sql
server 2000 version
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
> sham,
> Since BACKUP DATABASE only supports 64 backup devices, you should not need
> more than 64 to restore. If you paste in your RESTORE command here, maybe
> it will be apparent what is wrong.
> RLF
> "sham kulkarni" <sham252664@.gmail.com> wrote in message
> news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>>I am facing problem while restoring database:
>> "An excepting occured while executing a Transact-SQL statement or batch.
>> Too many backup device specified for backup or restore; only 64 are
>> allowed
>>
>> *** Sent via Developersdex http://www.developersdex.com ***
>|||Uri,
I did not think that of that possibility. Of course, if that is the case,
then it certainly will not work. But that is a strange message to get in
this case. I would have expected something like this:
Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.
RLF
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxQBlqFJIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Russel, I think the OP tries to restored sql server 2005 database on sql
> server 2000 version
>
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:ujgOF1tIIHA.1204@.TK2MSFTNGP03.phx.gbl...
>> sham,
>> Since BACKUP DATABASE only supports 64 backup devices, you should not
>> need more than 64 to restore. If you paste in your RESTORE command here,
>> maybe it will be apparent what is wrong.
>> RLF
>> "sham kulkarni" <sham252664@.gmail.com> wrote in message
>> news:uNS92ctIIHA.2480@.TK2MSFTNGP05.phx.gbl...
>>I am facing problem while restoring database:
>> "An excepting occured while executing a Transact-SQL statement or batch.
>> Too many backup device specified for backup or restore; only 64 are
>> allowed
>>
>> *** Sent via Developersdex http://www.developersdex.com ***
>>
>

reg. ReportService2005.asmx.

I am new to Reporting Service, I got the sample code, there is a method used
to connect reporting service,
http://servername/reports/ReportService2005.asmx,
But i don't find ReportService2005.asmx.
I chekced http://servername/reports/ folder ts is not there, how to get this
file? Is there any separate installtion/configuration needed?
I searched web, i don't find any information regarding this.
pl. any help
thanks
KalYou need to use http://servername/ReportServer/ReportService2005.asmx
/Reports is the web interface for Reporting Services whereas /ReportServer
is the Web Service interface.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: reg. ReportService2005.asmx.
> From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> Subject: reg. ReportService2005.asmx.
> Date: Mon, 8 Oct 2007 06:02:17 -0700
> I am new to Reporting Service, I got the sample code, there is a method
used
> to connect reporting service,
> http://servername/reports/ReportService2005.asmx,
> But i don't find ReportService2005.asmx.
> I chekced http://servername/reports/ folder ts is not there, how to get
this
> file? Is there any separate installtion/configuration needed?
> I searched web, i don't find any information regarding this.
>
> pl. any help
>
> thanks
> Kal
>|||Thanks Chris,
"Chris Alton [MSFT]" wrote:
> You need to use http://servername/ReportServer/ReportService2005.asmx
> /Reports is the web interface for Reporting Services whereas /ReportServer
> is the Web Service interface.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: reg. ReportService2005.asmx.
> > From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> > Subject: reg. ReportService2005.asmx.
> > Date: Mon, 8 Oct 2007 06:02:17 -0700
> >
> > I am new to Reporting Service, I got the sample code, there is a method
> used
> > to connect reporting service,
> >
> > http://servername/reports/ReportService2005.asmx,
> >
> > But i don't find ReportService2005.asmx.
> >
> > I chekced http://servername/reports/ folder ts is not there, how to get
> this
> > file? Is there any separate installtion/configuration needed?
> >
> > I searched web, i don't find any information regarding this.
> >
> >
> > pl. any help
> >
> >
> > thanks
> > Kal
> >
>|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: reg. ReportService2005.asmx.
> From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> References: <5D2E4DAA-6C21-4138-89A1-4109357A14BA@.microsoft.com>
<7snSqEbCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: reg. ReportService2005.asmx.
> Date: Mon, 8 Oct 2007 06:54:01 -0700
> Thanks Chris,
>
> "Chris Alton [MSFT]" wrote:
> > You need to use http://servername/ReportServer/ReportService2005.asmx
> >
> > /Reports is the web interface for Reporting Services whereas
/ReportServer
> > is the Web Service interface.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: reg. ReportService2005.asmx.
> > > From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> > > Subject: reg. ReportService2005.asmx.
> > > Date: Mon, 8 Oct 2007 06:02:17 -0700
> > >
> > > I am new to Reporting Service, I got the sample code, there is a
method
> > used
> > > to connect reporting service,
> > >
> > > http://servername/reports/ReportService2005.asmx,
> > >
> > > But i don't find ReportService2005.asmx.
> > >
> > > I chekced http://servername/reports/ folder ts is not there, how to
get
> > this
> > > file? Is there any separate installtion/configuration needed?
> > >
> > > I searched web, i don't find any information regarding this.
> > >
> > >
> > > pl. any help
> > >
> > >
> > > thanks
> > > Kal
> > >
> >
> >
>

reg. Prob with replication

HI,
Im using Mssql 2000, We are migrating the server from one server to
another.
i will list out what i have done, so pls let me know what wrong i did
and how to solve.
1. install mssql s/w
2. restore master db
3. restore users db's.
4. Run the replication script (extracted from old server)
im getting the errors, as follows
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
Line 164
Invalid object name 'msdb..MSdistributiondbs'.
Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber, Line
95
The server 'ADCPWSQLZ7' is already a Subscriber.
.............
.......
pls help me to solve the error.
thks
if you had restored your distribution and msdb databases you might have had
a chance of getting this to work. At this point your best bet is to restore
the publication database again using the keep_replication switch, script out
the publications and subscriptions, then drop the publications and
subscriptions, disable and then re-enable replication, and then recreate
your publications and subscriptions again from the script.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"calms" <calmsqurill@.gmail.com> wrote in message
news:54ef32ea-e652-41ce-a1ad-f2b90e6cb2ab@.i29g2000prf.googlegroups.com...
> HI,
> Im using Mssql 2000, We are migrating the server from one server to
> another.
> i will list out what i have done, so pls let me know what wrong i did
> and how to solve.
> 1. install mssql s/w
> 2. restore master db
> 3. restore users db's.
> 4. Run the replication script (extracted from old server)
> im getting the errors, as follows
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
> Line 164
> Invalid object name 'msdb..MSdistributiondbs'.
> Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber, Line
> 95
> The server 'ADCPWSQLZ7' is already a Subscriber.
> ............
> ......
> pls help me to solve the error.
> thks

reg. Prob with replication

HI,
Im using Mssql 2000, We are migrating the server from one server to
another.
i will list out what i have done, so pls let me know what wrong i did
and how to solve.
1. install mssql s/w
2. restore master db
3. restore users db's.
4. Run the replication script (extracted from old server)
im getting the errors, as follows
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
Line 164
Invalid object name 'msdb..MSdistributiondbs'.
Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
Line
95
The server 'ADCPWSQLZ7' is already a Subscriber.
.............
.......
pls help me to solve the error.
thks
If you wanted a hope of getting this to work you should have restored the
msdb and distribution databases as well and then renamed the new server with
the name of the old server.
you need to disable replication and then recreate it and then try to re-run
your scripts on this server.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"calms" <calmsqurill@.gmail.com> wrote in message
news:ddb85046-94b1-4e43-a006-f3d3a24bca5a@.s12g2000prg.googlegroups.com...
> HI,
> Im using Mssql 2000, We are migrating the server from one server to
> another.
>
> i will list out what i have done, so pls let me know what wrong i did
> and how to solve.
>
> 1. install mssql s/w
> 2. restore master db
> 3. restore users db's.
> 4. Run the replication script (extracted from old server)
>
> im getting the errors, as follows
>
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
> Line 164
> Invalid object name 'msdb..MSdistributiondbs'.
> Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
> Line
> 95
> The server 'ADCPWSQLZ7' is already a Subscriber.
> ............
> ......
>
> pls help me to solve the error.
>
> thks
>
sql

reg. Prob with replication

HI,
Im using Mssql 2000, We are migrating the server from one server to
another.
i will list out what i have done, so pls let me know what wrong i did
and how to solve.
1. install mssql s/w
2. restore master db
3. restore users db's.
4. Run the replication script (extracted from old server)
im getting the errors, as follows
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
Line 164
Invalid object name 'msdb..MSdistributiondbs'.
Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
Line
95
The server 'ADCPWSQLZ7' is already a Subscriber.
............
......
pls help me to solve the error.
thksIf you wanted a hope of getting this to work you should have restored the
msdb and distribution databases as well and then renamed the new server with
the name of the old server.
you need to disable replication and then recreate it and then try to re-run
your scripts on this server.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"calms" <calmsqurill@.gmail.com> wrote in message
news:ddb85046-94b1-4e43-a006-f3d3a24bca5a@.s12g2000prg.googlegroups.com...
> HI,
> Im using Mssql 2000, We are migrating the server from one server to
> another.
>
> i will list out what i have done, so pls let me know what wrong i did
> and how to solve.
>
> 1. install mssql s/w
> 2. restore master db
> 3. restore users db's.
> 4. Run the replication script (extracted from old server)
>
> im getting the errors, as follows
>
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
> Line 164
> Invalid object name 'msdb..MSdistributiondbs'.
> Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
> Line
> 95
> The server 'ADCPWSQLZ7' is already a Subscriber.
> ............
> ......
>
> pls help me to solve the error.
>
> thks
>

reg. Prob with replication

HI,
Im using Mssql 2000, We are migrating the server from one server to
another.
i will list out what i have done, so pls let me know what wrong i did
and how to solve.
1. install mssql s/w
2. restore master db
3. restore users db's.
4. Run the replication script (extracted from old server)
im getting the errors, as follows
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
Line 164
Invalid object name 'msdb..MSdistributiondbs'.
Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
Line
95
The server 'ADCPWSQLZ7' is already a Subscriber.
............
......
pls help me to solve the error.
thksIf you wanted a hope of getting this to work you should have restored the
msdb and distribution databases as well and then renamed the new server with
the name of the old server.
you need to disable replication and then recreate it and then try to re-run
your scripts on this server.
--
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"calms" <calmsqurill@.gmail.com> wrote in message
news:ddb85046-94b1-4e43-a006-f3d3a24bca5a@.s12g2000prg.googlegroups.com...
> HI,
> Im using Mssql 2000, We are migrating the server from one server to
> another.
>
> i will list out what i have done, so pls let me know what wrong i did
> and how to solve.
>
> 1. install mssql s/w
> 2. restore master db
> 3. restore users db's.
> 4. Run the replication script (extracted from old server)
>
> im getting the errors, as follows
>
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
> Line 164
> Invalid object name 'msdb..MSdistributiondbs'.
> Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
> Line
> 95
> The server 'ADCPWSQLZ7' is already a Subscriber.
> ............
> ......
>
> pls help me to solve the error.
>
> thks
>

reg. performance

Is there anyway pull logs and statistical information regarding performance
and Transaction database ?
Thanks
Kalyan
If you are talking about reading tran. log then there is 3rd party tool
called lumigent log explorer. Do a google search for it. On the otherhand if
the question is regarding performance monitoring, then read BOL on the topics
like SQL profiler and windows performance moniter. The DBA is required to
baseline the values of the performance counters when the SQL is functioning
normally. This base line will help you to compare the trace logs at the time
of bad performance and see what is the problem in event of performance
degradation.
Thanks
Chinna.
"Kalyan" wrote:

> Is there anyway pull logs and statistical information regarding performance
> and Transaction database ?
>
> Thanks
> Kalyan