What SQL Service pack do you have installed? Try this hotfix.

http://support.microsoft.com/?kbid=889170

Hi

Some members will not like using this but try the sp_OACreate proc.

Hope this helps

Hi,

You can exec an Oracle proc by using OPENQUERY. You can pass the proc parameters. But it does not seem if you can exec an Oracle cursor proc. So I...

On Win2003 the Microsoft Distributed Transaction Coordinator (MSDTC) is disabled for network transactions.

You need to follow these instructions http://support.microsoft.com/default.aspx?scid=kb;en-us;873160

Just one question.

If you recover the .mdf and .ldf files, how would you re-attach them?

I deal with this everday.

Temp tables and unions are the best methods. Cause you can debug easier and dynamically deal with a new level.

Mulitipal joins and the same table is...

This behaviour is by design try using

SET ARITHABORT ON

(keep the update in its own batch dont mix with other sql statments)

You can create a linked server. Seach on books on line.

When you create the linked server make sure that you give the user access only to the tables required and nothing...

Did you register the dll on the server?

What is the error message?

--Get the object id

declare @Object_id int

select @Object_id = object_id ('table')

--Get the column names

SELECT     [name] as coll_name

FROM         syscolumns

WHERE     (id = @Object_id)

--Put the column names into a data set and scroll through...

From Enterprise Manager Right click on the server.

Choose Edit SQL Server registration properties....

Choose Use Windows authentification

You should be able to log in then go to security choose logins and right...

YEAH  It was the simple stuff! And I have just noticed how I spelt Authentication!

Maybe this will help.

You must load DSO on the IIS front end. IIS an the Analysis services server.You use HTTP connectivity. You need to register msmdpump.dll on Front end and Analysis...

Hi Wayne ,

Obtaining data form another sql server is not at all a problem as its just another datasource for analysis services. However where will IIS be loaded? Explain your...

What is a DBA? The day I find out I will let you know as its been different for each company iv worked at. Right now I am the "do...