You've got quotes inside your name brackets:

['Temp..']

Does it all need to be done in a single maintenance window?

If not, consider breaking it up into multiple maintenance windows.

Nick M. (3/13/2008)

---

I can think of one real world reason.

Note: this is a simplified example but it covers the point.

...

So ideas on how avoid cursors (or a while loop which...

Just to clarify: Yes, you can use "S" as a table name.

The sysobjects table returns a list of every object in the database. One of the columns is Object Type which is "P" for a stored procedure, "V" for a...

In a tree repesentated by the hierarchy id, nodes are shown as /1/, /1/1/, /1/2/, /1/2/3/, etc. In this representation, what would the "2" repesent?

Choose your answer:

Nodes at the...

You have to double them up....

divecon (3/13/2008)

---

Thanks for the feed back but that just won't work for the several thousand line stored procedures I'm dealing with.

My original design for this project was to check the...

N'yuk! N'yuk! N'yuk!

The way that you can do this is to "Nest" your SQL command batches by using [font="Courier New"]EXEC('string')[/font].

This dynamic execution of SQL has its own batch that ends when the...

It is also worth noting that a column list alias can have the same name as any of the source columns. This works because it is an output attribute...

The clauses of SQL have an order of evaluation, specified by the standards as follows:

FROM clause

WHERE clause

GROUP BY clause

HAVING clause

column list (SELECT clause)

This means that...

brekher (3/13/2008)

---

I have a database with almost 1000 tables that are prefixed with tbl_. I need to go through all of them an rename them to exclude that prefix. Any...

Try this:

Select c.Name, g.Name, Count(u.CityId)

From User u

Right outer Join Group g ON (g.ID = U.GroupID

And u.Joindate Between @startdate and @enddate)

Right outer Join City c...

oraculum (3/13/2008)

---

Does anyone know if its possible to script out all tables within a database - then script them as create views within another database? or do i just need...