Hi,

Tools-->Options-->Query Results-->Default location for saving query results--> <Your path>

Thank you

Oops...Sorry -- I just noticed you are asking about saving query, not the result. It may be a registry change?!!?

Hi,

Try querying sys.master_files table in Master database.

Thank you

Hi,

If it is on the same instance and data inside tables is small, then

select * into "Backup Table Name" from "source table"

But it will copy only the data not the...

Hi,

The changes you mentioned (Creation of Table , Insert Some Value in that table ) will be reflected through log shipping.

Once you recover the database (from restoring mode), the...

Hi,

Yes; And make sure to transfer the logins and map them accordingly on the databases.

Thank you

Hi,

If it is fine, then try detaching the database and attache again, this time note the message that is displayed and post it. That might help finding if the issue...

Hi,

Backup database task does not freeze database; users will not be dropped; They can connect to the database and work.

Thank you

Hi,

It could be anything like table, procedure, function, user, constarint etc., etc., etc., You can query sys.sysobjects table for the objects under the database.

Check the link below:

http://msdn.microsoft.com/en-us/library/ms177596.aspx

Thank...

Hi,

May be you can query sys.sysprocesses table for details like hostname, programname etc.,

Thank you

Duplicate post:

http://www.sqlservercentral.com/Forums/Topic923395-146-1.aspx

Hi,

under the security node, a 'login' is created. It is instance specific. It is to logon to the instance. When a login is given access to a database, a user...

Hi,

I am not sure if we can use CONVERT function in INSERT statement; but you can use CONVERT while retrieving Datetime data in the format you want. Check the link...

Hi,

Script the logins from Master DB; Script the Jobs from MSDB;

Move the databases using either Detach\Attach or Backup\Restore to the new instance

Run the login script on Master

Create the jobs...

Hi,

-->Start SQL service with trace flag -T3608 (which prevents SQL server from automatically starting and recovering any database except Master database).

--> Rebuild MSDB using INSTMSDB.sql from service pack files

Thank you

Hi,

Generally restore from a backup is a good option here, but as you said, the backups do not exist now, may be re-building MSDB might be the next option. But...