How to create new database in sql server 2005

Hello Friends,
I am using sql server 2005 and cant find a way to create and / or view databases.
In sql server 2000, there was enterprise manager to display sql registrations and connections.. How sql server 2005 differs from it.
Please help me.

If you are using SQL Server 2005 Express, you have noticed that it does not install any client tools, such as 'EnterPrise Mangler'.

For SQL Server 2005 Express, you can download SQL Server Management Studio Express from here. (SSMS is the replacement for Enterprise Manager.)

How to create a PopUp Report

Hi Friends,

No I m not looking for a drill down report.

I want a hiperlink on my country sales reports. When user will click on this hiperlink one popup window will open(Popup report). This popup report will contain some input parameter eg list box of sales person name and list of country to be selected select.

One user will select country germany and sales person as Mr Bin and click go on the poup report I want the popup report to be closed and based on the input(country germany and sales person as Mr Bin ) want my country sales reports to get updated.

Hope you undestand my qn.

thanks

Novin

You should be able to achieve this, except the popup would not be a report. It would need to be some custom html page that collects user input and then submits it to opener page with the selection.

To navigate to the popup:

In your report add a textbox with an action of "Jump to URL" and set this to

javascript:window.open()

OR

javascript:window.showModalDialog()

To pass parameters from the popup:

Call a javascript function onclick of the submit button that does something like

Code Snippet

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

I've not tried this but theoretically it should work.

|||Hi Adam,

Thanks a lot for your kind and quick reply.

I will try this out. One qn. then the popup page(which must not be a report) need to be a php or JSP page which will have some database connection code and it will fill the input parameters listboxes.

Correct me if I am wrong and also suggest me the popup page implementation bcas I m new to microsoft technologies.

Thanks
Novin
|||

You are in control of the popup and it's implementation is totally up to you as long as your web server can handle it. Possible options are:

static html with hard coded lists of options

dynamic webpage, the technology is immaterial but you're likely to get better integration using ASP.NET 2.0

parametrs could be queried directly from database tables

OR you can connect to the RS web service and use the queries and connections defined within the report RDL to retrieve a collection of ValidValues (recommended)

|||Hi Adam,

As per your explaination it looks possible to me.

But I have one more doubt regarding the parameter passing to the parent report from the popup report and auto refreshing the parent report.

Using following code I can pass the selectede parameters back to the detail report but I want that detail report be get refreshed(hit the dabase and re executing the report sql) without user intervantion with new parameters. Is that possible or the user need to manually again click the some controll to get the new data with passed parameters from the popup page.

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

Thanks
Novin
|||

Whenever you change the value of location.href in javascript IE automatiacally posts back. This would be driven from the javascript and no user intervention is required.

How to create a PopUp Report

Hi Friends,

No I m not looking for a drill down report.

I want a hiperlink on my country sales reports. When user will click on this hiperlink one popup window will open(Popup report). This popup report will contain some input parameter eg list box of sales person name and list of country to be selected select.

One user will select country germany and sales person as Mr Bin and click go on the poup report I want the popup report to be closed and based on the input(country germany and sales person as Mr Bin ) want my country sales reports to get updated.

Hope you undestand my qn.

thanks

Novin

You should be able to achieve this, except the popup would not be a report. It would need to be some custom html page that collects user input and then submits it to opener page with the selection.

To navigate to the popup:

In your report add a textbox with an action of "Jump to URL" and set this to

javascript:window.open()

OR

javascript:window.showModalDialog()

To pass parameters from the popup:

Call a javascript function onclick of the submit button that does something like

Code Snippet

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

I've not tried this but theoretically it should work.

|||Hi Adam,

Thanks a lot for your kind and quick reply.

I will try this out. One qn. then the popup page(which must not be a report) need to be a php or JSP page which will have some database connection code and it will fill the input parameters listboxes.

Correct me if I am wrong and also suggest me the popup page implementation bcas I m new to microsoft technologies.

Thanks
Novin
|||

You are in control of the popup and it's implementation is totally up to you as long as your web server can handle it. Possible options are:

static html with hard coded lists of options

dynamic webpage, the technology is immaterial but you're likely to get better integration using ASP.NET 2.0

parametrs could be queried directly from database tables

OR you can connect to the RS web service and use the queries and connections defined within the report RDL to retrieve a collection of ValidValues (recommended)

|||Hi Adam,

As per your explaination it looks possible to me.

But I have one more doubt regarding the parameter passing to the parent report from the popup report and auto refreshing the parent report.

Using following code I can pass the selectede parameters back to the detail report but I want that detail report be get refreshed(hit the dabase and re executing the report sql) without user intervantion with new parameters. Is that possible or the user need to manually again click the some controll to get the new data with passed parameters from the popup page.

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

Thanks
Novin
|||

Whenever you change the value of location.href in javascript IE automatiacally posts back. This would be driven from the javascript and no user intervention is required.

How to create a PopUp Report

Hi Friends,

No I m not looking for a drill down report.

