ok, no sweat, just do as in my last posting...

yes, when the dns-client is starting is registers the PC with DNS, if DNS-Server-IP is given and the appropriate checkbox in the "Advanced TCP/IP Settings" - "DNS" is activated (Register...

What OS is on the PC's? w2k too? If that's the case, then install DNS Server on your Server and configure his IP as DNS-Option for DHCP.

W2k or XP will...

Hi,

converting to static IP is not necessary, but the SQL Server should have a static IP, so troubleshooting is easier done.

(ok, i'm a fan of static ip's, but that's...

Hi,

by using ipconfig -all you can see if the cluster-ip is active on a node

karl

Hi,

what kind of connection do you want? linked server, open rowset..?

In any case you can connect the servers by not using windows security but sql server logins.

regards karl

There is actually an other way to change the path:

If sqlserver is running you can connect with EM, open master, tables and right-click on table sysaltfiles, show all lines......

Hi,

you just did the restore in the wrong order!

First to restore is allways master, because the path to all other databases resides in master..sysfiles and master..sysaltfiles.

After master you...

I'm doing it like that, without linked server:

create view _v_ADS_Contacts as

SELECT *

FROM OPENROWSET(

'AdsDsoObject'

,'User ID=;Password=;ADSI Flag=0x11;Page Size=10000'

,'SELECT Name, givenName, SN, Mail,...

In case of trouble:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters

holds the path to master.db and errorlog,

master..sysfiles and master..sysaltfiles hold the paths to all other dtabases...

karl

Hi Terry,

on that topic i would recommend you read the following article

http://www.sql-server-performance.com/sql_server_log_shipping.asp

which explains logshipping in detail.

If you are going to implement logshipping you can either use the logshipping procedures...

Hi,

you could use something like:

/* Procedure to script all user-procedures, -functions and views on a server

Author: Karl Klingler

Created 20.10.2004

Modified...

Hi,

one thing the guys from microsoft told us was to use "sp_updatestats", and to additionally use the stored procedure "sp_createstats". Seems that sql server 2000 does not allways create statistics,...

Hi,

first thing to do if there are problems starting the agent is to test the mail function. If there is a problem with mapi or mail profile the agent won't...

Hi,

actually it should be easy to do it via backup and restore...

If on the new server all paths are the same as on the old server, then no sweat, you...