Does SQL Server have a command line program that can dump a whole database
into sql insert statements. I would like to reload the whole database on
another computer.

I can't believe this function is not simple.  All I need to do is copy
the entire contents of one database table into another existing
table.  The two tables exist on separate databases.  I am trying to
load the patient list from Database A patients_visits table to

Is there a way to isolate certain parts of a division calculation. I am
trying to get the result of, let's say e.g. 1 / 4 = 0.25; and isolate the 0
from the 25. Similar to Excel's TRUNC and MOD functions...
Thank you!

If I want to monitor for deadlocks with the least amount of performance
impact which is better.  1) Turning on trace flag 1222, or 2) Running a
profiler trace?

When writing .NET Windows applications, I sometimes need a database
system. I don't need that much sophisticated one but they said that MS
Access DB is now outdated, and Microsoft will not provide x64 driver
for Acess DB. So I think I might need to migrate to MS Sql Server

To test whether our application handles the exception correclty when a table
is locked, I want to be able to lock a table on purpose. For isntance: In
the query analyzer being able to run a command that locks a given table, do
my test, and than after some minutes unlock the table ...

I have a maintenance task for half hourly transaction logging, but in
the log file is says:
===================
[11] Database coldfusion-client-variables: Transaction Log Backup...

I'm looking for some scripts / a program to do standardized performance tests
on SQL Server. I thinking of TPC-C or similar. I'm going to use it to test
different hardware and virtualization configurations.
Ola Hallengren

I have a computer at a remote location that is running an application that
uses a sql database.  my goal is to view the database on my server with as
little work needed as possible.  ideally, i would be able to just open the
application on my end and have the database present ...

I want to calculate the number of days between today and another date and the
'another' date depends on if the record matches a given value in the SQL 2000
view rather than in the Access ADP so that I can sort on the value in the ADP
report.

I thought you guys might be interested in this.  As you should know, I look at some SQL Server newsgroups every day.
Last week, some poor soul posted this message in the microsoft.public.sqlserver.server newsgroup:
We had a developer who wrote the following query and left the ...

I've been using Microsoft connect for SQL Suggestions and the response
so far for my three issues is:
   * Call MS support for that problem
   * Defer your request.

Can anyone help
I have a parameter @empID that can be 0 for all employees or an integer
greater than 0 for a specific employee. Can I write a Where clause that
allows the Select query to act on either the specific employee i.e. @empID =

Does anyone know if it is possible to schedule an automatic backup of sql
database through SQL Server Management Studio Express? I have heard there is
no job scheduler included with this management tool however i'm not sure if
it's possible. If it's not possible could you make a ...

The following keys are missing from my SQL 2000 installation.
HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerConfiguration\Version
HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerConfigurationAddIn\Version
HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerInventory\Version\