How do I print contents of table (the data) in Management Studio, I dont see
any option and Help was no help.

I have a table
create table s_img1
(
img1 image,

hi everybody, i have a problem with an image field in mssql 2005.
it's the firt time i use it, and what i see is that every query that include
the image field is very slow.
how can i increase the speedy to make the querys faster?

I have web form calling stored procedure on sql2005
I use profler to trace execution,  RPC:Completed  duration is close to
8 minutes
When I execute this procedure with same or diffrent params from

The connection to our SQL servers is determined by a logical name, which
points to a physical server.   For example, the physical server name is
SERVER1, but when we connect, we connect to a server called ProdServer, which
points to SERVER1.

Is it possible to pull the top 5 records for each "group by" item?  Consider
the following SQL statement:
SELECT TOP 5 PubID, BooksID, SUM(QtySold) FROM SalesData
GROUP BY PubID, BooksID

The system is a Windows 2003 R2 Enterprise Edition cluster running SQL
Server 2005 9.00.1399.
I am in process of trying to get this upgraded past SP2 but I have run into
a 11009 error when trying to patch SQL Server.

how do i delete a paratition and all it's data from a paratitioned table?
if for examplei  have a column which is the key for the paratition, and the
data is inserted by this key, for example the column is called :
sdate

Is it really needed to STOP SQL Service before reboot the server?
Based on the the value in the registry key
HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout, the server
can kill the process if it takes too long to stop. I think it's not a good,

I am trying to create a linked server from SQL Server 2005 to a MySQL 5
database. On the real database server (SQL Server), I have installed the
ODBC driver for MySQL and created a system DSN. I then added a linked server
from SSMS. From SSMS it appears that it is able to connect ...

How to transfer linked server, include remote login and password, from SQL
Server 2000 to SQL Server 2005?
TIA
Att

Hi, I need tcp/ip on sql server 6.5 sp5 (windows NT sp6) but if I run
setup-change network support I see only "Named pipes" and
"multiprotocol".
How can I add "TCP/IP sockets"?

I am setting up a new SQL server based on Win2008 x64, SQL2005.  I then tried
to copy one of the db’s across from the old server (Win2003 32 bit, SQL 2000)
using the copy database wizard.  During the process it errors and reports
that it could not complete.  

I use the following command to insert data into a table from a text file:
INSERT ... SELECT * FROM OPENROWSET(BULK...)
The table has 4 indexes and it take about 2 hours if the text file has 2
million rows. However if the table has no indexes, inserting the same text

I'm trying to sync two separate SQL Databases. One DB is running SQL Express
and the other is running SQL 2005 full version.  I'm trying to update the
fields on the main DB with the development DB.  Is there a better way to
handle this then doing it manually one table and stored ...