SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 'PRIMARY' filegroup is full.

  Could not allocate space for object 'dbo.cmsPropertyData'.'PK_cmsPropertyData' in database 'HPPorta…

  surma.sql

  7 replies

  13 years, 8 months ago

  By: surma.sql

• New Line Character

  Hi, Am using below query to display veh_name, expiration_date, for new line character, here am usin…

  Minnu

  3 replies

  13 years, 8 months ago

  By: 2ndHelping

• how can we create remote disributor?

  I have to create a remote distributor can you please helpme out friends? Thanks in Advance 🙂

  ARUN KUMAR AGUNURU

  1 replies

  13 years, 8 months ago

  By: MysteryJimbo

• Max Recursion issue; Where does the OPTION(MAXRECURSION 250) go?

  basic syntax issue here, and i'm brain dead apparently. I've got a situation where i need to conver…

  Lowell

  5 replies

  13 years, 8 months ago

  By: Lynn Pettis

• Moving a backup file to another location as part of a SQL Job

  Hi all, First post so hopefully this goes OK! I have a SQL Server 2008 instance with 2 150GB databa…

  adam.spittles

  9 replies

  13 years, 8 months ago

  By: adam.spittles

• how many in common?

  Hi I have a table Client_id id value 10 1 1 20 1 1 30 1 1 40 …

  erics44

  6 replies

  13 years, 8 months ago

  By: PiMané

• Migrating 2008 reports to 2012

  Hi Friends, I am new to 2012 and I have been given the task to convert the Reports generated in 200…

  MuraliKrishnan1980

  2 replies

  13 years, 8 months ago

  By: MuraliKrishnan1980

• How To Sort Date When Date Is Formatted

  Hi all, I have a problem. The problem is that I want to sort dates in descending order, but the dat…

  anouars

  1 replies

  13 years, 8 months ago

  By: Ant-Green

• error :Column data type DT_STR is not supported by the PipelineBuffer class.

  I'm moving some data from sql server table to shaepoint list. I'm on sql server 2008 r2 The input c…

  Patrick.I

  3 replies

  13 years, 8 months ago

  By: Ant-Green

• Sum with Multi Category and Group By Acc No ?

  SELECT SUM(AMOUNT) as SumAmount,TransType_ID,Transaction_AccNo FROM Tbl_Transaction Group By TransT…

  chinye2020

  26 replies

  13 years, 8 months ago

  By: chinye2020

• Arithmatic operation in string

  declare @abc nvarchar(50)='500+200-100' select @abc from this I get, 500+200-100 But How to get 6…

  rajishavaravind

  1 replies

  13 years, 8 months ago

  By: Andy Hyslop

• unable to connect using sql authentication

  I have installed sql server 2008 r2 with mixed mode authentication. I am able to use the sa credent…

  Benki Chendu

  5 replies

  13 years, 8 months ago

  By: Benki Chendu

• Create login - domain name with '.'

  Hi I'm trying to create a simple script to allow Network Service accout to access my database DECLA…

  victorel

  2 replies

  13 years, 8 months ago

  By: Kenneth.Fisher

• Why use SNAPSHOT isolation with Change Tracking?

  Microsoft has strongly recommended that we use SNAPSHOT isolation with Change Tracking because of t…

  GuitarGuy

  3 replies

  13 years, 8 months ago

  By: AlBran LVP

• Count number of rown in transaction without adding to a parameter?

  It is possible to get the number of rows affected in a multiple statement transaction without addin…

  Jared

  10 replies

  13 years, 8 months ago

  By: Jared