I backed up two DBs on Server1.  Created two new DBs (same name) on Server2.
Restored (overwrite) over the two new databases on Server2 with the .BAK
files I created on Server1.
This is the way I always move DBs and I have never had any problems before.

Any of you who has heard about stream database management systems,
knows if sql server is capable of act as such a system? i have heard
that mysql is.What about Sql server?
Thanks a lot,

Is it necessary for performance reasons to have the ldf file of the
Reporting Services databases (including the ldf file of the Reporting
Services temp database) to a separate drive away from the same drive of the
mdf databases?

Dear MS Forum Members:
Unable to create a database connection, the server installation does not
support managed objects.
Error message reads: "The SQL server specified by these connection

Hello every body, i have a problem with my procedure, i cant find out
why.
can you please help me?
i think the problem is in "select top 1 date_actioned into

Is there a general purpose *on the fly* function (or other) that does
'printf' (as in raiserror) type string construction?
I have been unable to find any.
Thanks

I'm having difficulty understanding how exceptions/errors are
propagated up the SP call stack. Does SQL server have such a thing as
exception bubbling up ?
My usage scenario is this. I have got many SPs (including SPs calling

I found a stored procedure (spGrantExectoAllStoredProc) by Edgewood
solutions that allows you to pass in the user name and it would grant
exec permissions to all stored procedures for that user on the
database where spGrantExectoAllStoredProc is created.  This is pretty

I have a DLL which I registered in my SQL 2000 server and created a user
defined function to call it.  The DLL registration using Regasm.exe generated
a TLB file in the same folder as the DLL.
Later I upgraded the DLL with more features and tried to reinstall the new

We would like to make a copy of table in a SQL Server 2005 database (We will
make a change of it).
Is it the only way to do so is by running a SELECT * INTO New_Table FROM
Existing_Table ?

MS SQL Server 2005 Express / Management Studio Express
Pls help me with the 2, possibly simple, problems.
************
I've got the following table in a test sql script. Complains that

According to a developer, the SQL 2005 Express installation on one of my
servers is faulty and is producing duplicate records when only selecting a
single record.
Eg, the develop selects a single record (using a unique ID) into a record

The request is to modify the view to limit access to all but this one table
it exists in.. (the idea is to use the view as a security filter)
and would it be possible to write the code in the view that will create a
separate field for the date proper and the time, so there are 2 ...

This has happened once on two of our Sql 2005 servers.
The machines were not processing the similar quieries where the error
occurred.
Both are running Service Pack 2, Cumultive Update Package 7

Hi all. Newbie question here.
How do I create a log backup every two hours to disk and keep two days worth
of logs?
When I do this through the GUI SQL 2005 i don't have that option. But when I