Can I implement replication between MS SQL Server Enterprise Edition and MSDE?

Hello.
One of our customers has requested that he wants to have data on his PC and
synchronize his data as needed.
How can I implement this?
Is it possible to synchronize data between MS SQL Server and MSDE?
Or is there any other solution?
Any advice or hint would be appreciated.AFAIR, yes. But you cannot have the MSDE as replication publisher.
Best regards,
Benny
"Kim Keuk Tae" <seiyanotenshi@.hotmail.com> skrev i en meddelelse
news:OADOIg$sDHA.2004@.TK2MSFTNGP10.phx.gbl...
> Hello.
> One of our customers has requested that he wants to have data on his PC
and
> synchronize his data as needed.
> How can I implement this?
> Is it possible to synchronize data between MS SQL Server and MSDE?
> Or is there any other solution?
> Any advice or hint would be appreciated.
>
>|||"Kim Keuk Tae" <seiyanotenshi@.hotmail.com> wrote in message
news:OADOIg$sDHA.2004@.TK2MSFTNGP10.phx.gbl...
> Hello.
> One of our customers has requested that he wants to have data on his PC
and
> synchronize his data as needed.
> How can I implement this?
> Is it possible to synchronize data between MS SQL Server and MSDE?
Hello, it is possible but not all replication types are available. I suggest
you follow this link:
http://msdn.microsoft.com/vstudio/downloads/addins/msde/examining.aspx
Regards,
Tomislav Kralj
MCSD/.NET, MCDBA
tomislav.kralj1@.zg.tel.hrsql

Can I implement a replication between sql server 2005 and IBM AS400 DB?

Hello,

I want to set up As400 DB as a publisher and the sql server 2005 as a subscriper, so that I can read some data from AS400 DB in sql server 2005 and every evening, I need the replicated data from AS400 to be refreshed.

Can I do it ? If yes, how to do it?

Thanks

You cannot subscribe to an AS400 publication from SQL. SQL would have to be the publisher and push via an OLEDB driver.

You can probibly do it pushing to SQL but this would be a question for an AS400 forum.

Martin

Can i call Tigger in store procedure or vice versa and How?

Can i call Tigger in store procedure or vice versa in sql server 2000.

and How it implement ?

Your question has been replied in anthor post, please check it:

http://forums.asp.net/1318011/ShowPost.aspx

To call stored procedure in trigger, just call it like anywhere else you call it:

EXEC sp_mysp

sql

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

I have really had enough of Dell's PERC/3 DC controllers.
Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
Secondly they are just very slow even on a plain stripe.
We paid top dollar for these a couple of years ago but they are really
holding our SQL Server back. We have 24 15k U320 disks and three controllers
and wanted the best, safest solution.
ie Raid 10.
Any controller recommendations?
Thanks
Paul
We used such controlled, moved to EMC/Dell CX300.
"Paul Cahill" wrote:

> I have really had enough of Dell's PERC/3 DC controllers.
> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
> Secondly they are just very slow even on a plain stripe.
> We paid top dollar for these a couple of years ago but they are really
> holding our SQL Server back. We have 24 15k U320 disks and three controllers
> and wanted the best, safest solution.
> ie Raid 10.
> Any controller recommendations?
> Thanks
> Paul
>
>
|||I'd love to go down this route but it's not a financial option to ditch the
24 scsi drives (and the powervaults).
At this point replacing the Perc3/DCs is the only possibility.
Paul
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...[vbcol=seagreen]
> We used such controlled, moved to EMC/Dell CX300.
> "Paul Cahill" wrote:
|||Dell has the Perc4's out. They are all based on the Adaptec controller.
With 24 drives, unless you use Fiber, you won't get much faster performance.
SCSI is rather slow over copper.
Regards
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/
"Paul Cahill" <noname@.anon.com> wrote in message
news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'd love to go down this route but it's not a financial option to ditch
> the 24 scsi drives (and the powervaults).
> At this point replacing the Perc3/DCs is the only possibility.
> Paul
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>
|||When we bought the Perc3/dcs we thought 3 dual channel controllers would be
OK. We didn't realise they cannot do true raid 10.
Many of our disks are not being hit as the raid 10 arrays are span of
mirrors not a stripe. I built most of the arrays as a set of four and one
set of six.
eg the log file is on a raid 10 set of 4 18Gb 15k drives but only two lights
flash because the log is smaller than 18gb. If it was a stripe of mirrors
all four lights would flash.
Any idea if the perc4 does true raid 10.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23HgnHJ1cFHA.612@.TK2MSFTNGP12.phx.gbl...
> Dell has the Perc4's out. They are all based on the Adaptec controller.
> With 24 drives, unless you use Fiber, you won't get much faster
> performance. SCSI is rather slow over copper.
> Regards
> --
> 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/
> "Paul Cahill" <noname@.anon.com> wrote in message
> news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
>

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

