SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• IF any of my system database is crashed my sql server will work ah ?

  hi to all IF any of my system database is crashed my sql server will work ah ?

  anilr71

  5 replies

  13 years, 5 months ago

  By: HARIANGEL

• bcp in French characters

  Given example format file: 8.0 85 1 SQLCHAR 0 1 "\"" …

  Sailor

  2 replies

  13 years, 5 months ago

  By: alan_dykes

• Dynamic SQL for OPENQuery used within a CTE

  Is it possible to (I'm thinking No) to dynamically create a SQL SELECT and then use that SQL statem…

  robert.gerald.taylor

  2 replies

  13 years, 5 months ago

  By: GSquared

• Differential backups failing since we started VM

  I had a standard backup plan for a moderately used database, full backup once a week, differential…

  bev.kaufman

  7 replies

  13 years, 5 months ago

  By: Gail Shaw

• permissions issue

  How do I fix this issue?: I'm trying to run the SQL: SET IDENTITY_INSERT dbo.tblTransactions ON I …

  DaveBriCam

  9 replies

  13 years, 5 months ago

  By: DaveBriCam

• Mail queued, not delivered

  Hi Everyone, We have SQL SERVER 2008 R2,that it's Database Mail has stopped working.When I checked …

  Aspet Golestanian Namagerdi

  12 replies

  13 years, 5 months ago

  By: Aspet Golestanian Namagerdi

• Performance issue

  We have got a critical case where their is a performance degrade for many users on an application. …

  Keistad

  7 replies

  13 years, 5 months ago

  By: MyDoggieJessie

• Función Pago (Function Pay)

  Buenos días estimados, Creo este post para consultarse si alguno tiene idea de como puedo trasladar…

  jagger_89

  3 replies

  13 years, 5 months ago

  By: Sean Lange

• Job is failing for unknown reason

  We have a job which executes every 20 sec and it executes an SSIS package. Once in a while it fails…

  SQL Guy 1

  5 replies

  13 years, 5 months ago

  By: SQL Guy 1

• How to find any failed EXECUTE attempt on a particular Stored Procedure

  I need to find any failed EXECUTE attempt in the past two days on a particular Stored Procedure usi…

  SQLisAwe5oMe

  2 replies

  13 years, 5 months ago

  By: Grant Fritchey

• Insert string variable value into integer field

  I need to take the value from one text box txtSupply, assign it to a variable and then insert it in…

  adonetok

  3 replies

  13 years, 5 months ago

  By: Sean Lange

• Access local table joining linked table question

  In Access, if I query sql server and build a local table of something like 30,000 id numbers, then …

  Randy Doub

  3 replies

  13 years, 5 months ago

  By: Banana-823045

• Windows command to append Month name to file

  A rather naive question. anybody know an windows command code to append a file with previous Month …

  balasach82

  1 replies

  13 years, 5 months ago

  By: s_osborne2

• Adding "group by" or even "INTO #tmpTable" completely change Execution Plan (for the worse)

  Hello I have a CTE with several select and a final select that runs in less than a second giving 2 …

  j_wentu

  10 replies

  13 years, 5 months ago

  By: Grant Fritchey

• SSIS and MySQL ADO.net driver security and installation

  Hi All, I have created an SSIS package that grabs data from an external suppliers mySQL database an…

  bugg

  2 replies

  13 years, 5 months ago

  By: bugg