In every module you need to include an error handler. At the top put this:

on error goto Handler

and then near the bottom put this:

exit sub

Handler:

msgbox err.description

resume next

That's a bare bones...

Why are you using Openquery instead of just referencing the server directly?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Are you running with exactly the same parameters each time? If not there is a chance that the compiled plan works well with one set and not the other. In...

In VB you can take a shortcut and use the strconv function, has an option that will proper case everything. If you're doing it manually the basic sequence is to...

We've covered it a little in various threads, dont think we have an article on it so far. Your choices are to use a trigger to capture various changes or...

Try this article, has some sample code:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038

Andy

http://www.sqlservercentral.com/columnists/awarren/

And some good forum threads too. Lots of varying opinions, worth doing some reading first. I think in general we recommend not using prefixes like "tbl", standardizing on either always...

That's exactly right. You only do it on strings, numbers (true numbers that is!) don't have single quotes in them anyway. If you use an ADO recordset to do the...

Cant disable, have to remove the foreign key relationship.

Andy

http://www.sqlservercentral.com/columnists/awarren/

SQL7 requires a little more work. Shouldnt, but it does. Basically you have to generate filler transactions in the log to get it to move to the next virtual log...

RedGate has a product called Data Compare that generates inserts/updates necessary to sync two tables, saves as script. Doesnt support text columns though.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Insert into and select into wont work. One that stretches the definition a little would be to use ADO and the sp_oa procs to grab the result as a stream,...

Been a while since I worked on SQL7. I think it works about the same as 2000. Basically once you get everything into the object, you can call .save or...

Truncate does write to the log, it just logs the page deletes rather than row by row. If you run it inside a transaction and rollback all your data will...

Interesting article Steve. Kashif, I know what you're saying, but it's one of those things that I dont know WHY we have to understand. It's such a mismash of if...