Is it possible to run a SELECT query without printing the results? (I want
to run it in Query Editor and also from sqlcmd). e.g. I have a customers
table with 10,000 rows, I want to time how long it takes to get all the
data, but I don't want to actually see the data. Something ...

We are running SQL 2005 and I have questions about the tempdb. Is there a
way of viewing the data in the tables that are created in the tempdb? Also
is there a way to delete the tables in the tempdb?

Restored a Production SQL Server 7 Database to SQL Server 2005 running on a
test server. The ID for a user account that existed on the restored database
duplicates an ID on the test server. The ID on the restored Database cannot
be deleted because it owns a schema.

I'm currently converting á PHP web running on an Apache webserver on a Linux
machine with MySQL backend database, to Windows server, running Apache
webserver with an MSSQL 2005 backend database.
The old-web is written for UTF8 all the way, which it must be because of the

We have a Microsoft SQL Server 2000 SP3 running database for Microsoft
Navision 3.7
From time we encounter problems, especially when running heavy query
procedures from Navision, with the transaction log. It's actually setup as

We just create a new server and no particular Server login has been created.
We would like to know when we restore a database from the production server
to this new server, we will encounter the Orphanded user problem ?
Thanks

My database log file size is 62GB, I want to shrink it until less than 20GB,
but when I using Shrink File fucntion in SQL Enterprise Manager, the system
show Minimum Size is 60GB. In that case, how can I shrink the database log
file to 20GB?

We would like to make a daily backup of production database (finprod) + MSDB
+ Master DB that keeps 3 days.  On the other hand, we would like to make a
weekly backup of all system databases and testing database - fintest that
keeps 2 weeks.

Good afternoon!
Okay, feel a bit stupid on this....
In SQL2000 I can create very basic Maintenance Plans all day long and they
work perfectly.  Example:  Back up DatabaseX at this time to this location

What's the latest word on the release of MSSQL 2008?
Did I miss it?
--
Ror

Got a nasty error - never saw it before - running a very simple query.
This query first worked on a SQL 2005 dev server in my office - then worked
on my laptop (sqlexpress) but failed on a new customers fresh install of sql
2005.

Our client has recently migrated their SQL Server 2000 database to run under
SQL Server 2005 but in SQL Server 2000 in compatibility mode. My question is,
is there a performance overhead with doing this, or should there be no
difference in performance.

Consider that you create a new database and then perform a differential
backup. You will get this error message.
"Cannot perform a differential backup for database "Test", because a current
database backup does not exist. Perform a full database backup by reissuing

We're using a backup with sql server agent when doing a backup / restore
procedure. In some cases I get the following error when the restore job
fails:
Executed as user: DOMAIN\Administrator. Exclusive access could not be

what is the equivalent of this query in sqlserver ?
FROM ORACLE :
update emp set name ='jak' where rownum < 2;
THANK YOU.