ANYONE PLEASE - Local Synchronization Between SQL Mobile and Local SQL Database

Hi Everyone

I am at the stage of architecting my solution

My goal is to develop the system on a windows application and pda

There is a central server which will create a publication called inventory

The laptops which host the windows application will be subscribers to the central server using merge replication

The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server

I have been reading for days and I am still unsure whether this is possible to do.

I know Appforge provide a conduit for palm to access synchronization but not local sql databases

I would appreciate your help immensley

Can anyone please help me

|||

If you build your mobile application using VS2005 and SQL Mobile, you can use merge replication between your server-side publication and SQL Mobile. The SQL Mobile Books OnLine are the first place to start - read the section on merge replication.

-Darren Shaffer

|||

Hi Darren

Yes I got my sql mobile to synchronize successfully with the local desktop sql database called "Inventory"

However I have a new problem

I would like to have the desktop replicating with the server for database "Inventory"

I also got this to work seperately

I would now want the SQL mobile database to replicate with the local desktop database "Inventory" which inturn will replicate with the server copy called "Inventory"

I would like to have both replication scenarios joined together. I know that most people will say get the SQL mobile to talk directly to the server but this is the most expensive scenario I believe

Is this possible?

Thankyou for your earlier post

Touraj

|||

Touraj,

Sorry for not reading your post more closely - I see what you are trying to do now. You want to have a 3 tier merge replication going on. Yes, this is possible, but the database on the laptop is going to have to be SQL Server 2005, not SQL Express. The way it would have to work is this:

The laptop would have to have IIS installed and the SQL Mobile server tools. As far as the mobile app is concerned, the laptop is the publisher. On the laptop, you have a subscription to the central server in a replication relationship. You would turn around and create a publication on the laptop with the same articles that are in the subscription to the central server. You would need to be extremely careful with uniqueness in this situation - I would avoid identity columns and use GUIDs for everything in this app domain.

Is there any chance that both the laptops and the PDAs can be subscribers to the central server? That would be a much easier implementation, but it is possible to do what you suggested with the extra tier.

-Darren

|||

Hi Darren

Thankyou again for your kind assistance

Yes you are right. It would be easier and 'cheaper' to get the PDA to synch with the central server via the servers IIS process

I am tossing up between a i-Mate and iPaq 4700. I would be interested to know if you have a preference over the two

Thanks from sunny Australia.

Touraj

|||

I think both i-Mate and HP make great devices - I have not had any trouble with SQL Mobile on my JasJar or on a variety of iPaqs. My WM5 JasJar seems a little sluggish overall compared to a Dell Axim X50v (WM5), which others have noted as well. Not slow, just not instant to respond to input. I have not had specific experience with the 4700. There are some public newsgroups (microsoft.public.pocketpc.developer) where people tend to talk more about specific devices and you could use Google Advanced Groups search to get previous opinions on the 4700.

-Darren

Any way to run a invisible trace on Security Audit?

Is there anyway I could run an Audit trace on SQl Server which records SQL Server System Admin Login/Logout , failed login and machine names I don't want the trace window to show on screen however would like a file generated for later viewing. Also due to Firewall issues we have, We don't have SQL tools enabled to connect to that server.Yes, you can configure SQL 2000 Auditing (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2ard.asp), up through the C2 level. Unfortunately there isn't a "cookbook" approach for doing it, you really need to understand what you are doing, and the consequences and benefits of each decision.

-PatP|||I found out . Thanks for reply. C2 auditing however is not needed . I found out that from SQL Profiler , you can script the whole trace as SQL and execute it in ISQLW . This gives back a Trace ID . Next you have to run sp_trace_Setstatus @.traceID, 1 to run it .

Thanks for responding . I appreciate that

Any way to query EXECUTE perms on stored procs?

