compressed and encrypted SQL Server backups

hi,
does anyone can tell me some program that creates compressed and encrypted
SQL Server backups other than SQL LiteSpeed?
thanks in advanced!
BethRed-Gate SQL Backup, http://www.red-gate.com/products/SQL_Backup/index.htm
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||I've listed a few on my links page: http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted SQL Server backups
> other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||Just curious Beth, but do you have any complaints with SQL LiteSpeed? I ask
because I would also like to implement compressed backups soon.
-Phil
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||hello Phil...sorry about the delay...
no, i don´t have any but i need other SW in order to compare this one...
Beth
"Philip Mattson" <philm@.nwsoft.com> escribió en el mensaje
news:%23h%238o5eJGHA.1368@.TK2MSFTNGP10.phx.gbl...
> Just curious Beth, but do you have any complaints with SQL LiteSpeed? I
> ask because I would also like to implement compressed backups soon.
> -Phil
> "Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
> news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
>> hi,
>> does anyone can tell me some program that creates compressed and
>> encrypted SQL Server backups other than SQL LiteSpeed?
>>
>> thanks in advanced!
>> Beth
>>
>>
>

compressed and encrypted SQL Server backups

hi,
does anyone can tell me some program that creates compressed and encrypted
SQL Server backups other than SQL LiteSpeed?
thanks in advanced!
Beth
Red-Gate SQL Backup, http://www.red-gate.com/products/SQL_Backup/index.htm
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>
|||I've listed a few on my links page: http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted SQL Server backups
> other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>
|||Just curious Beth, but do you have any complaints with SQL LiteSpeed? I ask
because I would also like to implement compressed backups soon.
-Phil
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>
|||hello Phil...sorry about the delay...
no, i dont have any but i need other SW in order to compare this one...
Beth
"Philip Mattson" <philm@.nwsoft.com> escribi en el mensaje
news:%23h%238o5eJGHA.1368@.TK2MSFTNGP10.phx.gbl...
> Just curious Beth, but do you have any complaints with SQL LiteSpeed? I
> ask because I would also like to implement compressed backups soon.
> -Phil
> "Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
> news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
>
sqlsql

compressed and encrypted SQL Server backups

hi,
does anyone can tell me some program that creates compressed and encrypted
SQL Server backups other than SQL LiteSpeed?
thanks in advanced!
BethRed-Gate SQL Backup, http://www.red-gate.com/products/SQL_Backup/index.htm
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||I've listed a few on my links page: l]
Tibor Karaszi, SQL Server MVP
[url]http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/SQLServer/li...ver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
SQL Server backups
> other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||Just curious Beth, but do you have any complaints with SQL LiteSpeed? I ask
because I would also like to implement compressed backups soon.
-Phil
"Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
> hi,
> does anyone can tell me some program that creates compressed and encrypted
> SQL Server backups other than SQL LiteSpeed?
>
> thanks in advanced!
> Beth
>
>
>|||hello Phil...sorry about the delay...
no, i dont have any but i need other SW in order to compare this one...
Beth
"Philip Mattson" <philm@.nwsoft.com> escribi en el mensaje
news:%23h%238o5eJGHA.1368@.TK2MSFTNGP10.phx.gbl...
> Just curious Beth, but do you have any complaints with SQL LiteSpeed? I
> ask because I would also like to implement compressed backups soon.
> -Phil
> "Beth Med" <bmedina06@.prodigy.net.mx> wrote in message
> news:%23Jr$YlEJGHA.500@.TK2MSFTNGP15.phx.gbl...
>

Compiled Code as a data source

