SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Transfer large amounts of Data to an mdf

  I have a large Excel database. I can extract it in ASP.net. I have over 150 columns with 100000 row…

  philosophaie

  4 replies

  10 years ago

  By: DesNorton

• Recursive Table - Query Help

  All: I have two tables as defined below (I know this isn't the complete script to create the tables…

  kocheese

  2 replies

  10 years ago

  By: ScottPletcher

• Mail Qued

  Exec msdb.dbo.sp_send_dbmail @profile_name='SQLProfile', @recipients='ramana@yahoo.ccom', @body='Th…

  ramana3327

  4 replies

  10 years ago

  By: Steve Jones - SSC Editor

• SQL Server 2008 reboot on attempted password change

  All- An off the wall problem, I know, but on a healthy SQL 2008 installation when I attempt to chan…

  alan.j.raczek.ctr

  2 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Server TCP provider has stopped listening on port [ 1433 ] due to a failure. Error: 0x2747, state: 2

  Hello SQL experts, We are on SQL2008R2, SP3. Machine has 500GB RAM and 24 vCPUS, attached to a SSD …

  SQLJay

  1 replies

  10 years ago

  By: SQLJay

• How to Find Percentage using a recursive cte

  Hi all, Please i have this cte: declare @Parameter nvarchar(4000) set @Parameter = 'Urbanisation' …

  timotech

  5 replies

  10 years ago

  By: timotech

• Using Column Names as Parameters

  Good day all, Please how can i use this column name dynamically to query a table without writing se…

  timotech

  7 replies

  10 years ago

  By: timotech

• Select records in hierarchical order

  I have an SQL Server table like this: Table: Folders FolderID (int)_____Folder Name (varchar)_____…

  henryvuong1000

  4 replies

  10 years ago

  By: henryvuong1000

• Warning: Null value is eliminated by an aggregate or other SET operation in SSIS package failure

  SQL Job executing the SSIS package failed with this error message: Warning: Null value is eliminate…

  PJ_SQL

  1 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Stored procedure to pull Access data into SQL Server

  Thanks in advance... I am trying to develop a stored procedure to pull Access data into SQL Server.…

  DaveBriCam

  7 replies

  10 years ago

  By: DaveBriCam

• Determine ANSI_PADDING status in TSQL

  Hello SQL Gurus. I have a situation where the production databases have ANSI_PADDING on. This is wh…

  Mr. Cursor

  8 replies

  10 years ago

  By: ScottPletcher

• Mondays and Sundays of the month

  I am creating a cycle sql that give me the range of second dates to Sunday of each month, for that …

  jafm

  5 replies

  10 years ago

  By: Luis Cazares

• Could it be Tempdb corrupt ?

  HI All, I came across an issue in production issue “Msg 605, Level 21, State 3, Line 151 Attempt to…

  WhiteLotus

  10 replies

  10 years ago

  By: Gail Shaw

• Subscription streams

  Hi, I am trying to take advantage of multiple streams to fix the replication latency. Previously I…

  Roust_m

  1 replies

  10 years ago

  By: Roust_m

• Issue sending or receiving email from SQL Server

  We have a SQL 2008 EE, SP2 hoss of a server and have never had an issue before with the sending/rec…

  MyDoggieJessie

  13 replies

  10 years ago

  By: Lowell