Double-click on the report in the Solution Explorer to open it. Click on one of the report objects in the Design tab, go to View - Report Data; the...

Does the following query show it's being backed up?

select bs.database_name, bs.backup_start_date, bs.description, bmf.physical_device_name

from msdb.dbo.backupset bs

join msdb.dbo.backupmediafamily bmf

on ...

One way to see the deadlocks in action is to run profiler against the database with the Deadlock graph, Lock:Deadlock Chain and Lock:Deadlock events selected. SQL Server will roll...

Might be easier to use Powershell. Create a database with a table containing all the database instance names that you want to connect to, use Powershell to...

If it's a huge database then the advantage may be that you save time as you just need to copy the data and log files rather than backing up, copying...

I had a similar issue on SQL 2008 R2 just recently when we lost the tempdb disk (well, actually, the drive letter changed). In our config we have 8...

In example 1, The principle server goes down and you have no witness so the mirrored databases remain in a restoring state. They can be put online if you...

Can you show us the query you are running - is it using openquery?

Are you saying that you have SQL server database instances on a cluster and a particular application that uses them only works when it's database instance is running on one...

You could generate the detach statements via a query such as the following:

select 'EXEC sp_detach_db ' + '''' + name + ''''

from sys.databases

where name like '%dbname%'

The sp_attach_db statements (or create...

Is the report set up to connect to the database with the credentials of the user that is running the report? Looks like it's a 'double-hop' issue where the...

There are a number of ways of doing this sort of thing. An example is below

[font="Courier New"]

declare @string varchar(11)

set @string='reg0000000'

declare @input varchar(7)

set @input='123'

declare @output varchar(11)

set @output=left(@string,len(@string)-len(@input))+@input

print @output

[/font]

This performs string...

If I understand the question correctly, you want to group on a column that has been defined with a case statement.

So you can do the following to add a group...

The accounts used for the SQL services should only be changed via the SQL Configuration Manager. While changing them via the Windows services may work, it is not recommended...

Sounds like you have Analysis Services at 2008 RTM (1600) and SQL Server at SP1 (2531).

You can bring them in line by running the Service Pack 1 installation...