Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:
C:\msderela>setup sapwd = hillary instancename=mjh targetdir=c:\mike
The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed...any ideas of what I'm doing wrong...I really don't know anything about this at all.
ThanksSounds like you've tried it a couple of time already, huh?
Bounce the box, see what you got :)|||Like I said...I know nothing about this...bounce the box? sorry for being so stupid|||ummm. Reboot? Restart? Unplug and then re-plug? Either one will work ;)|||Originally posted by rdjabarov
Sounds like you've tried it a couple of time already, huh?
Bounce the box, see what you got :)
Is it possible to do if it does not look like a box (laptop)... ;)|||I've rebooted several times and still get the same results...|||What is the OS on your laptop?|||2000 pro|||progress bar going backwards?? check if the monitor is kept upside down??|||Thanks....|||I don't know if this will help but I have attached the error log. I don't understand what it is saying.|||Where is your log file?|||I'm sending the file again|||Do you have enough hard disk space?|||I have 2.43 GB|||I'm wondering if the problem is
C:\msderela>setup sapwd = hillary instancename=mjh targetdir=c:\mike
I pasted the text from Microsoft website:
TARGETDIR="executable_folder_path"
Specifies the folder where the Desktop Engine executable files are to be installed. The default for executable_folder_path when installing a default instance is C:\Program Files\Microsoft SQL Server\MSSQL\Binn\. The default for executable_folder_path when installing a named instance is C:\Program Files\Microsoft SQL Server\MSSQL$<InstanceName>\Binn\, where <InstanceName> is the name specified in the INSTANCENAME option. The file path for this parameter must end with a backslash (\).
Read the details at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp|||Nope...still won't install|||Did you try to click the file Setup.exe for the installation and use the default folder?
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/errorpages/smarterror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/errorpages/smarterror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 7, 2012
Meta Data services?
Hi
I'm very new to SQL Server 2000. I'm a student applied informatics and for my personal training I work in a software company.
My job exists of learning & using MS SQL Server 2000. I worked a lot and SQL Server 2000 works well.
The only thing I really don't understand is META DATA SERVICES !
So, my question to ...
What is the purpose of Meta data
How can I manage meta data in SQL Server 2000
Where can I find some good resources for learning to work with meta data in SQL Server 2000.
Thanks !!!
JHi
Is this topic so difficult?
I always heard that meta data was an important step in devellopement?
Is this true or not?|||Meta Data are the data of the data... What does it mean? Well, you need to store information to define a column in a table, like varchar(50) NULL. This information are called Meta Data.
The use of it? The other day I built a fast web form that had to validate the size of the string the user was entering. Depending of the option selected, I had to insert the string in a varchar(15), (18), (50) or (65) column. I wrote a stored proc that was returning the size of the field I had to write in, which I put in my MAXLENGTH web tag, using javascript.
So my stored proc reads the meta data of the field I ask for...
Fun isn't it?
I'm very new to SQL Server 2000. I'm a student applied informatics and for my personal training I work in a software company.
My job exists of learning & using MS SQL Server 2000. I worked a lot and SQL Server 2000 works well.
The only thing I really don't understand is META DATA SERVICES !
So, my question to ...
What is the purpose of Meta data
How can I manage meta data in SQL Server 2000
Where can I find some good resources for learning to work with meta data in SQL Server 2000.
Thanks !!!
JHi
Is this topic so difficult?
I always heard that meta data was an important step in devellopement?
Is this true or not?|||Meta Data are the data of the data... What does it mean? Well, you need to store information to define a column in a table, like varchar(50) NULL. This information are called Meta Data.
The use of it? The other day I built a fast web form that had to validate the size of the string the user was entering. Depending of the option selected, I had to insert the string in a varchar(15), (18), (50) or (65) column. I wrote a stored proc that was returning the size of the field I had to write in, which I put in my MAXLENGTH web tag, using javascript.
So my stored proc reads the meta data of the field I ask for...
Fun isn't it?
Meta Data cleanup
I have a quick question that I could not find the answer for anywhere.
The software developers that provided our SQL database program advised us to
put the subscription expiration on "never expire" because of their past
experience with customers who do not maintain their databases. Because of
this we now how massive meta data tables that need to be purged to increase
replkication performance (synchronization is extrmely slow). I have tried
setting the subscription retention to 14 days, but the amount of data to be
purged is huge and it interferes with the synchroniztion over night.
What I would like to do is use the stored procedure
sp_mergemetadataretentioncleanup to individually clean up the meta data
tables at each subscriber and the publisher. My problem is that I can not
find the parameters and correct syntax for this procedure anywhere. I have
seen the following:
sp_mergemetadataretentioncleanup (?,?,?)
but I don't know what to use to fill the question mark. I'm assuming I need
parameters since it seems doubtful the procedure is complete in itself (I'm
guessing a parameter is retention time and probably database?).
Thanks for the help.
Pete
these are output parameters.
declare @.num_genhistory_rows int , @.num_contents_rows int ,
@.num_tombstone_rows int
exec sp_mergemetadataretentioncleanup @.num_genhistory_rows output,
@.num_contents_rows output, @.num_tombstone_rows output
print @.num_genhistory_rows
print @.num_contents_rows
print @.num_tombstone_rows
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pete" <Pete@.discussions.microsoft.com> wrote in message
news:C19A9C44-1298-4AC0-8088-57D4ED4DD799@.microsoft.com...
> I have a quick question that I could not find the answer for anywhere.
> The software developers that provided our SQL database program advised us
to
> put the subscription expiration on "never expire" because of their past
> experience with customers who do not maintain their databases. Because of
> this we now how massive meta data tables that need to be purged to
increase
> replkication performance (synchronization is extrmely slow). I have tried
> setting the subscription retention to 14 days, but the amount of data to
be
> purged is huge and it interferes with the synchroniztion over night.
> What I would like to do is use the stored procedure
> sp_mergemetadataretentioncleanup to individually clean up the meta data
> tables at each subscriber and the publisher. My problem is that I can not
> find the parameters and correct syntax for this procedure anywhere. I have
> seen the following:
> sp_mergemetadataretentioncleanup (?,?,?)
> but I don't know what to use to fill the question mark. I'm assuming I
need
> parameters since it seems doubtful the procedure is complete in itself
(I'm
> guessing a parameter is retention time and probably database?).
> Thanks for the help.
> Pete
The software developers that provided our SQL database program advised us to
put the subscription expiration on "never expire" because of their past
experience with customers who do not maintain their databases. Because of
this we now how massive meta data tables that need to be purged to increase
replkication performance (synchronization is extrmely slow). I have tried
setting the subscription retention to 14 days, but the amount of data to be
purged is huge and it interferes with the synchroniztion over night.
What I would like to do is use the stored procedure
sp_mergemetadataretentioncleanup to individually clean up the meta data
tables at each subscriber and the publisher. My problem is that I can not
find the parameters and correct syntax for this procedure anywhere. I have
seen the following:
sp_mergemetadataretentioncleanup (?,?,?)
but I don't know what to use to fill the question mark. I'm assuming I need
parameters since it seems doubtful the procedure is complete in itself (I'm
guessing a parameter is retention time and probably database?).
Thanks for the help.
Pete
these are output parameters.
declare @.num_genhistory_rows int , @.num_contents_rows int ,
@.num_tombstone_rows int
exec sp_mergemetadataretentioncleanup @.num_genhistory_rows output,
@.num_contents_rows output, @.num_tombstone_rows output
print @.num_genhistory_rows
print @.num_contents_rows
print @.num_tombstone_rows
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pete" <Pete@.discussions.microsoft.com> wrote in message
news:C19A9C44-1298-4AC0-8088-57D4ED4DD799@.microsoft.com...
> I have a quick question that I could not find the answer for anywhere.
> The software developers that provided our SQL database program advised us
to
> put the subscription expiration on "never expire" because of their past
> experience with customers who do not maintain their databases. Because of
> this we now how massive meta data tables that need to be purged to
increase
> replkication performance (synchronization is extrmely slow). I have tried
> setting the subscription retention to 14 days, but the amount of data to
be
> purged is huge and it interferes with the synchroniztion over night.
> What I would like to do is use the stored procedure
> sp_mergemetadataretentioncleanup to individually clean up the meta data
> tables at each subscriber and the publisher. My problem is that I can not
> find the parameters and correct syntax for this procedure anywhere. I have
> seen the following:
> sp_mergemetadataretentioncleanup (?,?,?)
> but I don't know what to use to fill the question mark. I'm assuming I
need
> parameters since it seems doubtful the procedure is complete in itself
(I'm
> guessing a parameter is retention time and probably database?).
> Thanks for the help.
> Pete
Subscribe to:
Posts (Atom)