Thumb drives are another source of irritation. I have three: a 128MB, a 512MB, and a 4GB. The smallest one works fine, but when I plug in either of the...

I always write my script and save it to a disk file, using the following general structure:

DROP PROC dbo.MyProcedure

GO

CREATE PROC dbo.MyProcedure

AS

-- actual code goes here

GO

GRANT EXECUTE ON dbo.MyProcedure TO [MyUserName]

GO

I would definitely not recommend Vista for SQL developers:

My home office PC is a HP 2.8 GHz Pentium 4 with 2 GB RAM, running XP Pro. My biggest customer recently...

Actually, I was invited to "volunteer" for the IT Committee which is considering options for converting from Approach to something else. Like many trade associations, this is a not-for-profit corporation...

Thanks Matt for your comments. I found some VERY old info via Google, the web pages mentioned "the OS/2 version" so I knew this was a dinosaur. Is it true that...

Having zip codes in a separate table is going to be a maintenance nightmare. In areas of high population growth, the USPS is continually splitting zip code areas and creating...

http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php

If this is a one-time import, I would just open SSMS and create a new database, call it Access97 or whatever.

Then right-click on your new database, click Tasks ~ Import...

Hello Zach, glad you're back with us. We kind went off topic for a while here, can you supply a few details, like:

1) Can you convert the files from Access...

Making fun of Access is popular nowadays, but the fact remains that it includes the Jet relational database engine (a version of which is used in Exchange, by the way)...

Here is a full demo. MAKE UP BACKUP OF YOUR FILE before testing this, it WILL delete records if any of your tables have a Yes/No field named Inactive.

Sub LoopingDemo()

   ...

If you want to run an action query (INSERT, UPDATE, or DELETE) then you could use something like this. This example uses a table named tblClient which has a Yes/No...

Dynamic sql is when you build your sql statement as a string, and then execute it, like this in SQL Server:

EXEC ('SELECT * FROM Test2000...' + @tablename)

instead of using...

I get the same error that you get - apparently you cannot link to an Access 97 db using the 4.0 provider that comes with SS 2005.

However, if you could...

I have a college degree from 1972, does that make me "good"?