Viewing 15 posts - 1,216 through 1,230 (of 3,738 total)
Corrupt file, issue resolved.
August 18, 2012 at 12:13 pm
This is the response that I got:
You have two choices, a USB drive direct attached or a nas network attached drive. I don't have any other options. Sorry.
I do...
August 16, 2012 at 5:59 pm
Lynn Pettis (8/16/2012)
August 16, 2012 at 3:42 pm
Jo Pattyn (8/9/2012)
Install 64-bit first (full administrator) and then...
August 15, 2012 at 11:45 am
GilaMonster (8/13/2012)
As for the original question...
IF EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'Index name here' AND object_id = OBJECT_ID('Table Name Here')DROP INDEX ....
CREATE INDEX ...
Thank you...
August 13, 2012 at 5:02 pm
Lynn Pettis (8/13/2012)
IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')
...
August 13, 2012 at 4:09 pm
Lowell (8/13/2012)
obligatory compatibility nazi post:sysindexes should be replaced with sys.indexes, as it's going to be dropped in some future version.
Good point, thanks.
August 13, 2012 at 4:08 pm
Lynn Pettis (8/13/2012)
August 13, 2012 at 4:07 pm
Lynn Pettis (8/9/2012)
August 9, 2012 at 5:51 pm
It appears that neither of these tools can perform a compassion from one Database vendor to another. Oracle to Oracle, SQL Server to SQL Server, etc.
August 9, 2012 at 5:23 pm
So far I found these two tools.
http://www.sqlaccessories.com/Download.aspx
http://www.dbsolo.com/schema_comparison.html
Does anyone have any recommendations, suggestions, etc?
August 9, 2012 at 5:13 pm
Jo Pattyn (8/9/2012)
Install 64-bit first (full administrator) and then...
August 9, 2012 at 1:45 pm
Jo Pattyn (8/9/2012)
Did you install them in a different base directory? 11g has a deinstall bug
I did install in the same base?
I removed both installs. I had to remove part...
August 9, 2012 at 1:10 pm
Gift Peddie (7/13/2012)
Welsh Corgi (7/10/2012)
prvmine (7/9/2012)
according to Microsoft you do, if you want both to develop and to run SSIS packages on a 64-bit computer:http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx
I understand that you need...
August 9, 2012 at 10:29 am
Viewing 15 posts - 1,216 through 1,230 (of 3,738 total)