SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• The multi-part identifier could not be bound.

  I run the following statement but I get the same error message: Msg 4104, Level 16, State 1, Line 4…

  tt-615680

  2 replies

  10 years, 5 months ago

  By: tt-615680

• Assistance in analyzing job history

  I am trying to identify jobs which are long running compared to the baseline, i have created a sql …

  curious_sqldba

  3 replies

  10 years, 5 months ago

  By: sgmunson

• Update, Insert and Delete slowly changing table

  I have a reporting table that needs to be changed on a daily basis. The source data is created on t…

  brickpack

  2 replies

  10 years, 5 months ago

  By: brickpack

• Checking Multiple Fields in a Table

  I have a table that has the race of an individual - the individual can have multiple races checked.…

  Sjey

  5 replies

  10 years, 5 months ago

  By: Luis Cazares

• How to DELETE Thumbs.db File?

  Can anyone help this?

  caojunhe24

  4 replies

  10 years, 5 months ago

  By: Lowell

• Db Mail not seemingly working

  I have check all below - all seems ok, there is nothing in the error file , just that dbmail gets s…

  Adam Sandler

  14 replies

  10 years, 5 months ago

  By: Ant-Green

• collection_set_3_upload jobs keep failing

  I have a job called collection_set_3_upload, with 2 steps: 1. collection_set_3_upload_purge_logs wh…

  Casper101

  16 replies

  10 years, 5 months ago

  By: Kavic62

• Is this ever usefull/or ever going to help/why would someone do this inner join A1 on B1 column identity and then use A1.identity = B1.identity in where clause

  Ok guys, Sorry for the long title but I kind of want to lift my own confusion about this one. I've …

  Resender

  2 replies

  10 years, 5 months ago

  By: Resender

• Permissions on Backup Folder changed at OS level, causing scheduled backups to fail

  We are running SQL Server 2008 (SP3) [10.0.5520.0 (X64)] on a Windows 2008 server. Last night, all …

  MarkThornton

  1 replies

  10 years, 5 months ago

  By: mark.williams 37494

• Publication Properties - (Not Responding)

  Did anyone encounter this before? if yes, what solution? Trying to view the articles on Publication…

  CooLDBA

  1 replies

  10 years, 5 months ago

  By: rcverbeek

• Unable to print the charindex of a special character of its 4th occurrence.

  Hello, I am unable to get the 3rd and 4th occurrence of the "_" using charindex. Can anyone please …

  SQL_Hunt

  8 replies

  10 years, 5 months ago

  By: SQL_Hunt

• How to take the output of the command to a table (specially first two columns) to get logical name and physical name?

  Hello Experts, Please suggest : How to take the output of the command to a table (specially first t…

  SQL_Hunt

  3 replies

  10 years, 5 months ago

  By: SQL_Hunt

• Installing SQL Server using the local setup files

  Hi I just wanted to know the location of the setup.exe file folder so I can install SQL Server from…

  navtec

  1 replies

  10 years, 5 months ago

  By: curious_sqldba

• Ranking functions

  I am tracking comments made on applications using dense rank function. I only want to include the l…

  SQLPain

  1 replies

  10 years, 5 months ago

  By: SQLPain

• restore to a newer version of sql server

  I took a backup of a database on a 2005 version of sql server and copied the backup to a different …

  fizzleme

  3 replies

  10 years, 5 months ago

  By: fizzleme