Nope.

You have to take the db down in order to do it.

No, sql does not maintain a counter for a unique index field.

You should be able to change the acntID column to be an identity column.

But otherwise, there is no way...

Execute this query

select *

from INFORMATION_SCHEMA.TABLE_PRIVILEGES

where table_Name = 'mytable'

Substitute your tablename.

This will show you privileges for users on that table.

I'm not sure why your seeing this behavior.

I have seen where...

This is a generic error a few things could be wrong.

Just check that IP is correct, and server is set to "Mixed Mode" (Right click on server in enterprise manager,...

Click edit post on your post, Then click delete post on bottom right

You specify the collation in the create table statement.

You can also use a colate function in your queries. but it will be much better/easier to do it...

Please do not cross post usually everyone checks all boards.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=225016

tough question since we cannot see where you are in the installation process.

Ips are assigned to

Each node in the cluster.

And the virtual server. Which is where sql server lives.

Attached...

Did anything change serverside?

double click the Group in the security folder within enterprise manager.

The first tab indicates the user/group default database. Does the group have access to the db listed?...

Edit your excess posts and delete em,

Thx

You can also use query analyzer,

Go to Query --> Show Server trace.

Run the query, when its done executing you can see the duration/cpu used/reads and writes in the trace...

Yes you have to do it to all

just cheat

select 'grant select, insert, update, references on ' + table_name + ' to faeLogin'

from information_Schema.tables

where table_Type = 'base table'

  and table_name <>...

I guess just test it.

when I execute a query similar to yours.

With index on column in where clause this still produces an index seek

SELECT StaffID

FROM StaffInfo

WHERE FirstName LIKE 'Dan%'

whereas this query...

What iz your error message?

Do you see anything in the application logs?

There should be no difference. Name resolves to an ip address, you should be able to put the ip address in with no problems.

i'll try to dl toad and see...