search for: sp_helpindex

Displaying 4 results from an estimated 4 matches for "sp_helpindex".

2006 Jun 26
1
Rake + SQL Server + Migrations == Errors. Help?!
...owing ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex community_news # Could not dump table "community_news_users" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not d...
2006 Jan 19
3
problems with migrations in sql server
...L_LENGTH(''Foo'', COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''Foo''), COLUMN_NAME, ''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''Foo'' 54 SQL:BatchCompleted EXEC sp_helpindex Foo 54 SQL:BatchCompleted IF @@TRANCOUNT > 0 ROLLBACK TRAN 54 And finally the log file contains the following: # Logfile created on Wed Jan 18 23:10:19 Eastern Standard Time 2006 by logger.rb/1.5.2.4 [4;36;1mSQL (0.000000) [0;1mDBI::DatabaseError: Execute OLE error code:80040E14...
2006 Jan 19
0
db_schema_dump for SQL Server
...toCommit is set to true. rake aborted! DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex TABLENAME Thanks for any assistance! - Steve -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060119/1c51bffd/attachment.html
2005 Dec 15
2
Migrations on SQLServer ??
Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org