Hi,

If I have understood it correctly, accessing SQL 2008 instance from SQL 2005 client?

Yes, you will be able to access. But, you wont be able to access 2005 or 2008...

Hi,

SQL 2000 client returns the message that you must use SQL Server 2005 Management Studio; But, you should be able to open from SQL 2005 client with out any issues.

Opps..My mistake!!! No need to stop any service for detach/attach of user DBs...

Hi...

Its not the Agent service, but the SQL Server service should be stopped. But, there are other things need to be considered, like - informing the business users about the...

Hi,

If you are specifically looking for a query to run to get the job info...I think you can query MSDB. The tables like sysjobs, sysjobactivity, sysjobsteps, sysschedules etc., hold the...

Hi,

Shrinking files might help you here.

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

Hi,

I think you can query SYSPROCESSES table; there is DBID returned and corresponding DB can be found from SYSDATABASES table.

Hi,

Using arguments like (REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD), the CHECKDB errors can be repaired. (Check BOL for more info. as these options need to be used catiously. There may be loss...

Hi,

You may check if there are any blocks being created while these jobs run. See if there are any other jobs (optimization jobs like reindexing; consistency checks) running at the...

Hi,

Check in BOL for all the options and syntax for sp_dboption. Links from MS here:

http://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspx (SQL 2000)

http://technet.microsoft.com/en-us/library/ms187310(SQL.90).aspx (SQL 2005)

Hi,

Is there any specific reason that it should be a batch file. A SQL job can also be created with those T-SQL coomands and can be scheduled to run at...

Hi,

I think it stands for "internet".

This is some info I got from one forum:

--Starting in 1999 with Version 8i, Oracle added the "i" to

the version name to reflect support...

Hi,

You may try querying "sysprocesses" table (Master database) and apply filter on the rquired column.

Hi,

Table "Restorehistory" in MSDB holds this information.

Hi,

Primary Key is a constraint that 'uniquely' identifies a row in a table. Check Books On Line for more information.