Just the way the language works....

Like this. As I said, look at the rest of the query where it is done properly

BEGIN

select 'alter table '...

Might be worth calling Microsoft's customer support on this

Please read through this - Managing Transaction Logs[/url]

How big's the index? How many pages?

Sherri Barkley (12/1/2009)

---

They have looked at it and said all of the disks are healthy. So we are assuming that the hard shutdown due to the electrical issue in...

Few things. You're going to get a syntax error from that saying that the name column is ambiguous. You need to specify the table and column name in the piece...

This should work on SQL 2000

select 'alter table ' + sysusers.name + '.' + tables.name

+ ' alter column ' + columns.name +

case columns.xtype

...

homebrew01 (12/1/2009)

---

If SQL can't find a particular file or drive for a non-system DB, wouldn't SQL still start ok, but just give an error on that database, showing as "suspect"...

Why would you be doing data type changes very often?

If SQL...

Not unless there's a WAITFOR DELAY 2 hours before the SHUTDOWN. Possible though, evil thing to do. Wouldn't the...

homebrew01 (12/1/2009)

---

I can't find any problems with the drive. If I log onto the server, I can see the E and F drives fine, there don't appear to be any...

Dynamic SQL. No other practical way. Watch out for SQL injection....

Question I have is why a stored procedure? Are you expecting data type changes to happen so often that you...

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic826906-8-1.aspx