FTP Replication

Is it possible to implement SQL Replication via ftp without expose SQL
Server on Internet.
I mean if SQL Server is in local mashine and only ftp site is visible to the
subscribers.
And i dont want to use VPN
Well you have several options
1) have SQL run on port 21, then get your snapshot over another way.
2) use sp_browsereplcmds to get plain text commands to issue on the
subscriber. This will require a local subscription to generate these
commands.
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
"Greg" <gcholakidis@.hotmail.com> wrote in message
news:d74j04$3pe$1@.usenet.otenet.gr...
> Is it possible to implement SQL Replication via ftp without expose SQL
> Server on Internet.
> I mean if SQL Server is in local mashine and only ftp site is visible to
the
> subscribers.
> And i dont want to use VPN
>
|||I try to implement the second approach (using sp_browsereplcmds).
Unfortunly i see in help that sp_browsereplcmds doesnt work with merge
replication
(in remarks ' sp_browsereplcmds is working with transactional replication')
I dont understand why Microsoft is mention ftp replication since they dont
implement futures which allows
you to use ftp server anywhere in the net and require VPN or SQL Server
exposed to net.
Is there any workoroun or thirt party tool which will allows such
communication?
I mean i need merge replication between two sites. And i want to use ftp
server to store and exchange snapshots.
I have an application which works this way but using Sybase Anywhere
replication and want to convert it to SQL Server 2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%2393LawgYFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Well you have several options
> 1) have SQL run on port 21, then get your snapshot over another way.
> 2) use sp_browsereplcmds to get plain text commands to issue on the
> subscriber. This will require a local subscription to generate these
> commands.
>
> --
> 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
> "Greg" <gcholakidis@.hotmail.com> wrote in message
> news:d74j04$3pe$1@.usenet.otenet.gr...
> the
>
sql

ftp Failure

I have designed an SSIS that needs to download a set of files via ftp. The ftp is working fine under Business Studio. When I move it to The server and try runing the package I'm getting the following errors:

Error: Unable to connect to FTP server using "FTP Server"

Error: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.

This is not my first FTP in SSIS, so I also have the following item set:

Protectionlevel = EncryptProtectedWithPassword

I have several other FTP packages that go to the exact same server, with the exact same user ID and password that are working.

What am I missing?

Since noone is responding...

I also tried changing the protection level to "DontSaveEncrypted" and set up a package configuration with the password in it. I thought this would work, but I'm still getting the same messages.

|||This is an FTP server error, not an SSIS related error.

Search the Internet for "The password was not allowed." for discussions on this message.|||

Thanks for replying Phil.

If this is an FTP server error, why does it work in one package, but not in another that's using the exact same connection?

And why does it work in SSIS designer?

Frequency of joins between two tables in a database.

