Tim that's a really interesting solution. I've love to hear more in an article as I'm sure many would. How much data are you talking about for a full backup?

Dave,...

Thanks everyone for the comments and glad you liked the article. I'm kind of stunned by the response.

My apologies on the counting. I wrote the list and then started to...

I think working in a small town has to be something you want to do, or because you want to go back home where you grew up. Moving somewhere small...

Jennifer's a friend who works for NetApp.

She's probably got a swimsuit, but I don't think she'd do a layout for us

Usually it's filtering if you aren't getting it. Or maybe some rule that snags it since the content changes daily.

They're always here: http://www.sqlservercentral.com/newsletter

DTS is the easiest way to do this. Open a new package, add a connection to SQL Server and one to your access db. specify your view and destination table,...

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

You can add "print" or select statements inside for testing as well.

create procedure mytest

@myvar int, @myvar2

as

select @myvar, @myvar2, 'parameters'

declare @mysum int

select @mysum = @myvar + @myvar2

print @mysum

select @mysum

return

This should return...

What is the ASP page trying to do? You have something that's read-only and if you're trying to update it, you might get an error.

Thanks for the update and not deleting the post.

I'd make each of these a separate procedure just for readability. But I'm not sure it's more than personal preference.

I think you can continue with it. At first glance I don't see any other 2005 features in there.

As I see above, they're bit maps. So if you set the 4th bit, leaving, 1, 2, 3 at zero, you have 1000 in binary, or 8.

Since you're dealing with...

I believe only Database Mail (as mentioned above) works in 64-bit. SQLMail is a leftover from SQL 2000 and only runs on 32-bit.

SQL Server gets time from the OS, which gets it from the hardware clock. An update, like the DST we have in the US, is slightly delayed (a second or...