T-Replication - ON Demand Schedule, Without SnapShot

Please check the link below,

https://docs.google.com/open?id=0B3yagczqVQKlNjU0Yjg2MTEtMjE2Ny00YWExLTk4ZmYtZmEyZjlhMjI1YTBh

To Find Path Of SQL Log File

declare @dir nvarchar(4000) 


exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'SQLArg1', @dir output, 'no_output' 


if @dir is null 
begin
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup',N'SQLDataRoot', @dir output, 'no_output'
select @dir = @dir + N'\LOG'
end


select @dir


OR

SELECT SERVERPROPERTY('ErrorLogFileName')

To Find Path Of SQL Log File

declare @dir nvarchar(4000) 

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'SQLArg1', @dir output, 'no_output' 

if @dir is null 
begin
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup',N'SQLDataRoot', @dir output, 'no_output'
select @dir = @dir + N'\LOG'
end

select @dir

Sample Databases - SQL Server

Below are the few links to install sample databases on the SQL Server.

http://sqlserversamples.codeplex.com/
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10679
http://www.microsoft.com/download/en/details.aspx?id=23654
http://blog.sqlauthority.com/2008/08/10/sql-server-2008-download-and-install-samples-database-adventureworks-2005-detail-tutorial/

HELP! - PF Details

REGIONAL OFFICE [KARNATAKA (Bangalore)] Bhavishyanidhi Bhavan, No. 13, Raja Ram Mohan Roy Road,
P.B. No. 25146, Bangalore – 560 025 (KN).
General – EPBAX : 22216566, 22216596, 22214901, 22214961
E-mail: rpfcbglr@dataone.in / rpfcbglr@vsnl.net
Designation Phone Fax R.P.F.C 080-22277700 080-22273991 P.R.O 080-22279130        22384722
- SUB REGIONAL OFFICE  [KARNATAKA (Bangalore)]

BOMMASANDRA

2nd Floor, CMC Building, Begur Road, Bommanahally, Hosur Road, Bommasandra, Bangalore – 560 068. E-mail: srobmsbglr@dataone.in

Designation Phone Fax A.P.F.C (OIC) 080-25734492 080-25733817

K.R PURAM

36, “Lakshmi Complex”, NH-4 (Opposite Syndicate Bank), K.R. Puram, Bangalore – 560 036. E-mail: epfokrpbglr@hotmail.com

Designation Phone Fax A.P.F.C (OIC) 080-25611955        25613382
080-25610209 P.R.O 080-25617629 -

PEENYA

Plot No. S(1), 1st Cross, 1st Phase, Peenya Industrial Estate, Bangalore – 560 058. E-mail: rpfcpeenya@dataone.in

Designation Phone Fax R.P.F.C 080-23721377 080-23721377 General 080-23721355         23721355


More on :- http://www.sarkaritel.com/ministries/min_labour/epfo_index.htm

To Check status and other info :- http://www.epfindia.com/

max degree of parallelism

 If the computer has only one processor, the max degree of parallelism value is ignored.

Value	Edition of SQL Server
1	SQL Server Express
2	SQL Server Workgroup
4	SQL Server 2008 Web
4	SQL Server 2008 Standard
32	SQL Server 2008 Enterprise running on x86 operating systems.

Full Text Indexing

All user-created databases in SQL Server 2008 and later versions are always enabled for full-text indexing.


For previous versions we can find using below method,

SELECT DATABASEPROPERTYEX('DBNAME', 'IsFulltextEnabled');

Result :- 

1 = TRUE
0 = FALSE
NULL = Input not valid