You know, it could have been stored on punch cards, or even paper tape! 😛

Yes, I am quite familiar with these technologies.

Which is what I ended up doing. Wanted to do it beginning of February, but the wife didn't get me everything until the end of February, which by...

Robert.Smith-1001156 (4/14/2010)

---

I agree, education is great. Now I think we've beaten that particular topic to death, Steve. Can we talk about something else?

What about the need to take...

What recovery model is the database using?

Well Lutz, you beat me to it, by that much ''.

You are looking to do something like this:

create table #TestTab (

ID int,

SurveyDate datetime,

FY int);

insert into #TestTab

select 100, '20090825',...

I'll have to check this one out at home.

That's what makes forums like this so...

I actually still have some sitting around the house. Don't know why, but I do.

refund

Good article. I'll need to reread it in more depth when I have a bit more time.

I know it has been covered, but I want to reinforce some of what has been said.

Invest in yourself. For Microsoft SQL Server, purchase the Developers Edition, it is...

If the new location (MOVE clauses in the RESTORE DATABASE) are fixed, you really don't need dynamic sql to accomplish the RESTORE. Check out the following code:

DECLARE @DBBackupFile as...

Not sure. Don't have SQL Server 2005 where I can test it. ...

SQL Server 2005 will not be able to read the log backups from SQL Server 2008. I think your alternative is to upgrade the log shipping destination first, then...