Hi this is how I do it. The below example is for linking to an ORACLE server

[font="Courier New"]USE master

GO

-- To use named parameters:

EXEC sp_addlinkedserver

@server =...

Have you ever tried the free tool "SQL DBA Dashboard"? You might find the information there.

Download it from here http://www.sqlserverexamples.com/v2/Products/tabid/76/Default.aspx

have a look at the SQL Tool belt from redgate as well. One of the tools in there is just doing this. There is a 30 day trial available.

Like it as well. As I'm just moving from SQL Server 2K to 2K5 it also helps me to see how others work with the Management Studio.

Hi,

check this article about transaction log:

http://www.sqlservercentral.com/articles/Design+and+Theory/63350/

Cheers:)

Get some books about fundamental software development techniques.

Just as an example: Systems Analysis & Design Methods from Whitten Bentley ISBN-13: 978-0-07-305233-5 (www.mhhe.com/whitten). Good book for students covers traditional (data) analysis...

Hi Dex

I'm trying to do the same but I don't know what to install exactly on the SQL server. Can you provide a short instruction, please?

Kind regards

Rene

I fully agree to Ninja's remark. It is not worthwhile to design and program an application which can recover from every possible failure of one of it's components. A system...

Posted my opinion about the newsletter format in another area before I saw this threat.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=334255&edit=1

Cheers

René

Hi,

Usually I have problems with the German Version of a software

Im not joking. Even as a native (Swiss)-German speaking person I prefer always...

Very well described! What I specially like is that this article covers also the approach of such an exercise and how to minimize the impact on the business which has...

Read also here

http://msdn2.microsoft.com/en-us/library/ms151182.aspx

Check out this script. It currently drops all triggers from a database but the script can be used as a framework for tasks where you have to loop through a...

Why version 1.0 and not MSDE 2000A?

Check this out:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=281830