I want a hiperlink on my country sales reports. When user will click on this hiperlink one popup window will open(Popup report). This popup report will contain some input parameter eg list box of sales person name and list of country to be selected select.

One user will select country germany and sales person as Mr Bin and click go on the poup report I want the popup report to be closed and based on the input(country germany and sales person as Mr Bin ) want my country sales reports to get updated.

Hope you undestand my qn.

thanks

Novin

You should be able to achieve this, except the popup would not be a report. It would need to be some custom html page that collects user input and then submits it to opener page with the selection.

To navigate to the popup:

In your report add a textbox with an action of "Jump to URL" and set this to

javascript:window.open()

OR

javascript:window.showModalDialog()

To pass parameters from the popup:

Call a javascript function onclick of the submit button that does something like

Code Snippet

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

I've not tried this but theoretically it should work.

|||Hi Adam,

Thanks a lot for your kind and quick reply.

I will try this out. One qn. then the popup page(which must not be a report) need to be a php or JSP page which will have some database connection code and it will fill the input parameters listboxes.

Correct me if I am wrong and also suggest me the popup page implementation bcas I m new to microsoft technologies.

Thanks
Novin
|||

You are in control of the popup and it's implementation is totally up to you as long as your web server can handle it. Possible options are:

static html with hard coded lists of options

dynamic webpage, the technology is immaterial but you're likely to get better integration using ASP.NET 2.0

parametrs could be queried directly from database tables

OR you can connect to the RS web service and use the queries and connections defined within the report RDL to retrieve a collection of ValidValues (recommended)

|||Hi Adam,

As per your explaination it looks possible to me.

But I have one more doubt regarding the parameter passing to the parent report from the popup report and auto refreshing the parent report.

Using following code I can pass the selectede parameters back to the detail report but I want that detail report be get refreshed(hit the dabase and re executing the report sql) without user intervantion with new parameters. Is that possible or the user need to manually again click the some controll to get the new data with passed parameters from the popup page.

function loadReport(param1)

{

window.opener.location.href = opener.location.href + "&param1=" + param1;

window.opener.focus();

window.close();

}

Thanks
Novin
|||

Whenever you change the value of location.href in javascript IE automatiacally posts back. This would be driven from the javascript and no user intervention is required.

How to create a database on pendrive using MSSQL 7.0?

Hey friends,
I want create a database on a usb pendrive and acess it my server is
MSSQL 7.0 when ever i plugin the pend drive.
Please let me know the the procedure .. this is a chellenging job..
Thank You
regards

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi

SQL Server does not support plug and play in such a way. There is a means to
create databases on removable media (avaiable in SQL 2000 but I can't check
SQL 7) called sp_create_removable, which is aimed at distributing databases
on read only media.

Therefore you will have to manually make sure that the database was
detached/attached correctly
http://support.microsoft.com/defaul...kb;EN-US;224071

Personally I would only store a backup on removably media like this and
overwrite/restore it when necessary.

John

