Well,

Then there will be something else in addition to SQL. We had to move a server from one location to another without moving the old hardware. The clone was made...

IMPORTANT!!!

Here is what is posted in SQL server 2005 Books Online:

DBCC INDEXDEFRAG (Transact-SQL)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included...

Check Current Acivity window or try suser_sname

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_8kdh.asp

Sure, ask your network admin for the security logs on the domain controller they will be able to tell you what login was trying to query it at this particular...

May work. I did it from 2000 to 2000, or from 2003 to the same 2003 after SQL Server was re-installed. Just copied Data folder out with SQL Server stopped...

Sarah,

Normally you would select Last Known Good Configuration if you did not login successfully to roll back to well, last good configuration.

Please, look up on the Microsoft website from...

I was surprised yesterday when looking up Windows versions end-of-support dates on Microsoft website that the dates were posted like in Europe. For example, 30 June 2005. Good thing they...

What is funny: I did

SET SHOWPLAN_XML ON

GO

SELECT * FROM MYTABLE

I got a nice XML as expected. Next, I replaces 3 letters XML for ALL in the same query window and...

Steve, thanks!

The program in the article you pointed to uses Windows Shell Extensions. This looks like what I need. I have to read more on that.

Yelena

This is cool. I had to refresh what I new about SET and found more, see SET statement. For example, stored procedures:

".....Stored procedures execute with the SET settings specified at...

To use a name you need to ask your network admins to create a record foryour server on DNS server. I also tested creating a DNS alias which is not a...

OSQL -L and ListAvailableSQLServers list only servers that advertise on the subnet, not all of them. I usually do a 2-step thing.:

1. Creating a short script that dynamically composes a...

Do you want to run sp_changeobjectowner in a script once in a while or as a trigger on something? You may query sysobjects if there is an object of the...

Hi Bernard,

1. Logins. Martin is right. The logins and the database owner will be things to watch. Is it the same Windows server (for example- 7.0 is a default instance...

Hi,

I checked my Query Analyzers. SQL Server 2000 waits till all results are returned. SQL Server 2005 Beta posts results while they are being obtained.

I know there are 2...