log backup overwrite: copy

Showing posts with label copy. Show all posts

Tuesday, March 27, 2012

Does SQL Server 7 has anything to do with JVM?

I hava a MSDN Universal subscription. I was told the reason I can't get a copy of SQL Server 7 from Microsoft is because the "Java settlement". Does anyone know why?
According to: http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS, SQLServer7 is supported until Dec 31, 2005. I do not understand why Microsoft is still supporting it but us developers can not get a copy!Hi,
The http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS states
that SQL 7 will be supported till Dec 2005, but the availibility of SQL 7
was only till March 99.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||My understanding March 1, 1999 is the General Availibility (GA) date, or the first shipping date, not the last day it will be shipped.|||Hi,
I am sorry, it was my mistake.
Your understanding is correct.
The Softwares like (SQL 7) is still supported to benefit the existing users
of it.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Does SQL Server 7 has anything to do with JVM?

I hava a MSDN Universal subscription. I was told the reason I can't get a copy of SQL Server 7 from Microsoft is because the "Java settlement". Does anyone know why?
According to: http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS, SQLServer7 is supported until Dec 31, 2005. I do not understand why Microsoft is still supporting it but us developers can not get a copy!
Hi,
The http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS states
that SQL 7 will be supported till Dec 2005, but the availibility of SQL 7
was only till March 99.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||My understanding March 1, 1999 is the General Availibility (GA) date, or the first shipping date, not the last day it will be shipped.
|||Hi,
I am sorry, it was my mistake.
Your understanding is correct.
The Softwares like (SQL 7) is still supported to benefit the existing users
of it.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Does SQL Server 7 has anything to do with JVM?

I hava a MSDN Universal subscription. I was told the reason I can't get a co
py of SQL Server 7 from Microsoft is because the "Java settlement". Does any
one know why?
According to: http://support.microsoft.com/default.aspx?id=fh;[ln];lifep
rodS, SQLServer7 is supported until Dec 31, 2005. I do not understand why Mi
crosoft is still supporting it but us developers can not get a copy!Hi,
The http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodS state
s
that SQL 7 will be supported till Dec 2005, but the availibility of SQL 7
was only till March 99.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.|||My understanding March 1, 1999 is the General Availibility (GA) date, or the
first shipping date, not the last day it will be shipped.|||Hi,
I am sorry, it was my mistake.
Your understanding is correct.
The Softwares like (SQL 7) is still supported to benefit the existing users
of it.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Does SQL Server 2000 have any method or sp to copy files from other machine? -

If I use a workstation connected to a SQL Server 2000, can I remote the SQL Server to copy some external files (mdf & ldf) from other network machine.
I need to do it by programming, under condition:
SQL Server name is provided.
Network paths of mdf & ldf files are provided.You need to detach them using SP_DETACH_DB and copy them to the new location. Also refer to books online for RESTORE ... WITH MOVE topic for more information.

Thursday, March 22, 2012

Does 'SELECT INTO' not work in SQL Mobile?

I'm trying to programmatically create a new table that is a copy of another. The SQL statement I'm making is:

"SELECT * INTO sensor_stream_temp FROM sensor_stream"
and various combinations thereof (such as specifying the columns, etc)

The error I keep getting is:
There was an error parsing the query. [Token line number 1, Token line offset 10, , Token in error = INTO ]

Is it not possible to copy a table using this statement? *sigh*
Thanks in advance for any help.
-Dana
OK, so it looks like "INTO" is not allowed in SQL Mobile; how do I make a copy of a table?

|||

Try this:

INSERT INTO sensor_stream_temp (SELECT * FROM sensor_stream);

Note: Both sensor_stream_temp, sensor_stream MUST be of similar.

Monday, March 19, 2012

Does MS offer SQL Server 2000 for people who buy SQL Server 2005?

Does anyone know whether people who buy SQL Server 2005 can get a free copy
of SQL Server 2000 before moving to SQL Server 2005? Clients want to buy SQL
Server 2005 but some applications used by the clients only support SQL Server
2000 version until next year. So, clients want to know whether they can buy
SQL Server 2005 but get a free copy of SQL Server 2000 so they can use SQL
Server 2000 until all the applications are supporting 2005.
Thanks.Peter wrote:
> Does anyone know whether people who buy SQL Server 2005 can get a
> free copy of SQL Server 2000 before moving to SQL Server 2005?
> Clients want to buy SQL Server 2005 but some applications used by the
> clients only support SQL Server 2000 version until next year. So,
> clients want to know whether they can buy SQL Server 2005 but get a
> free copy of SQL Server 2000 so they can use SQL Server 2000 until
> all the applications are supporting 2005.
> Thanks.
You can usually get a downgrade license. Contact Microsoft for
clarification.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Wednesday, March 7, 2012

