You could also set up one database as the "Master" and then use Snapshot replication to replicate the procedures and functions. Another way is to create a DTS Package that...

I first noticed that happen in SQL 7. I have been using the SQL-92 syntax JOIN syntax ever since. Once you get used to writing your queries this way you...

Good point Greg. I totally missed the 6.5 compatibility. I'm so used to working with a SQL 2K database I never even looked at that.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr....

My guess is that your table has null values as Madhu indicated and you either need to update the null values to a specific value or drop off the NOT...

I think if you break this down as a select statement you will see why it does this. try running the following:

Select fname

  ...

Well let's see. If all you are doing is selecting data in your XML files and the files are fairly small then XML might be faster. As soon as you...

I agree with Nick, this is too general of a topic to cover here. But here is the way I would tackle this.

1: Map your database fields to the...

You might try the following... Since I don't have a schema to try it on it may fail. But it should give you the idea.

SELECT

...

I do this all the time. As kleb_writes said you want to check for errors after ANYTHING that might cause an error. As a note you also want to check...

I've used the stage table technique for a long time to weed out dupes. It is by far the easiest way to go. Plus you can archive the stage table...

In addition to the above you will want to script out the users/logins and move them manually first. Then once the database has been restored I would double check to...

You might be able to get around this if you use TOP 100 PERCENT on your subquery that you want to order by.

 

use...

quote:

---

I like to put the drop in myself. Sometimes to debug a procedure, I copy it into QA and comment out...

I usually basically do what Crispin does in his example. I feel this is much easier to read and I already have the function to split the string 🙂

Gary Johnson

Microsoft...

I always put a drop statement right before the creation with a check to see if the table exists. Most users won't run into the problem of having the table...