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...

I'm looking forward to Simon's post and a recursive reference as well

If you haven't checked out his blog (we link it in Database...