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