Link Server

Hi,
I got "there is no security context that we could use to
verified sql server exists." How should I resolve it?
Thanks in advance!
KarenMake sure you have set up a login mapping if required on the security tab.
See sp_addlinkedsrvlogin and "Establishing Security for Linked Servers" in
BOL for more details
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karen" <k.duan@.ieee.org> wrote in message
news:086b01c3506c$56832070$a001280a@.phx.gbl...
Hi,
I got "there is no security context that we could use to
verified sql server exists." How should I resolve it?
Thanks in advance!
Karen|||I got "Error 7303: Could not initialize data source object
of OLE db provider 'Microsoft jet OLEdb 4.0'".
The two servers are in different domains. One is Windows
NT 4.0 and SQL 7; the other is Windows 2000 and sql 2000.
Is there any knowing issue about this?
Thank!
Karen|||No question is stupid question; plus you don't have
resolution too.
Karen

Line Count in Crystal Report

Is there any function or way to get the no of lines displayed in the detail section of the report.

Hlp me.

Thx in advance.

Ashok Sis that not a group function.. something you would put in the group footer (a total)?

i cant be too specific because im still learning crystal myself!|||You need to use two formulae
Formula1 @.Reset having the code
Numbervar n;
WhilePrintingRecords;
n:=0;
Formula2 @.Count having the code
Numbervar n;
WhilePrintingRecords;
n:=n+1;
Now Place Formual1 at PageHeader
Formula2 at Details Section.
Now the last value is the total number of records of that page|||Or you could just use the inbuilt RecordNumber function. It works fine if you are not hiding any records in your record set

- Jukka|||My Problem is not getting the recordcount. I need to get the line count.
A Record may be displayed in multiple lines.

To be Specific, I have four Detail sections, and in that for three sections i have used can grow property except the first one. In this case I need to get the Line nos of the detail section.

Thx,

Ashok

Limit to number of functions in a DB

Hello,
Is there a limit to the number of user-defined functions one can have in a
database (i.e. 500 udfs per db)?
Thanks in advance for your help,
-CollinThe limit, AFAIK, is the number of objects (including tables, stored
procedures etc), which is the datatype for object id in sysobjects, which is
in, which mean about 2 billion. From BOL:
Objects in a database 2,147,483,6474 2,147,483,6474
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_ts_8dbn.htm
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"cc_gardner" <collin_gardner@.hotmail.com> wrote in message
news:buouvr$bjq12@.kcweb01.netnews.att.com...

quote:

---

> Hello,
> Is there a limit to the number of user-defined functions one can have in a
> database (i.e. 500 udfs per db)?
> Thanks in advance for your help,
> -Collin
>

---

Limit to number of functions in a DB

Hello,
Is there a limit to the number of user-defined functions one can have in a
database (i.e. 500 udfs per db)?
Thanks in advance for your help,
-CollinThe limit, AFAIK, is the number of objects (including tables, stored
procedures etc), which is the datatype for object id in sysobjects, which is
in, which mean about 2 billion. From BOL:
Objects in a database 2,147,483,6474 2,147,483,6474
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_ts_8dbn.htm
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"cc_gardner" <collin_gardner@.hotmail.com> wrote in message
news:buouvr$bjq12@.kcweb01.netnews.att.com...
> Hello,
> Is there a limit to the number of user-defined functions one can have in a
> database (i.e. 500 udfs per db)?
> Thanks in advance for your help,
> -Collin
>