I've recently been tasked with duplicating the permissions from one
account to another. We have a development, system test, and production
SQL Server, and approximately 35 databases in each. We use a fine
level of control on this particular account because it's what the
applications use to log in.
I've granted datareader/datawriter to the new account for all the dbs.
Each db, however, has a ton of stored procedures. Not all of them are
executable by the original account. I found a script that grants
access to all user stored procs, which is ok and will save me a few
days worth of point-and-click - but I'd be a happier DBA if I could
find a way to query the execute permissions on the stored procs to copy
them to the new account.
Any ideas? Below is the script I've used so far on the dev server.
SELECT 'GRANT EXECUTE ON ' + NAME + ' TO MyLogin' -- Replace MyLogin
with the name of your new Login
FROM SYSOBJECTS
WHERE TYPE = 'P'
AND LEFT(NAME,2) <> 'sp' -- system procs
AND LEFT(NAME,2) <> 'dt' -- VSS procs
Thanks,
Bill
A.K.A. PSPDBAThe PERMISSIONS system function can help you identify permission for the
current user:
http://msdn.microsoft.com/library/d...br />
6f78.asp
You could use it in combination with the SETUSER function:
http://msdn.microsoft.com/library/d...br />
6f78.asp
ML
http://milambda.blogspot.com/|||Ok, the sp_helprotect gives me back a list of the execute permissions
for the first user. I don't see how SETUSER is going to help me..|||PSPDBA (williambr@.state.pa.us) writes:
> Ok, the sp_helprotect gives me back a list of the execute permissions
> for the first user. I don't see how SETUSER is going to help me..
I guess the idea is:
SETUSER 'accountunderinvestigation'
go
SELECT name
FROM sysobjects
WHERE xtype = 'P'
AND permissions(id) & 32 = 1
go
SETUSER
That would list all the procedures that the account has permissions to
execute.
I should not that this solution contains three elements that are
deprecated in SQL 2005:
* The SETUSER command (Use EXECUTE AS instead)
* sysobjects (use sys.procedures instead)
* permissions(). (Use fn_my_permissions instead).
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Any way to make a "Page Footer Only For The First Page"

I am unclear if SSRS can handle this. We are using SSRS 2005 for a variety of things for a billing system; one of them being actual bill generation. The bills are generally one page long, but in rare exceptions can be multiplie pages. They end up being printed onto perforated paper at around the 8 inch mark, and we basically want to put a page footer there that is the "bill stub"... a section that summarizes the bill that they rip off and return with payment.

So, I guess the general problem is that I have a want to put a section of content at a specific place at the bottom of one and only one page (the first page would be preferrable, but the last page is also acceptable), in the middle of a report that has a table of bill line items of an indeterminate height.

I went down paths of looking at PageFooter, since it is generally the idea I am after, but I can't find a way to only show it on one page... on a 4 page bill, it always wants to print on page 2 AND 3 no matter what I do.

Thanks for any help that you can provide.

Michael

The only option supported is to print the footer on first or last page of the report (PrintOnFirstPage and PrintOnLastPage property respectively of the page footer band). Please note that currently RS (2000 and 2005) doesn't allow you to reclaim the space occupied in subsequent pages if the header/footer is not printed.|||

Just pinging this thread to see if anyone has a good workaround for this type of issue. I'm trying to use SSRS 2005 for creating invoices (currently using Crystal Reports). I have specific text (also includes data from the dataset) that has to be on a specific section of the LAST page of the invoice (can be 1 or multiple pages). This is done in Crystal by creating a second PAGE FOOTER that's suppressed on every page except the last one. This issues (along with not being to keep table groups together) are causing so much difficulty in creating reports. It's hard to believe this product is missing so many basic functions. Typical MSFT in throwing something out there that gets you 80-90% of what you need. Do they even try real world situations like the basic necessity of having an invoice, bill, etc.

|||

I don't think there is any way to suppress the whole Page Footer section. What you can try doing is giving a conditional visibility expression for the textbox that you have in your Page Footer.

For example if you want the text to shown only on the 1st page then the expression =IIf(Globals!PageNumber=1,false,true)

and if you want it only on the last page then =IIf(Globals!PageNumber=Globals!TotalPages,false,true) can be used.

Hope it helps,

Aayush

|||

I've already gone the expression route. I have a rectangle with a bunch of text boxes in it. I hide the rectangle on everypage but the last (IIf(Globals!PageNumber=Globals!TotalPages,false,true) ).

