If I run a simple "select top 10000 * from table" query against a SQL
2005 server from a client pc using management studio the query returns
in about a second. Running the same query on the same client pc using
the older query analyzer takes 25 seconds.

I know is possible I just forgot how.  Thanks.

I moved all my data files from mssql2000 to mssql2005.
problem is that my log files are GB's bigger than the MDF file.
Can I delete the LOG files?  IF not, can I reduced the size?
How?

we are running a maintainance plan on sql 2000 standard edition, got the error,
[2] Database db_source: Check Data Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8928: [Microsoft][ODBC SQL
Server Driver][SQL Server]Object ID 1221579390, index ID 0: Page (1:197116)

Hi, how can I copy the schema and the content of tables from one database to
another ?
Thank you
Andrea

I am looking for an object in a SQL 2000 db.  I tried using
fn_listextendedproperty but having no luck.  How do I look up say an object
called 'ABC' in a complete db
thanks in advance

I have installed sql server 2005 clusters before, but never ran into this issue
When I get to the screen to pick a drive for data files, after selecting any
of the available ones I get the same error
"there is not enough disk space on the destination disk for the current sql

Gurus,
Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster.  Is there a
Cluster command line I can run which will stop my "SQL Agent Service"?
--

I am unable to connect to SSRS (for managing reports, etc.) within SSMS (it
throws out a HTTP 401 error). So, I thought the configuration may have been
set up wrong or something so I opened up the SQL Surface Area Configuration
tool. The RS service was running and when I went to ...

I have a table with dates stored in a nvarchar(75), I would like to move
this over to datetime (for obvious reasons)
the problem is the field has some 'bad data'
how can i query the nvarchar field to return me anything that isnt a date?

Server generated an error 9002, Severity:17, State 6
The log file for database 'temdb' is full. Back up the transaction log for
the database to free up some log space.
tempdb.mdf file located at D:\Microsoft SQL Server\MSSQL\Data\ is with size

If I add the SSIS Import and Export Wizard to a toolbar (Tools >
Customize... > Categories:Project > Commands:SSIS Import and Export
Wizard...) in SSMS, it is disabled (dimmed/grayed out), at least it is when
I have nothing else open and I'm in Object Explorer Details inside a ...

What would be the best place to run profiler, on the production Server or on
another client Machine?
Thanks,

I have 4 files sent to me by a client, LogData.bak, PioneerTables.bak,
SEF.bak, and WSD.bak. I want to restore the database in SQL Server
2005 Express. I select Databases and right-click and select restore
database. There is no database in the To database drop down and typing

What Protocols should be enabled using a local copy of SQL Express?
Shared Memory
Name Pipes
TCP/IP