Hi All,
Is there anyway to tell the frequency of joins between two tables in a
database?. I need help on this one.
Thanks.
Message posted via http://www.webservertalk.comI don't know of any way to profile this, but what you could do
reasonably quickly is build up a quick structure mapping queries to the
tables they join, then run a profiler, log all the queries run into a
table, and thus be able to interrogate this. However that will assume
that your queries always join the same tables.|||Hi
Can you say what you need this for? If you are looking at de-normalisation
then you may want to base that on actual performance.
If you script your code you may get some idea of how often a table is joined
by using test searches.
John
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5ef609f8fb256@.uwe...
> Hi All,
> Is there anyway to tell the frequency of joins between two tables in a
> database?. I need help on this one.
> Thanks.
> --
> Message posted via http://www.webservertalk.com|||The reason to get this information is, I'm trying to split a large DB( 700gb
)
to group the join tables on one drive for performance purposes.
Thanks.
John Bell wrote:
>Hi
>Can you say what you need this for? If you are looking at de-normalisation
>then you may want to base that on actual performance.
>If you script your code you may get some idea of how often a table is joine
d
>by using test searches.
>John
>
Message posted via http://www.webservertalk.com|||I could be wrong, but won't it be better to have the joined tables on
different drives, so multiple IO paths can be used at the same time? Or are
we talking about moving certain data to faster drives and leaving other data
on slower drives?
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5ef800aece75b@.uwe...
> The reason to get this information is, I'm trying to split a large DB(
700gb)
> to group the join tables on one drive for performance purposes.
> Thanks.
> John Bell wrote:
de-normalisation
joined
> --
> Message posted via http://www.webservertalk.com|||Hi
You can look profile and look at high reads/writes as well as duration, that
will hopefully give some indication where you can split things up. You may
also want to split indexes onto different spindles, possibly looking at ITW
to show you some indication of what indexes are frequently used.
Also you can try creating multiple files on different drives that belong to
the same filegroup. The other option is to add extra discs to an existing
array so splitting I/O over more spindles.
John
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5ef800aece75b@.uwe...
> The reason to get this information is, I'm trying to split a large DB(
> 700gb)
> to group the join tables on one drive for performance purposes.
> Thanks.
> John Bell wrote:
> --
> Message posted via http://www.webservertalk.com|||And... don't forget move tempdb onto it's own spindles, possibly splitting
it into multiple files as well as moving the system databases into their own
discs.
John
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5ef800aece75b@.uwe...
> The reason to get this information is, I'm trying to split a large DB(
> 700gb)
> to group the join tables on one drive for performance purposes.
> Thanks.
> John Bell wrote:
> --
> Message posted via http://www.webservertalk.com|||Hi Jim
I had mis-read this... yes you would want to split I/O. I prefer a more
quantative approach i.e.target what is bad!
John
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:uz60VkwYGHA.3684@.TK2MSFTNGP05.phx.gbl...
>I could be wrong, but won't it be better to have the joined tables on
> different drives, so multiple IO paths can be used at the same time? Or
> are
> we talking about moving certain data to faster drives and leaving other
> data
> on slower drives?
>
> "Naana via webservertalk.com" <u14055@.uwe> wrote in message
> news:5ef800aece75b@.uwe...
> 700gb)
> de-normalisation
> joined
>|||We are thinking of moving certain large tables that are frequently access to
faster drives and leaving other data on slower drives.
Jim Underwood wrote:
>I could be wrong, but won't it be better to have the joined tables on
>different drives, so multiple IO paths can be used at the same time? Or ar
e
>we talking about moving certain data to faster drives and leaving other dat
a
>on slower drives?
>
>[quoted text clipped - 17 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200604/1

Free space on an index

On SQL 2000, how would you determine:
1. the percent free on an index?
2. the available page size?
Thanks
Message posted via http://www.sqlmonster.com
Indexes don't have "free space" - when pages need to be added to the index,
they are allocated and linked in.
In SQL Server the page size is always the same, 8KB. If you're referring to
the available free space on a particular page, there isn't any documented
way to do this. Perhaps you're talking about FILLFACTOR? You can specify a
FILLFACTOR for index creation that will leave a percentage of space on the
leaf level index pages free, but it is only maintained at index creation
time, not during normal operations. You can use INDEXPROPERTY (<table>,
<index>, 'IndexFillFactor') to get this value...
If I'm misunderstanding your questions, please let me know.
Thanks.
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:44a0ef20a81f45cb9afa95ac557ba389@.SQLMonster.c om...
> On SQL 2000, how would you determine:
> 1. the percent free on an index?
> 2. the available page size?
> Thanks
> --
> Message posted via http://www.sqlmonster.com
|||Okay. Thanks for getting me straight.
What is happening is I have inserts into a table that are timing out, but
updates on the table are proceeding. Is there a possibility of the index
size growing, or new pages being added to the index that may be causing
these insert timeouts?
Message posted via http://www.sqlmonster.com

Free space on an index

On SQL 2000, how would you determine:
1. the percent free on an index?
2. the available page size?
Thanks
--
Message posted via http://www.sqlmonster.comIndexes don't have "free space" - when pages need to be added to the index,
they are allocated and linked in.
In SQL Server the page size is always the same, 8KB. If you're referring to
the available free space on a particular page, there isn't any documented
way to do this. Perhaps you're talking about FILLFACTOR? You can specify a
FILLFACTOR for index creation that will leave a percentage of space on the
leaf level index pages free, but it is only maintained at index creation
time, not during normal operations. You can use INDEXPROPERTY (<table>,
<index>, 'IndexFillFactor') to get this value...
If I'm misunderstanding your questions, please let me know.
Thanks.
--
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:44a0ef20a81f45cb9afa95ac557ba389@.SQLMonster.com...
> On SQL 2000, how would you determine:
> 1. the percent free on an index?
> 2. the available page size?
> Thanks
> --
> Message posted via http://www.sqlmonster.com|||Okay. Thanks for getting me straight.
What is happening is I have inserts into a table that are timing out, but
updates on the table are proceeding. Is there a possibility of the index
size growing, or new pages being added to the index that may be causing
these insert timeouts?
--
Message posted via http://www.sqlmonster.com

Free space on an index

On SQL 2000, how would you determine:
1. the percent free on an index?
2. the available page size?
Thanks
Message posted via http://www.droptable.comIndexes don't have "free space" - when pages need to be added to the index,
they are allocated and linked in.
In SQL Server the page size is always the same, 8KB. If you're referring to
the available free space on a particular page, there isn't any documented
way to do this. Perhaps you're talking about FILLFACTOR? You can specify a
FILLFACTOR for index creation that will leave a percentage of space on the
leaf level index pages free, but it is only maintained at index creation
time, not during normal operations. You can use INDEXPROPERTY (<table>,
<index>, 'IndexFillFactor') to get this value...
If I'm misunderstanding your questions, please let me know.
Thanks.
--
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:44a0ef20a81f45cb9afa95ac557ba389@.SQ
droptable.com...
> On SQL 2000, how would you determine:
> 1. the percent free on an index?
> 2. the available page size?
> Thanks
> --
> Message posted via http://www.droptable.com|||Okay. Thanks for getting me straight.
What is happening is I have inserts into a table that are timing out, but
updates on the table are proceeding. Is there a possibility of the index
size growing, or new pages being added to the index that may be causing
these insert timeouts?
Message posted via http://www.droptable.com