That works when displaying in the browser. However, when printing or exporting to pdf the "white space" where the rectangle is shows up on every page. I need it suppressed. This is an invoice so not being able to print it or export it to pdf to be emailed is pointless.

|||

Hi,

I tried to copy and paste the condition for only displaying on last page IIf(Globals!PageNumber=Globals!TotalPages,false,true) but it doesn't seem to be working and I am getting an error ") is missing" and it highlights "Globals" (first one).

Am I doing something wrong? Please advice. Thanks for your help

Nabil

|||Looks correct to me. Sounds silly but I hope your expression starts with the '=' symbol, that is, =IIf(Globals!PageNumber=Globals!TotalPages,false,true)

Any way to make a "Page Footer Only For The First Page"

I am unclear if SSRS can handle this. We are using SSRS 2005 for a variety of things for a billing system; one of them being actual bill generation. The bills are generally one page long, but in rare exceptions can be multiplie pages. They end up being printed onto perforated paper at around the 8 inch mark, and we basically want to put a page footer there that is the "bill stub"... a section that summarizes the bill that they rip off and return with payment.

So, I guess the general problem is that I have a want to put a section of content at a specific place at the bottom of one and only one page (the first page would be preferrable, but the last page is also acceptable), in the middle of a report that has a table of bill line items of an indeterminate height.

I went down paths of looking at PageFooter, since it is generally the idea I am after, but I can't find a way to only show it on one page... on a 4 page bill, it always wants to print on page 2 AND 3 no matter what I do.

Thanks for any help that you can provide.

Michael

The only option supported is to print the footer on first or last page of the report (PrintOnFirstPage and PrintOnLastPage property respectively of the page footer band). Please note that currently RS (2000 and 2005) doesn't allow you to reclaim the space occupied in subsequent pages if the header/footer is not printed.|||

Just pinging this thread to see if anyone has a good workaround for this type of issue. I'm trying to use SSRS 2005 for creating invoices (currently using Crystal Reports). I have specific text (also includes data from the dataset) that has to be on a specific section of the LAST page of the invoice (can be 1 or multiple pages). This is done in Crystal by creating a second PAGE FOOTER that's suppressed on every page except the last one. This issues (along with not being to keep table groups together) are causing so much difficulty in creating reports. It's hard to believe this product is missing so many basic functions. Typical MSFT in throwing something out there that gets you 80-90% of what you need. Do they even try real world situations like the basic necessity of having an invoice, bill, etc.

|||

I don't think there is any way to suppress the whole Page Footer section. What you can try doing is giving a conditional visibility expression for the textbox that you have in your Page Footer.

For example if you want the text to shown only on the 1st page then the expression =IIf(Globals!PageNumber=1,false,true)

and if you want it only on the last page then =IIf(Globals!PageNumber=Globals!TotalPages,false,true) can be used.

Hope it helps,

Aayush

|||

I've already gone the expression route. I have a rectangle with a bunch of text boxes in it. I hide the rectangle on everypage but the last (IIf(Globals!PageNumber=Globals!TotalPages,false,true) ).

That works when displaying in the browser. However, when printing or exporting to pdf the "white space" where the rectangle is shows up on every page. I need it suppressed. This is an invoice so not being able to print it or export it to pdf to be emailed is pointless.

|||

Hi,

I tried to copy and paste the condition for only displaying on last page IIf(Globals!PageNumber=Globals!TotalPages,false,true) but it doesn't seem to be working and I am getting an error ") is missing" and it highlights "Globals" (first one).

Am I doing something wrong? Please advice. Thanks for your help

Nabil

|||Looks correct to me. Sounds silly but I hope your expression starts with the '=' symbol, that is, =IIf(Globals!PageNumber=Globals!TotalPages,false,true)

Any tutorials (confused!)

