ACCESS between serveral SQL-servers

I'v set up a new SQL6.5 server. The idea is to relieve our main server.
The problem is that I can't run a SP on the main server from the new server.

Ex: *fake data*

Insert into newserver exec mainserver.database..sp

this will generate:
Msg 18484, Level 14, State 1
Unable to connect to site 'newserver' because login failed

I've managed to add the newserver in mainserver.master..sysservers and the mainserver in newserver.master..sysservers

The way I see it I've got a problem with the users...??
This is all new to me so please help me!

Thanks:
BixHi, It's me again.
I solved my problem, and it was easy...
I guess that it was so easy that you guys didn't bother *s*

If anybody else get my problem, the answere lays in "Remote Servers" under the "Server" menu.
Register a remote server and map the logins...
and everything works like a dream!

Thanks!

Access ADP support SQLExp205

Is there anyone who have an idea when Access ADP (2003) would support SQLExp
2005? Is there any download to make them work together?
Pls help, many thanks.
> Is there anyone who have an idea when Access ADP (2003) would support
> SQLExp 2005? Is there any download to make them work together?
Probably never and no, I do think we'll see a patch to enable it. More here:
http://sqljunkies.com/weblog/ktegels...8/03/3735.aspx
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
sql

about subscribers

i have millions of subscribers,

any good idea to manage those subscribers efficently?

thanks

Same old, same old... Query optimization (the most important thing!!!...).

And remember that you can add custom indexes to NS tables.

Also, if possible, break your application into several separate applications based on the module's functionality, and run them separately, maybe even on separate machines.

Also, for performance, use SQL Server server machine for the SQL stuff only, and move the NS service and all other resources-hungry stuff (custom event providers, content formatters, etc.) to other server(s).

Use subscription expiration to remove all "old" subscriptions, and once in a while prompt your customers to confirm their old subscriptions (that they still want to receive their alerts AND confirm email addresses, cell phone #s, etc.). Maybe, even distribute your own notification with the request for confirmation; do it a few times; if someone does not reply, remove this subscriber.

|||

Thanks for that,and

Any good idea about how to create subscribers quickly,especially millions of subscribers

|||

For SSNS in 2000, you have to use the API.

In SSNS 2005, you can insert into subscriber views. Here's an example.

http://sqlns.blogspot.com/2005/10/creating-subscribers-in-2005.html

HTH...

Joe

about setup

Just appear 'configuration tools' and 'documentation and tutorials' after installed katmai June CTP

OS: WinXP sp2

any idea about this? many thanks

resetup failed,error code is :-2147467259 Message:Unspecified error
Log shown below:
MSI (s) (CC:04) [21:03:16:062]: Note: 1: 1708
MSI (s) (CC:04) [21:03:16:062]: Product: Microsoft SQL Server "Katmai" Tools -- Installation failed.

MSI (s) (CC:04) [21:03:16:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:04) [21:03:16:093]: MainEngineThread is returning 1603
MSI (s) (CC:24) [21:03:16:203]: Destroying RemoteAPI object.
MSI (s) (CC:70) [21:03:16:203]: Custom Action Manager thread ending.
=== Logging stopped: 6/27/2007 21:03:16 ===
MSI (c) (AC:1C) [21:03:16:234]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (AC:1C) [21:03:16:234]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/27/2007 21:03:16 ===

Also, I already uninstalled workstation component of 2005

What's this matter? thanks

|||Well, I think the solution was came from mverun
My VS8 was installed in non-default folder

about query ..

Hi all,
Does anyone know what is the following query mean:
select * from abc,def from abc.xx(+) = def.xx
i have no idea about the (+) symbol..what it represent?
Thank you in advance
Best regards,
Ocurnos
Hi,
Its Left outer join in Oracle. SQL Server will give you syntax error.
Thanks
Hari
SQL Server MVP
"Daniel" <Daniel@.discussions.microsoft.com> wrote in message
news:8453A3AC-B95C-45B0-B117-79EE86FCF452@.microsoft.com...
> Hi all,
> Does anyone know what is the following query mean:
> select * from abc,def from abc.xx(+) = def.xx
> i have no idea about the (+) symbol..what it represent?
> Thank you in advance
> Best regards,
> Ocurnos

about query

Hi all,
Does anyone know what is the following query mean:
select * from abc,def where abc.xx(+) = def.xx
i have no idea about the (+) symbol..what it represent?
Thank you in advance
Best regards,
Ocurnos
As I know that + Symbol to used to join string.
example below
SELECT top 10 Title_ID + Title As "Title_ID + Title", * FROM
[pubs].[dbo].[titles]
Regards,
Rajesh
"Daniel" wrote:

> Hi all,
> Does anyone know what is the following query mean:
> select * from abc,def where abc.xx(+) = def.xx
> i have no idea about the (+) symbol..what it represent?
> Thank you in advance
> Best regards,
> Ocurnos

About OLAP Service

Hi,
What is OLAP Service ?
What is the Advantage of OLAP ?
How can i use it in my VB/SQL Server Application ?
Where can i get details Idea about OLAP Service ?
Thanks ,\A good start is
http://msdn.microsoft.com/library/d...>
hs_7cbq.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"DMP" <debdulal.mahapatra@.fi-tek.co.in> wrote in message
news:uL04im3BFHA.3820@.TK2MSFTNGP11.phx.gbl...
> Hi,
> What is OLAP Service ?
> What is the Advantage of OLAP ?
> How can i use it in my VB/SQL Server Application ?
> Where can i get details Idea about OLAP Service ?
> Thanks ,\
>
>

about emailchannel?

I use email to notify my subscribers,but how to define my email format?

any idea?

thanks in advance

I'm not sure what exactly you mean by mail format...

If you are talking about "building" a custom email message with all data from your notification class, you need to create your custom content formatter.

If you have a Shyam Pather's book (2000 or 2005), which is a must-have for everyone working with SQL-NS, building your own custom content formatter is VERY easy if you just modify the sample from the book.

Also, you can use the built-in XSLT content formatter, but I personally found it much easier to build my own one, using C#. Just for your reference, creating a custom content formatter prototype took me just a few hours, so it's not as bad as it may sound...

About DateTime in SQL

Hi,
I am making a report in SQL Reporting with the following format.
Does any have any idea how can I get date in this format "Monday, March 26, 2007" and how can I get time of each tranction in Reporting.I tried Formatdatetime function but it doesn't work..Plzz help me Thanks

Monday, March 26, 2007
10am 100
10am 110
1pm 100
Total: 310
Tuesday,March 27,2007
11am 500
6 pm 500
Total: 1000
Grad Total 1310

Quote:

Originally Posted by ri58776

Hi,
I am making a report in SQL Reporting with the following format.
Does any have any idea how can I get date in this format "Monday, March 26, 2007" and how can I get time of each tranction in Reporting.I tried Formatdatetime function but it doesn't work..Plzz help me Thanks

Monday, March 26, 2007
10am 100
10am 110
1pm 100
Total: 310
Tuesday,March 27,2007
11am 500
6 pm 500
Total: 1000
Grad Total 1310

----
For Date format you can use....Example,

SELECT substring(CONVERT(CHAR(20),'March 26, 2007 05:32:08 PM',109),1,14)

For Time part... Example
SELECT CONVERT(CHAR(15),'05:32:08 PM',114)