I have really had enough of Dell's PERC/3 DC controllers.
Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
Secondly they are just very slow even on a plain stripe.
We paid top dollar for these a couple of years ago but they are really
holding our SQL Server back. We have 24 15k U320 disks and three controllers
and wanted the best, safest solution.
ie Raid 10.
Any controller recommendations?
Thanks
PaulWe used such controlled, moved to EMC/Dell CX300.
"Paul Cahill" wrote:
> I have really had enough of Dell's PERC/3 DC controllers.
> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
> Secondly they are just very slow even on a plain stripe.
> We paid top dollar for these a couple of years ago but they are really
> holding our SQL Server back. We have 24 15k U320 disks and three controllers
> and wanted the best, safest solution.
> ie Raid 10.
> Any controller recommendations?
> Thanks
> Paul
>
>|||I'd love to go down this route but it's not a financial option to ditch the
24 scsi drives (and the powervaults).
At this point replacing the Perc3/DCs is the only possibility.
Paul
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
> We used such controlled, moved to EMC/Dell CX300.
> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>|||Dell has the Perc4's out. They are all based on the Adaptec controller.
With 24 drives, unless you use Fiber, you won't get much faster performance.
SCSI is rather slow over copper.
Regards
--
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/
"Paul Cahill" <noname@.anon.com> wrote in message
news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'd love to go down this route but it's not a financial option to ditch
> the 24 scsi drives (and the powervaults).
> At this point replacing the Perc3/DCs is the only possibility.
> Paul
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>|||When we bought the Perc3/dcs we thought 3 dual channel controllers would be
OK. We didn't realise they cannot do true raid 10.
Many of our disks are not being hit as the raid 10 arrays are span of
mirrors not a stripe. I built most of the arrays as a set of four and one
set of six.
eg the log file is on a raid 10 set of 4 18Gb 15k drives but only two lights
flash because the log is smaller than 18gb. If it was a stripe of mirrors
all four lights would flash.
Any idea if the perc4 does true raid 10.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23HgnHJ1cFHA.612@.TK2MSFTNGP12.phx.gbl...
> Dell has the Perc4's out. They are all based on the Adaptec controller.
> With 24 drives, unless you use Fiber, you won't get much faster
> performance. SCSI is rather slow over copper.
> Regards
> --
> 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/
> "Paul Cahill" <noname@.anon.com> wrote in message
> news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
>> I'd love to go down this route but it's not a financial option to ditch
>> the 24 scsi drives (and the powervaults).
>> At this point replacing the Perc3/DCs is the only possibility.
>> Paul
>> "andsm" <andsm@.discussions.microsoft.com> wrote in message
>> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>>
>

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

I have really had enough of Dell's PERC/3 DC controllers.
Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
Secondly they are just very slow even on a plain stripe.
We paid top dollar for these a couple of years ago but they are really
holding our SQL Server back. We have 24 15k U320 disks and three controllers
and wanted the best, safest solution.
ie Raid 10.
Any controller recommendations?
Thanks
PaulWe used such controlled, moved to EMC/Dell CX300.
"Paul Cahill" wrote:

