SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Data Migration Assistant errors - dacpac and openquery failures

  Hi all, I am attempting to use DMA to assess an upgrade from 2008 R2 to Asure SQL on VM. Our databa…

  yonny24

  9 replies

  2 days, 15 hours ago

  By: yonny24

• install problem Missing >> Select a configuration task panel

  I have both MS SQL 2008 R2 and MS SQL 2014 (both developer editions) Both are missing the ability t…

  Digs

  3 replies

  3 days, 10 hours ago

  By: Sue_H

• Permission denied on the object sp_send_dbmail (but, not what you think)

  OK, so I'm trying to send an e-mail from within a job, using sp_send_dbmail. The job is pretty simp…

  sickpup

  11 replies

  4 days, 13 hours ago

  By: T Childers

• Removing a Key Lookup

  Hi I'd like to remove a key lookup against a large table and replace it with a join to a narrow ind…

  alex.palmer

  13 replies

  1 week, 2 days ago

  By: ScottPletcher

• Server drop connection error

  Error: 17886, Severity: 20, State: 1. The server will drop the connection, because the client dr…

  santhosh411

  14 replies

  1 week, 2 days ago

  By: gana79950

• About sp_prepare ?sp_execute and sp_unprepare of SQL Server The records o

  The records of the picture is from a SQL trace record(it was saved by the trace file, generated in …

  892717952

  2 replies

  1 week, 4 days ago

  By: 892717952

• About the Extended Event in SQL Server 2008 R2

  The source code below is a part of source code to create an extended event in SQL Server 2008 R2,no…

  892717952

  3 replies

  1 week, 6 days ago

  By: 892717952

• Need to group multiple lines into one line

  so I really struggle with grouping.  I have a view and it takes a few accounts and basically uses …

  randyetheridge

  21 replies

  1 week, 6 days ago

  By: randyetheridge

• Go from SQL 2008 R2 standard edition to Developer?

  Is it possible to 'downgrade' SQL 2008 R2 from standard edition to Developer edition? I'm working o…

  Brian Kukowski

  21 replies

  2 weeks, 1 day ago

  By: Daniel Serrano-488745

• SQL Server Agent Job - Decision Extract Question and Purpose

  Hello Support Forum, I've inherited a 2008 R2 server and after scrubbing through the maintenance Pl…

  cgrant0070

  4 replies

  2 weeks, 6 days ago

  By: cgrant0070

• Need to export SQL Query to .XLS ?

  SQLCMD -S.\dinerware -d BWG -i "C:\DWBACKUP\HouseAccount.sql" -o "C:\DWBACKUP\HouseAccount.xls" Thi…

  chef423

  5 replies

  3 weeks, 3 days ago

  By: ING_CHOY

• Licence type for 2008R2 CAL or CORE

  Hi How do I tell if I have a CAL or CORE licence for  Sql Server 2008 R2 Enterprise Edition? I've …

  SQL Bandit

  2 replies

  3 weeks, 3 days ago

  By: SQL Bandit

• Execute statement from profiler

  Hi I'm troubleshooting with profiler on a SQL 2008 box. When I capture the execution of one of the …

  alex.palmer

  1 replies

  3 weeks, 4 days ago

  By: Erland Sommarskog

• Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

  We are using SQl server 2008 R2 , we have such requirement so one of our table have 500 column . …

  g_theone

  16 replies

  3 weeks, 4 days ago

  By: Jeff Moden

• LOB pointers - am I stupid?

  This may be a stupid question but all the research I do states SLOB's (Row Overflow) have a 24-byte…

  sqlg67

  6 replies

  3 weeks, 4 days ago

  By: Jeff Moden