Rebuild replicated indexes

I have a number of databases that are being transactionally replicated from SQL 2000 Enterprise edition publisher to SQL 2005 Enterprise edition subscriber. I have included indexes in the replication. The subscriber database is then accessed and the data de-normalised and aggregated for reporting purposes.

My question is this: I want to periodically re-build the indexes on the publisher and subscriber via an automated task. If I rebuild the indexes on the publisher, will that automatically replicate to the subscriber? Will there be a problem with the "snapshot being out of date", and therefore replication stopping? I run a new snapshot once a day in the small hours of the morning. If there is likely to be a problem with the rebuild throwing the replication out, would it be wise to have the rebuild job running just before the new snapshot is taken?

Any help/advice appreciated.

No, the index rebuild isn't replicated. You would have to rebuild the indexes on the publisher and subscriber separately.|||

Or there is another option is to use @.pre/post_snapshot_script. You can use subscriber index rebuilding actions into a script and set the script as @.pre/post_snapshot_script in publication properties page -->Snapshot or through sql (sp_changepublication/sp_changemergepublication).

For example, as for post snapshot script, Distribution agent/merge agent will run the pre-snapshot script before any of the replicated object scripts when applying the snapshot at a Subscriber. The script is executed in the security context used by the Merge Agent when connecting to the subscription database. Pre-snapshot scripts are not run on SQL Server Mobile Subscribers.

Refer to: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/28a629a1-7374-4614-9b04-279d290a942a.htm

Therefore, once you rebuild index in publisher side, reinitialize sub, sub side index will be rebult through pre/post snapshot script as well.

Hope the above information will help.

-Yunjing

Re-attaching databases after upgrading to SQL Server Enterprise Edition

Since Upgrading from SQL Standard Edition to SQL Server EE we have been unable to re-attach the database files that we detached before the upgrade, to SQL Server Management studio. We get an error message that reads:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file

Any help with this matter would be truly appreciated. Thank you.

You need to reset the NTFS permisions on the physical files. SQL 2005 locks out the physical files NTFS permissions when the databases are detached.

Really urgent - Data field retrieve and store

Basically i make use of FormView in Web Developer Express Edition to create and store information to the database ...

what i want to do further is to capture the value within the primary key of the newly created recordset that I set it become auto increament ....

this value would be stored within a session string in global condition that allowed any page able to access it ....

If you simply want to return the ID to use within the application, and you are using a stored procedure, do this.

Insert the record as normal in the table, then add a statement such as SELECT SCOPE_IDENETITY() as TheNewId

If your insert fails, this line never executes. If insert is OK, you get teh new ID passed back

In your code, perform an execute scaler method call on the connection, and cast the return (decimal as object) into an integer, and store in session. If the returned value is null, the insert failed

What I often create for projects is a global "Execute Scaler" method that accepts the name of a stored procedure, and a string dictionary of name/value pairs.

IN the method, create the SQL Command object, call the SQLCommandBuilder static method to get the parameters, then iterate through the dictionary to add these by name.

Call the command ExecuteScaler as mentioned and proceed as above

|||Really appreciate ur feedback men... but it looks so technical for me men... i am totally a new beginner but have to complete this project within another week time...

can u demonstrate the code (sorry for the hassle)... i kind of not sure how to achieve what u had mentioned...|||

Example SP

CREATE PROCEDURE

dbo.MyTable_Insert

(

@.Parameter1varchar(100)

)

AS

SET NOCOUNT ON

INSERT INTOMyTable (MyData)VALUES(@.Parameter1)

SELECT SCOPE_IDENTITY()asTheNewId

Example Code

int InsertRecord(string insertValue)

{

// assumes you have set cnn as a suitable connection

SqlCommand cmd =newSqlCommand("MyTable_Insert", cnn);

cmd.CommandType = System.Data.CommandType.StoredProcedure;

cmd.Parameters["@.Parameter1"].Value = insertValue;

object retObject = cmd.ExecuteScalar();

if (retObject !=null)

return (int)retObject;

else

return 0;// no new record

}

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_7eur.asp
Regards
Mike
"JimD" wrote:
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>> Hi Folks!
>> I am trying to use 1 computer running XP home networked to a machine
>> using
>> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
>> computer.
>> My MSACESS ADP refuses to see the SQL server even though I can do file
>> shares/printer shares between the two. Is XP home or Desktop SQL
>> incapable
>> of this? I really don't want to spend an exasperating weekend if its
>> futile!!
>> Thanks for youe help and advice,,,
>> Jim
>>
>|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
--
David Gugick
Imceda Software
www.imceda.com|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic
to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>> Hi,
>> If you have the XP SP2 firewall running then it may be blocking traffic
>> to SQL Server on port 1433.
>> It will by default. Take a look in the firewall.log file when you try to
>> connect...
>>
>> "JimD" <jimd4115@.verizon.net> wrote in message
>> news:HcI5e.1264$1p4.1219@.trndny06...
>> Hi Folks!
>> I am trying to use 1 computer running XP home networked to a machine
>> using
>> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
>> computer.
>> My MSACESS ADP refuses to see the SQL server even though I can do file
>> shares/printer shares between the two. Is XP home or Desktop SQL
>> incapable
>> of this? I really don't want to spend an exasperating weekend if its
>> futile!!
>> Thanks for youe help and advice,,,
>> Jim
>>
>>
>|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unless
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
> need to connect with the machine name as the app is written that way. Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>
>|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic
to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
Jim
Hi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/de...ar_ts_7eur.asp
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>
|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>
|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
David Gugick
Imceda Software
www.imceda.com
|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/default...;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>
|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unless
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:

> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
> need to connect with the machine name as the app is written that way. Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
>
|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/d...br />
7eur.asp
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
David Gugick
Imceda Software
www.imceda.com|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/defaul...b;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to[vbcol=seagreen]
>|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unles
s
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:

> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtec
t
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way. Coul
d
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
>|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to[vbcol=seagreen]
>

Real Simple Question

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
Jim
Hi
Answered in .Setup
Pleae do not multi-post.
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>

Real Simple Question

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Answered in .Setup
Pleae do not multi-post.
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>

Ready Tool for SQL Ce Compact Edition

We have a plan to use Microsoft SQL Server 2005 Compact Edition RC1 as a backend. Our Front-end is VS .NET (VB.NET).

We want to know how to edit the Compact Edition database (.SDF). Is there any editor is available right now in the market? or microsoft provided any editor for this.

OR Can i use microsoft 2005 sql server standard edition for this.

Thanks

You can find two desktop editors in my company's website. The first is based on .NET 1.1 and is now showing its age. If you want to take a look at the second, please be advised that although it has much more features, it is still a draft (but works). Comments and suggestions are welcome.|||You can edit the .sdf right in vs2005 or SQL 2005 Management|||

I use SQL Server 2005 Management Studio to edit it.

But be weary, the functionality is very limited. For example, you can't add foreign key constraints, or editing an existing table, in many cases, requires you to rebuild the table... but there isn't a feature to export your table to a script.

I would highly suggest scripting the table instead of using the GUI.

|||

Hi,

After a great struggle we have comeup with our own tool designed for managing the SQL compact edition database.

Here the url http://www.satwhiz.com/datapump/info.html . You can download the beta tool.

Please post your comments to gopalan@.sofist.com

Thanks

Gops

Sofist India