Add one Bracket-

INSERT INTO Counting VALUES (598, (SELECT COUNT(*) FROM Transfer))

Ohh it is really weird :)....but we should keep in practice to save everytime all the work while using any microsoft product 😛

Extension is only for your refference there is nothing to do with SQL server. The only thing is you need to specify the name with extension (which you have given...

Have you checked by right clicking on each data flow task whether it is enabled or not?

You can create trigger for that-

IF EXISTS (SELECT * FROM sys.server_triggers

WHERE name = 'ddl_trig_database')

DROP TRIGGER ddl_trig_database

ON ALL SERVER;

GO

CREATE TRIGGER ddl_trig_database

ON ALL SERVER

FOR DROP_DATABASE

AS...

You can create trigger for that -

IF EXISTS (SELECT * FROM sys.server_triggers

WHERE name = 'ddl_trig_database')

DROP TRIGGER ddl_trig_database

ON ALL SERVER;

GO

CREATE TRIGGER ddl_trig_database

ON ALL SERVER

FOR DROP_DATABASE...

No they cann't be same as the data stored in a Differential backup includes only the transaction log files up to the current checkpoint and transaction log contains all the...

select left('TransactionLogBackupTest_TransLog_201104051400.TRN',(cast(charindex('_','TransactionLogBackupTest_TransLog_201104051400.TRN') AS INT) -1))

use "CAST AS INT" also before charindex. Sometime if the string return VARCHAR or anyother datatype than INT, than your query will fail.

Does user (sa on 1st server) have public role on master DB on secend server?

Analyze the latency using tracer token. Also check the LAN or WAN staus.

Hi Moorthy,

Yes using DB mirroring with replication is a good option as mirroring supports transaction replication with automatic failover if you do mirroring on publisher database.

Plz go through th BOL...

Comparison between Litespeed Backup and Native Backup Compression

-Michael

Run the powershell as an admin.

You can also do this from ssms. Security--->logins--->choose login--->rightclick--->properties----> Disabled

You can also do this from ssms. Security--->logins--->choose login--->rightclick--->properties----> Disabled