Hello,
I realize this topic has been beaten to death but I'm still having trouble
with a report.
I'm trying to open up an asp.net page in a new window. Here is what I'm
using based on examples I've read here so far:
= "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum=" & Fields!Name.Value ','_blank'))"
I do this through right clicking on a textbox and going to its advanced
navigation properties. Now the report builds fine with no errors and once
it's done building instead of giving me a preview of the report it says
something like: "Invalid URL type must use http://, https://, file://, etc.".
Is there some other way of doing this by using LinkTarget or something? I
am hoping my syntax is just wrong here. I have RS 2000 with SP2 installed.
Help!
ThanksAlso, when testing this you might need to deploy it to test it properly.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
> Hello,
> I realize this topic has been beaten to death but I'm still having trouble
> with a report.
> I'm trying to open up an asp.net page in a new window. Here is what I'm
> using based on examples I've read here so far:
> => "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
> & Fields!Name.Value ','_blank'))"
> I do this through right clicking on a textbox and going to its advanced
> navigation properties. Now the report builds fine with no errors and once
> it's done building instead of giving me a preview of the report it says
> something like: "Invalid URL type must use http://, https://, file://,
> etc.".
>
> Is there some other way of doing this by using LinkTarget or something? I
> am hoping my syntax is just wrong here. I have RS 2000 with SP2
> installed.
> Help!
> Thanks|||Here is one that works.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Looking at yours I would say that you need to do this:
="javascript:void(window.open('http://www.mysite.com/subdir/form.aspx?ctrlnum="
& Fields!Name.Value & "','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
> Hello,
> I realize this topic has been beaten to death but I'm still having trouble
> with a report.
> I'm trying to open up an asp.net page in a new window. Here is what I'm
> using based on examples I've read here so far:
> => "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
> & Fields!Name.Value ','_blank'))"
> I do this through right clicking on a textbox and going to its advanced
> navigation properties. Now the report builds fine with no errors and once
> it's done building instead of giving me a preview of the report it says
> something like: "Invalid URL type must use http://, https://, file://,
> etc.".
>
> Is there some other way of doing this by using LinkTarget or something? I
> am hoping my syntax is just wrong here. I have RS 2000 with SP2
> installed.
> Help!
> Thanks|||You mean I could have had it right and it would still give me that syntax
error?
"Bruce L-C [MVP]" wrote:
> Also, when testing this you might need to deploy it to test it properly.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John" <John@.discussions.microsoft.com> wrote in message
> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
> > Hello,
> >
> > I realize this topic has been beaten to death but I'm still having trouble
> > with a report.
> >
> > I'm trying to open up an asp.net page in a new window. Here is what I'm
> > using based on examples I've read here so far:
> >
> > => > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
> > & Fields!Name.Value ','_blank'))"
> >
> > I do this through right clicking on a textbox and going to its advanced
> > navigation properties. Now the report builds fine with no errors and once
> > it's done building instead of giving me a preview of the report it says
> > something like: "Invalid URL type must use http://, https://, file://,
> > etc.".
> >
> >
> > Is there some other way of doing this by using LinkTarget or something? I
> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
> > installed.
> >
> > Help!
> > Thanks
>
>|||What happens to me from development is I get a flash and a ding sound and
nothing happens.
No, I think you have your syntax incorrect. You are trying to assemble a
string. Look at this part: & Fields!Name.Value ','_blank'))"
it should be & Fields!Name.Value & "','_blank'))"
You want to append the two strings together. The value in your feild and the
rest of the string.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:2C4D09B7-C68E-4BFB-AA86-B2B8D36665B2@.microsoft.com...
> You mean I could have had it right and it would still give me that syntax
> error?
> "Bruce L-C [MVP]" wrote:
>> Also, when testing this you might need to deploy it to test it properly.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
>> > Hello,
>> >
>> > I realize this topic has been beaten to death but I'm still having
>> > trouble
>> > with a report.
>> >
>> > I'm trying to open up an asp.net page in a new window. Here is what
>> > I'm
>> > using based on examples I've read here so far:
>> >
>> > =>> > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
>> > & Fields!Name.Value ','_blank'))"
>> >
>> > I do this through right clicking on a textbox and going to its advanced
>> > navigation properties. Now the report builds fine with no errors and
>> > once
>> > it's done building instead of giving me a preview of the report it says
>> > something like: "Invalid URL type must use http://, https://, file://,
>> > etc.".
>> >
>> >
>> > Is there some other way of doing this by using LinkTarget or something?
>> > I
>> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
>> > installed.
>> >
>> > Help!
>> > Thanks
>>|||Great thanks!
I will test this as soon as I can and let you know.
"Bruce L-C [MVP]" wrote:
> What happens to me from development is I get a flash and a ding sound and
> nothing happens.
> No, I think you have your syntax incorrect. You are trying to assemble a
> string. Look at this part: & Fields!Name.Value ','_blank'))"
> it should be & Fields!Name.Value & "','_blank'))"
> You want to append the two strings together. The value in your feild and the
> rest of the string.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John" <John@.discussions.microsoft.com> wrote in message
> news:2C4D09B7-C68E-4BFB-AA86-B2B8D36665B2@.microsoft.com...
> > You mean I could have had it right and it would still give me that syntax
> > error?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Also, when testing this you might need to deploy it to test it properly.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "John" <John@.discussions.microsoft.com> wrote in message
> >> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
> >> > Hello,
> >> >
> >> > I realize this topic has been beaten to death but I'm still having
> >> > trouble
> >> > with a report.
> >> >
> >> > I'm trying to open up an asp.net page in a new window. Here is what
> >> > I'm
> >> > using based on examples I've read here so far:
> >> >
> >> > => >> > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
> >> > & Fields!Name.Value ','_blank'))"
> >> >
> >> > I do this through right clicking on a textbox and going to its advanced
> >> > navigation properties. Now the report builds fine with no errors and
> >> > once
> >> > it's done building instead of giving me a preview of the report it says
> >> > something like: "Invalid URL type must use http://, https://, file://,
> >> > etc.".
> >> >
> >> >
> >> > Is there some other way of doing this by using LinkTarget or something?
> >> > I
> >> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
> >> > installed.
> >> >
> >> > Help!
> >> > Thanks
> >>
> >>
> >>
>
>|||I just wanted to say this is exactly what I needed. It still gives me a
"invalid url" error inside VS but it works fine once I deploy it and test
inside IE.
Thanks!
"Bruce L-C [MVP]" wrote:
> Here is one that works.
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> Looking at yours I would say that you need to do this:
> => "javascript:void(window.open('http://www.mysite.com/subdir/form.aspx?ctrlnum="
> & Fields!Name.Value & "','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
> > Hello,
> >
> > I realize this topic has been beaten to death but I'm still having trouble
> > with a report.
> >
> > I'm trying to open up an asp.net page in a new window. Here is what I'm
> > using based on examples I've read here so far:
> >
> > => > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
> > & Fields!Name.Value ','_blank'))"
> >
> > I do this through right clicking on a textbox and going to its advanced
> > navigation properties. Now the report builds fine with no errors and once
> > it's done building instead of giving me a preview of the report it says
> > something like: "Invalid URL type must use http://, https://, file://,
> > etc.".
> >
> >
> > Is there some other way of doing this by using LinkTarget or something? I
> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
> > installed.
> >
> > Help!
> > Thanks
>
>|||Make sure you are running at least RS 2000 SP1 on the report server and
report designer for this to work.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:1B63DA2A-1655-477E-BBCA-7839423DBD52@.microsoft.com...
> Great thanks!
> I will test this as soon as I can and let you know.
>
> "Bruce L-C [MVP]" wrote:
>> What happens to me from development is I get a flash and a ding sound and
>> nothing happens.
>> No, I think you have your syntax incorrect. You are trying to assemble a
>> string. Look at this part: & Fields!Name.Value ','_blank'))"
>> it should be & Fields!Name.Value & "','_blank'))"
>> You want to append the two strings together. The value in your feild and
>> the
>> rest of the string.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:2C4D09B7-C68E-4BFB-AA86-B2B8D36665B2@.microsoft.com...
>> > You mean I could have had it right and it would still give me that
>> > syntax
>> > error?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Also, when testing this you might need to deploy it to test it
>> >> properly.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "John" <John@.discussions.microsoft.com> wrote in message
>> >> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I realize this topic has been beaten to death but I'm still having
>> >> > trouble
>> >> > with a report.
>> >> >
>> >> > I'm trying to open up an asp.net page in a new window. Here is what
>> >> > I'm
>> >> > using based on examples I've read here so far:
>> >> >
>> >> > =>> >> > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
>> >> > & Fields!Name.Value ','_blank'))"
>> >> >
>> >> > I do this through right clicking on a textbox and going to its
>> >> > advanced
>> >> > navigation properties. Now the report builds fine with no errors
>> >> > and
>> >> > once
>> >> > it's done building instead of giving me a preview of the report it
>> >> > says
>> >> > something like: "Invalid URL type must use http://, https://,
>> >> > file://,
>> >> > etc.".
>> >> >
>> >> >
>> >> > Is there some other way of doing this by using LinkTarget or
>> >> > something?
>> >> > I
>> >> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
>> >> > installed.
>> >> >
>> >> > Help!
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||It is common to get different behaviour in the dev environment than in
prod... We always go ahead and deploy and test both places before we decide
that something doesn't work.
--
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
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OYsFzsqqFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Make sure you are running at least RS 2000 SP1 on the report server and
> report designer for this to work.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "John" <John@.discussions.microsoft.com> wrote in message
> news:1B63DA2A-1655-477E-BBCA-7839423DBD52@.microsoft.com...
>> Great thanks!
>> I will test this as soon as I can and let you know.
>>
>> "Bruce L-C [MVP]" wrote:
>> What happens to me from development is I get a flash and a ding sound
>> and
>> nothing happens.
>> No, I think you have your syntax incorrect. You are trying to assemble a
>> string. Look at this part: & Fields!Name.Value ','_blank'))"
>> it should be & Fields!Name.Value & "','_blank'))"
>> You want to append the two strings together. The value in your feild and
>> the
>> rest of the string.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:2C4D09B7-C68E-4BFB-AA86-B2B8D36665B2@.microsoft.com...
>> > You mean I could have had it right and it would still give me that
>> > syntax
>> > error?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Also, when testing this you might need to deploy it to test it
>> >> properly.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "John" <John@.discussions.microsoft.com> wrote in message
>> >> news:02B7C28C-8A74-465A-95B9-C5959F426FB7@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I realize this topic has been beaten to death but I'm still having
>> >> > trouble
>> >> > with a report.
>> >> >
>> >> > I'm trying to open up an asp.net page in a new window. Here is
>> >> > what
>> >> > I'm
>> >> > using based on examples I've read here so far:
>> >> >
>> >> > =>> >> > "javascript:void(window.open('"http://www.mysite.com/subdir/form.aspx?ctrlnum="
>> >> > & Fields!Name.Value ','_blank'))"
>> >> >
>> >> > I do this through right clicking on a textbox and going to its
>> >> > advanced
>> >> > navigation properties. Now the report builds fine with no errors
>> >> > and
>> >> > once
>> >> > it's done building instead of giving me a preview of the report it
>> >> > says
>> >> > something like: "Invalid URL type must use http://, https://,
>> >> > file://,
>> >> > etc.".
>> >> >
>> >> >
>> >> > Is there some other way of doing this by using LinkTarget or
>> >> > something?
>> >> > I
>> >> > am hoping my syntax is just wrong here. I have RS 2000 with SP2
>> >> > installed.
>> >> >
>> >> > Help!
>> >> > Thanks
>> >>
>> >>
>> >>
>>
>
Showing posts with label net. Show all posts
Showing posts with label net. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
JPG image does not render in Report Manager
A JPG image does not render in Report Manager but does when I export the report to PDF format. Also it renders fine in VS.NET Preview mode.
I have tried deleting the image and redeploying it to the Report Server but with no success! I don't know what else to do.
Can anyone help me with this one please?There have been several threads on this newsgroup about problems with images
not showing up in HTML rendering.
Most likely the machine name of the report server contains a character like
"_", which causes problems with finding the image streams by IE. This is not
an issue in Reporting Services, but in Internet Explorer - related to
security patch MS01-055. Details are available at:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q316112
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PeteJ" <PeteJ@.discussions.microsoft.com> wrote in message
news:588EF768-BD27-46E3-9FA1-4ECDF62CC444@.microsoft.com...
> A JPG image does not render in Report Manager but does when I export the
report to PDF format. Also it renders fine in VS.NET Preview mode.
> I have tried deleting the image and redeploying it to the Report Server
but with no success! I don't know what else to do.
> Can anyone help me with this one please?sql
I have tried deleting the image and redeploying it to the Report Server but with no success! I don't know what else to do.
Can anyone help me with this one please?There have been several threads on this newsgroup about problems with images
not showing up in HTML rendering.
Most likely the machine name of the report server contains a character like
"_", which causes problems with finding the image streams by IE. This is not
an issue in Reporting Services, but in Internet Explorer - related to
security patch MS01-055. Details are available at:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q316112
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PeteJ" <PeteJ@.discussions.microsoft.com> wrote in message
news:588EF768-BD27-46E3-9FA1-4ECDF62CC444@.microsoft.com...
> A JPG image does not render in Report Manager but does when I export the
report to PDF format. Also it renders fine in VS.NET Preview mode.
> I have tried deleting the image and redeploying it to the Report Server
but with no success! I don't know what else to do.
> Can anyone help me with this one please?sql
Journal table for a database
Hi,
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log fi
le
> to know since i have to buy a seperate program to explore the log file. Ho
w
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log fi
le
> to know since i have to buy a seperate program to explore the log file. Ho
w
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
Journal table for a database
Hi,
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar
> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log file
> to know since i have to buy a seperate program to explore the log file. How
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>
|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO
|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar
> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log file
> to know since i have to buy a seperate program to explore the log file. How
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>
|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndL ogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO
|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
Journal table for a database
Hi,
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log fi
le
> to know since i have to buy a seperate program to explore the log file. Ho
w
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log fi
le
> to know since i have to buy a seperate program to explore the log file. Ho
w
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusL
ogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
Journal table for a database
Hi,
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log file
> to know since i have to buy a seperate program to explore the log file. How
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
I am using a SQL Server 2000 database with a VB.net program and uses
Integerated security. I want to log all the changes made to any table
data(whether addition, deletion, updation) to a single table by all the
users.
Is this possible by way of a common trigger. I dont want to use the log file
to know since i have to buy a seperate program to explore the log file. How
can achieve this.
Thanks for all the answers.
Senthilkumar> Is this possible by way of a common trigger.
NO.
Another option is running a profiler trace to log these changes.
But that has a performance impact.
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>|||hi Senthilkumar,
What about the creation of fields which store domain user or updating time
in every row
"Senthilkumar" wrote:
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log file
> to know since i have to buy a seperate program to explore the log file. How
> can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
>|||You can however implement something generic as example below for all
your tables:
CREATE TRIGGER logChanges
ON [any_table]
FOR INSERT, UPDATE, DELETE
AS
DECLARE @.trigType char(1), @.rwCnt int
SET @.rwCnt = @.@.ROWCOUNT
IF @.rwCnt = 0 RETURN
IF(select count(*) from inserted) > 0
BEGIN
SET @.trigType = 'i'
IF(select count(*) from deleted) > 0
BEGIN
SET @.trigType = 'u'
END
END
ELSE
BEGIN
SET @.trigType = 'd'
END
IF @.trigType = 'i'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'i', GETDATE() from inserted
END
IF @.trigType = 'u'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'ui', GETDATE() from inserted
UNION
SELECT val1, val2, val3, 'ud', GETDATE() from deleted
END
IF @.trigType = 'd'
BEGIN
INSERT INTO
aLogTableWithSameColumnsAsOrigTablePlusLogTypeAndLogDateColumn (val1,
val2, val3, LogType, LogDate)
SELECT val1, val2, val3, 'd', GETDATE() from inserted
END
GO|||Thanks for all those who replied.
I was creating a trigger for each table to store the values in a different
table. but then i found a tool ApexAudit which exactly does what i want. I
have used it now.
Once again thanks for all the answers.
Senthilkumar
"Senthilkumar" <kesk32@.yahoo.co.in> wrote in message
news:ewqweKAGGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using a SQL Server 2000 database with a VB.net program and uses
> Integerated security. I want to log all the changes made to any table
> data(whether addition, deletion, updation) to a single table by all the
> users.
> Is this possible by way of a common trigger. I dont want to use the log
> file to know since i have to buy a seperate program to explore the log
> file. How can achieve this.
> Thanks for all the answers.
> Senthilkumar
>
Subscribe to:
Posts (Atom)