hi, i just heard a question from someone. He asked me what was the differecen
between a lock and a block in sql server. I'm a little confused about this. I
know what a lock is (shared locks, exclusive locks, at page or table or row
level when updating or inserting).

I have(had) a windows 2003 standard server running MS SQL server 2000 SP3a
with a default instance and a named instance.
Last night I upgrade the default instance to SQL 2005. Everything went find
durring the in place upgrade and the server services start without issue.  

I back up a number of servers to a NAS device.  This morning I rebooted the
NAS to resolve a particular issue. Unfortunately, I initiated the reboot
just before realizing that my first transaction log backups of the day for
SQL 2005 were currently running.  Of course the SQL ...

The tempdb.mdf on our SQL 2005 SP3 Server becomes heavily fragmented
after just one week of defragmenting it.  It is set to simple mode, is
just under 600 Mb in size, Auto Shrink is turned off and it resides on
the same Raid 5 D:\ drive as the main database mdf and ldf files.  The

I have a working installation of SQL Server 2005.
I tried to update to 2008 and everything was apparently OK,  but the
database engine version, as displayed in SSMS, was still 9.
I then removed 2008.

 I want know:  How to using sql get the saved disk space after I compressed
a table?
Has known:
   how to operate :In Sql Server Management Studio, Object Explorer, expend

I need to install on an XP machine to manage the sql server.  What is this
call?  management studio  ?
Tnt

We have a large number of production instances, where we need to change the
port setting from dynamic to static.
We wrote a script to do this change, with a port number unused by any other
application.

       where i have to post my answers to get MVP ?, where i have to
register?
where i have to create blogs ? Please suggest me
Adv Thanks.

I cannot believe that there is not a simple, automated fix from Microsoft.
I have been searching and searching for a fix and have nothing.  I had a sql
2000 server, then installed named instance of 2005.  Attached databases to
2005, ran script to capture sql logins from 2000 and ...

I received the following errors listed below when trying to apply
SQLServer2005-KB960089-x86-ENU security patch to a SQL Server 2005 Express
Edition with service patch 2.
Please help me resolve this issue.

Thare are two tables. There is no joint field. User input search parameter
into tParameters.
I want to code to select reocrds from tOrder but parameter dependdent on
tParameters.

Is it possible to create several databases inside one main database?  I have
huge amount of data for each state and I want to create one U.S. database
containing separate databases for each state.  Is this possible?  Are there
performance issues?  Would it be difficult to manage ...

Hello, really want to use the copy database wizard to copy a bunch of
databases from SQL Server 2000  to SQL Server 2005, which is also from
one machine to the other.  I am able to successfuly transfer from
another SQL Server 2005 server using the copy database tool.  Copying

My Database is SQL 2000
I want to convert datatype of type varchar(50) to datetime value.  Please
let me know the syntax for the same. In the Books Online, it gives ways to
convert from datetime to varchar but not vice-versa. Can anyone please throw