Is it possible to modify column data type of view

The SQL Server Management Studio shows the data type of each column of views. I am wondering how SQL server determines the types since my SQL code of views does not specifiy data types for any columns.

I am much more interested in knowing whether the data types can be modified. Could anyone offer some hint?

Thanks,

hz

SQL Server uss the underlying schema information to do so unless you don′t specify a different data type than the source data type (liek within CONVERT). You can change the resulting data type in the view e.g. via CONNVERT(VARCHAR(10),GETDATE(),112), which was a datetime before and a varchar afterwards.

HTH, Jens Suessmeyer.|||

Jens, thanks a lot! That is exactly what I was looking for.

hz

Is it possible to insert a PDF File into a SQL 2k Table?

Hello,
I want to develop a small PDF Management System for our Web Insurance
Systems and Im wondering if I can use SQL Server to save my generated PDF
Documents. Is it possible? If so is it suggested? Are there any other
alternatives?
Jorge Luzarraga C
Fidens S.A.
321 7610 Anx 23
"I can do it quick. I can do it cheap. I can do it well. Pick any two."Jorge Luzarraga Castro wrote:
> Hello,
> I want to develop a small PDF Management System for our Web Insurance
> Systems and Im wondering if I can use SQL Server to save my generated PDF
> Documents. Is it possible? If so is it suggested? Are there any other
> alternatives?
>
It would be better to store the filenames to the PDF files in the
database. Otherwise, the database could become too large, or if the
database was to be corrupted, all pdf-files could be lost.
Steven|||> Is it possible?
Yes.

> If so is it suggested?
Typically, no.
http://www.aspfaq.com/2149

> Are there any other alternatives?
Yes, store the files in the filesystem, and their paths and other
information about them in the database.
A

Is it possible to export a View to Excel in MS SQL 2000 ?

Hi all,

In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I have many views I want
to simply export to Excel, but the only way I've found to do it is
creating an ODBC connection to the MS SQL database from MS Access,
linking the Views to Access Tables, and exporting from Access. surely
there's someway to export a View to Excel within MS SQL easily like
exporting a table...

Thanks --

AlexIf this is a one-off task, the Import/Export Wizard can export to a
..xls. If you need to run it regularly, then you can save the DTS
package created by the wizard, and modify it as required.

Simon

Is it possible to create a DTS package using Microsoft Sql server management studio

Is it possible to create a DTS package using microsoft sql server management studio. if yes? How can i do it.

Any help is appreciated.

Regards,

Karen

I'm not sure if it is possible to create a DTS package in SSMS but it is possible to edit and maintain existing DTS packages. The SQL Server 2000 DTS Designer Components are part of the 2005 Feature Pack.

http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

I would highly recommend using SSIS for any new development.

|||

Thanks a lot for your answer,

Cause i have couple of spread sheets which i need to import to database from a web based application, and i not sure as how can i import the values from the excel spread sheet to the database..

regards,

Karen

sql

Is it not possible to access sql 2005 database, without attaching it first in management s

Hi All ...

I am not facing a problem while connecting to sql server 2005 databse, when i attach that first, in management studio, then I can access that from localhost, its fine at this point. but when i detach that database from management studio i am facing the follwing error while accessing it from localhost i.e.

System.Data.SqlClient.SqlException: Unable to open the physical file "D:\database\Hunzian.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file D:\database\Hunzian.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

The connection string to access that database is

undefined=@."Data

I will be happy to have your replies .

I am confused over " detach that database from management studio " - are just closing the connection for SQL Management Studio or are you detaching it.

Where is the database located w.r.t. to the localhost you refer to - is it on one of its drives or on a network share?

|||

Hi ... thanks for the reply ...

I am actually detaching the database from management studio, that database is actually situated at one of my local drive D:\Database\database.mdf. When I detach that database I am facing the above mentioned problem.

Regards

|||

Hi,

Is this error message thrown when you click detach? I think it might be generated when you connect to this database. Please check if you have granted proper permission on that folder to ASPNET account or Network Service account.

|||

Thanks,

When i detach the database from Management Studio, acctually i get this error while i try to connect to the database through localhost.

I am able to connect to the database when i attach database first from management studio then connect through localhost

What i want is:

I have detached the database from management studio, its fine uptill now, but i want to connect to that database from localhost without attaching it in management studio.

I hope you understood the scenario, the connection string works just fine while testing that in visual studio built in web server. I have already given permissions to ASPNET user.

Regards,

Is it a good idea to use management studio to manage SQL 2000?

