Hi Gail,

If TRUNCATE statement breaks the Log Chain, then please could you confirm whether BACKUP LOG with NO_LOG | TRUNCATE_ONLY options are similar to DBCC SHRINKFILE (‘file_name’,TRUNCATEONLY)?

I believe DBCC SHRINKFILE...

Tara,

To get your result a GROUP BY clause has to be used.

When a GROUP BY clause is used, the required columns have to present in either with the AGGREGATE functions...

Easy but brushing up the knowledge

Thanks

Thanks George.

A question from my side is that if SP3 CU1 has SP2 CU10 and CU11, then how can we add the SP2 CU12 to CU17 after the SP3 installation....

Hi,

I believe, we can also take the date info with the help of MS DOS commands through xp_cmdshell and take it for the calculation of backup file retention and...

Create an SP which uses the xp_cmdshell and use the del command along with it.

Call the SP through a SQL agent job. Schedule the job for daily run.

Also, When you upgrade instances of SQL Server 2005 in a merge replication topology or in a transactional replication topology with updating Subscribers, you must upgrade the instances in the...

Hi,

Your build is 9.0.3353 - Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2.

You can upgrade the MSSQL Database engine to SP3 directly. In fact, a service...

The NO_TRUNCATE option is also giving an error.

Example:

BACKUP LOG AdventureWorks

TO DISK ='C:\Program Files\Microsoft SQL Server\SQLWorks\Backup\adv3.bak'

WITH NO_TRUNCATE

RESULT:

Msg 942, Level 14, State 3, Line 1

Database 'AdventureWorks' cannot be opened because it is...

Hi all,

This is an extrapolated question from the actual QoD, but I would like to know the reason (coz of knowledge gaining reason)

Why the 'mmm' part in the RESULT section...

When I insert the datatime row into a table as below, I get different result. Any idea?

use tempdb

go

create table test1 (dat datetime)

go

insert into test1 values('1753-01-01')

select * from test1

RESULT:

1753-01-01 00:00:00.000

insert into...

I have been granted the rights.

But I'm stuck in an INFINITE LOOP now.

After getting the rights, I went to past using TIMEWARP (to try the TIMEWARP in the past...

Used my friend's system. It contains Enterprise, so made a DAC to my Xpress (with my secret DBCC), then tried the DBCC TIMEWARP.

It turned out, SSC is not equiped with...

I'm using Xpress edition, it doesnt have this ability.:cool:

The result 1 is obtained only when the table is in the default schema (dbo).

When the table is queried by specifying the schema name like (SELECT COUNT(*) FROM schema_name.table_name),...