Does anyone have any examples of a c# program and that returns a record set
from sql server that could be compiled and referenced as a data source in an
RDL file? If so I would sure like an example of the C# and the RDL file that
references it. Thanks.no.. but MS Access can do this for sure
On Apr 19, 7:10 am, Greg Larsen <gregalar...@.removeit.msn.com> wrote:
> Does anyone have any examples of a c# program and that returns a record set
> from sql server that could be compiled and referenced as a data source in an
> RDL file? If so I would sure like an example of the C# and the RDL file that
> references it. Thanks.|||Instead use web services using c# to directly access the datasource and
reports itself. A good sample is given in the BOL.
Amarnath
"Greg Larsen" wrote:
> Does anyone have any examples of a c# program and that returns a record set
> from sql server that could be compiled and referenced as a data source in an
> RDL file? If so I would sure like an example of the C# and the RDL file that
> references it. Thanks.|||yeah.. or you could write your own compiler and install linux
I mean wtf
fuck web services
fuck C#
can I put a form in a BI project and loop through all of the reports
in my PROJECT?
until I can do this; SSRS can fuck themselves
On Apr 19, 11:28 pm, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> Instead use web services using c# to directly access the datasource and
> reports itself. A good sample is given in the BOL.
> Amarnath
> "Greg Larsen" wrote:
> > Does anyone have any examples of a c# program and that returns a record set
> > from sql server that could be compiled and referenced as a data source in an
> > RDL file? If so I would sure like an example of the C# and the RDL file that
> > references it. Thanks.

compile

Anyone have an idea why a program that compiles in
developer will give a 'not responding' message when being
compiled to create an executable?Does this have anything to do with SQL Server? I suspect you posted to the
wrong newsgroup...
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Syl" <clemnsyl@.netscape.net> wrote in message
news:f58801c43dcc$89775b60$a501280a@.phx.gbl...
> Anyone have an idea why a program that compiles in
> developer will give a 'not responding' message when being
> compiled to create an executable?

compile

Anyone have an idea why a program that compiles in
developer will give a 'not responding' message when being
compiled to create an executable?
Does this have anything to do with SQL Server? I suspect you posted to the
wrong newsgroup...
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Syl" <clemnsyl@.netscape.net> wrote in message
news:f58801c43dcc$89775b60$a501280a@.phx.gbl...
> Anyone have an idea why a program that compiles in
> developer will give a 'not responding' message when being
> compiled to create an executable?

Compatibility issue