"Vikram Jain" <vicky_j77@.hotmail.com> wrote in message
news:4143f445$0$26124$c397aba@.news.newsgroups.ws.. .
> Hey friends,
> I want create a database on a usb pendrive and acess it my server is
> MSSQL 7.0 when ever i plugin the pend drive.
> Please let me know the the procedure .. this is a chellenging job..
> Thank You
> regards
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||John Bell (jbellnewsposts@.hotmail.com) writes:
> SQL Server does not support plug and play in such a way. There is a
> means to create databases on removable media (avaiable in SQL 2000 but I
> can't check SQL 7) called sp_create_removable, which is aimed at
> distributing databases on read only media.

I made a quick check, and sp_create_removable is available on SQL7.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

How to create a database on MS SQL Server Desktop Engine

Dear friends,

Can anybody give me some piece of information about creating a database on SQL Server Desktop Engine.

I have installed MSDE 2000 (Rel A) on my system running Win 2000 Prof. The SQL Server icon is now visible on my taskpar with green arrow showing 'Running - \\ALI-LAPTOP' But I want to use it to accomodate my database currently in Access. I have tried to use Upsizing Wizard to create new database on it but it is giving this error (Login failed for user 'sa' (with password 'sa'). Not associated with a trusted SQL Server connection.)

I was also not able to connect it with ODBC.

Can you please help me even if seems to be setup problem. Because, the MSDE setup completed successfully with a good system restart.

Regards,
Zulfiqar AliBased on your description you are not providing the correct password for the SA account, or you are not using Mixed Mode authentication. You need to know which Authentication method you enabled when you installed MSDE to know how to log in.
Let’s assume you didn’t specify anything, then you are using Windows Authentication and the SA account isn’t enabled. In that case, the Upsize Wizard in Access will only work if you choose the option to use Windows Authentication when choosing your database. If you want to create a database without using the Upsize Wizard, you can do that using oSQL to run a CREATE DATABASE statement.
More information about oSQL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp
Help on CREATE DATABASE statement: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp?frame=true
If you are using Mixed Mode authentication you should be able to log in using an appropriate User/Password combination. Make sure you are using the right password for your SA account, you would have had to set the password when you installed MSDE.
Hope this helps,

Mike

How to correct index problems in system tables

Hi friends, I have one corrupted index in sysobjects from
one user database (not master). The SQL Server don't
accept to use DBCC or drop and recreate the index to
system tables. In my backup the index alread is corrupted.
How can I fix this problem? I'm using SQL 2000 with the
last SP.DBCC DBREINDEX would help in rebuilding the corrupted index. I notice you
say the SQL Server doesn't accept DBCC though.
Why is this..? Permissions .. ?
--
HTH
Ryan Waight, MCDBA, MCSE
"Khayman" <himura@.click21.com.br> wrote in message
news:08d101c3b997$f77eabe0$a401280a@.phx.gbl...
> Hi friends, I have one corrupted index in sysobjects from
> one user database (not master). The SQL Server don't
> accept to use DBCC or drop and recreate the index to
> system tables. In my backup the index alread is corrupted.
> How can I fix this problem? I'm using SQL 2000 with the
> last SP.|||Hi ,
Please use the below undocumented system procedure This stored procedure can
be used to fix a corruption in a system table.
sp_fixindex dbname,tabname,indid
Before using this stored procedure the database has to be in single user
mode
See this link for more information: "How can I fix a corruption in a system
table?"
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14051
Thanks
Hari
MCDBA
"Khayman" <himura@.click21.com.br> wrote in message
news:08d101c3b997$f77eabe0$a401280a@.phx.gbl...
> Hi friends, I have one corrupted index in sysobjects from
> one user database (not master). The SQL Server don't
> accept to use DBCC or drop and recreate the index to
> system tables. In my backup the index alread is corrupted.
> How can I fix this problem? I'm using SQL 2000 with the
> last SP.|||i have tried this yet.
This only works for nonclustered indexes, but the
corrupted index is clustered.
Khayman.
>--Original Message--
>Hi ,
>Please use the below undocumented system procedure This
stored procedure can
>be used to fix a corruption in a system table.
>sp_fixindex dbname,tabname,indid
>Before using this stored procedure the database has to be
in single user
>mode
>See this link for more information: "How can I fix a
corruption in a system
>table?"
>http://www.windows2000faq.com/Articles/Index.cfm?
ArticleID=14051
>Thanks
>Hari
>MCDBA
>
>"Khayman" <himura@.click21.com.br> wrote in message
>news:08d101c3b997$f77eabe0$a401280a@.phx.gbl...
>> Hi friends, I have one corrupted index in sysobjects
from
>> one user database (not master). The SQL Server don't
>> accept to use DBCC or drop and recreate the index to
>> system tables. In my backup the index alread is
corrupted.
>> How can I fix this problem? I'm using SQL 2000 with the
>> last SP.
>
>.
>|||In Microsoft Documentation says:
"DBCC DBREINDEX is not supported for use on system tables."
I don't know why.
Khayman
>--Original Message--
>DBCC DBREINDEX would help in rebuilding the corrupted
index. I notice you
>say the SQL Server doesn't accept DBCC though.
>Why is this..? Permissions .. ?
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Khayman" <himura@.click21.com.br> wrote in message
>news:08d101c3b997$f77eabe0$a401280a@.phx.gbl...
>> Hi friends, I have one corrupted index in sysobjects
from
>> one user database (not master). The SQL Server don't
>> accept to use DBCC or drop and recreate the index to
>> system tables. In my backup the index alread is
corrupted.
>> How can I fix this problem? I'm using SQL 2000 with the
>> last SP.
>
>.
>|||Please contact Product Support who are best placed to help you with this.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Khayman" <himura@.click21.com.br> wrote in message
news:000101c3b9b7$53f1dfe0$a301280a@.phx.gbl...
> i have tried this yet.
> This only works for nonclustered indexes, but the
> corrupted index is clustered.
> Khayman.
>
> >--Original Message--
> >Hi ,
> >
> >Please use the below undocumented system procedure This
> stored procedure can
> >be used to fix a corruption in a system table.
> >
> >sp_fixindex dbname,tabname,indid
> >
> >Before using this stored procedure the database has to be
> in single user
> >mode
> >
> >See this link for more information: "How can I fix a
> corruption in a system
> >table?"
> >
> >http://www.windows2000faq.com/Articles/Index.cfm?
> ArticleID=14051
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >
> >"Khayman" <himura@.click21.com.br> wrote in message
> >news:08d101c3b997$f77eabe0$a401280a@.phx.gbl...
> >> Hi friends, I have one corrupted index in sysobjects
> from
> >> one user database (not master). The SQL Server don't
> >> accept to use DBCC or drop and recreate the index to
> >> system tables. In my backup the index alread is
> corrupted.
> >> How can I fix this problem? I'm using SQL 2000 with the
> >> last SP.
> >
> >
> >.
> >|||We have the same issue. Did you resolve your problem? How did it go?