Greg,

We had a discussion lst week at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=192943#bm193675

that linked server transforms some data types. I researched ad it appears when you use Linked server it uses OLEDB and as a...

Hi,

The IP configuration of the server should be based on Default Gateway IP and Subnet Mask for this subnet as I understand. If you move this server to another subnet...

Hanslindgren ,

This is pretty good. Do you use any performance-enhancing third-party SQL Tools like QuickShift? Is it high-end multi-processor system with optimized IO?...

Hello,

This is a very good article. One has to read it once in a while. I am well familiar with the concept and these 4 rules. But  every now and...

I agree with JP. See BOL

query governor cost limit Option

Use the query governor cost limit option to specify an upper limit for the time in which a query...

James,

Wizards are not for inexpirienced, judging by your result and my own experience only very skilled DBAs who understand minor details how it works should use them.

I usually do...

John,

tell us more what are you doing: are you moving only 1 database to the new install of SQL Server 2000 on another server and DTS packages that are stored in...

Hi,

My next advice will be valid only in a case if SQL Server can be started. Then you will do steps 1 through 4. If it can not be started, do ...

Hello,

Copy Database wizard is supposed to use DTS according to documentation and it does, but it includes detaching the source database. That is why I would really recommend restoring backup...

Hi,

we had a discussion here some time ago on this topic, I am getting this very error a lot between Windows 2000 and Windows 2003 servers, everything is in the same...

Hi,

I am confirming everything. I created and linked an alias to the same server. So I have the same table through linked server and without linked server depending on query.

select...

Hi Hanslindgren,

Did you try any other providers? I mean, there are 2 options:SQL Server and Other Data Source when creating Linked Server. In Other Data Source there are OLEDB providers...

I am not getting it.

You can certainly remotely login to a server not being an admin. For example in Windows 2003 server there is a built-in Remote Desktop Users group. If...

Ann,

Yes, you have to backup Master. It contains all information about other databases and most important, logins and passwords.

You absolutely have to backup MSDB if you have jobs and DTS...

Juanita,

Wait Type is a type of lock, please see

http://www.sqldev.net/articles/wait_types.htm

In your case this article says:

Wait resource is a resource that is...