BACKUP CERTIFICATE MyServerCert TO FILE = 'C:\Projects\Certificate\MyServerCert.dat'

WITH PRIVATE KEY ( FILE = 'C:\Projects\Certificate\MyServerCertKey.dat', ENCRYPTION BY PASSWORD = '997jkhUbhk$w4ez0876hKHJH5gh');

CREATE CERTIFICATE MyServerCert FROM FILE = 'G:\BackUp\MyServerCert.dat' WITH PRIVATE KEY

( FILE...

create view dbo.v_stat as

select c.name as ColumnName, sc.stats_column_id, s.name as StatName, OBJECT_NAME(sc.object_id) as TblName

from sys.stats_columns sc

inner join sys.columns c on sc.column_id = c.column_id and sc.object_id = c.object_id

inner join...

FILLFACTOR is missing

uncheck Force protocol encryption in cliconfg.exe

Thank you for idea

create function dbo.Calc_Age (@dob datetime) -- date of birth

returns int

as

begin

return ( select datediff (year, @dob,v_date) -

case

when (month(@dob) = month(v_date) and...

I also have similar problem.

Step 1.

Create the file get_users_login.sql

select 'exec sp_change_users_login ' + quotename('Update_One', char(39)) + ',' + quotename(sl.name, char(39)) + ',' + quotename(su.name, char(39)) +...

Why USB? FireWire 800 as IEEE1394b is faster. External SATA as eSATA even faster. We use IEEE1394b and eSATA for backups.