SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• T-SQL script needed

  Hi All, Please help, I need to generate a script to find the log file when they get filled to 50% …

  SQLisAwe5oMe

  2 replies

  14 years, 1 months ago

  By: SQLisAwe5oMe

• What edition of SQL 2008 should be ordered for small business? (3-5 users)?

  What edition of SQL 2008 should be ordered for small business? (3-5 users)?

  adonetok

  3 replies

  14 years, 1 months ago

  By: Ron McCullough

• SSIS and "connection is not valid" error

  I have a SSIS package that needs to write to a share on a server separate from where the package is…

  DBAgal

  4 replies

  14 years, 1 months ago

  By: DBAgal

• generate xml using sql query

  Hi All, I want to generate an xml from the below tables using sql query(sql 2008) in the following …

  rams.prsk

  2 replies

  14 years, 1 months ago

  By: Sean Lange

• Not able to remove trailing space

  Somehow i am not able to remove trailing space. I did try Replace, substring but no result. Check C…

  EasyBoy

  10 replies

  14 years, 1 months ago

  By: Lynn Pettis

• Get only 100 records in a transaction using LSN

  HI Experts, Am new to CDC has some doubt on this.I have a table and enabled CDC on it.For a single …

  sai198503

  5 replies

  14 years, 1 months ago

  By: Gail Shaw

• Who created a filegroup?

  How do I find out who created a filegroup in SQL 2008, and what is in it?

  Darren McGregor

  1 replies

  14 years, 1 months ago

  By: Gail Shaw

• SSRS and Qlikview

  Hi there, Do you know if it is possible to create a Reporting Services (2008/2008 R2) report using …

  luciano.arias

  2 replies

  14 years, 1 months ago

  By: markodonovan

• Upgrading SQL 2005 to SQL 2008 R2 on VM - Invalid Function Error

  Hello, When trying to Upgrade a virtual server from SQL 2005 to SQL 2008 R2 I keep encountering the…

  ken.miller

  1 replies

  14 years, 1 months ago

  By: EdVassie

• How reliable execuion plan estimates are!!

  Hi I have a proc with 3 sql statements. Executing this proc takes around 5 minutes. The plan shows …

  S_Kumar_S

  14 replies

  14 years, 1 months ago

  By: S_Kumar_S

• Importing data from a Firebird Database into SQL Server 2008

  Hi, I am faced with some work coming up where I will need to on a daily basis extract data from a f…

  shanewiso

  2 replies

  14 years, 1 months ago

  By: Igor Micev

• A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.

  I getting below error We have update trigger on one table and update data from procedure . While ex…

  srikant maurya

  3 replies

  14 years, 1 months ago

  By: Preetham Gowda

• Should I stop the sql server agent?

  I have a transactional replication.Now apps team wants 1 column need to be added in one published t…

  forsqlserver

  6 replies

  14 years, 1 months ago

  By: forsqlserver

• SET BASED UPDATE Statement

  Hi, I am not able to figure out the order of where to set my variables so I can update the IsCurr C…

  jsteinbeck-618119

  8 replies

  14 years, 1 months ago

  By: jsteinbeck-618119

• get MAX for 3 rows

  Hello, I have tbl called policystatus which has 5 columns policynbr, policyid, lastupdated, First N…

  tracmonali

  2 replies

  14 years, 1 months ago

  By: Lynn Pettis