SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• USER DEFINED DATA TYPES: Used in table creation - What happens if you change just the user defined type to varchar(max) from text?

  Question: Table definition uses user defined types for EVERY field (yeah, I know, but it's legacy…

  sgmunson

  18 replies

  11 years ago

  By: sgmunson

• Am not able to export 10 lakh records to excel sheet.

  Hi all, Am not able to export more than 10 lakh records to excel sheet(2007 xlsx). I'll get suce…

  ravi@sql

  15 replies

  11 years ago

  By: SQLRNNR

• database corrupted

  Hi, Database is corrupted, Do you have any recommendations how to know which object is corrupted ? …

  de2times

  1 replies

  11 years ago

  By: Gail Shaw

• Create login of sysadmin role on server having logon trigger

  Hi, All the logins with sysadmin role are locked out in one of the SQL server. Also in that instanc…

  saum70

  10 replies

  11 years ago

  By: saum70

• Why is CDC returning Insert/Delete when I UPDATE a row in a table?

  This is my second post asking this question. Hopefully someone will respond this time. I am exper…

  gcresse

  7 replies

  11 years ago

  By: Jeff Moden

• SQL statement erroring out due to source field being unidqueidentifier

  I have a field I am trying to bring into a SQL statement ,ISNULL(Convert(nvarchar(50),OPP1.Originat…

  randyetheridge

  10 replies

  11 years ago

  By: Kristen-173977

• ForeignKey points to not the most appropriate index of the referenced table

  Hi all, Lately, I faced the below strange situation in SQL Server 2008R2: The parent table has the …

  acheras

  4 replies

  11 years ago

  By: ScottPletcher

• Compare Data, Loop Through Dates and Insert into Table

  Hi, I have three tables: "PaymentsLog" "DatePeriod" "PaidOrders" As per below SET ANSI_NULLS ON GO…

  SQL_Kills

  3 replies

  11 years ago

  By: SQL_Kills

• Seems like a job for a window function, but...

  I've been banging my head against this for days, and I'm getting nowhere. This seems like an obviou…

  ronmoses@gmail.com

  5 replies

  11 years ago

  By: ronmoses@gmail.com

• Resourse Governor in SQL2008R2

  Can we restrict a buffer pool for a user using resource governor?

  akhi0587

  1 replies

  11 years ago

  By: Steve Jones - SSC Editor

• PIVOT situation-- String Value in Aggregate columns

  Hello Need T-SQL help, If numeric value then I could get is using PIVOT, but string value is there,…

  Joe-420121

  11 replies

  11 years ago

  By: WayneS

• CDC Tracking tables are not in the Backup?

  I have enabled CDC on my productive database with USE MyDB GO EXEC sys.sp_cdc_enable_db GO and I ha…

  Ian_McCann

  8 replies

  11 years ago

  By: Gail Shaw

• SQL Server agent services has stopped

  Hi folks By looking at the configuration tool, I have seen my sql server agent service has stopped?…

  sqlgeeks123

  5 replies

  11 years ago

  By: John Mitchell-245523

• Getting the Formula of a computed column

  I'm trying to write a query that will display the formula for a computed column in SQL Server 2008R…

  gary.mazzone

  8 replies

  11 years ago

  By: ceasor

• Logic to split Monthly numbers

  Hi I am trying to split the annual cost into monthly numbers based on the contract Period. Since th…

  sharonsql2013

  3 replies

  11 years ago

  By: Jeff Moden