Reinitilize subscribtions

I have trans replication and i want every sunday to make complete snapshot -
push replication. If I was able to make some command with query analyzer to
reinitilize subscribtions it would be great!
Thanks in advance!I believe you can change the snapshot agent schedule to do once on every
Sunday.
richard
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:uIdVvwK5DHA.488@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I have trans replication and i want every sunday to make complete

---

snapshot -

quote:

---

> push replication. If I was able to make some command with query analyzer

---

to

quote:

---

> reinitilize subscribtions it would be great!
> Thanks in advance!
>

---

Reinitilize subscribtions

I have trans replication and i want every sunday to make complete snapshot -
push replication. If I was able to make some command with query analyzer to
reinitilize subscribtions it would be great!
Thanks in advance!I believe you can change the snapshot agent schedule to do once on every
Sunday.
richard
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:uIdVvwK5DHA.488@.TK2MSFTNGP12.phx.gbl...
> I have trans replication and i want every sunday to make complete
snapshot -
> push replication. If I was able to make some command with query analyzer
to
> reinitilize subscribtions it would be great!
> Thanks in advance!
>

re-indexing job takes more time

We have a re-indexing all DBs schedule job in our SQL 2000 box,
normally it took 7 hours to complete but all of the sudden now it
takes more than 20 hours.
What do you think it cause this problem? We have no clue."Frank" <soal6570@.yahoo.com> wrote in message
news:42601b2.0405052143.66cdbe69@.posting.google.co m...
> We have a re-indexing all DBs schedule job in our SQL 2000 box,
> normally it took 7 hours to complete but all of the sudden now it
> takes more than 20 hours.
> What do you think it cause this problem? We have no clue.

Have you checked general CPU and I/O activity on the server, using Perfmon?
There may be another process which is taking up resources, or perhaps it
could be a symptom of Slammer infection, if the MSSQL service has a very
high CPU load. You might also want to use Profiler to check if there's any
unusual activity within MSSQL itself, which might be creating problems.

Simon|||It could also be caused by other activity blocking the rebuilds, or badly
fragmented freespace if the indexes have grown.

On a seperate note, here's a link to a whitepaper you may want to read to
determine if reindexing everything is the right thing to do for your
particular situation.

http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx

Regards

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:409a67f2$1_1@.news.bluewin.ch...
> "Frank" <soal6570@.yahoo.com> wrote in message
> news:42601b2.0405052143.66cdbe69@.posting.google.co m...
> > We have a re-indexing all DBs schedule job in our SQL 2000 box,
> > normally it took 7 hours to complete but all of the sudden now it
> > takes more than 20 hours.
> > What do you think it cause this problem? We have no clue.
> Have you checked general CPU and I/O activity on the server, using
Perfmon?
> There may be another process which is taking up resources, or perhaps it
> could be a symptom of Slammer infection, if the MSSQL service has a very
> high CPU load. You might also want to use Profiler to check if there's any
> unusual activity within MSSQL itself, which might be creating problems.
> Simon

Register dll

I would like to register the cpx.dll as an external stored procedure for
"xp_cpx.
Please let me the procedures to complete this task?
Thanks"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:5A5FCB65-476C-40B6-A1B7-0DD7409BC355@.microsoft.com...
> I would like to register the cpx.dll as an external stored procedure for
> "xp_cpx.
> Please let me the procedures to complete this task?
> Thanks
>
From the Books Online
Adding an Extended Stored Procedure to SQL Server
A DLL that contains extended stored procedure functions acts as an extension
to Microsoft® SQL ServerT. To install the DLL, copy the file to the
directory containing the standard SQL Server DLL files (C:\Program
Files\Microsoft SQL Server\Mssql\Binn by default).
To add each extended stored procedure function in an extended stored
procedure DLL, a SQL Server system administrator must run the
sp_addextendedproc system stored procedure, specifying the name of the
function and the name of the DLL in which that function resides. For
example, this command registers the function xp_hello, located in
xp_hello.dll, as a SQL Server extended stored procedure:
sp_addextendedproc 'xp_hello', 'xp_hello.dll'
It is not necessary to stop and restart SQL Server. This is in a sample only
available if you select Dev Tools during setup.

Register dll

I would like to register the cpx.dll as an external stored procedure for
"xp_cpx.
Please let me the procedures to complete this task?
Thanks
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:5A5FCB65-476C-40B6-A1B7-0DD7409BC355@.microsoft.com...
> I would like to register the cpx.dll as an external stored procedure for
> "xp_cpx.
> Please let me the procedures to complete this task?
> Thanks
>
From the Books Online
Adding an Extended Stored Procedure to SQL Server
A DLL that contains extended stored procedure functions acts as an extension
to Microsoft SQL ServerT. To install the DLL, copy the file to the
directory containing the standard SQL Server DLL files (C:\Program
Files\Microsoft SQL Server\Mssql\Binn by default).
To add each extended stored procedure function in an extended stored
procedure DLL, a SQL Server system administrator must run the
sp_addextendedproc system stored procedure, specifying the name of the
function and the name of the DLL in which that function resides. For
example, this command registers the function xp_hello, located in
xp_hello.dll, as a SQL Server extended stored procedure:
sp_addextendedproc 'xp_hello', 'xp_hello.dll'
It is not necessary to stop and restart SQL Server. This is in a sample only
available if you select Dev Tools during setup.

Register dll

I would like to register the cpx.dll as an external stored procedure for
"xp_cpx.
Please let me the procedures to complete this task?
Thanks"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:5A5FCB65-476C-40B6-A1B7-0DD7409BC355@.microsoft.com...
> I would like to register the cpx.dll as an external stored procedure for
> "xp_cpx.
> Please let me the procedures to complete this task?
> Thanks
>
From the Books Online
Adding an Extended Stored Procedure to SQL Server
A DLL that contains extended stored procedure functions acts as an extension
to Microsoft SQL ServerT. To install the DLL, copy the file to the
directory containing the standard SQL Server DLL files (C:\Program
Files\Microsoft SQL Server\Mssql\Binn by default).
To add each extended stored procedure function in an extended stored
procedure DLL, a SQL Server system administrator must run the
sp_addextendedproc system stored procedure, specifying the name of the
function and the name of the DLL in which that function resides. For
example, this command registers the function xp_hello, located in
xp_hello.dll, as a SQL Server extended stored procedure:
sp_addextendedproc 'xp_hello', 'xp_hello.dll'
It is not necessary to stop and restart SQL Server. This is in a sample only
available if you select Dev Tools during setup.