Reputation
630
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 21
Impact
~34k people reached

  • 0 posts edited
  • 0 helpful flags
  • 29 votes cast
Jan
14
awarded  Popular Question
Dec
8
comment Microsoft.ACE.OLEDB.12.0 Error when querying Excel
For info installing Office had no affect.
Dec
7
comment Microsoft.ACE.OLEDB.12.0 Error when querying Excel
For info I tried installing the 32bit one but I got an error that the provider couldn't be loaded into 64bit SQL
Dec
7
comment Microsoft.ACE.OLEDB.12.0 Error when querying Excel
I used the 64bit one
Dec
7
asked Microsoft.ACE.OLEDB.12.0 Error when querying Excel
Dec
5
comment xp_delete_file not working
thats the spirit ;)
Dec
4
comment xp_delete_file not working
Amazingly after I copied over the file and rebooted it all started working!
Dec
4
revised xp_delete_file not working
added 256 characters in body
Dec
4
asked xp_delete_file not working
Dec
3
comment Contained DB Collation error
superb thanks very much
Dec
3
accepted Contained DB Collation error
Dec
3
accepted Change port number for SQL 2012 Cluster
Dec
3
comment Change port number for SQL 2012 Cluster
I will have to wait till OOH again before I can try, we have noticed an issue with some of the cluster disks which is clouding the issue. Although I don't see how that would affect the registry of the servers (I might be wrong).
Dec
3
comment Change port number for SQL 2012 Cluster
OK so I only need to run the commands if the resources are offline. However I was noticing that even when I changed the port on the active node with the resource up, when I restarted it reverted back to the old port.
Dec
2
asked Change port number for SQL 2012 Cluster
Dec
2
comment Contained DB Collation error
Unfortunately scripting the ALTER Database statement is only a single command when changing to contained. I will try profiler however.
Dec
2
comment Contained DB Collation error
OK have posted the code
Dec
2
revised Contained DB Collation error
added 5188 characters in body
Dec
2
comment Contained DB Collation error
Hi, the instance default collation is SQL_Latin1_General_CP1_CI_AS and the database default is Latin1_General_CI_AS. As for the object I am searching for that.
Nov
26
comment Contained DB Collation error
Yes, in my case I am just using the GUI to change the database to partially contained and getting the said error. I am at a loss.