Does SQL replication

Hi all,
I am looking to develop a handheld device that requires online and offline
data synchronisation with a central SQL server 2000. I have been reading up
on SQL merge replication to implement this functionality. Has anybody
implemented this type of functionality before and if so how did the merge
replication work for you and how did you find it. I have heard reports the
SQL replication does not work efficiently, so before i implement replication
i would like to get some feedback from people who may have used merge
replication before. Any help would be great.
one of the more large implementations of SQL Ce and merge replication has
1500 clients IIRC, and it works extremely reliably. This is on SQL CE and
SQL 2000. The company is Nabisco and nestle IIRC, there are case studies on
Microsoft's web site about this.
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
"sanjo" <sanjo@.discussions.microsoft.com> wrote in message
news:4FE5598C-FDC1-42ED-BEF7-77E664B7398A@.microsoft.com...
> Hi all,
> I am looking to develop a handheld device that requires online and offline
> data synchronisation with a central SQL server 2000. I have been reading
> up
> on SQL merge replication to implement this functionality. Has anybody
> implemented this type of functionality before and if so how did the merge
> replication work for you and how did you find it. I have heard reports the
> SQL replication does not work efficiently, so before i implement
> replication
> i would like to get some feedback from people who may have used merge
> replication before. Any help would be great.
>

Does Shrinkfile Emptyfile block users?

I read BOL says this can be done online but will it generate blocks.
Is it done in small transactions?
Thanks
Paul
Can you point us to exactly where it stats that? A shrinkfile with or
without Emptyfile will lock the page or extent as it moves it from the back
of the file to the front or from file to file in the case of the empty file.
It should not hold that lock unless you wrapped it in your own transaction.
Andrew J. Kelly SQL MVP
"Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>I read BOL says this can be done online but will it generate blocks.
> Is it done in small transactions?
> Thanks
> Paul
>
|||Hi Andrew
As follows. If it does it page at a time I should be OK.
Thanks
Paul
DBCC SHRINKFILE
Shrinks the size of the specified data file or log file for the related
database
........
To remove any data that may be in a file, execute DBCC
SHRINKFILE('file_name', EMPTYFILE) before executing ALTER DATABASE.
The database being shrunk does not have to be in single-user mode; other
users can be working in the database when the file is shrunk. You do not
have to run SQL Server in single-user mode to shrink the system databases.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OeBukJYiFHA.500@.TK2MSFTNGP09.phx.gbl...
> Can you point us to exactly where it stats that? A shrinkfile with or
> without Emptyfile will lock the page or extent as it moves it from the
> back of the file to the front or from file to file in the case of the
> empty file. It should not hold that lock unless you wrapped it in your own
> transaction.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
> news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>

Does Shrinkfile Emptyfile block users?

I read BOL says this can be done online but will it generate blocks.
Is it done in small transactions?
Thanks
PaulCan you point us to exactly where it stats that? A shrinkfile with or
without Emptyfile will lock the page or extent as it moves it from the back
of the file to the front or from file to file in the case of the empty file.
It should not hold that lock unless you wrapped it in your own transaction.
Andrew J. Kelly SQL MVP
"Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>I read BOL says this can be done online but will it generate blocks.
> Is it done in small transactions?
> Thanks
> Paul
>|||Hi Andrew
As follows. If it does it page at a time I should be OK.
Thanks
Paul
DBCC SHRINKFILE
Shrinks the size of the specified data file or log file for the related
database
.......
To remove any data that may be in a file, execute DBCC
SHRINKFILE('file_name', EMPTYFILE) before executing ALTER DATABASE.
The database being shrunk does not have to be in single-user mode; other
users can be working in the database when the file is shrunk. You do not
have to run SQL Server in single-user mode to shrink the system databases.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OeBukJYiFHA.500@.TK2MSFTNGP09.phx.gbl...
> Can you point us to exactly where it stats that? A shrinkfile with or
> without Emptyfile will lock the page or extent as it moves it from the
> back of the file to the front or from file to file in the case of the
> empty file. It should not hold that lock unless you wrapped it in your own
> transaction.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
> news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>

