Thanks John.

I am not able to open Lynn Pettis post..

Yes Michael, that is certainly there. My post gives an idea of forthcoming weekends without having any intimation of dates.

Excellent Article !! covered almost all points for time bomb coding.

You have made a mistake in the parameters of DateAdd function.

Second parameter is the number of minutes you need to add to the date given as the third parameter. So,...

You can dump the results into a temp table using bulk insert like

create table #temp(names varchar(100))

BULK insert #temp from 'c:ames.txt'

select * from #temp

select a.users

from yourtable a inner join #temp...

Update gpcb

Set Sgpa=T2.Sgpa,Cgpa=T3.Cgpa

From GradePointCalculation_Bkup gpcb

INNER JOIN #temparrearTable1 T1 T1.Registerno = gpcb.Registerno

Inner join #temparrearTable2 T2 on T1.Registerno=T2.Registerno

Inner Join #temparrearTable3 T3 on T3.Registerno=T1.REgisterno

If you have more than one object to be copied from one server to another, or if you have some updates on the structure of the objects, you can do...

you can execute sp_who2 to see the processes

I used the same logic of Conditional Split in my package to split the records based on conditions having data and nodata. I have a stored procedure which will either...

You can get all the servers list from "sqlcmd -L" or "isql -L"

you can execute these commands using xp_cmdshell..Take all the servers list into a table and then iterate one...

I have scripted the objects this way to script the triggers for a particular list of tables.

Yes even i am confused on the post. It does not say anywhere in the entire article, what is the main purpose of Copy_only backups. It starts with the growth...

Yes you are right. But we can do one thing change the compatibility level to 90 and then perform the operation and again change the compatibility to 80..

This problem i...

fn_TopOrders returns the top 3 Orderid,Orderdate from the SalesOrder table. As my issue was not more based upon that i have not included the function..!!

yes