quote:

---

thanks for that frank. something i'd missed.

at least I've learned something today, so the day hasn't been wasted 🙂

---

quote:

---

syslockinfo is not a 'fake' table. see syslockinfo in BOL

---

I'm not sure if this is...

quote:

---

help! SQL optimizer is deciding not to use indexes because of index density (too many items with the same value), resulting in...

quote:

---

I need to transfer data (address, phone number, email etc) from "Master" MSSQL200 database to Exchange, so user can use it in...

Hi Ray,

quote:

---

The two MAIN reasons I like identity columns is that you can put a clustered index on them and your inserts...

No solution, but it happens from time to time here on NT4. too.

Update to SP3 didn't help either

Frank

http://www.insidesql.de

This might also be helpful

http://support.microsoft.com/default.aspx?scid=kb;EN-US;274463

Frank

http://www.insidesql.de

On which action did you receive this message?

For resolving I would start here

http://support.microsoft.com/search/default.aspx?QuerySource=gASr_Query&Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Queryc=Copy+database+wizard&Query=Copy+database+wizard&KeywordType=ANY&maxResults=25&Titles=false&numDays=

Also, I found that although some error messages do appear, everything is working properly.

Frank

http://www.insidesql.de

No, you only must have access to both servers. That's ok

Frank

http://www.insidesql.de

Edited by - Frank Kalis on 10/13/2003 08:08:22 AM

On one of the wizard pages there is a check box where you can specify if want to copy or to move the db. Check the copy option. Maybe you...

Hi,

maybe this one will help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14030

If you need to use dynamic SQL you should really use sp_executeSQL. This will give you a chance of reusable execution plans.

Btw, in addition there...

Hi Knpo,

quote:

---

Is it possible to transfer data from MSSQL2000 to Exchange2000?

---

take a look in BOL...

Hi,

maybe this http://www.sqlservercentral.com/columnists/dpoole/sqlandiisonthesamebox.asp

and the discussion on this article will help you.

Frank

http://www.insidesql.de

Hi 5409045121009,

well, consider this a WAG, but AFAIK Windows loads the profile of the currently logged on user into registry. So you should be able to query the registry for...

I think the Copy Database Wizard does quite an acceptable job. You can invoke him by right-clicking on the target server in EM ->All tasks->Copy Database wizard.

The wizard will also...