And what if the query is run on any other day than saturday?

What if i run it on 12/22 or 12/25? What should the date ranges be for each...

Yes, there are Tech Centers that specialize in MS Courseware throughout the US.

what is the default database for the user?

Also, what db roles have you added for the user/group?

Thanks for the feedback. That was the next suggestion.

So, you have no method or test cases or values for which you could use to test these procs?

Having valid test data to go with these procs would also help...

You're welcome.

Touching on something that Gus mentioned.

When the procs are moved into the database, there is better control on performance of the proc by the DBA. When the code is...

atwite (12/18/2009)

---

Hi Nabha and Jeff,

How would you change the query to find duplicates if the entries were numbers? I have been tasked with creating a query that will...

Lowell (12/18/2009)

---

still fairly easy: you jsut add the dependancies and the columns to teh same query:

SELECT

CASE

WHEN object_name(tr.parent_id) IS NULL Then 'Database'

...

If the new file is in a separate filegroup, you move the data by moving the clustered index to the new filegroup.

Otherwise, it is as Homebrew said for if it...

Is the child stored procedure able to execute independently of the parent proc?

Has the process ever worked?

This script is a nice starter script. What I see from the script is that it lists all of the foreign keys. After that, you are required to...

More information would be needed to best answer the question. As it is, we are only guessing at how best to help/answer your question.

Pricing is where I am coming from. In pricing the two, I have noticed the price gap close to about $100. For that $100 I can get 4GB...

Greg Edwards-268690 (12/18/2009)

---

x64 bit W2008 R2

x64 bit SQL 2008 R2

Box has the new 48 core Intel chip, single socket

Living on the edge....

Did Alvin change his avatar, or is Steve still...