Icon missing

Hi,
After fresh installation of 2k/SE there is no icon (servcice center) on the bottom right tool bar.
I’m wondering what could cause that; can I add the missing icon somehow?
Thx,
Dobby
Rebooting the server solves it, it is in the Startup group. Or you can just
start Service manager from the SQL Server Program group.
Jacco Schalkwijk
SQL Server MVP
"nemohm" <nemohm@.discussions.microsoft.com> wrote in message
news:756A55C1-40CC-4805-A4BC-CBDED57C1FEE@.microsoft.com...
> Hi,
> After fresh installation of 2k/SE there is no icon (servcice center) on
the bottom right tool bar.
> I'm wondering what could cause that; can I add the missing icon somehow?
> Thx,
> Dobby
>
|||Thank you,
Dobby
"Jacco Schalkwijk" wrote:

> Rebooting the server solves it, it is in the Startup group. Or you can just
> start Service manager from the SQL Server Program group.
> --
> Jacco Schalkwijk
> SQL Server MVP
> "nemohm" <nemohm@.discussions.microsoft.com> wrote in message
> news:756A55C1-40CC-4805-A4BC-CBDED57C1FEE@.microsoft.com...
> the bottom right tool bar.
>
>

Icon missing

Hi,
After fresh installation of 2k/SE there is no icon (servcice center) on the
bottom right tool bar.
I’m wondering what could cause that; can I add the missing icon somehow?
Thx,
DobbyRebooting the server solves it, it is in the Startup group. Or you can just
start Service manager from the SQL Server Program group.
Jacco Schalkwijk
SQL Server MVP
"nemohm" <nemohm@.discussions.microsoft.com> wrote in message
news:756A55C1-40CC-4805-A4BC-CBDED57C1FEE@.microsoft.com...
> Hi,
> After fresh installation of 2k/SE there is no icon (servcice center) on
the bottom right tool bar.
> I'm wondering what could cause that; can I add the missing icon somehow?
> Thx,
> Dobby
>|||Thank you,
Dobby
"Jacco Schalkwijk" wrote:

> Rebooting the server solves it, it is in the Startup group. Or you can jus
t
> start Service manager from the SQL Server Program group.
> --
> Jacco Schalkwijk
> SQL Server MVP
> "nemohm" <nemohm@.discussions.microsoft.com> wrote in message
> news:756A55C1-40CC-4805-A4BC-CBDED57C1FEE@.microsoft.com...
> the bottom right tool bar.
>
>

IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379008&SiteID=1

Thanks

sql

IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379008&SiteID=1

Thanks

I wrote my own configuration tool to maintain the connection strings in a SQL table

I wrote my own VB app to maintain all of my connection strings and link them to packages. I then grab them at run time and set them as variables in memory.Sorry this was suppose to be a reply not a new post.

i want to create database

Hi
i have installed sql server and i didn't find any GUI tool like sqlserver 2000 to create database or list the avilable databases or run sql statements ,,,

can you help me

thanks in advance.

Hi Seco,

You can download Management Studio Express from the SQL Express download page.

Mike

|||Thanks mike for reply

is this tool come with workgroup edition? what it's name or the one you gave me can work with all versions of sql server?

2- how can i make relation between 2 tables ?

thanks in advance.|||

hi,

seco wrote:

Thanks mike for reply

is this tool come with workgroup edition? what it's name or the one you gave me can work with all versions of sql server?

quite, but not really... the "full" editions of SQL Server 2005 provides "SQL Server Management Studio", including futher "wizards" and the like being "the full tool" implementation...

SQL Server Management Studio Express is the "lite" version, available for free...

2- how can i make relation between 2 tables ?

you can use the "Diagram" feature of SQL Server Management Studio Express or, (and you should go that way for learning purpose), you should dig into the Data Definition Language statements like CREATE TABLE or ALTER TABLE statements where you can define this kind of constraint..

regards

|||

You might be interested in the learning resources that I posted in this thread, there are a bunch of videos that teach you how to use the tools and how to create the standard database objects such as tables, views and stored procedures.

Mike

I needa tool to uninstall a SQL Server completly!