Hi,
I'm new to this reporting services technology, but done a far bit of C#
and web services. In the current system I work on we have a complex
typed dataset which I want to use as the source for a reporting
services report.
using c#, can you let me know if the following is possible and point me
in a direction;
Populate the typed dataset in the main c# application.
Call reporting services, passing in this dataset (or XML) as a
parameter
All I've done with reporting services so far is to create a static
report and render this as a PDF and output the result to a physical
file on the local hard drive.
Many thanks
MatMat, have a look at www.gotreportviewer.com
HTH,
Ed
<matpublic@.ntlworld.com> wrote in message
news:1140550512.461086.100440@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm new to this reporting services technology, but done a far bit of C#
> and web services. In the current system I work on we have a complex
> typed dataset which I want to use as the source for a reporting
> services report.
> using c#, can you let me know if the following is possible and point me
> in a direction;
> Populate the typed dataset in the main c# application.
> Call reporting services, passing in this dataset (or XML) as a
> parameter
> All I've done with reporting services so far is to create a static
> report and render this as a PDF and output the result to a physical
> file on the local hard drive.
> Many thanks
> Mat
>

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>

Any possibility?

Any possibility?
Right now I have a 600 MB space free and on my system I have a 6 GB backup
file and I want to restore it on my own system...
I don't have any network where I have place this file and restore it from
there and no DVD which support this 6 GB... any
possibility like when I restore this file the backup file also remove
simultaneously so that space would be there... I am
sure it's not possible but might be some idea from you guys...
thanks
Joh wrote:
> Any possibility?
> Right now I have a 600 MB space free and on my system I have a 6 GB
> backup file and I want to restore it on my own system...
> I don't have any network where I have place this file and restore it
> from there and no DVD which support this 6 GB... any
> possibility like when I restore this file the backup file also remove
> simultaneously so that space would be there... I am
> sure it's not possible but might be some idea from you guys...
> thanks
Why not purchase a small USB hard drive. You can get one for about $129
that will give you the needed space for these type of operations. Or a
second internal hard drive which might be cheaper. Or a friend's
networked PC or laptop.
David G.

Any need to convert DAO to ADO?

I have recently completed upsizing a large Access 97 system from a Jet
backend to SQL Server 2000.
It uses linked tables and DAO exclusively.
It's working fine.
Sooner or later, the front end will need to go to A2003 or whatever,
which I asssume won't be too much of a problem.
Would there be any advantage converting to ADO, now, or when it goes to
A2003?
I can't see any justification at the moment.
Terry BellHi
There probably isn't any significant reasons to do this if you are keeping
Access as the front end, although it should help reduce the impact of the
upgrade to 2003.
John
<dreadnought8@.hotmail.com> wrote in message
news:1119167899.670346.155260@.g47g2000cwa.googlegroups.com...
>I have recently completed upsizing a large Access 97 system from a Jet
> backend to SQL Server 2000.
> It uses linked tables and DAO exclusively.
> It's working fine.
> Sooner or later, the front end will need to go to A2003 or whatever,
> which I asssume won't be too much of a problem.
> Would there be any advantage converting to ADO, now, or when it goes to
> A2003?
> I can't see any justification at the moment.
> Terry Bell
>|||BTW
You may want to post to an access newsgroup as they are more likely to have
indepth experience of this sort of conversion.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uzQgLjKdFHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hi
> There probably isn't any significant reasons to do this if you are keeping
> Access as the front end, although it should help reduce the impact of the
> upgrade to 2003.
> John
> <dreadnought8@.hotmail.com> wrote in message
> news:1119167899.670346.155260@.g47g2000cwa.googlegroups.com...
>>I have recently completed upsizing a large Access 97 system from a Jet
>> backend to SQL Server 2000.
>> It uses linked tables and DAO exclusively.
>> It's working fine.
>> Sooner or later, the front end will need to go to A2003 or whatever,
>> which I asssume won't be too much of a problem.
>> Would there be any advantage converting to ADO, now, or when it goes to
>> A2003?
>> I can't see any justification at the moment.
>> Terry Bell
>|||Yes thanks - I posted to this newsgroup in error
Terry|||Hi
DAO and RDO are considered obsolete by Microsoft.
http://msdn.microsoft.com/data/mdac/techinfo/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<dreadnought8@.hotmail.com> wrote in message
news:1119185731.468657.15010@.g49g2000cwa.googlegroups.com...
> Yes thanks - I posted to this newsgroup in error
> Terry
>

Any need to convert DAO to ADO?

