DROP DATABASE Question

Hello,
in our project i have to drop an existing sql server database and
immediately create a new (and empty) one with exactly the same name. MSDN
says that in case of dropping a database also the physical files on the
harddrive are deleted but this is not the case, as sql server complains that
there's already a file with that name on disk.
Is there a way to delete also the disk files of a database using T-SQL or do
i have to choose a different approach?
Thanks in advance
ChristianIn 6.5 and older, the database files were not deleted when you execute DROP
DATABASE. As of 7.0,
they are. If you are seeing something different, you have either hit a bug i
n the product (unlikely)
or may have some problems in your scripts.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"chris" <chris@.discussions.microsoft.com> wrote in message
news:68AFCD1C-85B6-4661-9332-3F50830BF386@.microsoft.com...
> Hello,
> in our project i have to drop an existing sql server database and
> immediately create a new (and empty) one with exactly the same name. MSDN
> says that in case of dropping a database also the physical files on the
> harddrive are deleted but this is not the case, as sql server complains th
at
> there's already a file with that name on disk.
> Is there a way to delete also the disk files of a database using T-SQL or
do
> i have to choose a different approach?
> Thanks in advance
> Christian|||Check the default file location. Could it be that you previously created a
database with the same name in this location, but later abandoned it and
started creating databases with files in another location while the default
file location was left unchanged?
The easiest way would be to check your default location and check your file
system.
ML
http://milambda.blogspot.com/|||Thank you very much for your replies.
I found that before dropping the database it was set OFFLINE to disconnect
users and in this case the files remain on disk. I set it to SINGLE_USER
instead and then it worked.
Chris
"chris" wrote:

> Hello,
> in our project i have to drop an existing sql server database and
> immediately create a new (and empty) one with exactly the same name. MSDN
> says that in case of dropping a database also the physical files on the
> harddrive are deleted but this is not the case, as sql server complains th
at
> there's already a file with that name on disk.
> Is there a way to delete also the disk files of a database using T-SQL or
do
> i have to choose a different approach?
> Thanks in advance
> Christian|||> I found that before dropping the database it was set OFFLINE to disconnect
> users and in this case the files remain on disk.
That was news for me. Thanks for sharing the information, Chris.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"chris" <chris@.discussions.microsoft.com> wrote in message
news:B5951FCB-2434-4241-969C-02BF0E7816A3@.microsoft.com...
> Thank you very much for your replies.
> I found that before dropping the database it was set OFFLINE to disconnect
> users and in this case the files remain on disk. I set it to SINGLE_USER
> instead and then it worked.
> Chris
> "chris" wrote:
>

Drill-through to a report in another project

Hello All,

I am sure many people faced this problem before. I want to drill-through to a report in another project. I want to use "Jump to report" in the navigation tab.

I am able to use Jump to URL. But I cound not specify "method="post" target="_self" in the "Jump to URL" box.

Can some one help me on how to use:

1. "Jump to Report" for reports in another project.

2. Or. Help me specify method="post" target="_self"

Regards

Bobba

I found the solution.

I put ../anotherProject/reportname. anotherProject is really folder name on Reportserver .

Drill-through to a report in another project

Hello All,

I am sure many people faced this problem before. I want to drill-through to a report in another project. I want to use "Jump to report" in the navigation tab.

I am able to use Jump to URL. But I cound not specify "method="post" target="_self" in the "Jump to URL" box.

Can some one help me on how to use:

1. "Jump to Report" for reports in another project.

2. Or. Help me specify method="post" target="_self"

Regards

Bobba

I found the solution.

I put ../anotherProject/reportname. anotherProject is really folder name on Reportserver .

DRILLTHROUGH in report server

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

go to the textbox or the field, where you want to drill throught to another report by clicking on it.

right click and go to the properties

Use Navigation tab

there go to Hyperlink action and select the second option "Jump to the report" and select the report in the dropdown box

|||

Thank u Suresh

Now I got . Still I have one doubt how can we go to previous screen from the drill down. Please give me ...

Suresh where is ur place .. I am from Kerala now I am working in NI , UK

Regards

Polachan

DRILLTHROUGH in report server

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

I assume you are having problems with the query. There is a "bug" in SSRS that I logged here http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126175 and there is also a work around listed on this site.

If you are just after a sample, Nick Barclay has one on his blog here: http://nickbarclay.blogspot.com/2006/03/ssrs-mdx-drillthrough-gotcha.html

Drill through --relative path

I'm trying to use the drill-through feature to link to a report in different solution, on the same server, but in a different project. Local help files say: "The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."

The report will be passing a parameter to the target report through drill-through. The target report is located on different solution and project but on a same server (report manager). Any help will be be appreciated.

Can someone give an example of a relative path? Nothing I've tried has worked, and I've posted this on sqlteam to no avail.

Thanks,

Lalon

if your base directory is "c:/SomeProgram/"

relative_path -> absolute path
"dir1/dir2" -> "c:/SomeProgram/dir1/dir2/"
"../dir3" -> "c:/dir3/"

i don't know what and how you are using the relative paths, but if you are using paths in directly in code, in some programming languages you have to double the '/' ("../dir3" -> "..//dir3")

Amaral