Hey,
sometimes i need to reinstall a MS SQL Server, therefore i
need a tool to uninstall him first completly!
Somebody an idea?
Doesn't "Control Panel, Add/Remove Programs" work?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DJ Piet" <anonymous@.discussions.microsoft.com> wrote in message
news:055c01c4b6b5$21362970$a401280a@.phx.gbl...
> Hey,
> sometimes i need to reinstall a MS SQL Server, therefore i
> need a tool to uninstall him first completly!
> Somebody an idea?
|||Sorry, sometimes I have the problem to install a SQL Server
Version, because there are some fragments of an old
installation! I heard about a tool out of the developer
kit, but I don=B4t know the name, nore I can it get from! :-(
>--Original Message--
>Doesn't "Control Panel, Add/Remove Programs" work?
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
|||The KB below details the manual steps to remove SQL2000, you can use these
to tidy up any remnants left by the uninstall
How to manually remove SQL Server 2000
http://support.microsoft.com/default...;EN-US;q290991
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"DJ Piet" <anonymous@.discussions.microsoft.com> wrote in message
news:059401c4b6b8$307bbd70$a401280a@.phx.gbl...
Sorry, sometimes I have the problem to install a SQL Server
Version, because there are some fragments of an old
installation! I heard about a tool out of the developer
kit, but I dont know the name, nore I can it get from! :-(
>--Original Message--
>Doesn't "Control Panel, Add/Remove Programs" work?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
|||THX
I was looking for but it depends on the questions do made
to a database ;-)

>--Original Message--
>The KB below details the manual steps to remove SQL2000,
you can use these=20
>to tidy up any remnants left by the uninstall
>How to manually remove SQL Server 2000
>http://support.microsoft.com/default...;EN-US;q290991
>--=20
>HTH
>Jasper Smith (SQL Server MVP)
>http://www.sqldbatips.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"DJ Piet" <anonymous@.discussions.microsoft.com> wrote in
message=20
>news:059401c4b6b8$307bbd70$a401280a@.phx.gbl...
>Sorry, sometimes I have the problem to install a SQL Server
>Version, because there are some fragments of an old
>installation! I heard about a tool out of the developer
>kit, but I don=B4t know the name, nore I can it get from! :-(
>
>.
>

I need help using DTS Import/Export tool.

I am trying to use MS SQL Server 2000's Export/Import DTS tool to transfer an existing database on my pc to a remote web server. I am able to connect to the remote database that my web hosting package provided (and thanks to all of you who helped with with the connection issue). Now when I selected the option "Copy Tables and Views From Data Source" to do my transfer, the process completed successfully, but when I tried to do some queries, I get incorrect results. It seems like only the "table values" in my source database was copied. The data that describes how these tables are related (ie. constraints, primary keys, foreign keys, etc) seemed to have NOT been copied to the web database.

So I went back to do the transfer again, this time choosing the option "Copy Objects and Data Between SQL Servers". Now the transfer process proceeds smoothly for the first half (the first half seems to be the same as described above -- just copying the table values). But as it started to copy object data (around 59% done or so), it errored out with the following message:

"[Microsoft][ODBC SQL Server Driver][SQL Server]Only members of the sysadmin role or the database owner may set database options"

Then I went back to the options tab, and tried deselecting some of them. I tested a lot of various combinations, and finally I unchecked them ALL. But still I get the same error. Now, I dont know what "database options" it's referring to.

However, the odd thing is that even though the transfer process failed halfway through, my queries seem to be getting correct results now. I havent tested it much but the few that I tried out returned expected results.

My concern now is that why doesnt this tranfer process complete without errors? I'm worried that since there are still problems with the data transfer process, then there must still be (possibly hidden) problems with the "incomplete" copy of the database on the web server.

Can anyone pinpoint the cause of this?in my experience, when transferring multiple tables with DRI from one server to another, there are sometimes problems related to precedence. For example, when you tranfer relationships, keys, etc... the job might fail. What happens is that the process attempts to create the table with FK reference before the primary table. I havent seen the precise error that you are experiencing... but, would make sure that this is not happening to you...

Sometimes permissions are applied before the user has been created, resulting in an error...

you can also script the relationshipes, keys, etc... and apply them manually after all data has been copied.