I would say No to your Query,

You should install the another instance with all the binaries.

I assumed that you're trying to execute the Select statement in query analyzer.

If you want to run a select statement to Oracle table then the syntax is

Select * from Openquery(Oracle...

I found this script in same site !

USE (What ever the database to be indexed)

--Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT...

Dear John

Thanks ! But did you think this dead lock is happening because of bad indexes .

If i run dbcc inputbuffer(spid)  i get the below results

EventType Parameters EventInfo  

--------- ---------- -----------

RPC...

Domain admin account is not required.But Local Admin account is must to install the sqlserver,service packs etc...,

Yes, but I installed both versions in different Drives.

I uses the same logic (I have found an approach similar to Colins to fastest and easiest.  I recently had to change the collation sequence on two diffrent data...

The only way to revoke the permissions to start or stop the DTS packages ,Save the Package with  Password.

select

CONVERT(VARCHAR(10), GETDATE(), 23) by this you get the...

The only way to check the Valid Windows NT user is through Active Directory.Use Linked server concept to connect your LDAP Directory .

Yeah! great job man

Even I was looking for the same

Use the ALTER DATABASE statement, specifying the logical file name as follows:

use master

go

Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')

go

Alter database tempdb modify file (name = templog,...

Reconfigure your outlook with new profile and check

Mr deepak good work .might be other ways to do the process.but this way is simple and its userfriendly isnt.