Named Pipes Provider, error: 40 - Could not connect; Error 2

I have installed MSSQL 2005 successfuly, checked the services their are running I can connect to the

server with Intergrations Services ok. I get the following when I try to connect to the Database Engine

(provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

What file is SQL looking for (net helpmsg 2)?

Thanks for the help

Did you enable remote conenctions ? Check my website for the screencast which explains how to enable the Remote connections on your instance.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||Would this be true for a standalone PC? I don't have SQL Server installed on a remote server.|||

For a standalone PC, you want to disable remote connections for TCP/IP and Named Pipes but you probably want to enable them locally (especially considering that you are trying to use named pipes here). So you should start SQL Server Configuration Manager, then go to "Protocols" then enable both TCP/IP and Named Pipes. To make sure that remote computers cannot connect to your machine -- go to SQL Server Surface Area Configuration -> Surface Area Configuration for Services and Connections ->Remote Connections and turn off remote connections.

That should do it,

John

Named Pipes Provider, error: 40 - Could not connect; Error 2

I have installed MSSQL 2005 successfuly, checked the services their are running I can connect to the

server with Intergrations Services ok. I get the following when I try to connect to the Database Engine

(provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

What file is SQL looking for (net helpmsg 2)?

Thanks for the help

Did you enable remote conenctions ? Check my website for the screencast which explains how to enable the Remote connections on your instance.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||Would this be true for a standalone PC? I don't have SQL Server installed on a remote server.|||

For a standalone PC, you want to disable remote connections for TCP/IP and Named Pipes but you probably want to enable them locally (especially considering that you are trying to use named pipes here). So you should start SQL Server Configuration Manager, then go to "Protocols" then enable both TCP/IP and Named Pipes. To make sure that remote computers cannot connect to your machine -- go to SQL Server Surface Area Configuration -> Surface Area Configuration for Services and Connections ->Remote Connections and turn off remote connections.

That should do it,

John

name of month from int value

What is the best way to get the month name from an int value
within a mssql statement ?
(there is no need to consider the language settings)

e.g.
1 -> January
11 -> Novembre

My first approach seems to work but is very ugly:
CASE WHEN my_month_int<10
THEN DATENAME(month,"20000"+cast(my_month_int as varchar(2))+"15 00:00:00")
ELSE DATENAME(month,"2000"+cast(my_month_int as varchar(2))+"15 00:00:00")
END AS my_month_nameselect datename(m,dateadd(m,my_month_int-1,0)) as my_month_name

:cool:|||Thanx a lot, r937. Nice trick.sql

MySQLAdmin for mssql

Hey,

I am looking for a asp.net web application witch has the same functionality as MySQLAdmin.
Does somebody know where I can get that (for free)?

ThxHi,

Yes, ASP EM to access SQl Server is available in 2 flavours VB.NET/C#

click here http://www.aspenterprisemanager.com/

Find Demo http://www.aspenterprisemanager.com/appcsharp/Connect.aspx

FREE Download http://sourceforge.net/projects/asp-ent-man/

Hope that helps
Murali Kumar|||Are there alternatives for this one?|||hi,

No, if i come across one other such application i ll let u know.

Murali Kumar

Mysql Vs Mssql query

Hi,
I have a query that works perfectly in Mysql but fails in MSSQL.
Can anyone please throw light on this issue and guide me on how to avoid
this?

quote:

---

select cust_name,cust_email from customer,cust_departments
where customer.cust_id=cust_departments.cust_id and
cust_departments.dept_id='1' and cust.notify_ticket='1' group by
cust_departments.cust_id

---

The error thrown is Column 'cust_name' is invalid in the select list because
it is not contained in either an aggregate function or the GROUP BY clause.
What do I do?
Thanks and Regards,
Celia>

quote:

---

> select cust_name,cust_email from customer,cust_departments
> where customer.cust_id=cust_departments.cust_id and
> cust_departments.dept_id='1' and cust.notify_ticket='1' group by
> cust_departments.cust_id
>

---

I have no idea what you expect to see in MySQL. Why are using GROUP BY? Do
you multiple cust_name/cust_email combinations for a single cust_id? If so,
which one do you expect to show (I assume you only want one cust_id per
row)?
Perhaps you could provide schema (I have no idea what table cust_name /
cust_email belong to), sample data and desired results as per
http://www.aspfaq.com/5006|||Does MySQL not have DISTINCT? Is that why the group by is being used?
Also you should not use the old join style - update it to the ANSI syntax
select DISTINCT cust_name,cust_email
from customer
join cust_departments on customer.cust_id=cust_departments.cust_id and
cust_departments.dept_id='1'
where cust.notify_ticket='1'
celia wrote:
> Hi,
> I have a query that works perfectly in Mysql but fails in MSSQL.
> Can anyone please throw light on this issue and guide me on how to avoid
> this?
>

quote:

---

> select cust_name,cust_email from customer,cust_departments
> where customer.cust_id=cust_departments.cust_id and
> cust_departments.dept_id='1' and cust.notify_ticket='1' group by
> cust_departments.cust_id
>

---

> The error thrown is Column 'cust_name' is invalid in the select list becau
se
> it is not contained in either an aggregate function or the GROUP BY clause
.
> What do I do?
> Thanks and Regards,
> Celia
>

MySQL vs MSSQL

Hi, I've been coding in C#/ASP.NET for a little while now, but I've only ever used MS SQL.
I'm starting a new project at work soon, and our host provides free MySQL databases but charges for MS SQL databases.

What are the pros/cons for each of these databases, and how much conversion would be required in an existing C#/ASP.NET application if I wanted to change from MS SQL to MySQL? I assume the syntax/commands to operate a C# app with MS SQL are different to the ones required to communicate with a MySQL database?

I'll probably stick with MS SQL because it's what I know, but I'd like to get familiar with MySQL as it might come in handy one day.
Thanks, any information is greatly appreciated.

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html|||

awesome. thanks mike

MySQL to MSSQL or vice versa

Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith

I don't have any personal experience using SSIS with MySQL, but there is a decent volume of discussion on these forums on the subject:

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=mysql&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80

There's also quite a few articles out there in general:

http://www.google.com/search?hl=en&q=ssis+mysql

http://groups.google.com/groups?um=1&tab=wg&hl=en&q=ssis%20mysql

MySQL to MsSQL 2005

Hi!

How can i convert this code to work with MsSQL 2005?

/Tomas

PartialClass skaalbInherits System.Web.UI.PageProtected Sub Button1_Click(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles Button1.ClickDim strConnectionStringAs String Dim strQueryAs String Dim MyConnectionAs OdbcConnectionDim myCommandAs OdbcCommandDim pathAs String = Server.MapPath("~/album") &"/"Dim albNameAs String = Trim(Replace(txtAlbum.Text,"'", "''")) Dim folderName As String = Trim(Replace(txtAlbum.Text, "'", "''")) folderName = Replace(folderName," ","_")Try If Not My.Computer.FileSystem.DirectoryExists(path & folderName)Then My.Computer.FileSystem.CreateDirectory(path & folderName) labelStatus.Text ="Folder <b>" & folderName &"</b> created!"Dim BeskrivningAs String = Trim(Replace(txtBeskrivning.Text,"'", "''")) strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=xxxxxxxx; DATABASE=xxxxxxx; UID=xxxxxxxx; PASSWORD=xxxxxxxxx; OPTION=3" MyConnection = New OdbcConnection(strConnectionString) MyConnection.Open() strQuery = "INSERT INTO tbl_albumet(alb_Namn, alb_Beskrivning, alb_Mapp) VALUES (?, ?, ?)" myCommand = New OdbcCommand(strQuery, MyConnection) myCommand.Parameters.AddWithValue("?", albName) myCommand.Parameters.AddWithValue("?", Beskrivning) myCommand.Parameters.AddWithValue("?", folderName) myCommand.ExecuteNonQuery() MyConnection.Close() Else labelStatus.Text = "Folder excist, pick another name!" End If Catch ex As Exception labelStatus.Text = "Unable to create folder!"End Try End SubEnd Class

Just useDriver={SQL Native Client}; in the connectionstring

mysql to mssql

i have dumped a mysql database to my my documents folder on my server, how can i convert this to a mssql database.

the database came from a site that was in php and of course using mysql, the database has all the users logon information and other information in there personal profile.

i would like to convert this to a mssql database and connect it to the new site i am doing in .net/C#

I don't think there is any conversion tool to do that.|||

You have to use mySQL ODBC data source and import data from this source to SQL server, you can use SSIS package. Another solution is to do it inside your C# code you can have two connections and copy data from first (MYSQL) to second (MSSQL).

SSIS package will be faster.

And after that, or better before you have to create database structure on MS SQL server. but remember that MYSQL and MS SQL are not compatible.

mysql to ms sql

Need a little help. I am a newbie with both databases (mysql and mssql). I
am transferring from mysql to ms sql. There are very few tables and data.
I am basically transferring structure by hand.
I am finding the syntax to be difficult to deal with. I have a txt file
with several tables and their attributes from mysql but I am not finding the
exact same thing in ms sql. I wonder if someone can look at the code and
give me a hand. I am using the EM to put this on ms sql online.
Here is an example of one table and the trouble I am having with it. This
is the mysql code to be changed. Please see my comments under this code.
CREATE TABLE room_action (
id varchar(100) NOT NULL default '',
room tinyint(3) unsigned NOT NULL default '0',
user tinyint(3) unsigned NOT NULL default '0',
name varchar(50) NOT NULL default '',
cmd varchar(10) NOT NULL default '',
x mediumint(9) defaulnamet '0',
y mediumint(9) default '0',
msg varchar(255) default NULL,
avatar tinyint(3) unsigned default NULL,
viewed tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
I am creating the table in the EM. I am assuming that the numbers are the
field length. For example:
room tinyint(3) unsigned NOT NULL default '0'
I am attempting to put 3 in the length but it will only use 1.
I also am confused about unsigned. Also what is TYPE=MyISAM
Can anyone give me a hand?
Thanks
Laura KLaura,
Try this:
CREATE TABLE room_action (
id varchar(100) NOT NULL default '',
room smallint NOT NULL default 0,
userID smallint NOT NULL default 0, --user is a keyword, change to
userID
name varchar(50) NOT NULL default '',
cmd varchar(10) NOT NULL default '',
x integer default 0,
y integer default 0,
msg varchar(255) default NULL,
avatar smallint default NULL, --use a default of 0 instead of null if
possible, will prevent aggreatation warnings
viewed smallint NOT NULL default 0,
PRIMARY KEY (id)
)
Also, please consider removing the default '' on your not null columns. It
is contradictory and a pain in the rear to maintain.
Take some time to review Books On Line, especially data types, as many of
your conversion questions will be answered.
--Morgan
"Laura K" <klkazanAT@.ATcharter.net> wrote in message
news:%23Gz90CleDHA.1824@.TK2MSFTNGP10.phx.gbl...
> Need a little help. I am a newbie with both databases (mysql and mssql).
I
> am transferring from mysql to ms sql. There are very few tables and data.
> I am basically transferring structure by hand.
> I am finding the syntax to be difficult to deal with. I have a txt file
> with several tables and their attributes from mysql but I am not finding
the
> exact same thing in ms sql. I wonder if someone can look at the code and
> give me a hand. I am using the EM to put this on ms sql online.
> Here is an example of one table and the trouble I am having with it. This
> is the mysql code to be changed. Please see my comments under this code.
> CREATE TABLE room_action (
> id varchar(100) NOT NULL default '',
> room tinyint(3) unsigned NOT NULL default '0',
> user tinyint(3) unsigned NOT NULL default '0',
> name varchar(50) NOT NULL default '',
> cmd varchar(10) NOT NULL default '',
> x mediumint(9) defaulnamet '0',
> y mediumint(9) default '0',
> msg varchar(255) default NULL,
> avatar tinyint(3) unsigned default NULL,
> viewed tinyint(3) unsigned NOT NULL default '0',
> PRIMARY KEY (id)
> ) TYPE=MyISAM;
>
> I am creating the table in the EM. I am assuming that the numbers are the
> field length. For example:
> room tinyint(3) unsigned NOT NULL default '0'
> I am attempting to put 3 in the length but it will only use 1.
> I also am confused about unsigned. Also what is TYPE=MyISAM
> Can anyone give me a hand?
> Thanks
> Laura K
>|||Thanks but I don't want to do mySQL. The original program was written for a
mysql database but we want to run it from MS sql. I am writing the tables
by hand in ms sql but I do not know much about the differences.
Laura
"Groucho" <rog11228@.aol.com> wrote in message
news:eFKpYqleDHA.4024@.TK2MSFTNGP11.phx.gbl...
> "Laura K" wrote in message
> > Need a little help. I am a newbie with both databases (mysql and
mssql).
> .
> .
> Don't expect to much help in the way of MySql here.
> It's not considered a *real* rdbms in these parts:)
> There are many differences/similarities between the two.
> You'll get Mysql help on google at:
> mailing.database.mysql
> mailing.database.mysql-win32
> You can also let MySql utilities help you,especially the ones that
> import and export data.Check out:
> SQLyog @.
> www.webyog.com
> and
> MySql GUI tool @.
> www.mysqlgui.net
> Install the MySql odbc driver and you can use the
> Server dts utility to transfer data and see how the
> table structure(s) turn out.
> A type MyISAM is a particular type of MySql table.
> In MySql there are different types of tables you can use.
> This concept does not exist in Server.See the MySql
> docs for details.
> It also matters what version of MySql your working with.
> Check their website for details.(You should be using 4.0.xx).
> If you want subqueries,derived tables and some other
> fancy server like constructs check out 4.1 alpha.
> Using both Server and MySql will probably become
> pretty common as time goes on.You can pick the one
> you want to pay for:).
> RAC v2.2 and QALite for Sql Server released.
> www.rac4sql.net
>
>|||Thanks so much. I am beginning the understand the differences.
I did a search for conversion but all I got all kinds of non helpful things
instead from the search engines. I will take a look at books online.
Thanks again for the detailed help.
Laura
"Morgan" <mfears@.spamcop.net> wrote in message
news:OaAQiGmeDHA.3528@.tk2msftngp13.phx.gbl...
> Laura,
> Try this:
> CREATE TABLE room_action (
> id varchar(100) NOT NULL default '',
> room smallint NOT NULL default 0,
> userID smallint NOT NULL default 0, --user is a keyword, change to
> userID
> name varchar(50) NOT NULL default '',
> cmd varchar(10) NOT NULL default '',
> x integer default 0,
> y integer default 0,
> msg varchar(255) default NULL,
> avatar smallint default NULL, --use a default of 0 instead of null if
> possible, will prevent aggreatation warnings
> viewed smallint NOT NULL default 0,
> PRIMARY KEY (id)
> )
> Also, please consider removing the default '' on your not null columns. It
> is contradictory and a pain in the rear to maintain.
> Take some time to review Books On Line, especially data types, as many of
> your conversion questions will be answered.
> --Morgan
>
> "Laura K" <klkazanAT@.ATcharter.net> wrote in message
> news:%23Gz90CleDHA.1824@.TK2MSFTNGP10.phx.gbl...
> > Need a little help. I am a newbie with both databases (mysql and
mssql).
> I
> > am transferring from mysql to ms sql. There are very few tables and
data.
> > I am basically transferring structure by hand.
> >
> > I am finding the syntax to be difficult to deal with. I have a txt file
> > with several tables and their attributes from mysql but I am not finding
> the
> > exact same thing in ms sql. I wonder if someone can look at the code
and
> > give me a hand. I am using the EM to put this on ms sql online.
> >
> > Here is an example of one table and the trouble I am having with it.
This
> > is the mysql code to be changed. Please see my comments under this code.
> >
> > CREATE TABLE room_action (
> > id varchar(100) NOT NULL default '',
> > room tinyint(3) unsigned NOT NULL default '0',
> > user tinyint(3) unsigned NOT NULL default '0',
> > name varchar(50) NOT NULL default '',
> > cmd varchar(10) NOT NULL default '',
> > x mediumint(9) defaulnamet '0',
> > y mediumint(9) default '0',
> > msg varchar(255) default NULL,
> > avatar tinyint(3) unsigned default NULL,
> > viewed tinyint(3) unsigned NOT NULL default '0',
> > PRIMARY KEY (id)
> > ) TYPE=MyISAM;
> >
> >
> > I am creating the table in the EM. I am assuming that the numbers are
the
> > field length. For example:
> > room tinyint(3) unsigned NOT NULL default '0'
> >
> > I am attempting to put 3 in the length but it will only use 1.
> >
> > I also am confused about unsigned. Also what is TYPE=MyISAM
> >
> > Can anyone give me a hand?
> >
> > Thanks
> >
> > Laura K
> >
> >
>

MySQL or PostGreSQL to go with MSSQL?

Sorry to post this here, but of course I need to give expert advice in the
next 5 minutes.
Does anyone have any experience with either of these? My company is going to
start using one of these in addition to MSSQL for long winded reasons and
they want my input as to which one to go with. I know that MySQL doesnt
(yet) support Stored Procs, but is very fast. What Im really wondering about
though is stuff like...
1; Can DTS be used to import/ export data from either of these? If so, is
one easier than the other? (I dont see a connection for either in the design
DTS tool.)
2; Is one more secure than the other?
3; DB size limits for either?
4; Disaster recovery for either?
TIA, ChrisR
"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
Why not MSDE or SQL Server 2005 Express Edition?
David
|||Never thought about it. But if theres no GUI, one needs to be designed?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Why not MSDE or SQL Server 2005 Express Edition?
> David
>
|||There are plenty of free and cheap GUI's for MSDE. Check Aarons www.aspfaq.com, I know he has an
article on the subject.
And, SQL Server Express ("SQL Server 2005 MSDE") will come with a basic GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:OJLdwIGlFHA.708@.TK2MSFTNGP10.phx.gbl...
> Never thought about it. But if theres no GUI, one needs to be designed?
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in message
> news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
>
|||Well, I will throw in my $0.02!
A good while back I was playing with the idea of looking into some
open-source database server options. I made a post in this news group
inquiring about the possibilities.
MySQL is a popular open-source database. They have a lot of free support
( via forums and news groups and mailing lists and what not ) and - from
what I hear - some pretty good paid support. They do offer a lot of
training. And you can find a lot of good books on MySQL. It also seems
that more and more people are catching the fever.
However, what was suggested to me was to stick with PostgreSQL. I do not
remember why ( well isn't that convenient ). I am pretty sure that it was
Aaron who made the suggestion with the reasons. Now, I am not sure if MySQL
version 5 is going to negate that suggestion.
Check in this news group about four months ago ( something like this... )
for my post.
Now, I am very sure that MySQL runs on Windows. I help in some environments
where MySQL is running on SBS2000. I *believe* that there is a problem with
PostgreSQL running on a Windows platform ( not really sure if the problem is
that it does not run at all or if there are some problems....sorry! Not
really a data base guy - yet! ). I am currently back on the database server
quest and playing with FreeBSD and PostgreSQL. Just waiting for the FreeBSD
CD-ROM to arrive before I can do some hands on...
Hope that this was somewhat helpful to you. It looks like you have some
pretty good answers already.
Cary W. Shultz
Roanoke, VA 24012
Microsoft Active Directory MVP
http://www.activedirectory-win2000.com
http://www.grouppolicy-win2000.com
"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
> TIA, ChrisR
>
|||"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> glsD:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx .gbl...
> I *believe* that there is a problem with PostgreSQL running on a Windows
> platform ( not really sure if the problem is that it does not run at all
> or if there are some problems....sorry! Not really a data base guy -
> yet! ).
Yes. There is also a severe performance issue if PostgreSQL is running in
Windows platform too.
So you'd better use *nix system if you want to use it.
|||At one time, to run PostgreSQL under Windows you had to use the Cygwin Unix
emulation library, but there is now a native Windows port for PostgreSQL
8.0.
"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> wrote in message
news:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> Well, I will throw in my $0.02!
> A good while back I was playing with the idea of looking into some
> open-source database server options. I made a post in this news group
> inquiring about the possibilities.
> MySQL is a popular open-source database. They have a lot of free support
> ( via forums and news groups and mailing lists and what not ) and - from
> what I hear - some pretty good paid support. They do offer a lot of
> training. And you can find a lot of good books on MySQL. It also seems
> that more and more people are catching the fever.
> However, what was suggested to me was to stick with PostgreSQL. I do not
> remember why ( well isn't that convenient ). I am pretty sure that it was
> Aaron who made the suggestion with the reasons. Now, I am not sure if
> MySQL version 5 is going to negate that suggestion.
> Check in this news group about four months ago ( something like this... )
> for my post.
> Now, I am very sure that MySQL runs on Windows. I help in some
> environments where MySQL is running on SBS2000. I *believe* that there is
> a problem with PostgreSQL running on a Windows platform ( not really sure
> if the problem is that it does not run at all or if there are some
> problems....sorry! Not really a data base guy - yet! ). I am currently
> back on the database server quest and playing with FreeBSD and PostgreSQL.
> Just waiting for the FreeBSD CD-ROM to arrive before I can do some hands
> on...
> Hope that this was somewhat helpful to you. It looks like you have some
> pretty good answers already.
> --
> Cary W. Shultz
> Roanoke, VA 24012
> Microsoft Active Directory MVP
> http://www.activedirectory-win2000.com
> http://www.grouppolicy-win2000.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>

MySQL or PostGreSQL to go with MSSQL?

Sorry to post this here, but of course I need to give expert advice in the
next 5 minutes.
Does anyone have any experience with either of these? My company is going to
start using one of these in addition to MSSQL for long winded reasons and
they want my input as to which one to go with. I know that mysql doesnt
(yet) support Stored Procs, but is very fast. What Im really wondering about
though is stuff like...
1; Can DTS be used to import/ export data from either of these? If so, is
one easier than the other? (I dont see a connection for either in the design
DTS tool.)
2; Is one more secure than the other?
3; DB size limits for either?
4; Disaster recovery for either?
TIA, ChrisR"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
Why not MSDE or SQL Server 2005 Express Edition?
David|||Never thought about it. But if theres no GUI, one needs to be designed?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Why not MSDE or SQL Server 2005 Express Edition?
> David
>|||There are plenty of free and cheap GUI's for MSDE. Check Aarons [url]www.aspfaq.com,[/u
rl] I know he has an
article on the subject.
And, SQL Server Express ("SQL Server 2005 MSDE") will come with a basic GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:OJLdwIGlFHA.708@.TK2MSFTNGP10.phx.gbl...[vbc
ol=seagreen]
> Never thought about it. But if theres no GUI, one needs to be designed?
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in mes
sage
> news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]|||Well, I will throw in my $0.02!
A good while back I was playing with the idea of looking into some
open-source database server options. I made a post in this news group
inquiring about the possibilities.
MySQL is a popular open-source database. They have a lot of free support
( via forums and news groups and mailing lists and what not ) and - from
what I hear - some pretty good paid support. They do offer a lot of
training. And you can find a lot of good books on MySQL. It also seems
that more and more people are catching the fever.
However, what was suggested to me was to stick with PostgreSQL. I do not
remember why ( well isn't that convenient ). I am pretty sure that it was
Aaron who made the suggestion with the reasons. Now, I am not sure if MySQL
version 5 is going to negate that suggestion.
Check in this news group about four months ago ( something like this... )
for my post.
Now, I am very sure that mysql runs on Windows. I help in some environments
where mysql is running on SBS2000. I *believe* that there is a problem with
PostgreSQL running on a Windows platform ( not really sure if the problem is
that it does not run at all or if there are some problems....sorry! Not
really a data base guy - yet! ). I am currently back on the database server
quest and playing with FreeBSD and PostgreSQL. Just waiting for the FreeBSD
CD-ROM to arrive before I can do some hands on...
Hope that this was somewhat helpful to you. It looks like you have some
pretty good answers already.
Cary W. Shultz
Roanoke, VA 24012
Microsoft Active Directory MVP
http://www.activedirectory-win2000.com
http://www.grouppolicy-win2000.com
"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
> TIA, ChrisR
>|||"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> glsD:OF6Lm%23GlFHA.3656@.TK2MSFTNG
P09.phx.gbl...
> I *believe* that there is a problem with PostgreSQL running on a Windows
> platform ( not really sure if the problem is that it does not run at all
> or if there are some problems....sorry! Not really a data base guy -
> yet! ).
Yes. There is also a severe performance issue if PostgreSQL is running in
Windows platform too.
So you'd better use *nix system if you want to use it.|||At one time, to run PostgreSQL under Windows you had to use the Cygwin Unix
emulation library, but there is now a native Windows port for PostgreSQL
8.0.
"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> wrote in message
news:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> Well, I will throw in my $0.02!
> A good while back I was playing with the idea of looking into some
> open-source database server options. I made a post in this news group
> inquiring about the possibilities.
> mysql is a popular open-source database. They have a lot of free support
> ( via forums and news groups and mailing lists and what not ) and - from
> what I hear - some pretty good paid support. They do offer a lot of
> training. And you can find a lot of good books on MySQL. It also seems
> that more and more people are catching the fever.
> However, what was suggested to me was to stick with PostgreSQL. I do not
> remember why ( well isn't that convenient ). I am pretty sure that it was
> Aaron who made the suggestion with the reasons. Now, I am not sure if
> mysql version 5 is going to negate that suggestion.
> Check in this news group about four months ago ( something like this... )
> for my post.
> Now, I am very sure that mysql runs on Windows. I help in some
> environments where mysql is running on SBS2000. I *believe* that there is
> a problem with PostgreSQL running on a Windows platform ( not really sure
> if the problem is that it does not run at all or if there are some
> problems....sorry! Not really a data base guy - yet! ). I am currently
> back on the database server quest and playing with FreeBSD and PostgreSQL.
> Just waiting for the FreeBSD CD-ROM to arrive before I can do some hands
> on...
> Hope that this was somewhat helpful to you. It looks like you have some
> pretty good answers already.
> --
> Cary W. Shultz
> Roanoke, VA 24012
> Microsoft Active Directory MVP
> http://www.activedirectory-win2000.com
> http://www.grouppolicy-win2000.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>

MySQL or PostGreSQL to go with MSSQL?

Sorry to post this here, but of course I need to give expert advice in the
next 5 minutes.
Does anyone have any experience with either of these? My company is going to
start using one of these in addition to MSSQL for long winded reasons and
they want my input as to which one to go with. I know that MySQL doesnt
(yet) support Stored Procs, but is very fast. What Im really wondering about
though is stuff like...
1; Can DTS be used to import/ export data from either of these? If so, is
one easier than the other? (I dont see a connection for either in the design
DTS tool.)
2; Is one more secure than the other?
3; DB size limits for either?
4; Disaster recovery for either?
TIA, ChrisR"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
Why not MSDE or SQL Server 2005 Express Edition?
David|||Never thought about it. But if theres no GUI, one needs to be designed?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>> Sorry to post this here, but of course I need to give expert advice in
>> the next 5 minutes.
>> Does anyone have any experience with either of these? My company is going
>> to start using one of these in addition to MSSQL for long winded reasons
>> and they want my input as to which one to go with. I know that MySQL
>> doesnt (yet) support Stored Procs, but is very fast. What Im really
>> wondering about though is stuff like...
>> 1; Can DTS be used to import/ export data from either of these? If so, is
>> one easier than the other? (I dont see a connection for either in the
>> design DTS tool.)
>> 2; Is one more secure than the other?
>> 3; DB size limits for either?
>> 4; Disaster recovery for either?
> Why not MSDE or SQL Server 2005 Express Edition?
> David
>|||There are plenty of free and cheap GUI's for MSDE. Check Aarons www.aspfaq.com, I know he has an
article on the subject.
And, SQL Server Express ("SQL Server 2005 MSDE") will come with a basic GUI.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:OJLdwIGlFHA.708@.TK2MSFTNGP10.phx.gbl...
> Never thought about it. But if theres no GUI, one needs to be designed?
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in message
> news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
>> "ChrisR" <noemail@.bla.com> wrote in message news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>> Sorry to post this here, but of course I need to give expert advice in the next 5 minutes.
>> Does anyone have any experience with either of these? My company is going to start using one of
>> these in addition to MSSQL for long winded reasons and they want my input as to which one to go
>> with. I know that MySQL doesnt (yet) support Stored Procs, but is very fast. What Im really
>> wondering about though is stuff like...
>> 1; Can DTS be used to import/ export data from either of these? If so, is one easier than the
>> other? (I dont see a connection for either in the design DTS tool.)
>> 2; Is one more secure than the other?
>> 3; DB size limits for either?
>> 4; Disaster recovery for either?
>>
>> Why not MSDE or SQL Server 2005 Express Edition?
>> David
>|||Well, I will throw in my $0.02!
A good while back I was playing with the idea of looking into some
open-source database server options. I made a post in this news group
inquiring about the possibilities.
MySQL is a popular open-source database. They have a lot of free support
( via forums and news groups and mailing lists and what not ) and - from
what I hear - some pretty good paid support. They do offer a lot of
training. And you can find a lot of good books on MySQL. It also seems
that more and more people are catching the fever.
However, what was suggested to me was to stick with PostgreSQL. I do not
remember why ( well isn't that convenient ). I am pretty sure that it was
Aaron who made the suggestion with the reasons. Now, I am not sure if MySQL
version 5 is going to negate that suggestion.
Check in this news group about four months ago ( something like this... )
for my post.
Now, I am very sure that MySQL runs on Windows. I help in some environments
where MySQL is running on SBS2000. I *believe* that there is a problem with
PostgreSQL running on a Windows platform ( not really sure if the problem is
that it does not run at all or if there are some problems....sorry! Not
really a data base guy - yet! ). I am currently back on the database server
quest and playing with FreeBSD and PostgreSQL. Just waiting for the FreeBSD
CD-ROM to arrive before I can do some hands on...
Hope that this was somewhat helpful to you. It looks like you have some
pretty good answers already.
--
Cary W. Shultz
Roanoke, VA 24012
Microsoft Active Directory MVP
http://www.activedirectory-win2000.com
http://www.grouppolicy-win2000.com
"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
> TIA, ChrisR
>|||"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> ¼¶¼g©ó¶l¥ó·s»D:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I *believe* that there is a problem with PostgreSQL running on a Windows
> platform ( not really sure if the problem is that it does not run at all
> or if there are some problems....sorry! Not really a data base guy -
> yet! ).
Yes. There is also a severe performance issue if PostgreSQL is running in
Windows platform too.
So you'd better use *nix system if you want to use it.|||At one time, to run PostgreSQL under Windows you had to use the Cygwin Unix
emulation library, but there is now a native Windows port for PostgreSQL
8.0.
"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> wrote in message
news:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> Well, I will throw in my $0.02!
> A good while back I was playing with the idea of looking into some
> open-source database server options. I made a post in this news group
> inquiring about the possibilities.
> MySQL is a popular open-source database. They have a lot of free support
> ( via forums and news groups and mailing lists and what not ) and - from
> what I hear - some pretty good paid support. They do offer a lot of
> training. And you can find a lot of good books on MySQL. It also seems
> that more and more people are catching the fever.
> However, what was suggested to me was to stick with PostgreSQL. I do not
> remember why ( well isn't that convenient ). I am pretty sure that it was
> Aaron who made the suggestion with the reasons. Now, I am not sure if
> MySQL version 5 is going to negate that suggestion.
> Check in this news group about four months ago ( something like this... )
> for my post.
> Now, I am very sure that MySQL runs on Windows. I help in some
> environments where MySQL is running on SBS2000. I *believe* that there is
> a problem with PostgreSQL running on a Windows platform ( not really sure
> if the problem is that it does not run at all or if there are some
> problems....sorry! Not really a data base guy - yet! ). I am currently
> back on the database server quest and playing with FreeBSD and PostgreSQL.
> Just waiting for the FreeBSD CD-ROM to arrive before I can do some hands
> on...
> Hope that this was somewhat helpful to you. It looks like you have some
> pretty good answers already.
> --
> Cary W. Shultz
> Roanoke, VA 24012
> Microsoft Active Directory MVP
> http://www.activedirectory-win2000.com
> http://www.grouppolicy-win2000.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>> Sorry to post this here, but of course I need to give expert advice in
>> the next 5 minutes.
>> Does anyone have any experience with either of these? My company is going
>> to start using one of these in addition to MSSQL for long winded reasons
>> and they want my input as to which one to go with. I know that MySQL
>> doesnt (yet) support Stored Procs, but is very fast. What Im really
>> wondering about though is stuff like...
>> 1; Can DTS be used to import/ export data from either of these? If so, is
>> one easier than the other? (I dont see a connection for either in the
>> design DTS tool.)
>> 2; Is one more secure than the other?
>> 3; DB size limits for either?
>> 4; Disaster recovery for either?
>>
>> TIA, ChrisR
>

MySQL and MSSQL?

Is it possible to have both these products installed in the same system?
And if so what the best versions for each that would be best here? Thanks.
--
George Hester
__________________________________George
You asked this at the right time
12 hours ago i got an install od MSSQL server (2000), MySQL Server (4.x),
Apache Web Server, PHP all working on a Win2003 server. Now can I can create
portals for our systems.
So yes and they work fine together.
Regards
Jeff
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003|||Hi George,
> Is it possible to have both these products installed in the same system?
Yes. Pay attention to TCP/IP ports, if you do not change them, no problem.
Tune up your server and your databases. Be careful on choosing the server
hardware, remember that it will be a "double database" server and you could
possible find a bottleneck soon.
> And if so what the best versions for each that would be best here?
Thanks.
SQL Server: use 2000 version
MySQL: try 4.0.14, avoid 4.1.x series
Regards,
Fernando Monteiro

mySQL -> msSQL

Hello all,

I spent the last two days trying to find an application that can export a mySQL database into msSQL syntax so that I can then use that to just create my msSQL database. I have had no such luck, though I could find a bunch to do msSQL to mySQL.

Please let me know if anyone has one or knows of one that works because I really do not want to hand port my 70 table database from mySQL to msSQL

Thanks in advance,

Anthony F Greco

DO you want application tool?

i found these two sites, not sure if it helps

http://www.softplatz.com/Soft/Network-Internet/Other/MySQL-MS-SQL-Server-Import-Export-Convert-Software.html

http://mysql-to-sql-server.qarchive.org/

|||Yes I did see them, I was just hopping to find a freeware one. If not I will go with one of them though. Thanks for the help =]|||

Hey

You could take a look at this:

Migrating MySQL to Microsoft SQL Server

I've done this before and just want to remind you that MySql is case sensitive but Sql server is not ,for example:

You hava column A(pk) B with values:

valueA valueB

valuea valueb

Sql Server will complain about violation ofprimary key constraint .

Hope this helps.

MYSQL - DTS - MSSQL help needed Warning novice inside!

Hi,
**I appologise as this is posted in microsoft.public.sqlserver.dts
also**
Would anyone be so kind and point me in the rigth direction?
I have a mysql server and a MSSQL 2000 server.
MYSQL
Database name is Membership
Table is Users
Column is email_address.
I want to transfer the email_address data over to a column in an
existing MSSQL Database.
When I run the DTS wizard I can successfully connect to the MYSQL
database server, but the only option I get is to use a SQL Statement.
So this is what I have started with...
mysql_select_db('membership');
SELECT * FROM users WHERE email_address='"*"
If i try and preview I get an unexpected errror and if i run through
the wizard I get wrong systax at line 1.
I am a total novice at this and am stumbling around in the dark...
Any help much appreciated...
Thanks
Col
**Sorry this is posted in microsoft.public.sqlserver.dts also..**Sorry to add I need this to be automated which is why I am trying to
use DTS
Thanks
Col|||Do you want to transfer all email addresses?
If so, I think this is what you want to do
SELECT * FROM membership.users
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"techcs" <colinsealeaf@.blueyonder.co.uk> wrote in message
news:1158045662.036499.225710@.e3g2000cwe.googlegroups.com...
> Hi,
> **I appologise as this is posted in microsoft.public.sqlserver.dts
> also**
> Would anyone be so kind and point me in the rigth direction?
>
> I have a mysql server and a MSSQL 2000 server.
>
> MYSQL
> Database name is Membership
> Table is Users
> Column is email_address.
>
> I want to transfer the email_address data over to a column in an
> existing MSSQL Database.
>
> When I run the DTS wizard I can successfully connect to the MYSQL
> database server, but the only option I get is to use a SQL Statement.
> So this is what I have started with...
>
> mysql_select_db('membership');
> SELECT * FROM users WHERE email_address='"*"
>
> If i try and preview I get an unexpected errror and if i run through
> the wizard I get wrong systax at line 1.
>
> I am a total novice at this and am stumbling around in the dark...
>
> Any help much appreciated...
>
> Thanks
> Col
> **Sorry this is posted in microsoft.public.sqlserver.dts also..**
>|||techcs wrote:
> Sorry to add I need this to be automated which is why I am trying to
> use DTS
> Thanks
> Col
>
Automation doesn't require DTS. If you can connect to mysql with DTS,
then you can connect with other components as well. Create a linked
server that points to the mysql instance, and then you can use a simple
SELECT statement to grab the data. The SELECT statement can then be
scheduled as an Agent job. Something like this:
SELECT email_address FROM linkedservername.Membership.dbo.Users
I don't know MySQL, so I'm not sure of the exact syntax, you might not
need the schema reference, i.e. "dbo".
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks will have a look at that now... Sounds good...
Col

MYSQL - DTS - MSSQL help needed Warning novice inside!

Hi,
**I appologise as this is posted in microsoft.public.sqlserver.dts
also**
Would anyone be so kind and point me in the rigth direction?
I have a MYSQL server and a MSSQL 2000 server.
MYSQL
Database name is Membership
Table is Users
Column is email_address.
I want to transfer the email_address data over to a column in an
existing MSSQL Database.
When I run the DTS wizard I can successfully connect to the MYSQL
database server, but the only option I get is to use a SQL Statement.
So this is what I have started with...
mysql_select_db('membership');
SELECT * FROM users WHERE email_address='"*"
If i try and preview I get an unexpected errror and if i run through
the wizard I get wrong systax at line 1.
I am a total novice at this and am stumbling around in the dark...
Any help much appreciated...
Thanks
Col
**Sorry this is posted in microsoft.public.sqlserver.dts also..**Sorry to add I need this to be automated which is why I am trying to
use DTS
Thanks
Col|||Do you want to transfer all email addresses?
If so, I think this is what you want to do
SELECT * FROM membership.users
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"techcs" <colinsealeaf@.blueyonder.co.uk> wrote in message
news:1158045662.036499.225710@.e3g2000cwe.googlegroups.com...
> Hi,
> **I appologise as this is posted in microsoft.public.sqlserver.dts
> also**
> Would anyone be so kind and point me in the rigth direction?
>
> I have a MYSQL server and a MSSQL 2000 server.
>
> MYSQL
> Database name is Membership
> Table is Users
> Column is email_address.
>
> I want to transfer the email_address data over to a column in an
> existing MSSQL Database.
>
> When I run the DTS wizard I can successfully connect to the MYSQL
> database server, but the only option I get is to use a SQL Statement.
> So this is what I have started with...
>
> mysql_select_db('membership');
> SELECT * FROM users WHERE email_address='"*"
>
> If i try and preview I get an unexpected errror and if i run through
> the wizard I get wrong systax at line 1.
>
> I am a total novice at this and am stumbling around in the dark...
>
> Any help much appreciated...
>
> Thanks
> Col
> **Sorry this is posted in microsoft.public.sqlserver.dts also..**
>|||techcs wrote:
> Sorry to add I need this to be automated which is why I am trying to
> use DTS
> Thanks
> Col
>
Automation doesn't require DTS. If you can connect to MySQL with DTS,
then you can connect with other components as well. Create a linked
server that points to the MySQL instance, and then you can use a simple
SELECT statement to grab the data. The SELECT statement can then be
scheduled as an Agent job. Something like this:
SELECT email_address FROM linkedservername.Membership.dbo.Users
I don't know MySQL, so I'm not sure of the exact syntax, you might not
need the schema reference, i.e. "dbo".
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks will have a look at that now... Sounds good...
Col

mydatabase.ckp ?

Hi
A file has been generated in my MSSQL\backup directory called [myDB].ckp.
It's only a 6K binary file, but I've no idea what it is.
Any suggestions?
Thanks
GriffI remember seeing this. A CKP file gets created when you cancel a
backup/restore operation. I think it is used for restarting a failed
backup/restore operation.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"GriffithsJ" <GriffithsJ_520@.hotmail.com> wrote in message
news:%23CBUU%233zDHA.2872@.TK2MSFTNGP09.phx.gbl...
Hi
A file has been generated in my MSSQL\backup directory called [myDB].ckp.
It's only a 6K binary file, but I've no idea what it is.
Any suggestions?
Thanks
Griff|||Cool, thanks.
I can in fact verify this - the update did fail (it wouldn't overwrite the
data and log files).
Griff