Does Shrinkfile Emptyfile block users?

I read BOL says this can be done online but will it generate blocks.
Is it done in small transactions?
Thanks
PaulCan you point us to exactly where it stats that? A shrinkfile with or
without Emptyfile will lock the page or extent as it moves it from the back
of the file to the front or from file to file in the case of the empty file.
It should not hold that lock unless you wrapped it in your own transaction.
--
Andrew J. Kelly SQL MVP
"Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>I read BOL says this can be done online but will it generate blocks.
> Is it done in small transactions?
> Thanks
> Paul
>|||Hi Andrew
As follows. If it does it page at a time I should be OK.
Thanks
Paul
DBCC SHRINKFILE
Shrinks the size of the specified data file or log file for the related
database
.......
To remove any data that may be in a file, execute DBCC
SHRINKFILE('file_name', EMPTYFILE) before executing ALTER DATABASE.
The database being shrunk does not have to be in single-user mode; other
users can be working in the database when the file is shrunk. You do not
have to run SQL Server in single-user mode to shrink the system databases.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OeBukJYiFHA.500@.TK2MSFTNGP09.phx.gbl...
> Can you point us to exactly where it stats that? A shrinkfile with or
> without Emptyfile will lock the page or extent as it moves it from the
> back of the file to the front or from file to file in the case of the
> empty file. It should not hold that lock unless you wrapped it in your own
> transaction.
> --
> Andrew J. Kelly SQL MVP
>
> "Paul Cahill" <xyzpaul.xyzcahill@.dsl.pipex.com> wrote in message
> news:eLgLMZXiFHA.2644@.TK2MSFTNGP09.phx.gbl...
>>I read BOL says this can be done online but will it generate blocks.
>> Is it done in small transactions?
>> Thanks
>> Paul
>>
>sql

Does offline database come back online when server is restarted?

If you take a database offline to prevent users from accessing it, and then restart the server, will the database be back online when the server starts up?

If so, is there an option to prevent this from happening so that a database taken offline will remain offline until it is manually put online again by an administrator?

The database state is kept in the master database, and is persistent across shutdowns as long as the database is not detached.

A database which is set OFFLINE will not come ONLINE until an administrator explicitly sets it back ONLINE.

Documentation to get started

What is the best online documentation either on the Web or installed
with
SQL Server that I could use to get started? I want to jump in and
start
creating tables, etc for applications.

Also, what is the most recommended text for converting my DBA
experience from other database to SQL Server.

Thanks
Bill.Books Online, SQL Server's official documentation installed
with SQL Server, is a good place to start. There are many
good SQL Server books. One of them which I like is:

The Guru's Guide to Transact-SQL by Ken Henderson
(publisher: Addison Wesley).

Note that this is not an official endorsement!
--
Arun Marathe
Program Manager
SQL Server Query Processor
Microsoft Corporation

Disclaimers:
(1) This posting is provided "AS IS" with no warranties, and confers no
rights.
(2) Use of included script samples are subject to the terms specified at:
http://www.microsoft.com/info/cpyright.htm

"Bill" <bill_ralenkotter@.yahoo.com> wrote in message
news:96254b32.0309040631.21c23b1b@.posting.google.c om...
> What is the best online documentation either on the Web or installed
> with
> SQL Server that I could use to get started? I want to jump in and
> start
> creating tables, etc for applications.
> Also, what is the most recommended text for converting my DBA
> experience from other database to SQL Server.
> Thanks
> Bill.|||Bill

As you will soon find there are dozens of useful SQL Server Web sites.
These are two of the best ones to help get you started.

http://www.microsoft.com/technet/ne...rver&frame=true

http://www.sql-server-performance.com/

Hope these help

John|||Thanks for the links I will continue to look at them.

One thinkn in particular that I am after are instructions
for connecting to the DB right after it is installed.
I think there is a test database and I want to log into that.
I am probably not seeing these instructions on the installed
docs?

Thanks
Bill.

Documentation for RDL (Report Definition Language)

