HI,
I try to use the FTP protocol to transfert the snapshot file from the
Distributers to the subcribers
What I did is that I right click on the subcription on the subcribers Laptop
I choose the tab Snapshot File location
Instead of using Get the snapshot file from the Publisher normal snapshot
folder I try to use the option Download the snapshot using FTP
It does work but what FTP services Sql Use because i did not set up any Ftp
server
I dont understand
Also it is more stable to use Ftp protocol instead of Sharing Folder
Thanks in advance
You normally use FTP when you are replicating over the internet. Let me ask
some basic questions first. Did you configure your publication for FTP? Have
you reviewed the ftp logs for errors?
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
"GC" <GC@.discussions.microsoft.com> wrote in message
news:151761DE-14F0-4DE2-963B-DD9EF9EBC31B@.microsoft.com...
> HI,
> I try to use the FTP protocol to transfert the snapshot file from the
> Distributers to the subcribers
> What I did is that I right click on the subcription on the subcribers
> Laptop
> I choose the tab Snapshot File location
> Instead of using Get the snapshot file from the Publisher normal snapshot
> folder I try to use the option Download the snapshot using FTP
> It does work but what FTP services Sql Use because i did not set up any
> Ftp
> server
> I dont understand
> Also it is more stable to use Ftp protocol instead of Sharing Folder
> Thanks in advance
>
|||No , i did not configure the publication for FTP.
If we use FTP when we are replcating over Internet, I wont use it because we
are using Shared Folder over the Intranet network
Thank you for the information
"Hilary Cotter" wrote:
> You normally use FTP when you are replicating over the internet. Let me ask
> some basic questions first. Did you configure your publication for FTP? Have
> you reviewed the ftp logs for errors?
> --
> 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
> "GC" <GC@.discussions.microsoft.com> wrote in message
> news:151761DE-14F0-4DE2-963B-DD9EF9EBC31B@.microsoft.com...
>
>
Showing posts with label click. Show all posts
Showing posts with label click. Show all posts
Sunday, March 25, 2012
Thursday, March 22, 2012
Download Link of SQL Express 2005 not working
When I click Download, it show NOT FOUND
What happened ?
Hi,
Download it from http://msdn.microsoft.com/vstudio/express/sql/download/ this link is working properly.
Hemantgiri S. Goswami
Sunday, March 11, 2012
double clicking a trace file does not bring any results
I installed SP4 and when i double click on a sql trace file that i had the
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
double clicking a trace file does not bring any results
I installed SP4 and when i double click on a sql trace file that i had the
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
>> I installed SP4 and when i double click on a sql trace file that i
>> had the profiler write to, just opens up Profiler and does not
>> display the saved results.
>> But when i go File-> Open and select the trace file, it populates the
>> results. So I dont know why the double clicking does not populate it
>> ? Is it a bug ? It used to work when i had Sp3a but after installing
>> Sp4, it acts as such
>> Has anyone seen this ?
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
>> I installed SP4 and when i double click on a sql trace file that i
>> had the profiler write to, just opens up Profiler and does not
>> display the saved results.
>> But when i go File-> Open and select the trace file, it populates the
>> results. So I dont know why the double clicking does not populate it
>> ? Is it a bug ? It used to work when i had Sp3a but after installing
>> Sp4, it acts as such
>> Has anyone seen this ?
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
double clicking a trace file does not bring any results
I installed SP4 and when i double click on a sql trace file that i had the
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?
Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?
Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com
double click SQL Server Express and install with sa password
Hi!
Is it possible to double click the sql server express installer, it will install sql server 2005 in silent mode, set sa password..
Just want alternative of command installation on double click
setup.exe /qb INSTANCENAME=<InstanceName> SAPWD=<StrongPassword>
is it possible
thanks in advance
No, double-clicking the installer will always launch in UI mode, not quite mode.
Mike
|||Thanks for your answer
Is there any way, the installer automatically checks the settings file while installation. On double click it reads instructions from the ini file and continue installation...
Asif Mahboob
|||Perhaps these will help.
SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://www.devx.com/dbzone/Article/31648
Subscribe to:
Posts (Atom)