Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
planetoneautomation
Posting Yak Master
105 Posts |
 Posted - 2010-10-08 : 08:20:37
|
| HelloI am getting the message:"Some tables were created with SQL Server Authentication and some with Windows Authentication"... in running a program that upgrades some particular HP software which uses SQL Server 2008 R2. I was not aware the creation of a table in SQL Server had anything to do with how authentication was done. I need to get all the tables to "think" they were created with SQL Server Authentication but I can find nothing in Properties for a table. Maybe I missed it?.Does anyone know:1. How to tell if a table in a database was created using SQL Auth versus Windows Auth2. How to change how a table "thinks" it was created in terms of authenticationWhat I am afraid I'm going to hear is the table will need to be dropped and recreated. I hope not.Any help is appreciated. |
|
|
|
|
|
Table Creation and Authentication Method