Describe command.

Hi,

I have some (OLD) college notes that say if I type

Describe tablename;
Name NOT NULL? Type

in my SQL code window in access once run it will give me the structure of the table.

When I try to run I get a Invalid SQL statement error 'DELETE', 'INSERT'...

Where am I going wrong.

Thanksoh, it's simple, your old notes are wrong, access doesn't support that commandsql

Deploying report into a folder

Hello,

I deploy my report through deploy command in the menu. If I create a folder in the report manager how can deploy my report into the folder?

Thanks,

Go to Project Prperties in that you have to type in the newly createdfolder name in the 'TargetFolder' also check the TargetServerURL.
This would solve your issue.

Deploy on the hoster

Dears,

I have devoloped an application ASP.NET 2.0.

Before I have builded the aspnetdb throught the command then I built some tables and stored procedures on this db. (My db is sql express 2005 and my hoster db is sql 2005 workgroup)

My hoster doesn't allow connection Management studio express, doesn't allow attach or restore functionalities.

Than I have built my script db (contains Tables, Views and Stored Procedures), I have substituted the dbo with my user account in the script because my hoster doesn't allow the dbo access.

I have also transfered my site files (.aspx, img, etc.) on the server.

When I try to access the db I receive this error (for example when I push on the button create user):

The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

Please could you help me?

Thank you.

I Forgot one thing!!

For allow the access throught an user different from dbo I have modified the "ASP.NET Provider Toolkit SQL Samples".

Thank you

Deploy of reports from command prompt

hi friends,

can anyone tell me that , how can we deploy the reports from command prompt ?

is there and command for that ?

any help will be greatly appreaciated

sandeep

Yes. There is a tool named RS.EXE which will do this for you. You point it at a script which publishes the report on your behalf. Here is a BOL help topic about a sample script you could modify:

http://msdn2.microsoft.com/en-us/library/ms160854(SQL.90).aspx

|||That link takes me to an OWA login screen....

Deploy MSDE using Command

I am using VB6 to install MSDE and here is my syntax.
Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM
It will install and show the progress bar all they way to about 4 second
left then freezes up. The log shows this as the last thing it did prior to
locking up "Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqlredis.exe /q:a"
Any idea what went wrong?
hi Grant,
Grant wrote:
> I am using VB6 to install MSDE and here is my syntax.
>
> Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM
> It will install and show the progress bar all they way to about 4
> second left then freezes up. The log shows this as the last thing it
> did prior to locking up "Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> Any idea what went wrong?
please have a look at http://tinyurl.com/dm5hs
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Interesting but I cannot do it through that process. It will be install on
thousands of customer so you can image the volume of calls we will get. I
will look for a different way to deploy MSDE. Thanks.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3vloskF164dfqU1@.individual.net...
> hi Grant,
> Grant wrote:
> please have a look at http://tinyurl.com/dm5hs
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>