| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 August 2008 |
Filter by week: 1 2 3 4 5 Are user/rights restored with a 'forced' restore? Posted by Bob Brainin at 8/14/2003 9:23:14 PM I restored an early backup on SQL 7, only to find that users had been
dropped in EM. I then restored a later backup which I was sure had all the
users properly authorised, but they're still not there!
What is the correct way to administer this? Is it by ticking the individual
boxes for each ta...more >>
Ansi_nulls & warnings Posted by mai at 8/14/2003 11:58:04 AM Hi there!
DO you any idea why this error comes up? What should i do?
"Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This
ensures consistent query semantics. Enable these options
and then reissue your query."
I did try in my script ...more >>
Attach db without using detach Posted by kokoiski at 8/14/2003 3:36:19 AM Hi,
Is it possible to attach a database without detaching it
first?
Thank you in advance....more >>
SQL Server communicating with an Oracle Database Posted by jholgu1 at 8/12/2003 10:12:53 AM Is there some kind of database link in SQL Server that I
can use to access an Oracle Table real time?...more >>
Connectivity Problem Posted by W. Carpenter at 8/12/2003 4:44:07 AM I have a connectivity problem with SQL 7.0. During light
use there is no problems. During heavy use clients get a
error message when trying to connect. "unable to connect
to database. A SQL Server request resulted in a bad
return code or status but no error message was returned.
When a...more >>
MSDTC Service not available Posted by Royce Lithgo at 8/11/2003 9:29:31 PM Sorry for all the postings, but I've found something new.
I tried a new DTS package, this one copying data from SQL
Server to SQL Server tables (ie. No Oracle objects
involved). I changed the properties of each step to set
JoinTransactionIfPresent and Rollback Failure to true.
When I run...more >>
MSDAORA not support distributed transactions Posted by Royce Lithgo at 8/11/2003 9:03:02 PM The following SQL:
begin transaction
insert into ps_jrnl_header
select * from ps_jrnl_header_arc_vw
(ps_jrnl_header_arc_vw selects from an Oracle table using
an MS OLE DB Oracle Linked server).
Generates the error:
Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be...more >>
sql connection error Posted by Rygane Manuel at 8/11/2003 8:55:23 AM I need help to resolve this connection issue:
Error creating database connection: Missing database
information
Page: /intratime/content/login.asp
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDTC service not available Posted by Royce Lithgo at 8/11/2003 2:17:09 AM I've setup a Linked Server to an Oracle DB and have
created a view in MS SQL Server to fetch data from the
Oracle DB. The following SQL issues an Error:
BEGIN TRANSACTION
insert into PS_JRNL_HEADER
select * from PS_JRNL_HEADER_ARC_VW
Server: Msg 7391, Level 16, State 1, Line 3
The o...more >>
Slow connect Posted by Barry Dakers at 8/10/2003 3:31:40 AM Suddenly the connection speed to a server or object is so
slow I can make a cup of tea while waiting.
It was ok only days ago. I've tried reinstalling but no
avail.
I'm running Win2000prosp3 and SQL Server 2000 personal
addition.
Hope someone can help
Thanks...more >>
accessing linked servers externally Posted by dan at 8/8/2003 1:50:04 PM I have been able to create a linked server to an ole db
provider with out any problem. My question is how to I
access the tables mapped to the linked server from other
applications for example: Ms Query in excel. When I
connect to SQL Server inside ms/query, I do not see any
of the tables ...more >>
Procedures and Linked Servers Posted by Namir Rodriguez at 8/8/2003 10:44:12 AM Hi all... I am triying to execute a Procedure in an Oracle
instance from a SQL Server 7.0 Linked Server and I get
this error message:
Server: Msg 7212, Level 17, State 1, Line 3
Could not execute procedure 'TEST' on remote
server 'ORATEST'.
[OLE/DB provider returned message: One or more err...more >>
Export database Posted by Liyuan Wu at 8/8/2003 9:56:35 AM Hi,
How can I export a SQL database to a CD_ROM (burn a CD)
and send it to clients.
Thanks,
Liyuan
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |