MSSQL, Microsoft SQL Server:
I succeeded in transferring a backup file from the SQL Server machine
to the client using OPENROWSET.
I used this way because it is not (always easy) possible to restore a
file residing on the client machine on a SQL Server.
One has to share drives on the client machine for remote SQL Server
access or better granting access on the SQL Server machine for the
client.
In my line of bussiness it is not possible to help every client on this
issue (several thousand users)
What I need to achieve is transferring backup to the server by using
SQL Server to do it and restoring it with SQL Server.
A solution for SQL 2005 would be perfect (it is not necessary to solve
this in SQL Server 2000). Using Named pipes is not an option because it
is no longer supported in SQL2005
Hi
"Oz" wrote:
> MSSQL, Microsoft SQL Server:
> I succeeded in transferring a backup file from the SQL Server machine
> to the client using OPENROWSET.
I am not sure why you are doing this, if you are actually talking about a
database backup. I assume this is a CSV or XML file? If so why not use the
BULK INSERT command? This will take a UNC name for the file if necessary.
> I used this way because it is not (always easy) possible to restore a
> file residing on the client machine on a SQL Server.
> One has to share drives on the client machine for remote SQL Server
> access or better granting access on the SQL Server machine for the
> client.
> In my line of bussiness it is not possible to help every client on this
> issue (several thousand users)
> What I need to achieve is transferring backup to the server by using
> SQL Server to do it and restoring it with SQL Server.
Have you looked at SSIS and loading the file using FTP either through a
package or User Interface (e.g
http://classicasp.aspfaq.com/general/how-do-i-ftp-files-from-asp.html ) onto
the SQL Server or somewhere which can be seen by the SQL Server and then
loading it from a package?
> A solution for SQL 2005 would be perfect (it is not necessary to solve
> this in SQL Server 2000). Using Named pipes is not an option because it
> is no longer supported in SQL2005
>
John
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
How to tell whether SQL Server is listening on port 1433 and port
If I run netstat -a on a machine with a default instance of SQL Server 2000 and the port has not been changed, should I see port 1433 and port 1434? Does it matter which SQL Server service pack has been applied?
Hi,
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>
|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>
Hi,
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>
|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>
How to tell whether SQL Server is listening on port 1433 and port
If I run netstat -a on a machine with a default instance of SQL Server 2000 and the port has not been changed, should I see port 1433 and port 1434? Does it matter which SQL Server service pack has been applied?Hi,
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
--
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>|||Hi Hari,
I can see port 1433 in the Server Network Utility. But I don't see port 1433 when I run netstat -a to check what port is active. I'm using Windows XP SP2 RC2 and have disabled Windows Firewall.
Thank you for your help,
Peter
"Hari Prasad" wrote:
> Hi,
> The port should be 1433.
> You can the see the port SQl Serevr Listening by-
> 1. Open Server network utility
> 2. In the enabled protocols -- Select TCP /IP and click properties to get
> the PORT number.
> --
> Note:
> For Default Instance SQL Server listen on port 1433, which is static.
> Thanks
> Hari
> MCDBA
>
>
> "peter" <peter@.discussions.microsoft.com> wrote in message
> news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> > If I run netstat -a on a machine with a default instance of SQL Server
> 2000 and the port has not been changed, should I see port 1433 and port
> 1434? Does it matter which SQL Server service pack has been applied?
> >
> >
>
>|||Hi,
Login to SQL server using a query analyzer window and issue the below
command from command prompt
nbtstat -n
In the local address you iwl be able to see the server ip addree:1433
Otherwise :- , From command prompt Telnet and see whether the port 1433 is
accessible.
TELNET ipaddress 1433
If the port is accessible, automatically the connection will be accessible
else u will get an error.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:142340D1-70EB-4F27-BF82-E2C8ED172081@.microsoft.com...
> Hi Hari,
> I can see port 1433 in the Server Network Utility. But I don't see port
1433 when I run netstat -a to check what port is active. I'm using Windows
XP SP2 RC2 and have disabled Windows Firewall.
> Thank you for your help,
> Peter
> "Hari Prasad" wrote:
> > Hi,
> >
> > The port should be 1433.
> >
> > You can the see the port SQl Serevr Listening by-
> >
> > 1. Open Server network utility
> > 2. In the enabled protocols -- Select TCP /IP and click properties to
get
> > the PORT number.
> >
> > --
> >
> > Note:
> > For Default Instance SQL Server listen on port 1433, which is static.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > "peter" <peter@.discussions.microsoft.com> wrote in message
> > news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> > > If I run netstat -a on a machine with a default instance of SQL Server
> > 2000 and the port has not been changed, should I see port 1433 and port
> > 1434? Does it matter which SQL Server service pack has been applied?
> > >
> > >
> >
> >
> >|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>> If I run netstat -a on a machine with a default instance of SQL Server
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>>
>
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
--
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>|||Hi Hari,
I can see port 1433 in the Server Network Utility. But I don't see port 1433 when I run netstat -a to check what port is active. I'm using Windows XP SP2 RC2 and have disabled Windows Firewall.
Thank you for your help,
Peter
"Hari Prasad" wrote:
> Hi,
> The port should be 1433.
> You can the see the port SQl Serevr Listening by-
> 1. Open Server network utility
> 2. In the enabled protocols -- Select TCP /IP and click properties to get
> the PORT number.
> --
> Note:
> For Default Instance SQL Server listen on port 1433, which is static.
> Thanks
> Hari
> MCDBA
>
>
> "peter" <peter@.discussions.microsoft.com> wrote in message
> news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> > If I run netstat -a on a machine with a default instance of SQL Server
> 2000 and the port has not been changed, should I see port 1433 and port
> 1434? Does it matter which SQL Server service pack has been applied?
> >
> >
>
>|||Hi,
Login to SQL server using a query analyzer window and issue the below
command from command prompt
nbtstat -n
In the local address you iwl be able to see the server ip addree:1433
Otherwise :- , From command prompt Telnet and see whether the port 1433 is
accessible.
TELNET ipaddress 1433
If the port is accessible, automatically the connection will be accessible
else u will get an error.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:142340D1-70EB-4F27-BF82-E2C8ED172081@.microsoft.com...
> Hi Hari,
> I can see port 1433 in the Server Network Utility. But I don't see port
1433 when I run netstat -a to check what port is active. I'm using Windows
XP SP2 RC2 and have disabled Windows Firewall.
> Thank you for your help,
> Peter
> "Hari Prasad" wrote:
> > Hi,
> >
> > The port should be 1433.
> >
> > You can the see the port SQl Serevr Listening by-
> >
> > 1. Open Server network utility
> > 2. In the enabled protocols -- Select TCP /IP and click properties to
get
> > the PORT number.
> >
> > --
> >
> > Note:
> > For Default Instance SQL Server listen on port 1433, which is static.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > "peter" <peter@.discussions.microsoft.com> wrote in message
> > news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> > > If I run netstat -a on a machine with a default instance of SQL Server
> > 2000 and the port has not been changed, should I see port 1433 and port
> > 1434? Does it matter which SQL Server service pack has been applied?
> > >
> > >
> >
> >
> >|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>> If I run netstat -a on a machine with a default instance of SQL Server
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>>
>
How to tell whether SQL Server is listening on port 1433 and port
If I run netstat -a on a machine with a default instance of SQL Server 2000
and the port has not been changed, should I see port 1433 and port 1434? Do
es it matter which SQL Server service pack has been applied?Hi,
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>
and the port has not been changed, should I see port 1433 and port 1434? Do
es it matter which SQL Server service pack has been applied?Hi,
The port should be 1433.
You can the see the port SQl Serevr Listening by-
1. Open Server network utility
2. In the enabled protocols -- Select TCP /IP and click properties to get
the PORT number.
Note:
For Default Instance SQL Server listen on port 1433, which is static.
Thanks
Hari
MCDBA
"peter" <peter@.discussions.microsoft.com> wrote in message
news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
> If I run netstat -a on a machine with a default instance of SQL Server
2000 and the port has not been changed, should I see port 1433 and port
1434? Does it matter which SQL Server service pack has been applied?
>|||Port 1433 is used by default only for the default (unnamed) instance
of the server. Named instances communicate over random prt numbers
unless you set them for port 1433 using the Server Network Utility.
Look under Program files and run the Svrnetcn.exe file that is in the
SQL Server Tools\Binn folder
See the article:
http://support.microsoft.com/default.aspx?kbid=814130
On Sun, 20 Jun 2004 08:02:18 +0530, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Hi,
>The port should be 1433.
>You can the see the port SQl Serevr Listening by-
>1. Open Server network utility
>2. In the enabled protocols -- Select TCP /IP and click properties to get
>the PORT number.
>--
>Note:
>For Default Instance SQL Server listen on port 1433, which is static.
>Thanks
>Hari
>MCDBA
>
>
>"peter" <peter@.discussions.microsoft.com> wrote in message
>news:17C8C6CA-4929-41B8-BA6E-2FEF6AAB91BD@.microsoft.com...
>2000 and the port has not been changed, should I see port 1433 and port
>1434? Does it matter which SQL Server service pack has been applied?
>
how to tell SP level?
How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
Wednesday, March 21, 2012
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> Your SQL Server is SP3
> Markus
>sql
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> > on Windows NT 5.2 (Build 3790: Service Pack 1)
> Your SQL Server is SP3
> Markus
>sql
How to tell what service patches are applied
I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:
> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>
how to tell SP level?
How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria
How to tell if SP1 is installed?
Hi,
I was just wondering if somebody could tell me how to check and see if SP1
for SQL Reporting Services is installed on a particular machine?
Thanks>From the SP1 ReadMe:
"To identify which version of Reporting Services you have installed,
type the URL of the report server (for example,
http://<exampleWebServer>/reportserver). Version information is located
at the bottom of the page. The final product release is build
8.00.0743.00."
My SP1 installation is 8.00.878.00.
HTH
Erik|||Enter http://YourReportServerName/ReportServer in your browser. If the
version displayed is 8.00.878.00, then you have SP1.
Bob
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks|||Hi,
You can check the version number from http://machine/reportserver url.
Microsoft SQL Server Reporting Services Version 8.00.743.00 is version 1
without SP
Version 8.00.0878 is the onewith SP1
Microsoft SQL Server Reporting Services Version 9.00.852.00 is the latest
version coming with SQL Server 2005 Beta 2
Eralper
http://www.kodyaz.com
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks
I was just wondering if somebody could tell me how to check and see if SP1
for SQL Reporting Services is installed on a particular machine?
Thanks>From the SP1 ReadMe:
"To identify which version of Reporting Services you have installed,
type the URL of the report server (for example,
http://<exampleWebServer>/reportserver). Version information is located
at the bottom of the page. The final product release is build
8.00.0743.00."
My SP1 installation is 8.00.878.00.
HTH
Erik|||Enter http://YourReportServerName/ReportServer in your browser. If the
version displayed is 8.00.878.00, then you have SP1.
Bob
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks|||Hi,
You can check the version number from http://machine/reportserver url.
Microsoft SQL Server Reporting Services Version 8.00.743.00 is version 1
without SP
Version 8.00.0878 is the onewith SP1
Microsoft SQL Server Reporting Services Version 9.00.852.00 is the latest
version coming with SQL Server 2005 Beta 2
Eralper
http://www.kodyaz.com
"Spencer23" wrote:
> Hi,
> I was just wondering if somebody could tell me how to check and see if SP1
> for SQL Reporting Services is installed on a particular machine?
> Thanks
Monday, March 12, 2012
How to sync data between MSDE
Is there any article/help/doc on how to sync data between MSDE2000? I have installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
Thanks
Look in the BOL about SQL Server replication.
Depending on your synchronization needs, there are a variety of options. If
you don't have the Developer's Edtion of SQL Server then I recommend that
you get it so that you can use EM to develope any replication DTS packages
you may need.
Jim
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:39504051-7ECA-4EC2-BF34-562271854B62@.microsoft.com...
> Is there any article/help/doc on how to sync data between MSDE2000? I have
installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
> Thanks
|||Thanks, Jim.
I try to EM config the replication, use one machine as distributor and publisher, but it kept tell me can not connect to server because 'distributor_admin' is not defined as a remote login at the server. Do you know how to define this user? I tried creati
ng db and windows user, wouldn't work. These two machines are in a workgroup.
In my application, one MSDE(1) is collecting data, the other MSDE(2) get the data published from the (1) and read the data only. I plan to use (1) as publisher & distributor, (2) as subscriber. these two machines are not always online. Which way to sync i
s better, push or pull?
Henry
Thanks
Look in the BOL about SQL Server replication.
Depending on your synchronization needs, there are a variety of options. If
you don't have the Developer's Edtion of SQL Server then I recommend that
you get it so that you can use EM to develope any replication DTS packages
you may need.
Jim
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:39504051-7ECA-4EC2-BF34-562271854B62@.microsoft.com...
> Is there any article/help/doc on how to sync data between MSDE2000? I have
installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
> Thanks
|||Thanks, Jim.
I try to EM config the replication, use one machine as distributor and publisher, but it kept tell me can not connect to server because 'distributor_admin' is not defined as a remote login at the server. Do you know how to define this user? I tried creati
ng db and windows user, wouldn't work. These two machines are in a workgroup.
In my application, one MSDE(1) is collecting data, the other MSDE(2) get the data published from the (1) and read the data only. I plan to use (1) as publisher & distributor, (2) as subscriber. these two machines are not always online. Which way to sync i
s better, push or pull?
Henry
how to supress instance name while logging to sql server 2005?
Hi,
I am using SQL server 2005 express edition on win XP installed on my machine
.
when I use the SQL server Management studio, I have to enter
machinename\SQLExpress .How can I connect using just machinenname and omit
the SQLExpress instancename?what settings do i need to do?
Thanks for your help.
regards,
tech@.77SQLExpress is the default instance name that is given to that edition when
you indtsll it. You could have changed it during the installation. You can
now only uninstall SQL Express and reintall it as the default instance.
But I would suggest you not to do that and leave it as it is, so that when
you are going for developer edition or any other edition at a later stage,
you might want it to run under default instance.
Hope this helps.
I am using SQL server 2005 express edition on win XP installed on my machine
.
when I use the SQL server Management studio, I have to enter
machinename\SQLExpress .How can I connect using just machinenname and omit
the SQLExpress instancename?what settings do i need to do?
Thanks for your help.
regards,
tech@.77SQLExpress is the default instance name that is given to that edition whenyou indtsll it. You could have changed it during the installation. You can
now only uninstall SQL Express and reintall it as the default instance.
But I would suggest you not to do that and leave it as it is, so that when
you are going for developer edition or any other edition at a later stage,
you might want it to run under default instance.
Hope this helps.
Sunday, February 19, 2012
How to stop PAD_INDEX being scripted
Our team checks SQL scripts into version control. On my machine, however, the generated script always differs slightly. When I generate a create table script, the primary key part always has PAD_INDEX = OFF. Nobody else's server generates this. Does anyone know what option or setting I need to change to prevent PAD_INDEX = OFF from being output?
WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
BOL specifies
When creating indexed views or manipulating rows in tables participating in an indexed view, seven SET options must be assigned specific values. The SET options ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and ANSI_WARNINGS must be ON. The SET option NUMERIC_ROUNDABORT must be OFF.
If any of these settings is different, data modification statements (INSERT, UPDATE, DELETE) on any table referenced by an indexed view fail and SQL Server raises an error listing all SET options that violate setting requirements. In addition, for a SELECT statement that involves an indexed view, if the values of any of the SET options are not the required values, SQL Server processes the SELECT without considering the indexed view substitution. This ensures correctness of query result in cases where it can be affected by the above SET options.
If the application uses a DB-Library connection, all seven SET options on the server must be assigned the required values. (By default, OLE DB and ODBC connections have set all of the required SET options correctly, except for ARITHABORT.)
|||Thank you for taking the time to copy and paste. However, I don't see how your post is relevant.
I am asking what determines whether the PAD_INDEX option is included in scripted CREATE TABLE statements.
|||Is anyone able to help with this?
Subscribe to:
Posts (Atom)