Does anyone know that where have the most mssql extended procedures for download?

I have a extended procedure for sending email by smtp already.

Are there anywheres can be downloaded the rest?
e.g. copy, move, detect, and delete some files and directories in harddisk
access Active directories
read and write .ini files
etc......I suggest you search 'Books Online', the help files for MS Sql Server.|||I just know C# & VB only, and i don't know C/C++.

those are useless.

Sunday, February 26, 2012

does anyone have the old SQL server versions?

I would really love to see how the old SQL server versions looked like ..I
would love to get a copy to install and see what it looked like..
Any verion prior to 7.0. Can anyone upload it to their site if its legal to
download ?
ThanksCheck out www.ebay.com for SQL Server 6.5 and 7.0. You should determine for
yourself that any software you purchase is genuine and legal.
--
David Portas
SQL Server MVP
--|||For a real laugh, have a look at version 4.21 - the one I started with.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Hassan wrote:
> I would really love to see how the old SQL server versions looked like ..I
> would love to get a copy to install and see what it looked like..
> Any verion prior to 7.0. Can anyone upload it to their site if its legal to
> download ?
> Thanks
>|||This is a multi-part message in MIME format.
--040700040605000703020101
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Mark Allison wrote:
> For a real laugh, have a look at version 4.21 - the one I started with.
--040700040605000703020101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Me too - quality software (just like Windows NT 3.51 - quality).</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Mark Allison wrote:
<blockquote cite="midODn$KMxcFHA.3488@.tk2msftngp13.phx.gbl" type="cite">For
a real laugh, have a look at version 4.21 - the one I started with.
 
</blockquote>
</body>
</html>
--040700040605000703020101--|||Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mike Hodgson wrote:
> Me too - quality software (just like Windows NT 3.51 - quality).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>|||Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Looks great on OS/2 Warp too. :-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Mike Hodgson wrote:
> > Me too - quality software (just like Windows NT 3.51 - quality).
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
> >|||This is a multi-part message in MIME format.
--050308050508020305020302
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Not me. The earliest one I've kept is 6.5 but I've worked with 4.21,
6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to go back
prior to 7.0 now (I've been spoilt). Can't wait to start plugging away
on Yukon production boxes (up until now it's been only "play" instances)
- I find Yukon a really exciting new version (with a fair bit of
potential for abuse, i.e. CLR integration - good for some things like
user-defined aggregates but should be used with extreme care methinks).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Hassan wrote:
>Do you guys have a copy of 4.2 ? Would love to have it as a collectible
>"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
>news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
>
>>Looks great on OS/2 Warp too. :-)
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html
>>
>>Mike Hodgson wrote:
>>
>>Me too - quality software (just like Windows NT 3.51 - quality).
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>
>http://www.mallesons.com
>
>
>
--050308050508020305020302
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Not me. The earliest one I've kept is 6.5 but I've worked with
4.21, 6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to
go back prior to 7.0 now (I've been spoilt). Can't wait to start
plugging away on Yukon production boxes (up until now it's been only
"play" instances) - I find Yukon a really exciting new version (with a
fair bit of potential for abuse, i.e. CLR integration - good for some
things like user-defined aggregates but should be used with extreme
care methinks).</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Hassan wrote:
<blockquote cite="mid%23VjR3E2cFHA.2436@.TK2MSFTNGP10.phx.gbl"
type="cite">
<pre wrap="">Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:mark@.no.tinned.meat.mvps.org"><mark@.no.tinned.meat.mvps.org></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl">news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.markallison.co.uk</a>">http://www.markallison.co.uk">http://www.markallison.co.uk</a>
Looking for a SQL Server replication book?
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.nwsu.com/0974973602m.html</a>">http://www.nwsu.com/0974973602m.html">http://www.nwsu.com/0974973602m.html</a>
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
</pre>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</body>
</html>
--050308050508020305020302--

Tuesday, March 27, 2012

Does SQL Server 7 has anything to do with JVM?

Does SQL Server 7 has anything to do with JVM?

Does SQL Server 7 has anything to do with JVM?

Does SQL Server 2000 have any method or sp to copy files from other machine? -

Thursday, March 22, 2012

Does 'SELECT INTO' not work in SQL Mobile?

Monday, March 19, 2012

Does MS offer SQL Server 2000 for people who buy SQL Server 2005?

Wednesday, March 7, 2012

Does anyone know that where have the most mssql extended procedures for download?

Sunday, February 26, 2012

does anyone have the old SQL server versions?

does anyone have the old SQL server versions?

does anyone have the old SQL server versions?

log backup overwrite

Blog Archive

About Me