When I start "SQL Server Business Intelligence Development Studio" I am
getting the following message:
This program has known compatibility issue
Program: Visual Studio 2005
Publisher: Microsoft
Location: ...................\ide\devenv.exe
I am running Vista and SQL 2005 Express edition.
ThanksOn Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> When I start "SQL Server Business Intelligence Development Studio" I am
> getting the following message:
> This program has known compatibility issue
> Program: Visual Studio 2005
> Publisher: Microsoft
> Location: ...................\ide\devenv.exe
> I am running Vista and SQL 2005 Express edition.
> Thanks
Are you running SQL Server 2005 Express Edition Service Pack 2? If
not, this will be the problem.
Regards,
Enrique Martinez
Sr. Software Consultant|||I tried to install SP2 but setup said there were no components to upgrade.
Can you help?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> When I start "SQL Server Business Intelligence Development Studio" I am
>> getting the following message:
>> This program has known compatibility issue
>> Program: Visual Studio 2005
>> Publisher: Microsoft
>> Location: ...................\ide\devenv.exe
>> I am running Vista and SQL 2005 Express edition.
>> Thanks
>
> Are you running SQL Server 2005 Express Edition Service Pack 2? If
> not, this will be the problem.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> I tried to install SP2 but setup said there were no components to upgrade.
> Can you help?
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> When I start "SQL Server Business Intelligence Development Studio" I am
> >> getting the following message:
> >> This program has known compatibility issue
> >> Program: Visual Studio 2005
> >> Publisher: Microsoft
> >> Location: ...................\ide\devenv.exe
> >> I am running Vista and SQL 2005 Express edition.
> >> Thanks
> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> > not, this will be the problem.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I had the same problem a little while back. You want to backup your
databases and uninstall the original Express Edition and install the
SP2 version.
Regards,
Enrique Martinez
Sr. Software Consultant|||I see.
Do I need to uninstall everything (Visual Studio 2005 part as well) ?
Which download from MS site do I use to have SQL 2005, Reporting Services,
and Business Intelligence for report creation installed?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> I tried to install SP2 but setup said there were no components to
>> upgrade.
>> Can you help?
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> When I start "SQL Server Business Intelligence Development Studio" I
>> >> am
>> >> getting the following message:
>> >> This program has known compatibility issue
>> >> Program: Visual Studio 2005
>> >> Publisher: Microsoft
>> >> Location: ...................\ide\devenv.exe
>> >> I am running Vista and SQL 2005 Express edition.
>> >> Thanks
>> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
>> > not, this will be the problem.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> I had the same problem a little while back. You want to backup your
> databases and uninstall the original Express Edition and install the
> SP2 version.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> I see.
> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
> Which download from MS site do I use to have SQL 2005, Reporting Services,
> and Business Intelligence for report creation installed?
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> I tried to install SP2 but setup said there were no components to
> >> upgrade.
> >> Can you help?
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> >> When I start "SQL Server Business Intelligence Development Studio" I
> >> >> am
> >> >> getting the following message:
> >> >> This program has known compatibility issue
> >> >> Program: Visual Studio 2005
> >> >> Publisher: Microsoft
> >> >> Location: ...................\ide\devenv.exe
> >> >> I am running Vista and SQL 2005 Express edition.
> >> >> Thanks
> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> >> > not, this will be the problem.
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> > I had the same problem a little while back. You want to backup your
> > databases and uninstall the original Express Edition and install the
> > SP2 version.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you have just the Express Editions, you just need to uninstall SQL
Server Express Edition and the Express Edition Toolkit (not VB.NET
Express or C#.NET Express, etc). The latest Express Edition downloads
are located here:
http://msdn.microsoft.com/vstudio/express/sql/download/
You will want to download and install: MS SQL Server Express Edition w/
Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
Toolkit (SP2 Edition).
Both of the SP2 Editions are here at this link. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||After I reinstall everything I still get "Compatibility ..." message when I
start Business Intelligence Studio.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
> On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> I see.
>> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
>> Which download from MS site do I use to have SQL 2005, Reporting
>> Services,
>> and Business Intelligence for report creation installed?
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
>> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> I tried to install SP2 but setup said there were no components to
>> >> upgrade.
>> >> Can you help?
>> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
>> >> > wrote:
>> >> >> When I start "SQL Server Business Intelligence Development Studio"
>> >> >> I
>> >> >> am
>> >> >> getting the following message:
>> >> >> This program has known compatibility issue
>> >> >> Program: Visual Studio 2005
>> >> >> Publisher: Microsoft
>> >> >> Location: ...................\ide\devenv.exe
>> >> >> I am running Vista and SQL 2005 Express edition.
>> >> >> Thanks
>> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
>> >> > not, this will be the problem.
>> >> > Regards,
>> >> > Enrique Martinez
>> >> > Sr. Software Consultant
>> > I had the same problem a little while back. You want to backup your
>> > databases and uninstall the original Express Edition and install the
>> > SP2 version.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> If you have just the Express Editions, you just need to uninstall SQL
> Server Express Edition and the Express Edition Toolkit (not VB.NET
> Express or C#.NET Express, etc). The latest Express Edition downloads
> are located here:
> http://msdn.microsoft.com/vstudio/express/sql/download/
> You will want to download and install: MS SQL Server Express Edition w/
> Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
> Toolkit (SP2 Edition).
> Both of the SP2 Editions are here at this link. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 16, 6:16 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> After I reinstall everything I still get "Compatibility ..." message when I
> start Business Intelligence Studio.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
> > On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> I see.
> >> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
> >> Which download from MS site do I use to have SQL 2005, Reporting
> >> Services,
> >> and Business Intelligence for report creation installed?
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> >> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> >> I tried to install SP2 but setup said there were no components to
> >> >> upgrade.
> >> >> Can you help?
> >> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> >> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
> >> >> > wrote:
> >> >> >> When I start "SQL Server Business Intelligence Development Studio"
> >> >> >> I
> >> >> >> am
> >> >> >> getting the following message:
> >> >> >> This program has known compatibility issue
> >> >> >> Program: Visual Studio 2005
> >> >> >> Publisher: Microsoft
> >> >> >> Location: ...................\ide\devenv.exe
> >> >> >> I am running Vista and SQL 2005 Express edition.
> >> >> >> Thanks
> >> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> >> >> > not, this will be the problem.
> >> >> > Regards,
> >> >> > Enrique Martinez
> >> >> > Sr. Software Consultant
> >> > I had the same problem a little while back. You want to backup your
> >> > databases and uninstall the original Express Edition and install the
> >> > SP2 version.
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> > If you have just the Express Editions, you just need to uninstall SQL
> > Server Express Edition and the Express Edition Toolkit (not VB.NET
> > Express or C#.NET Express, etc). The latest Express Edition downloads
> > are located here:
> >http://msdn.microsoft.com/vstudio/express/sql/download/
> > You will want to download and install: MS SQL Server Express Edition w/
> > Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
> > Toolkit (SP2 Edition).
> > Both of the SP2 Editions are here at this link. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Are you running different versions of either SQL Server or Visual
Studio on the same box?|||I am not really sure. I am not installing any VS components. Whatever SQL
installs that is what I have.
In the message about "Compatibility ..." problem it says that it is a known
issue and offers me to check MS site for the solution. When I select that it
takes me to VS 2005 download site with different SP1s. There is one for
Express Edition and another for Vista. This one is not specific to a SQL
2005 version. At least how I understand it. Which one do I need to install
assuming that it is the fix?
Thanks
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176728887.064188.163410@.e65g2000hsc.googlegroups.com...
> On Apr 16, 6:16 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> After I reinstall everything I still get "Compatibility ..." message when
>> I
>> start Business Intelligence Studio.
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
>> > On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> I see.
>> >> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
>> >> Which download from MS site do I use to have SQL 2005, Reporting
>> >> Services,
>> >> and Business Intelligence for report creation installed?
>> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >>news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
>> >> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> >> I tried to install SP2 but setup said there were no components to
>> >> >> upgrade.
>> >> >> Can you help?
>> >> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> >> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
>> >> >> > wrote:
>> >> >> >> When I start "SQL Server Business Intelligence Development
>> >> >> >> Studio"
>> >> >> >> I
>> >> >> >> am
>> >> >> >> getting the following message:
>> >> >> >> This program has known compatibility issue
>> >> >> >> Program: Visual Studio 2005
>> >> >> >> Publisher: Microsoft
>> >> >> >> Location: ...................\ide\devenv.exe
>> >> >> >> I am running Vista and SQL 2005 Express edition.
>> >> >> >> Thanks
>> >> >> > Are you running SQL Server 2005 Express Edition Service Pack 2?
>> >> >> > If
>> >> >> > not, this will be the problem.
>> >> >> > Regards,
>> >> >> > Enrique Martinez
>> >> >> > Sr. Software Consultant
>> >> > I had the same problem a little while back. You want to backup your
>> >> > databases and uninstall the original Express Edition and install the
>> >> > SP2 version.
>> >> > Regards,
>> >> > Enrique Martinez
>> >> > Sr. Software Consultant
>> > If you have just the Express Editions, you just need to uninstall SQL
>> > Server Express Edition and the Express Edition Toolkit (not VB.NET
>> > Express or C#.NET Express, etc). The latest Express Edition downloads
>> > are located here:
>> >http://msdn.microsoft.com/vstudio/express/sql/download/
>> > You will want to download and install: MS SQL Server Express Edition w/
>> > Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
>> > Toolkit (SP2 Edition).
>> > Both of the SP2 Editions are here at this link. Hope this helps.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
> Are you running different versions of either SQL Server or Visual
> Studio on the same box?
>

comparing two string columns and show difference

Hello,

I am having this problem. I have a table to log any changes to the configuration of a program. If something changes, it gets recorded in this table.

So, I have two columns: BeforeChange, AfterChange. It looks like this:

BeforeChange AfterChange
------------------------
Amount = 30.00, Quantity = 3 Amount=30.00, Quantity=2

When I query those changes, I want to show only the changed values.
So, it will show only:

ChangeMade
------
Quantity = 2

Can anyone help me on this?

Thanks in advance.What about to normalize your table - problem will be resolved by itself.|||Originally posted by snail
What about to normalize your table - problem will be resolved by itself.

The problem is that, this table is filled by a program that I have no access to. (Honestly, I don't really know about the program at all)

I can only query the modificationlog table, and I have to make a report of any changes made with stored procedure.

If you can enlighten me a bit more, I would really appreciate it. I'm new to this MS SQL)

Thank you...