Thank you, Max
Yes , you can but I have my doubt that it is a good /efficient/wise
practice.
Why not just to upgrade to SQL Server 2005 and use SSMS?
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:%23obaw7$UGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Thank you, Max
>
|||I use management studio to manage both 2000 and 2005 servers. The reason
being that we only have 2005 in test environments at the moment (awaiting the
first service pack before production), and because I am used to the
Management Studio now, I would rather have everything in one place and in one
tool.
'Just upgrading your servers to 2005' isnt really that quick and easy when
you have management and politics involved. And there are some
incompatibilities between 2000 and 2005 that you need to resolve, such as the
use of table hints (ie, in 2000 you dont need the WITH clause in a SELECT
statement. In 2005, you need to specifiy WITH).
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Maxwell2006" wrote:

> Thank you, Max
>
>
|||Maxwell2006 wrote:
> Thank you, Max
>
I've also been using SSMS for several months for managing both SQL2000
and SQL2005 and I haven't seen any problems. This biggest issue I can
think of right now, is that you can't use SSMS to edit/design DTS packages.
Regards
Steen

Is it a good idea to use management studio to manage SQL 2000?

Thank you, MaxYes , you can but I have my doubt that it is a good /efficient/wise
practice.
Why not just to upgrade to SQL Server 2005 and use SSMS?
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:%23obaw7$UGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Thank you, Max
>|||I use management studio to manage both 2000 and 2005 servers. The reason
being that we only have 2005 in test environments at the moment (awaiting th
e
first service pack before production), and because I am used to the
Management Studio now, I would rather have everything in one place and in on
e
tool.
'Just upgrading your servers to 2005' isnt really that quick and easy when
you have management and politics involved. And there are some
incompatibilities between 2000 and 2005 that you need to resolve, such as th
e
use of table hints (ie, in 2000 you dont need the WITH clause in a SELECT
statement. In 2005, you need to specifiy WITH).
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Maxwell2006" wrote:

> Thank you, Max
>
>|||Maxwell2006 wrote:
> Thank you, Max
>
I've also been using SSMS for several months for managing both SQL2000
and SQL2005 and I haven't seen any problems. This biggest issue I can
think of right now, is that you can't use SSMS to edit/design DTS packages.
Regards
Steen

Is it a good idea to use management studio to manage SQL 2000?

Thank you, MaxYes , you can but I have my doubt that it is a good /efficient/wise
practice.
Why not just to upgrade to SQL Server 2005 and use SSMS?
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:%23obaw7$UGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Thank you, Max
>|||I use management studio to manage both 2000 and 2005 servers. The reason
being that we only have 2005 in test environments at the moment (awaiting the
first service pack before production), and because I am used to the
Management Studio now, I would rather have everything in one place and in one
tool.
'Just upgrading your servers to 2005' isnt really that quick and easy when
you have management and politics involved. And there are some
incompatibilities between 2000 and 2005 that you need to resolve, such as the
use of table hints (ie, in 2000 you dont need the WITH clause in a SELECT
statement. In 2005, you need to specifiy WITH).
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Maxwell2006" wrote:
> Thank you, Max
>
>|||Maxwell2006 wrote:
> Thank you, Max
>
I've also been using SSMS for several months for managing both SQL2000
and SQL2005 and I haven't seen any problems. This biggest issue I can
think of right now, is that you can't use SSMS to edit/design DTS packages.
Regards
Steen

Is cube browser available as seperate control for use in winforms app?

I love the cube browser in SQL Server management studio and would like to use it in a client app. But I don't want to give end users the SQL Server management studio.

Is it available as a seperate control or is there another one that would be available to me? I have tried the Excel addin for cube analysis but it is not as flexible and a Pivot Table report is pretty static.

Ta

Dirc

It's actually just a slightly modified OWC pivot table.|||

I installed OWC 11 and added a axPivotTable control to my winform. There were so many problems getting it to do anything I gave up.

Using COM controls designed for the web in a winform app seems a bit dodgy anyway....

|||I agree, it's a little odd to work with. And the properties aren't documented that well. But it's a lot better than having to code it yourself :)|||

Hi,

I am also trying to use the OWC control, but I am using it for a web based olap browser that needs to be integrated. If you have some links, material, information regarding the use of OWC, please do forward me the same.

Also, if you are succesful in implementing the OWC, give me some pointers.

thanks

Regards

|||

Found RadarCube NET Windows Forms for MS AS: http://www.radar-soft.com/products/radarwin_msas.aspx

Has similar functionality.