.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

Hi,

I have followed the steps from the .NET FW SDK QuickStart Configuration (C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Samples\Setup\html\ConfigDetails.htm), and have got an error message trying to grant the ASP.NET User account access to the databases by the command sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin LEONEW\ASPNET" where LEONEW is my local machine name, and the ASPNET account exists in the Users group.

I am getting the error message: Msg 102, Level 15, State 1, Server LEONEW\SQLEXPRESS, Line 1
Incorrect syntax near '\'.

Please help if you know how to resolve this. Thanks in advance.

Alex.

Did you try putting apostrophes around the login name:

'LEONEW\ASPNET'

|||I have tried with no success sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin N' LEONEW\ASPNET'".|||

Do you get the same error?

What about

sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin 'LEONEW\ASPNET'"

If I use it without the apostrophes I get the same error as you:

Msg 102, Level 15, State 1, Server <...>, Line 1
Incorrect syntax near '\'.

If I add the apostrophes the command succeeds.

|||You are absolutely right. Thanks.

.net framework and sql2000

I'm having a problem regeistering a downloaded program. All firewalls were disabled before downloading. When the CD Key is input the following message occurs:

"An error has occurred attempting to register your copy of Encompass, The underlying connection was closed: Unable to connect to remote server."

The desktop engine (MDSE) was checked and running. The CD Key is correct.

I was steered to this website because someone felt that this may be a .network connectivity issue to Encompass registration. After weeks back and forth with the software techs at Encompass they have given up.

Can someone please help me. I'm willing to try anything. Keep in mind I am not a "computer tech" person but I can read and follow directions. I'm desperate!!!

This isn't the correct forum for your question. You might try the database engine forum or the SQL Express forum (SQL Express is the successor to MSDE). Unfortunately even on those forums they may not know the details of how Encompass registration works. Perhaps you could escalate this to Encompass support management.

.mdf to .mdb

My web host only supports .mdb database files, so is there a way to convert .mdf to .mdb with a program? Or would I have to do it by hand?

Thank you.

I am not aware that such a program exists.

Maybe you can use SQL Server DTS or SQL Server Transformation Services to download your database into a .mdb format.

|||Try to use this.
http://www.data-conversions.net/products.php?prod_num=1&&dest=MENU&&ID=100|||

I was having the same issue and followed these steps...

1. In your ODBC connections add a SQL server connection to your current SQL server and database.

2. Create a new Access Database

3. Import from ODBC source and select all tables.

The tables will import with a dbo_ prefix, but all of the structure and information will be there. It does not carry over the table relationships either.

Nick

.mdf to .mdb

My web host only supports .mdb database files, so is there a way to convert .mdf to .mdb with a program? Or would I have to do it by hand?

Thank you.

I am not aware that such a program exists.

Maybe you can use SQL Server DTS or SQL Server Transformation Services to download your database into a .mdb format.

|||Try to use this.
http://www.data-conversions.net/products.php?prod_num=1&&dest=MENU&&ID=100|||

I was having the same issue and followed these steps...

1. In your ODBC connections add a SQL server connection to your current SQL server and database.

2. Create a new Access Database

3. Import from ODBC source and select all tables.

The tables will import with a dbo_ prefix, but all of the structure and information will be there. It does not carry over the table relationships either.

Nick

..\MSSQL\Data\ - Directory saturated

C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
..ldb files that are huge, some reach 21GB! while backup files don't
exceed 8MB.

I guess it's a kind of transaction log, but I'm not sure.

Can I erase them all and lose no information?
Where I configure it to avoid it to happen in the future?

Thanks in advance.Try to shrink the database. Run the SQL Server Enterprise manager.
Right-click on the database of interest and select "all tasks | shrink
database" from the context menu. Try this witthout and then with the "move
pages" option checked. Free space "holes" can develop in your database as
storage expands and rows are added/deleted/updated. Doing index maintenance
may help, too but at 8MB vs 21GB, I'm thinking it's not just sparse page
fills but wholesale extents. You could set the databases for autoshrink but
this might cause operations in your database to slow down when you weren't
expecting it. Probably better to do it on a schedule.

