pragyan.banerjee (3/29/2012)

---

Hello All,

I have all the credentials handy but still I couldn't connect to a database from enterprise manager,

its giving the reason :"Sql server not exist or access denied".

My question...

i'm already leaning towards a not null constraint violation; every column in the table is defined as not null, so if the entity framework creates a command with a null...

how about adding another server side trace that captures all errors and warnings , and limit it to just the database in question.

http://support.microsoft.com/kb/199037

then you might see that some basic error,...

ok two questiosn for you:

you are getting TOP 10 from each database with no ORDER BY...were you trying to get slow running queries? ie the ones with a long elapsed...

another issue to consider: is there a trigger on the table in quesiton? if the trigger fails, the insert fails, and the data "disappears" like you seem to be identifying.

could...

it's a scripting option:

if you go to tools options in SSMS, one of the selections available is "Include collation"

change it, you might have to reirun in a new window, and...

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt

if the database you are executing the query from is not compatibility 9 or above, i think that will fail.

ugh, i hate it when people start adding permissions to public.

this script will generate the REVOKE commands for any permissions granted to PUBLIC to specific objects ;

from there you can...

ok i see that; case sensitive collations, and accent insensitive colaltions will see Ä as matching both 'a' and 'A' for example.

i fiddled with it a little, not much...

clearly you've modified what i posted in order to get the results you are showing. show us the code YOU created.

we can find the issues there.

the CREATE LOGIN process already does that.

for example if you try this command:

CREATE LOGIN [fakedomain\fakeuser] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

you get this error:

Msg 15401, Level 16, State 1, Line 1

Windows NT...

did you try my exmaple? it worked perfectly for me:

/*

DescriptionFoundChar

Nº20º

*/

WITH TBProduct (Description)

AS

(

SELECT 'Nº20' UNION ALL

SELECT 'No Special Characters'

)

SELECT Description,

...

Anders Pedersen (3/28/2012)

---

Performance however becomes, uhm, bad,...

not sure what you mean...do you want to test if mydomain\sureshrajan has a login or has access to a...

here's one way to do it;

the typical chars you are looking for are highascii between 160 and 255;

here i'm just using a row_number() function generate a table of numbers so...