I downloaded a 30 day trial version of the Basis ODBC driver but that is a Read license. When i try to use "Other Connection" it gives me an error...

The active users are mixed in with the inactive. Also the table is keyed on the Identity field.

Are there any articles that provide information on the working of SQL...

Here's what I did.

I pulled up the memo field in the select statement using the left function. It worked. for example:

'SELECT Left(abc, 99999) as ABC, Key

FROM tblABC'

Needed to change the password from the Services Undet Admin Tools and things are bright and sunny again.

Thanx anyways.

The network client utility is enabled. It gives me a 1069 error when i try to register.

Both servers are named instances of SQL Server and are on the same box.

This is the SPROC.

CREATE PROCEDURE usp_Test

AS

SELECT *

FROM OPENQUERY (LINKED_SERVER_NAME, 'SELECT TOP 10 * FROM tblTemp')

I think that service is running as it shows up in lower right corner os system tray.

even profiler is not able to connect. its a named instance on default port.

...

Currently I am using SQLXML connections to the Database. I do not have a ConnectionString but I connect using Virtual Directory Support in SQL Server. I have completed versioning ...

i have a set of SPROCS and VIEWS. the sprocs and views currently access data in db1 (say ver1.0) from db2. The data in db1 is not version specific. I...

At any given point of time I am looking at 2 versions of data. Moreover i can't have the data in the same database since data / sprocs in the...

Declare @intAcctID

Insert into tablename(...) values (...)

SELECT @intAcctID = @@IDENTITY

SELECT intAcctID

FROM tblAccount

WHERE intAcctID = @intAccountID

FOR XML AUTO, ELEMENTS

I need this since we're using templates to call SP's.

intID is Fk and intAcctID is the pk for this insert. sorry abt the ambiguity 🙂

CREATE PROCEDURE usp_BankAccountInsert

@intID numeric, @vchTitle2 varchar(50), @vchNumber varchar(25), @vchName varchar(100)

AS

INSERT INTO tblBankAccount (intID, vchTitle2, vchNumber, intID)

VALUES (@intID, @vchTitle2, @vchNumber, @vchName)

SELECT @intAcctID = @@IDENTITY

FOR XML AUTO

GO

CREATE TRIGGER TR_AuditDetail ON dbo.tblDetail

FOR UPDATE

AS

DECLARE @OldValue VARCHAR(255)

DECLARE @NewValue VARCHAR(255)

DECLARE @User VARCHAR(20)

DECLARE @OldValueMoney MONEY

DECLARE @NewValueMoney MONEY

DECLARE @dteOldValue DATETIME

DECLARE @dteNewValue DATETIME

DECLARE @intOldValue NUMERIC

DECLARE @intNewValue NUMERIC

DECLARE @key INT

DECLARE @FieldName VARCHAR(50)

SELECT...

CREATE TABLE #tempTbl (

[recid] [int] IDENTITY (1,1) NOT NULL,

[id] [int] NOT NULL,

[name] [varchar] (1000) NOT NULL,

[codedescription] [varchar] (50) NOT NULL,

[date] [smalldatetime] NOT NULL,

[number] [int] NOT NULL

)

INSERT INTO #tempTbl ([id], [name],...