I have recently completed upsizing a large Access 97 system from a Jet
backend to SQL Server 2000.
It uses linked tables and DAO exclusively.
It's working fine.
Sooner or later, the front end will need to go to A2003 or whatever,
which I asssume won't be too much of a problem.
Would there be any advantage converting to ADO, now, or when it goes to
A2003?
I can't see any justification at the moment.
Terry Bell
Hi
There probably isn't any significant reasons to do this if you are keeping
Access as the front end, although it should help reduce the impact of the
upgrade to 2003.
John
<dreadnought8@.hotmail.com> wrote in message
news:1119167899.670346.155260@.g47g2000cwa.googlegr oups.com...
>I have recently completed upsizing a large Access 97 system from a Jet
> backend to SQL Server 2000.
> It uses linked tables and DAO exclusively.
> It's working fine.
> Sooner or later, the front end will need to go to A2003 or whatever,
> which I asssume won't be too much of a problem.
> Would there be any advantage converting to ADO, now, or when it goes to
> A2003?
> I can't see any justification at the moment.
> Terry Bell
>
|||BTW
You may want to post to an access newsgroup as they are more likely to have
indepth experience of this sort of conversion.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uzQgLjKdFHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hi
> There probably isn't any significant reasons to do this if you are keeping
> Access as the front end, although it should help reduce the impact of the
> upgrade to 2003.
> John
> <dreadnought8@.hotmail.com> wrote in message
> news:1119167899.670346.155260@.g47g2000cwa.googlegr oups.com...
>
|||Yes thanks - I posted to this newsgroup in error
Terry
|||Hi
DAO and RDO are considered obsolete by Microsoft.
http://msdn.microsoft.com/data/mdac/...dacroadmap.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<dreadnought8@.hotmail.com> wrote in message
news:1119185731.468657.15010@.g49g2000cwa.googlegro ups.com...
> Yes thanks - I posted to this newsgroup in error
> Terry
>

Any need to convert DAO to ADO?

I have recently completed upsizing a large Access 97 system from a Jet
backend to SQL Server 2000.
It uses linked tables and DAO exclusively.
It's working fine.
Sooner or later, the front end will need to go to A2003 or whatever,
which I asssume won't be too much of a problem.
Would there be any advantage converting to ADO, now, or when it goes to
A2003?
I can't see any justification at the moment.
Terry BellHi
There probably isn't any significant reasons to do this if you are keeping
Access as the front end, although it should help reduce the impact of the
upgrade to 2003.
John
<dreadnought8@.hotmail.com> wrote in message
news:1119167899.670346.155260@.g47g2000cwa.googlegroups.com...
>I have recently completed upsizing a large Access 97 system from a Jet
> backend to SQL Server 2000.
> It uses linked tables and DAO exclusively.
> It's working fine.
> Sooner or later, the front end will need to go to A2003 or whatever,
> which I asssume won't be too much of a problem.
> Would there be any advantage converting to ADO, now, or when it goes to
> A2003?
> I can't see any justification at the moment.
> Terry Bell
>|||BTW
You may want to post to an access newsgroup as they are more likely to have
indepth experience of this sort of conversion.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uzQgLjKdFHA.1244@.TK2MSFTNGP10.phx.gbl...
> Hi
> There probably isn't any significant reasons to do this if you are keeping
> Access as the front end, although it should help reduce the impact of the
> upgrade to 2003.
> John
> <dreadnought8@.hotmail.com> wrote in message
> news:1119167899.670346.155260@.g47g2000cwa.googlegroups.com...
>|||Yes thanks - I posted to this newsgroup in error
Terry|||Hi
DAO and RDO are considered obsolete by Microsoft.
http://msdn.microsoft.com/data/mdac...mdacroadmap.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<dreadnought8@.hotmail.com> wrote in message
news:1119185731.468657.15010@.g49g2000cwa.googlegroups.com...
> Yes thanks - I posted to this newsgroup in error
> Terry
>

any ideas?

I have a system currently runs in house only.
The system is for enforcement officers where they are creating and working
on case files.
When they create a new case, the insert statement has logic that will go out
and find the last case number used and then increment that number by 1 and
assign this number as the case number.
I am looking to extend this application to Tablet PC's so they can take the
application out into the field. I have the database setup for merge
replication and I am using the Windows Syncrozination Manager to syncronize
the database when they logged into the network.
I would like to have the ability for them to create a new case while in the
field and disconnected from the network.
that is where the problem comes in, while they are disconnected they won't
know what the last case number was, so I need to assign a temporary case
number till they syncronize, during the syncrozination process assign
permannet case numbers.
Anybody had a situation like this or have any ideas how I could do this?
ThanksHi Mike
I have not deal with you situation, but I could envisage that a solution may
be to sync with a set of "holding" tables rather than the main ones and then
a batch process would update from the main tables at some other point.
John
"Mike Read" wrote:
> I have a system currently runs in house only.
> The system is for enforcement officers where they are creating and working
> on case files.
> When they create a new case, the insert statement has logic that will go out
> and find the last case number used and then increment that number by 1 and
> assign this number as the case number.
> I am looking to extend this application to Tablet PC's so they can take the
> application out into the field. I have the database setup for merge
> replication and I am using the Windows Syncrozination Manager to syncronize
> the database when they logged into the network.
> I would like to have the ability for them to create a new case while in the
> field and disconnected from the network.
> that is where the problem comes in, while they are disconnected they won't
> know what the last case number was, so I need to assign a temporary case
> number till they syncronize, during the syncrozination process assign
> permannet case numbers.
> Anybody had a situation like this or have any ideas how I could do this?
> Thanks
>
>

any ideas?

I have a system currently runs in house only.
The system is for enforcement officers where they are creating and working
on case files.
When they create a new case, the insert statement has logic that will go out
and find the last case number used and then increment that number by 1 and
assign this number as the case number.
I am looking to extend this application to Tablet PC's so they can take the
application out into the field. I have the database setup for merge
replication and I am using the Windows Syncrozination Manager to syncronize
the database when they logged into the network.
I would like to have the ability for them to create a new case while in the
field and disconnected from the network.
that is where the problem comes in, while they are disconnected they won't
know what the last case number was, so I need to assign a temporary case
number till they syncronize, during the syncrozination process assign
permannet case numbers.
Anybody had a situation like this or have any ideas how I could do this?
Thanks
Hi Mike
I have not deal with you situation, but I could envisage that a solution may
be to sync with a set of "holding" tables rather than the main ones and then
a batch process would update from the main tables at some other point.
John
"Mike Read" wrote:

> I have a system currently runs in house only.
> The system is for enforcement officers where they are creating and working
> on case files.
> When they create a new case, the insert statement has logic that will go out
> and find the last case number used and then increment that number by 1 and
> assign this number as the case number.
> I am looking to extend this application to Tablet PC's so they can take the
> application out into the field. I have the database setup for merge
> replication and I am using the Windows Syncrozination Manager to syncronize
> the database when they logged into the network.
> I would like to have the ability for them to create a new case while in the
> field and disconnected from the network.
> that is where the problem comes in, while they are disconnected they won't
> know what the last case number was, so I need to assign a temporary case
> number till they syncronize, during the syncrozination process assign
> permannet case numbers.
> Anybody had a situation like this or have any ideas how I could do this?
> Thanks
>
>

any ideas?

I have a system currently runs in house only.
The system is for enforcement officers where they are creating and working
on case files.
When they create a new case, the insert statement has logic that will go out
and find the last case number used and then increment that number by 1 and
assign this number as the case number.
I am looking to extend this application to Tablet PC's so they can take the
application out into the field. I have the database setup for merge
replication and I am using the Windows Syncrozination Manager to syncronize
the database when they logged into the network.
I would like to have the ability for them to create a new case while in the
field and disconnected from the network.
that is where the problem comes in, while they are disconnected they won't
know what the last case number was, so I need to assign a temporary case
number till they syncronize, during the syncrozination process assign
permannet case numbers.
Anybody had a situation like this or have any ideas how I could do this?
ThanksHi Mike
I have not deal with you situation, but I could envisage that a solution may
be to sync with a set of "holding" tables rather than the main ones and then
a batch process would update from the main tables at some other point.
John
"Mike Read" wrote:

