Showing posts with label associated. Show all posts
Showing posts with label associated. Show all posts

Friday, February 24, 2012

Adding Entity after model creation

I'm woundering if and how it is possible to add a entity to a report model that is directly associated with a database table after the model has already been created?

Thanks for the help if there is any.

You will need to refresh the Data Source View (.dsv) first to pull in the schema for your new table. You can then right-click on the root node in the Model Designer and choose New->Entity. Set the Binding property of the new entity to the new table.

Sunday, February 19, 2012

adding datafile to database

sql server 2000 sp4
Hi
I have a database that was initially created for 70MB. It has a application
associated with it and can not be deleted. I need to increase size of the
database to 440 GB. What is the best way of doing it.
--
ontario, canadaDo you want to add another file or increase the size of an existing file? Anyhow, both operations
are very straight forward:
ALTER DATABASE db ADD FILE (...)
ALTER DATABASE db MODIFY FILE (...)
You find exact syntax in Books Online. It will take a while to add or grow a file close to half a
terabyte...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"db" <db@.discussions.microsoft.com> wrote in message
news:0030A5B4-3B73-440A-9710-9A210DBBD9D9@.microsoft.com...
> sql server 2000 sp4
> Hi
> I have a database that was initially created for 70MB. It has a application
> associated with it and can not be deleted. I need to increase size of the
> database to 440 GB. What is the best way of doing it.
>
> --
> ontario, canada