> I have really had enough of Dell's PERC/3 DC controllers.
> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
> Secondly they are just very slow even on a plain stripe.
> We paid top dollar for these a couple of years ago but they are really
> holding our SQL Server back. We have 24 15k U320 disks and three controlle
rs
> and wanted the best, safest solution.
> ie Raid 10.
> Any controller recommendations?
> Thanks
> Paul
>
>|||I'd love to go down this route but it's not a financial option to ditch the
24 scsi drives (and the powervaults).
At this point replacing the Perc3/DCs is the only possibility.
Paul
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...[vbcol=seagreen]
> We used such controlled, moved to EMC/Dell CX300.
> "Paul Cahill" wrote:
>|||Dell has the Perc4's out. They are all based on the Adaptec controller.
With 24 drives, unless you use Fiber, you won't get much faster performance.
SCSI is rather slow over copper.
Regards
--
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/
"Paul Cahill" <noname@.anon.com> wrote in message
news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'd love to go down this route but it's not a financial option to ditch
> the 24 scsi drives (and the powervaults).
> At this point replacing the Perc3/DCs is the only possibility.
> Paul
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>|||When we bought the Perc3/dcs we thought 3 dual channel controllers would be
OK. We didn't realise they cannot do true raid 10.
Many of our disks are not being hit as the raid 10 arrays are span of
mirrors not a stripe. I built most of the arrays as a set of four and one
set of six.
eg the log file is on a raid 10 set of 4 18Gb 15k drives but only two lights
flash because the log is smaller than 18gb. If it was a stripe of mirrors
all four lights would flash.
Any idea if the perc4 does true raid 10.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23HgnHJ1cFHA.612@.TK2MSFTNGP12.phx.gbl...
> Dell has the Perc4's out. They are all based on the Adaptec controller.
> With 24 drives, unless you use Fiber, you won't get much faster
> performance. SCSI is rather slow over copper.
> Regards
> --
> 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/
> "Paul Cahill" <noname@.anon.com> wrote in message
> news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
>

Can a virtual server have local Windows users and groups?

Hi,
I have a scenario which works fine on a non-clustered SQL server, and I now
want to implement it on a clustered SQL server.
In a stand-alone, non-clustered environment:
- I have local Windows security groups on the machine; call the groups
MyGroup1, MyGroup2.
- I grant these groups login to the server, and access to the DB, as
follows: (later I add them to DB roles)
declare @.servername sysname
declare @.pos int
set @.servername = serverproperty('MachineName')
set @.pos = charindex(N'\', @.servername, 0)
if @.pos > 0
set @.servername = left(@.servername, @.pos-1)
use master
declare @.loginame sysname
set @.loginame = @.servername + '\MyGroup1'
if (not exists (select name from syslogins where name = @.loginame))
begin
exec sp_grantlogin @.loginame
end
exec sp_defaultdb @.loginame, MyDatabase
I'd like to do something similar on a clustered SQL server. But does a
cluster have a concept of local Windows groups, or must they be domain
groups?
How would I go about setting this up?
Thanks,
John.
I think I can answer this, since a cluster requires a domain account to
run - just make domain groups. Besides creating the local ones would be a
pain, think about failover.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"John [412075]" <John_dot_Knox_hyphen_Davies@.wonderware0com> wrote in
message news:OmdbtRLBFHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a scenario which works fine on a non-clustered SQL server, and I
> now
> want to implement it on a clustered SQL server.
> In a stand-alone, non-clustered environment:
> - I have local Windows security groups on the machine; call the groups
> MyGroup1, MyGroup2.
> - I grant these groups login to the server, and access to the DB, as
> follows: (later I add them to DB roles)
> declare @.servername sysname
> declare @.pos int
> set @.servername = serverproperty('MachineName')
> set @.pos = charindex(N'\', @.servername, 0)
> if @.pos > 0
> set @.servername = left(@.servername, @.pos-1)
> use master
> declare @.loginame sysname
> set @.loginame = @.servername + '\MyGroup1'
> if (not exists (select name from syslogins where name = @.loginame))
> begin
> exec sp_grantlogin @.loginame
> end
> exec sp_defaultdb @.loginame, MyDatabase
>
> I'd like to do something similar on a clustered SQL server. But does a
> cluster have a concept of local Windows groups, or must they be domain
> groups?
> How would I go about setting this up?
> Thanks,
> John.
>

Calling XML web service from a reporting services report (RDL)

Hi,

I wanted to display data returned by xml webservice in a sql reporting service report(RDL).

How I can implement the same, Please let me know the steps.

Thanks,

Anees

Check this: http://msdn.microsoft.com/library/en-us/dnsql90/html/RepServXMLDS.asp

Calling XML web service from a reporting services report (RDL)

Hi,

I wanted to display data returned by xml webservice in a sql reporting service report(RDL).

How I can implement the same, Please let me know the steps.

Thanks,

Anees

Check this: http://msdn.microsoft.com/library/en-us/dnsql90/html/RepServXMLDS.asp