> I have a system currently runs in house only.
> The system is for enforcement officers where they are creating and working
> on case files.
> When they create a new case, the insert statement has logic that will go o
ut
> and find the last case number used and then increment that number by 1 and
> assign this number as the case number.
> I am looking to extend this application to Tablet PC's so they can take th
e
> application out into the field. I have the database setup for merge
> replication and I am using the Windows Syncrozination Manager to syncroniz
e
> the database when they logged into the network.
> I would like to have the ability for them to create a new case while in th
e
> field and disconnected from the network.
> that is where the problem comes in, while they are disconnected they won't
> know what the last case number was, so I need to assign a temporary case
> number till they syncronize, during the syncrozination process assign
> permannet case numbers.
> Anybody had a situation like this or have any ideas how I could do this?
> Thanks
>
>

Any idea where SQL store the synonyms? thanks

I need read defination of my synonyms, but I could not find which system
table it stores, I know they get one entry in sysobjects table, but I have
no idea where is the defination.
Thanks!The sys.synonyms catalog view returns the base_object_name on which the
synonym is based. Is that what you're looking for?
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"davidw" <davidw@.affinisys.com> wrote in message
news:OTeJq6YOGHA.964@.tk2msftngp13.phx.gbl...
>I need read defination of my synonyms, but I could not find which system
> table it stores, I know they get one entry in sysobjects table, but I have
> no idea where is the defination.
> Thanks!
>|||Nice!
That is exactly what I am looking for.
I only searched on sys tables, didn't think about sys view.
thanks!
"Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
news:OX2781aOGHA.1288@.TK2MSFTNGP09.phx.gbl...
> The sys.synonyms catalog view returns the base_object_name on which the
> synonym is based. Is that what you're looking for?
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "davidw" <davidw@.affinisys.com> wrote in message
> news:OTeJq6YOGHA.964@.tk2msftngp13.phx.gbl...
> >I need read defination of my synonyms, but I could not find which system
> > table it stores, I know they get one entry in sysobjects table, but I
have
> > no idea where is the defination.
> >
> > Thanks!
> >
> >
>

Any good webcast for Data cleansing

I have sql server 2005 developer edition and vs2005 team system.
I want's to use data cleansing feature.i.e.
Integration Services Advanced Transforms Includes data mining, text mining, and data cleansing

Can please some body points me to any good webcast about using this feature

I just know about this document:

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=data+reader&searchKey=&lcid=1033&searchscope=forumscope&siteid=1&ForumID=80&ForumGroupID=-1

Any blocking when we extend the data files ?

Will there be any blocking ifi grow the data files and Log files from say
5GB to 25GB on a highly transactional system ? Let me know your thoughts.Hi
No locks are taken at data level, but the high I/O does affect performance
on queries.
Do it when usage is lowest and like normal, test it on a non-production
system before you do it.
Regards
Mike
"Hassan" wrote:
> Will there be any blocking ifi grow the data files and Log files from say
> 5GB to 25GB on a highly transactional system ? Let me know your thoughts.
>
>

Any blocking when we extend the data files ?

Will there be any blocking ifi grow the data files and Log files from say
5GB to 25GB on a highly transactional system ? Let me know your thoughts.
Hi
No locks are taken at data level, but the high I/O does affect performance
on queries.
Do it when usage is lowest and like normal, test it on a non-production
system before you do it.
Regards
Mike
"Hassan" wrote:

> Will there be any blocking ifi grow the data files and Log files from say
> 5GB to 25GB on a highly transactional system ? Let me know your thoughts.
>
>

AntiVirus Software