Hi,
I am searching for a document or the specification of RDL (Report Definition
Language). Does anyone know a good book or an online documentation dealing
with RDL?
Best regards,
ChristianReporting Services is still in beta so you aren't likely to
find any books out on the subject yet. You can sign up for
the beta to access some of the specifications in the help
file for the product:
http://www.microsoft.com/sql/reporting/default.asp
-Sue
On Mon, 10 Nov 2003 18:24:33 +0100, "Christian Nein"
<christian@.nein.de> wrote:
>Hi,
>I am searching for a document or the specification of RDL (Report Definition
>Language). Does anyone know a good book or an online documentation dealing
>with RDL?
>Best regards,
>Christian
>

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.
Hi,
The xp_availablemedia extended stored procedure is used to return a list of
available storage
devices that can be written to. It doesn't require any special signature
definitions,
because all you have to do to use it is call it directly, with no parameters
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uwcqVr7OEHA.3596@.tk2msftngp13.phx.gbl...
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
>
>
|||Dear Try this ,
http://www.remainsecure.com/whitepap...l/sqlcheck.htm
Regards
Faheem Latif
Network Solutions

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.
>
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
The system stored procedure xp_availablemedia is UNDOCUMENTED. The behavior
of xp_availablemedia may change across service packs and SQL Server
versions.
This system stored procedure is used when backing up and restoring from SQL
Server Enterprise Manager.
This system stored procedure is mentioned in this article:
PRB: "Error 229: Execute Permission Denied on Object 'xp_availablemedia'
Owner 'dbo'"
http://support.microsoft.com/?id=323249
Why do you want to know? Do you have a specific issue that you need to
address? Perhaps we can help in that area.
Cheers,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.Hi,
The xp_availablemedia extended stored procedure is used to return a list of
available storage
devices that can be written to. It doesn't require any special signature
definitions,
because all you have to do to use it is call it directly, with no parameters
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uwcqVr7OEHA.3596@.tk2msftngp13.phx.gbl...
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
>
>|||Dear Try this ,
http://www.remainsecure.com/whitepa...ql/sqlcheck.htm
Regards
Faheem Latif
Network Solutions

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.>
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
--
The system stored procedure xp_availablemedia is UNDOCUMENTED. The behavior
of xp_availablemedia may change across service packs and SQL Server
versions.
This system stored procedure is used when backing up and restoring from SQL
Server Enterprise Manager.
This system stored procedure is mentioned in this article:
PRB: "Error 229: Execute Permission Denied on Object 'xp_availablemedia'
Owner 'dbo'"
http://support.microsoft.com/?id=323249
Why do you want to know? Do you have a specific issue that you need to
address? Perhaps we can help in that area.
Cheers,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.>
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
--
The system stored procedure xp_availablemedia is UNDOCUMENTED. The behavior
of xp_availablemedia may change across service packs and SQL Server
versions.
This system stored procedure is used when backing up and restoring from SQL
Server Enterprise Manager.
This system stored procedure is mentioned in this article:
PRB: "Error 229: Execute Permission Denied on Object 'xp_availablemedia'
Owner 'dbo'"
http://support.microsoft.com/?id=323249
Why do you want to know? Do you have a specific issue that you need to
address? Perhaps we can help in that area.
Cheers,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

doc on xp_availablemedia

I tried to find the document on xp_availablemedia extended procedure but
couldn't find it on online help or support microsoft website. Can you please
tell me what it is doing? Thanks.Hi,
The xp_availablemedia extended stored procedure is used to return a list of
available storage
devices that can be written to. It doesn't require any special signature
definitions,
because all you have to do to use it is call it directly, with no parameters
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uwcqVr7OEHA.3596@.tk2msftngp13.phx.gbl...
> I tried to find the document on xp_availablemedia extended procedure but
> couldn't find it on online help or support microsoft website. Can you
please
> tell me what it is doing? Thanks.
>
>|||Dear Try this
http://www.remainsecure.com/whitepapers/database/mssql/sqlcheck.ht
Regards
Faheem Latif
Network Solutions