SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Qurery to know tha no of instances

  How to know No. of instances in my sever using Query

  SQLCracker

  1 replies

  13 years ago

  By: Sean Lange

• Error="8952" Severity="16" State="1 what is error number 8952 stands and solution?

  What is the error number 8952 and remedy to fix the same. <DbccResults> <Dbcc ID="0" Error…

  SQLBegin

  2 replies

  13 years ago

  By: SQLBegin

• Add x amount off days and don't count Weekends

  Good Day I am struggling to figure this one out. I have a column with Startdate, I want to add x am…

  ruanp

  1 replies

  13 years ago

  By: ChrisM@Work

• Urgent help!

  Hi I ran a xp_cmdshell 'copy con.....' command on my live server to create a file. It didn't work f…

  S_Kumar_S

  8 replies

  13 years ago

  By: e4d4

• DATA consitency errors

  I dont have the backup when we ran the dbcc check db got the data consistency errors , how can we …

  ramyours2003

  2 replies

  13 years ago

  By: Gail Shaw

• Invalid colum Name

  Hi, I am following query in any database, the table is exists, but the column my be exists in some …

  tonyarp05 61903

  4 replies

  13 years ago

  By: ChrisM@Work

• Different in count of records.

  Hi All, when i am trying to find the count of records, i am getting two different counts. example: …

  Kumara1011

  4 replies

  13 years ago

  By: ChrisM@Work

• jobs execution monitoring

  Hi I wonder if there is an article about monitoring jobs, something similar to backups recent arti…

  federico.hauske

  2 replies

  13 years ago

  By: writearjun53

• Very interested to know what can be done in the case of a long running select query

  Hi everyone. I'd love to get some help understanding why SQL Server 2008R2 x64 Enterprise Edition d…

  PHXHoward

  9 replies

  13 years ago

  By: TheSQLGuru

• Having real trouble...although it's probably easy!

  I asked for some ideas about this last week, but nothing quite suited my situation, which is kinda …

  brian.battles

  7 replies

  13 years ago

  By: Sean Lange

• A backup is made on SQL Server 2005, can it be restored to SQL Server 2008 R2 engine?

  Quick question experts! A backup is made on SQL Server 2005, can it be restored to SQL Server 2008 …

  haiao2000

  5 replies

  13 years ago

  By: haiao2000

• Make a select from three columns (with case expression)

  HI, I have a table (named empresa) which has several fields. Three of the fields are: perc_cs_publi…

  river1

  3 replies

  13 years ago

  By: river1

• T-SQL HELP NEEDED

  Create table Mytemp (Id int , value nvarchar(100), name varchar(50)) insert into [rbamouser\parAPat…

  greeshatu

  22 replies

  13 years ago

  By: Jeff Moden

• disk usage by top tables

  script to find disk usage by the top tables on a database in sql 2005\2008

  ramyours2003

  4 replies

  13 years ago

  By: george sibbald

• Communication Link Failures

  Hello, I am receiving Communication link failures in SQL which are causing my backups to fail. This…

  kylemkr85

  1 replies

  13 years ago

  By: dbafromthecold@gmail.com