I have two websites written in .NET that use MSDE and that I'm trying to
migrate over to SQL Sever 2005 Express Edition. Both sites have a similar
workload (i.e. very small). I wanted to compare the performance of the two
so I kept one site in MSDE and the other I converted to ...

I installed SQL server 2005 on a Windows 2003 Server everything went well. I
also installed sp1 everything went well. I decided to add a second instance
in the process I received two warnings:
1 default installation path permission requirement

I am getting this message in the event log
"IO Completion Listener (0xe0c) Worker 0x00000000040601C0 appears to be
non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms,
Interval: 15016."

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on.  Google searches
have turned up nothing.  Help!

How do I get a list of the column names in my SQL tables?  Preferable a
list that can be exported to Excel or Word.
Thanks!
Yvette

I would like to grab a handful of DMVs and Catalog views one should get
familiar with while working on SQL 2005 as a DBA. For eg: in SQL 2000, I
would look at sp_who2, sysprocesses,dbcc
inputbuffer,sp_lock,sysobjects,sp_dboption,etc.

I have a client that is continually getting this error message:
Could not continue scan with NOLOCK due to data movement
Intially they were not at SP4 of SQL Server 2000, so per this Microsoft
Document they patched the server

I believe that SQL 2000 64 bit on x64 AMD Procs are not truly 64 bit, but
some WoW and that true 64 bit is only suppoerted on IA64 for SQL 2000.
Please let me know if this is true and if so, what would be the difference
in the x64 vs IA64 versions as it relates to SQL Server. What ...

Since indexed views aren't going to work for me, I'm working on
revamping a large, ugly query that hits a large, ugly database.
The database stores inventory.
Some items in inventory are single items (e.g. a calendar), while

Why did MS use the trem "Truncate transaction log" to refer to the process of
making the log space with committed and backed up transactions in the
transaction log reusable?
I keep dealing with people who think the term means the same as shrinkfile

I have a SP the runs fine during a period of time, but after a database
back up, it stops working until it is recompiled again. What would
break this?
The SP does use a function that creates a tempDB table with about 8000

We regularly load data into hundreds of tables in a reporting database.
I know that many of the tables were needed years ago for short-term
projects, and are no longer used.  I'm trying to find a way to identify
which tables are never accessed by users, so that we can stop those

Is they any feature that allows replication between Active Directory an SQL
server.  I know I can write an assembly to do it but I'm checking on easier
ways first.

SQL Server 2005
Someone here attempted to update about 3000 rows in a table that is in
replication (on the publisher side). We are using push replication.
The rows were updated successfully on the publisher table, but for some

We have an OLTP database handling our business production operations.
Our reporting team wants to extract from the OLTP db every 15 min, but
that will hammer the OLTP db I/O-wise, breaking the system.  The
reporting team wants a copy of the OLTP system to do their extractions.