We are getting an error "[Microsoft][ODBC SQL Server Driver]Timeout expired"
error on a single table in one of our customers SQL 2000 databases. The
application is connecting via ODBC driver, but I get the same error if I run
directly from Query Analyzer (I have to stop it ...

Hi, excuse my ignorance but I'm what you would call an accidental DBA.  I'm
working with Database Publishing Wizard to script and recreate a database
elsewhere.  The script created is about 1.5GB in size and SQL Management
Studio doesn't seem to be able to handle this. I get an ...

I have date of birth column datetime as datetype I need to generate random
date of birth for this column using update. I'm for logic to do it
Thanks in advance

dear sir/madam
  I have to show row wise record to column wise
please help me
thanks in advance

We had a developer who wrote the following query and left the company and now
we are getting time-out from the application. When I run the profiler, this
query is the most CPU hog. How can this query be written so that it is
doesn't consume too much query ?

i have a database, called 'asdb' which went into suspect mode.
I changed the status of the database, it went to recovery, then went back to
suspect.
I tried to attach via Enterprise Manger, but it would not attach.

We have a SBS 03 R2 server with SQL server 2005 installed. We're attempting
to install CRM4. CRM4 required 2 things to be installed, SP2 and a cumulative
update patch 7. We've installed both of these and the installed passed this
stage. The installed now asks to have the ...

While doing SQL2005 install, is it possible to do only named instances and
no default instance?
Thanks,
SQL_Help

I read that the size for each base is limited to 4 Gb with SQL 2005
Express edition.
If I use synonyms  in one base will it increase the size of this base ?
(I plan to use synonyms to access some tables in another base)

We had a non responsive SQL Server last week and tried admin:<ServerName>
and it still could not connect. What more do we need to know about its usage
?

There used to be a good white paper on SQL mirroring here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
It still comes up in search results on msdn & technet, but the link is now
dead.

We tend to run out of disk space time and again due to some adhoc runaway
queries, poor planning,etc.. and its always reactive.
Are there some free or not so expensive tools out there to do some capacity
management where we can for starters trend growth and have a good graphical

I'm going to setup a SQL Server 2005 linked servers system that contains
three SQL2K5 Enterprise Edition instances.
The principle: one server will query the remaining two others on the same
objects that host complementary data, sort of partitioning view.

Good afternoon!
Quick Question - SQL2000 SP4 running on SBS2003 SP2 - we have an application
that has one main database.  This database contains some 100 tables.
I need to delete the content of each of the 17 tables that start with "Csh".

Good morning!
SQL-rookie here.  I want to say that I have asked a similar question long
ago but do not remember the answer.
Assuming that the hardware is sufficient, is this possible?  Assuming that