We have McAfee VirusScan installed on our database server. I would like to
configure the system not to scan *.bak, *.mdf, *.ldf. My question:
1. Is this the right configuration ?
2. By doing so, any potential security breach ?
3. By doing so, will the SQL box performance improve a bit?
Furthermore, we will have a new clustered SQL insatlled later on in our data
center, any recommendation on antiVirus configuration on SAN ?
Much appreciated.Hi
By not allowing the file extensions to be scanned will mean any file in any
directory will be able to have this extension, you may want to look at
excluding by directory, which if would leave less possibilities for a rogue
file if your permissions are tight enough, a combination of both would be
even tighter!!.
You may want to run MBSA to see if it recomends anything to be improved.
http://support.microsoft.com/defaul...kb;en-us;309422 also
recommends .ndf files but database files can have any extension name so make
sure that any database file extension is included in an exclude list. The
article also gives recommendations for SAN discs.
Make sure that your database do not have the autoclose property set.
If you have full text searching then you should look at not scanning
"C:\Program Files\Microsoft SQL Server\MSSQL\FTData"
A-V software can cause problems such as
http://support.microsoft.com/defaul...kb;en-us;170338
The performance effect of the a-v software will depend to some extent on the
hardware you are running, make sure that when it is running it is not too
resource hungry and your disc have not become a bottleneck.
John
"Lan" <Lan@.discussions.microsoft.com> wrote in message
news:AAF5085D-DF64-4E0E-A4F2-7C34D0AC468F@.microsoft.com...
> We have McAfee VirusScan installed on our database server. I would like to
> configure the system not to scan *.bak, *.mdf, *.ldf. My question:
> 1. Is this the right configuration ?
> 2. By doing so, any potential security breach ?
> 3. By doing so, will the SQL box performance improve a bit?
> Furthermore, we will have a new clustered SQL insatlled later on in our
> data
> center, any recommendation on antiVirus configuration on SAN ?
> Much appreciated.|||Most anti-virus products will allow you to bypass the scanning of specific
directories.You can selectively disallow the scanning of the data file and
transaction log directories.
Hilary Cotter
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
"Lan" <Lan@.discussions.microsoft.com> wrote in message
news:AAF5085D-DF64-4E0E-A4F2-7C34D0AC468F@.microsoft.com...
> We have McAfee VirusScan installed on our database server. I would like to
> configure the system not to scan *.bak, *.mdf, *.ldf. My question:
> 1. Is this the right configuration ?
> 2. By doing so, any potential security breach ?
> 3. By doing so, will the SQL box performance improve a bit?
> Furthermore, we will have a new clustered SQL insatlled later on in our
> data
> center, any recommendation on antiVirus configuration on SAN ?
> Much appreciated.|||I don't know what type of virus McAfee would be looking for in a mdf or ldf
file. If it scans the entire GB sized files from top to bottom while
referncing every possible virus signature pattern, it would result in a lot
of wasted I/O, CPU cycles, and possibly locking issues.
First make sure you have installed the version specifically designed to run
on a server. Also, it may only be prudent to have it scan only those file
types typically infected by viruses.
"Lan" <Lan@.discussions.microsoft.com> wrote in message
news:AAF5085D-DF64-4E0E-A4F2-7C34D0AC468F@.microsoft.com...
> We have McAfee VirusScan installed on our database server. I would like to
> configure the system not to scan *.bak, *.mdf, *.ldf. My question:
> 1. Is this the right configuration ?
> 2. By doing so, any potential security breach ?
> 3. By doing so, will the SQL box performance improve a bit?
> Furthermore, we will have a new clustered SQL insatlled later on in our
> data
> center, any recommendation on antiVirus configuration on SAN ?
> Much appreciated.|||On Fri, 30 Dec 2005 01:57:02 -0800, Lan <Lan@.discussions.microsoft.com> wrot
e:
in <AAF5085D-DF64-4E0E-A4F2-7C34D0AC468F@.microsoft.com>

>We have McAfee VirusScan installed on our database server. I would like to
>configure the system not to scan *.bak, *.mdf, *.ldf. My question:
>1. Is this the right configuration ?
>2. By doing so, any potential security breach ?
>3. By doing so, will the SQL box performance improve a bit?
>Furthermore, we will have a new clustered SQL insatlled later on in our dat
a
>center, any recommendation on antiVirus configuration on SAN ?
>Much appreciated.
I've found McAfee to be about the worst choice for anti virus, especially on
a
server. It's bloated, heavy handed, and almost amateurish in its ability to
discriminate between what constitutes a threat and what doesn't.
For ease of use, small footprint, and utter effectiveness have a look at AVG
.
Although I'm disheartened by the fact that they've been acquired by microsof
t,
it's been almost a year now and I haven't seen any overtly negative changes
yet.
Stefan Berglund