Hello people
I am trying to restore DB from a Live company (using SSMS, restore) to Test and following is the error message I get and can't do the restore.
System.data.sqlclient.sqlerror: exclusive access could not be obtained because the database is in use    
Please help  

I have some client code that creates a temp table on sql server, bulk loads
data into that table (using .net SqlBulkCopy class), then calls a stored proc
that operates on the temp table. I'm noticing that when called with a small
amount of data, the bulk of the time spent in the ...

I am running SQL Server 2005 Enterprise x64bit SP2 and am using a stored
procedure to execute a query against two remote SQL 2000 SP4 databases with
imbedded linked server connections that does not return results.  This query
runs in 45 seconds when run on SQL 2000 against SQL ...

Is it possible to get a return value from exec() method(executing
dynamic query)?
Table details
tablename =test

We have about 25 databases on a single SQL 2005 DB server. We now feel
the need to consolidate them all into 5 databases gouped by their
logical classification. All objects from each of the 25 DBs need to go
in one of the 5 DBs such that objects that were together in the

I found a table use partition schema and partition function.  I also found
them in sys.partition_schemes and sys.partition_functions.  But I want to
find the text which creating them, like 'create partition functon......' so
it's more easy to alter them.  I use sp_help and ...

I need quick help and a UDF for comparing last name in the database
table to a last name in the file (one at a time). File can contain
names in any of the following ways.
Joseph Edna (interrested in parsing Edna only)

If this is posted to the wrong group please advise the best place for
it.  We think it is an SQL Server problem but can't be sure.
I develop a program that uses an ODBC connection to provide native
access to an SQL server.  We have found that, depending on the size of

I have a table that has a FK relation from a different table (e.g. this table
has multiple records with the primary key id of the foreign table).
In order to look up things efficiently do I need an index on this column or
is an index implicit because it has an FK?

Can the SQL Server 2008 client tools be used to connect to and query a SQL
Server 2000 database?
Thanks,
Mark

I am able to run 30 DTS w/f only out of 50.
after 30 it comes out.
I have saved DTS vb files & calling in vb.net app.
Is there any settings in .net or sql server

There are two tables.  One is called the Transactions Table and the other one
is called TransactionDetail
In the Transactions Table, the primary key is TransactionID, which is a
unique key.  There is another column called transactionDate.  

I just wonder how fast you guys have upgraded to SQL 2008?
If you are using/developing SQL 2005, will you or how long you will wait to
upgrade to SQL 2008? Or will you just keep working with SQl 2005 until SQL
2010 (if any)?

I'm new to SQL Server 2008 and having trouble with a job that was installed
with SQL called syspolicy_purge_history.  Step 3 uses a powershell command
and is failing.
The powershell command is: (Get-Item

Hi - please could someone point me in the direction of a good tutorial for
joining tables from 2 different databases or list some basic sql to get me
started.....