interesting issue datsun; here's how i would do it.

the detection for me would simply be to query sys.server_principals:

select 'EXEC sp_defaultlanguage @loginame=''' + name + ''',@language=''us_english''',*

from sys.server_principals

where type_desc in('SQL_LOGIN','WINDOWS_LOGIN','WINDOWS_GROUP')...

yeah i'm having trouble with the definition of Crashing Sql server;

I'd expect a web page not load with an error, or time out, but saying "crashing Sql Server" means what...

wittke (5/16/2016)

---

I have different Applications using VB 6.0, VB.NET and Compact Framework 3.5. Now my client demands LDAP-Authentification (Active Directory) for all of it.

All Applications using the SQL-2014-Server and I...

Complete non-sequitur here guys, but I'm rather pleased with myself.

I just got my MCSA after taking 70-463 Implementing a Data Warehouse in SQL Server 2012/2014.

I had set a mental goal...

newbieuser (5/16/2016)

---

Hi friends,

We would need to create tables in Oracle via Linked Server in SQL Server.. I tried select * into from table, I get the below error..

...

there's a DMV with that info:

select s.virtual_machine_type,

s.virtual_machine_type_desc

FROM sys.dm_os_sys_info s

a row_number() in a view might be a solution, since he wants a repeating value.

i think i would just a dd a calculated column that does the checksum; that would...

it's not the server, it's your individual connection that is the issue.

something related to Remote desktop must be setting your regional settings, which in turn affects your specific session setting

run...

first you are being a bad boy, changing dates to strings and back to dates.

if you simply select your code, instead of assigning it, you will see you are...

SSRS is wierd; that UAC error message is misleading.

there are TWO places you have to add the same group or user:

it should be

select * from [linkytomysql]...[mytable];

you cannot specify database or schema.

can you connect to your local mysql , using the exact same credentials, via mysqladmin?

yes, it would explain it.

Lowell (5/11/2016)

---

calling xp_cmdshell requires sysadmin privileges, and normal end users don't have that. the trigger will fail for normal users

the service account SQL runs on will...

Tava here is what i created, based on a post her eon SCC that i found;

I've enhanced it over time, but i just put this in master and run it...

alexferreira (5/12/2016)

---

I can safely assume only one row is inserted because the application that does the update or insert can only modify one record at a time luckily. I launched...

{edit}

whoops no you cannot, because that is a correlated subquery...it's returning more than one value, joining the inner data and the outer data .

i would move the query to a...