SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Tempdb stopped SQL Service

  Hi All, I had an incident this morning that I haven't seen before regarding the tempdb. When I got …

  Fox87

  7 replies

  14 years, 5 months ago

  By: chetanr.jain

• what are the difference between Sql Authetication and windowns authetication user..?

  i have create database,maintenance plan and sql jobs in windows authentication user login but now i…

  Coolroof

  1 replies

  14 years, 5 months ago

  By: chetanr.jain

• my dbcc checkdb is getting failed

  Due to high tempdb usage my dbcc checkdb is getting failed as my databsae size is 300 GB. What shou…

  forsqlserver

  11 replies

  14 years, 5 months ago

  By: chetanr.jain

• Developer tools

  Is there a tool out there that can take me to the definition (SQL) of an object by right-clicking i…

  Ray Cacciatore

  8 replies

  14 years, 5 months ago

  By: Devendrakumar

• VB script to delete old backups is NOT working in SQL Server 2008 R2

  Hi, I'm using the below VB script to delete the old backup files via SQLAgent and it's working fine…

  Mani-584606

  2 replies

  14 years, 5 months ago

  By: Steve Jones - SSC Editor

• DATA FILES -AUTOGROWTH

  For my database , i have 9 data files and 1 log file kept across 10 drives (1 file in 1 drive ) 3 …

  aby_dvd

  2 replies

  14 years, 5 months ago

  By: Steve Jones - SSC Editor

• Xml DML - delete error - Cannot implicitly atomize or apply 'fn:data()'

  Hello there, I want to delete some nodes from menu xml that is being stored in a typed xml column i…

  inuts

  5 replies

  14 years, 5 months ago

  By: Mark Cowne

• concatenate row values into single row

  hello, can anyone please show me how to concatenate values from multiple rows to single row ?? for …

  Dyn-o-mite!!

  2 replies

  14 years, 5 months ago

  By: Dyn-o-mite!!

• Remote Access to SQLEXPRESS (not the obvious solution!)

  Dear all, Wondering if someone can help me out here. I took on dev for an app that requires remote …

  integritec

  3 replies

  14 years, 5 months ago

  By: integritec

• select works in sql 2000 but not in 2008

  Hi Guys, I have the following code the works in 2000 but not in 2008 SELECT substring(ltrim(r…

  ricko

  8 replies

  14 years, 5 months ago

  By: ricko

• ssis deployment

  hi i am having ssis project called ie,student in my project i am having 10 package..now i deploy my…

  sql Anand

  2 replies

  14 years, 5 months ago

  By: Suresh B.

• Exit script if fails

  Below is part of a stored proc. If the Bulk insert fails will it run the get sequence. What can y…

  kyle.doouss

  2 replies

  14 years, 5 months ago

  By: kyle.doouss

• High plan count on query without literal values

  SQL 2008 In Activity Monitor's Recent Expensive Queries, this query shows up with a Plan Count valu…

  chris.nilsson

  8 replies

  14 years, 5 months ago

  By: GetheBeber

• Need help please

  Why is my decimal returning 6 in the scale andnot 4 like I need it? USE TSQLFundamentals2008; SELEC…

  mrwillcostello

  4 replies

  14 years, 5 months ago

  By: cashare1234

• Typical Usage of Change Tracking

  Hi, I've learnt on Change Tracking and successfully implemented it on a test environment. What isn'…

  ahmed_b72

  7 replies

  14 years, 5 months ago

  By: Devendrakumar