You might also look at the properties and see how much space is used versus
allocated. Before looking at properties, be sure to right-click on the
database and do a "refresh" to get the figures updated.

Could be your log has never been dumped and truncated. You may have to set
up a maintenance plan. Check the Administrator's guide for advice. The log
is in the .LDF file.

"Pablo" <pablopettis@.yahoo.com> wrote in message
news:47ae7cc6.0407150630.4ad7be1d@.posting.google.c om...
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
> .ldb files that are huge, some reach 21GB! while backup files don't
> exceed 8MB.
> I guess it's a kind of transaction log, but I'm not sure.
> Can I erase them all and lose no information?
> Where I configure it to avoid it to happen in the future?
> Thanks in advance.|||Hi

Check out:
http://msdn.microsoft.com/library/d...ar_da2_1uzr.asp

If this is production machine you should think about moving the log files
onto a different set of spindles (disks/controller card) to the data files,
operating system and page file.

John

"Pablo" <pablopettis@.yahoo.com> wrote in message
news:47ae7cc6.0407150630.4ad7be1d@.posting.google.c om...
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and
> .ldb files that are huge, some reach 21GB! while backup files don't
> exceed 8MB.
> I guess it's a kind of transaction log, but I'm not sure.
> Can I erase them all and lose no information?
> Where I configure it to avoid it to happen in the future?
> Thanks in advance.

*** Can anyone explain me this ***

Hi:
I'm having a very strange and problematic behavior of SQL Server 2000 in my
program.

Program execution:
--------------
1.BEGIN TRANSACTION
2.EXECute for the first time a SP called sp_GAupdARMAZ_MOV, which inserts into a table ARMAZ_MOV a new record.
3.Til this point everything is ok!
4.EXECute for the second time sp_GAupdARMAZ_MOV, which I don't why rollbacks my transaction, aborting obviously the previously inserted record. But still continues execution without any error and inserts another record in my table ARMAZ_MOV.
5.COMMIT TRANSACTION

I make a "select * from armaz_mov" and there's only one record !!!!!!! What the hell? ... Can anyone explain me this???

I attached the SQL profiler trace of this problem, and an image of the exact line where my transaction is rolled back.

I analysed very well my SP and the only reason I encountered to explain this is because of an string concatenation with an integer in a SP line of code that's not even executed !!! Maybe a compilation error is causing this...
If I include a "convert(varchar,id)" in my string concatenation everything
works fine !!!!!!!!

If anyone could help me with this, maybe already had a similar problem, or maybe this is a known issue of SQL Server...

I would appreciate a lot if someone could analise for some minutes the
attached SQL Profiler trace and give me some feedback, opinion ...

Thanks a lot.
Monica
------------------------Can you post your stored procedure ? You may want to repost the profiler in zip format rather than rar.|||Originally posted by rnealejr
Can you post your stored procedure ? You may want to repost the profiler in zip format rather than rar.

Ok I reposted the Profiler trace in zip format and included my SP.|||What is the schema for the table ARMAZ_MOV ? Also, where are you executing the transaction (in query analyzer) ? Have you tried it in query analyzer to see if any errors are reported ? What are the exact statements that you are using to execute this transaction (including the parameters) ? You have to cast your int value to varchar anyway - but I am curious as well.|||Also, which version of sql server are you using - including service pack ?|||Originally posted by rnealejr
Also, which version of sql server are you using - including service pack ?

I execute my program in Delphi 6, W2K, with SQL Server 2000 and SP2 installed.
I'm connecting to my database and executing the SP using ADO.

