Hi Folks,
I'm new to the MS SQL Server world. Couple quick questions:
1) Can I use the current version of Mangement Studio Express (MSE) to
create/update/delete fields/tables on an existing SQL Server 2000?
2) How do I get connected over the 'Net? I have created an ODBC system
DSN which passes the connection test, but I don't see anywhere in MSE where
I can select from a list of system DSNs
3) If MSE is not the correct db administration client for SQL Server
2000, what is?
Your help is appreciated.
> 1) Can I use the current version of Mangement Studio Express (MSE) to
> create/update/delete fields/tables on an existing SQL Server 2000?
SQLMSE has the same "engine" (SMO) like the big brother. But there are
still some limitations:
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
> 2) How do I get connected over the 'Net? I have created an ODBC syst=
em
> DSN which passes the connection test, but I don't see anywhere in MSE whe=
re
> I can select from a list of system DSNs
You don=B4t need DSNs. They should be wiped out DNSless connections. All
you need is a connecting string to the server, which will be created
behind the scenes after registring a server in the management Studio.
> 3) If MSE is not the correct db administration client for SQL Server
> 2000, what is?
Well, that depends. Depends on how much you want to achieve and want to
administer. make sure that the knockout limitations mentioned in 1)
will not affect your daily work.
HTH, Jens K. Suessmeyer,
http://www.sqlserver2005.de
Sunday, February 12, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment