not sure what you are using the results for, but with so many values, i'd consider creatign a table with the permutations of the parameters you are filtering for.

maybe something...

etl2016 (5/18/2016)

---

Hi,

Am new to MS environment, coming from a diff programming background.

I am setting up my home computer for a collection of MS development tools. Could you please let...

if you right click on SQL server Agent, and choose properties, what are the values you see here?

for me, with more than 60 jobs, some of them log backups ever...

Sean Lange (5/17/2016)

---

You will become familiar with both the backup and...

In my neck of the woods in South Florida, On Jun 18, 2016 I'll be at the SQLSaturday #524 - South Florida 2016

This event is ridiculously close to my house,...

I've seen this before due to connection pooling where the database context becomes the default database, instead of the one in the connection string;

ie the connection to the database...

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...