The schema for my ARMAZ_MOV table is:
--
create table DBO.ARMAZ_MOV
(
ID_ARMAZ_MOV integer not null,
ID_REG_MOV integer not null,
REF_TIPO_MOV char(3) not null,
COD_FABRICA char(2) not null,
REF_TP_ARMAZ char(2) not null,
COD_ARTIGO varchar(10) not null,
DATA_MOV datetime not null,
QTD_MOV decimal(18,3) not null,
QTD_EXIST decimal(18,3) null ,
UNIDADE_MOV varchar(10) not null,
OBS_MOV varchar(200) null ,
INS_BY varchar(10) not null,
INS_DATE datetime not null,
UPD_BY varchar(10) not null,
UPD_DATE datetime not null,
STATUS_EXPORT varchar(15) null
constraint CKC_STATUS_EXPORT_ARMAZ_MO check (STATUS_EXPORT in ('EXPORTADO','NAO_EXPORTADO')),
ERRO_EXPORT varchar(200) null ,
TIPO_REG varchar(15) not null
constraint CKC_TIPO_REG_ARMAZ_MO check (TIPO_REG in ('NORMAL','CORRECCAO')),
ID_ORIGINAL integer null ,
constraint PK_ARMAZ_MOV primary key (ID_ARMAZ_MOV)
)|||I executed the 2 iterations of my program in qry analyser and everything worked fine.

So my conclusion is that problem is not from the DBMS but from the client side (ADO/Delphi).

I have to see if this is a known problem of ADO or Delphi, or not.

Rui Ferreira

* * * Passing Parameter - Urgent * * *

I program an ASP.NET application that uses SQL Server 2005 Reporting
Services.
Recently I came into a dead end when I had to pass a parameter from my
application
to the report. I 've looked over the Internet and found absolutely nothing.
If someone is
capable of doing that he/she doesn't have to be shy to share it with me.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.Hi,
What kind of parameter you must pass?|||Hi Cesar,
I have to pass four string parameters.
Two that will appear in the report and two
(from-to) that will be used in the query.
Thanks in advance,
Nick Hatzis
P.S. : To answer by e-mail remove the "bog" from the username.
"Cesar" <Cesar@.discussions.microsoft.com> wrote in message
news:490E74EF-519C-4D5E-BB69-C8412CB909C2@.microsoft.com...
> Hi,
> What kind of parameter you must pass?|||Are you using an URL to open the report? In that case, you should look at
the topic "URL access" in the SQL Server 2005 Books Online.
If you have it locally, this should be the URL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/52c3f2a3-3d6d-4fee-9c46-83f366919398.htm
Or find it online at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_urlaccess_374y.asp
Kaisa M. Lindahl Lervik
"Nick Hatzis" <boghatzisn@.panafonet.gr> wrote in message
news:%23MK70oQ7GHA.1012@.TK2MSFTNGP05.phx.gbl...
>I program an ASP.NET application that uses SQL Server 2005 Reporting
> Services.
> Recently I came into a dead end when I had to pass a parameter from my
> application
> to the report. I 've looked over the Internet and found absolutely
> nothing.
> If someone is
> capable of doing that he/she doesn't have to be shy to share it with me.
> Thanks in advance,
> Nick Hatzis
> P.S. : To answer by e-mail remove the "bog" from the username.
>|||On Wed, 11 Oct 2006 11:01:52 +0300, "Nick Hatzis"
<boghatzisn@.panafonet.gr> wrote:
>I program an ASP.NET application that uses SQL Server 2005 Reporting
>Services.
>Recently I came into a dead end when I had to pass a parameter from my
>application
>to the report. I 've looked over the Internet and found absolutely nothing.
>If someone is
>capable of doing that he/she doesn't have to be shy to share it with me.
>Thanks in advance,
>Nick Hatzis
>P.S. : To answer by e-mail remove the "bog" from the username.
>
Are you using reportviewer or just going direct to the URL? If direct
to the URL, something like this:
Response.Redirect("http://199.199.199.199/ReportServer?%2fReportProjectName%2fReportName&rs:Command=Render&rs:Format=PDF&IssueID=11000")
That IssueID at the end is a parameter. Note the rs:Format that gets
the report directly as a PDF.
If you're using a reportviewer control, parameters are done like this:
Dim RptParm As New
Microsoft.Reporting.WebForms.ReportParameter("FileNumParam",
lblFileNum.Text) ' name/value pair for a parameter
Dim RptParms As New Generic.List(Of
Microsoft.Reporting.WebForms.ReportParameter)
RptParms.Add(RptParm)
' add more parameters as necessary to RptParams
Reportviewer1.ServerReport.SetParameters(RptParms)