Be sure to look at Dense_Rank as well as Rank. They are slightly different, but very similar. Might want to check it out, just in case.

I have to admit, I haven't had a lot of luck with the wizard for moving databases. I usually just back them up and then restore them on the...

Look up the Max() and Sum() aggregate functions. You could use those in sub-queries (or CTEs - those are my preference) and then join to the sub-query/CTE.

You're welcome.

This can be done with a cursor, but I would recommend NOT doing it unless you absolutely have to. Most of the time, shrinking databases is a bad idea.

They...

Jim, Venky and Mike, run the sample from BOL. The second cursor, the one with the column_details data in it, returns a recordset. You can count the rows...

My first thought was that an ID column would mess that up, since it gets ignored by an implicit insert statement, but included in "select *", but I tested it...

That's probably a permissions issue. Make sure the job is running under an account that has the necessary rights. Often, you have to set up a proxy account...

I believe there's a setting in the scripting options for that.

I'm having trouble duplicating the results you have, since the sample data from your first post in this thread gives zero results for either query when I tested it.

That means...

Right-click the database in Management Studio, select Tasks -> Generate Scripts...

It will walk you through a wizard where you pick which objects to script, whether or not to include the...

I figured it out! On the describe_cursor_columns one, you don't get the number of rows in the original cursor, but you can count the number of rows in the...

Piotr Rodak (6/16/2008)

---

Well I agree, one could've used bigger version of SQL server. Yes, I created custom maintenance plan. A few scripts ran by windows scheduler.

The reason I used...

majorbloodnock (6/17/2008)

---

For all those who don't like the chair analogy, perhaps we ought to come up with an alternative.

An SSC member starts putting together a Question of the Day, and,...

Both.