Viewing 15 posts - 7,186 through 7,200 (of 7,429 total)
Also try this if you don't know for sure.
EXEC sp_addlinkedserver
@server = 'YourNameForLinkServerHere',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle.1',
@datasrc = 'WhatYouEnterForHostStringInSQL*Plus'
This will use the native Oracle Driver if everything else is right, and...
February 19, 2002 at 10:34 am
Ok let's back up, I got to reading here. What is the value you input for Host String in SQL*Plus, and is this an ODBC entry on your machine or...
February 19, 2002 at 10:18 am
Sorry, I did not see a post about the error. What is the error message you are getting?
February 19, 2002 at 10:06 am
From SQL Books Online ALTER COLUMN cannot be used on a column associated with a default, except that changing the length, precision, or scale of a column is allowed if...
February 19, 2002 at 9:56 am
Syntax
sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'
[ , [ @useself = ] 'useself' ]
[ , [ @locallogin = ] 'locallogin' ]...
February 19, 2002 at 9:16 am
These should answer your question. They are from SQL Books Online. Statement 1 in Function Invocation and statement 3 in Permissions apply to your question.
Function Invocation
Scalar-valued functions may be invoked...
February 19, 2002 at 7:48 am
From what I have seen the only known problem is with immediate updating subsribers that you can read about here http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271727. The problem is a design difference.
February 19, 2002 at 5:18 am
Looking around I found a reference I want to verify. Does the table have a unique index? Also so I know what is up with the table could you please...
February 19, 2002 at 4:39 am
Hint think about the order of the data and what you can do with it and how you can get the first record out of a data set.
February 19, 2002 at 4:05 am
Well done article, nicely presented with reference material.
February 18, 2002 at 3:54 pm
I just tend to stick with Query Analyzer or work in NotePad (yeah just plain old text). And had got curious about this previously. I will say thou in previous...
February 18, 2002 at 3:52 pm
How will they access the data first. If thru access then right view to database (but I hope you are not using access as it will drag large DBs down...
February 18, 2002 at 3:42 pm
In my office we adopted a precomment to views and stored procedures (which still not everyone follows). But it our databases especially those created in the last 8 months by...
February 18, 2002 at 3:36 pm
You should avoid the sysobjects and other similar tables as they may change in future releases and for the moment Microsoft is saying you the SPs or Schema views as...
February 18, 2002 at 3:05 pm
Plus with Brians statement you could write it as a summary of the records so if someone wants trending on the values you do not have to recalc saving you...
February 18, 2002 at 3:02 pm
Viewing 15 posts - 7,186 through 7,200 (of 7,429 total)