Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 13,460 total)

  • RE: SharePoint crashing SQL all the time

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 16, 2016 at 1:55 pm

    #1879370

  • RE: LDAP-Authentification with SQL-Server

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 16, 2016 at 1:22 pm

    #1879361

  • RE: Are the posted questions getting worse?

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 16, 2016 at 9:23 am

    #1879294

  • RE: create table via Linked server

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

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 16, 2016 at 9:04 am

    #1879286

  • RE: Virtual or Physical

    there's a DMV with that info:

    select s.virtual_machine_type,

    s.virtual_machine_type_desc

    FROM sys.dm_os_sys_info s

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 13, 2016 at 11:16 am

    #1878983

  • RE: new field id

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 13, 2016 at 10:02 am

    #1878965

  • RE: MS SQL Server Management Studio works fine when connected to database via my PC but not when using date commands via remote desktop session

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 13, 2016 at 9:23 am

    #1878943

  • RE: MS SQL Server Management Studio works fine when connected to database via my PC but not when using date commands via remote desktop session

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 13, 2016 at 8:51 am

    #1878925

  • RE: User Security Issue: User does not have required permission

    SSRS is wierd; that UAC error message is misleading.

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 9:20 am

    #1878698

  • RE: Unable to establish a linked server from sql server to mysql

    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?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 8:31 am

    #1878685

  • RE: Trigger that launches a script using xp_cmdshell

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 7:57 am

    #1878666

  • RE: recursive sp_spaceused query

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 7:52 am

    #1878662

  • RE: Trigger that launches a script using xp_cmdshell

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 7:45 am

    #1878648

  • RE: SQL Query With Variables

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 6:03 am

    #1878494

  • RE: Using computed Columns to Create another Computed Column

    Matthew Saggers-700210 (5/12/2016)

    This is a pain as it make the compute code massive in my case so I made them UDF like below

    A

    B

    C = A+B

    D = SumABX(A,B)

    Function SumABX(A,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2016 at 5:57 am

    #1878493

Viewing 15 posts - 1,021 through 1,035 (of 13,460 total)