Anyone have a sqldmo installer?

Hi;
Does anyone have a .msi program that correctly installs sqldmo, and does
nothing if it is already installed?
I was going to do this but there are a bunch of details that must be exactly
right and I am not an expert with the Visual Studio installer.
thanks - dave
David Thielen wrote:
> Hi;
> Does anyone have a .msi program that correctly installs sqldmo, and
> does nothing if it is already installed?
> I was going to do this but there are a bunch of details that must be
> exactly right and I am not an expert with the Visual Studio installer.
It's not likely the VS Installer would work for you in this case.
There's not a lot of customization support in the tool.
What problems are you running into?
David Gugick
Imceda Software
www.imceda.com

any user access audit programs available?

Hello all, does anyone know of a SS2005RS user audit program that an administrator can run on a RS server to show which userids have access to folders? I have in mind a pgm that would show:

folder users

Home user01, user02, user03

folderA user01,user02, user05

folderB user02, user06

Is there a pgm available as a download, or does someone have a home-grown pgm whose source they would let out?

Has anyone else faced this need?

Thanks in advance

I don't know of such a program but writing your own shouldn't be that difficult. You can call ReportingService2005.GetPolicies method to obtain the secuity polices per folder.|||Mr. Lachev, thanks so much, I'll do that. P.S. I like your website.

Any Program or Tool that helps in convertion !

Hi,
I need a tool or a program that helps me to convert an MS SQL backup
database file with the ( .bak) extension into ( .sql) , I need that
urgently please.
Many Thanks in advance.
Alabdulelah
Hi,
The tool is called "SQL Server"
Seriously. Restore your database, then script it using Enterprise Manager
or Query Analyzer.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
<alabdulelah@.gmail.com> wrote in message
news:1140018773.153566.38100@.z14g2000cwz.googlegro ups.com...
> Hi,
> I need a tool or a program that helps me to convert an MS SQL backup
> database file with the ( .bak) extension into ( .sql) , I need that
> urgently please.
> Many Thanks in advance.
> Alabdulelah
>

Any Program or Tool that helps in convertion !

Hi,
I need a tool or a program that helps me to convert an MS SQL backup
database file with the ( .bak) extension into ( .sql) , I need that
urgently please.
Many Thanks in advance.
Alabdulelahalabdulelah@.gmail.com wrote:
> Hi,
> I need a tool or a program that helps me to convert an MS SQL backup
> database file with the ( .bak) extension into ( .sql) , I need that
> urgently please.
> Many Thanks in advance.
> Alabdulelah
You can restore a SQL Backup to SQL Server using the RESTORE DATABASE
command. Once you've done that you can script the database schema as a
SQL script using the Generate Script feature of SQL 2000 Enterprise
Manager or SQL 2005 Management Studio. (I assume SQL scripts are what
you mean when you say you want a .SQL file?)
Scripting the data itself may be harder depending on how much and how
complex it is. Two possible solutions:
http://vyaskn.tripod.com/code.htm#inserts
http://www.red-gate.com/products/SQ...mpare/index.htm
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Any difference between SQL Server 2000 and MSDE 2000?

I am creating an install program and I'm wondering if there is a

difference between SQL Server 2000 and MSDE 2000? Do they have

different entries in the Registry?

From the documentation that I've read it seems as if they are one and the same.

However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
ThanksMSDE 2000 is the desktop engine of the SQL Server 2000.|||So as far as Registry entries go, there would be no noticeable difference between the two....is that correct?