SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Database Restore Problem

  Hi Gurus, We've a DR server which is using VM machine, running Windows 2008 R2 (Standard). Had conf…

  Peter2012

  16 replies

  14 years ago

  By: Peter2012

• Remove first character and add trailing zero

  y data in column A look like: -0002 00030 -0004 00050 I need to remove the first character '-' when…

  helal.mobasher 13209

  1 replies

  14 years ago

  By: Mark Eckeard

• Query Help

  I am trying to come up a better way to query this data ;with TempCTE(State,County,City,Action,Time…

  haiao2000

  3 replies

  14 years ago

  By: haiao2000

• truncate a table on a linked server

  Hi I’m trying to truncate a table on a linked server. I’ve given myself all possible permissions on…

  herb 25632

  1 replies

  14 years ago

  By: herb 25632

• Running .bat file in SSIS package

  Hi, From a VB script task in SSIS, I am trying to run a bat file. Here is my piece of code. This wo…

  infodemers

  16 replies

  14 years ago

  By: striker-baba

• SQL 2008 R2 Scheduled Automated Database Restore

  I need to setup a scheduled automated process to restore a database file once a day. In the past I…

  J-Rock

  4 replies

  14 years ago

  By: J-Rock

• Server crash, less than 100MB of disk space

  Yesterday a mail server nearly crashed due to major space issues. It turns out we had less than 100…

  JESDBA

  4 replies

  14 years ago

  By: JESDBA

• SELECT fields with a space in the name

  How do I Select a Field in SQL whose name has spaces? Field: STR89 Type Table (FROM): TRUS Thanks R…

  davdam8

  4 replies

  14 years ago

  By: davdam8

• Internationalization: Handling Lookup Data in Multiple Languages

  I have searched high and low and the best I could find was this SSC post from a while back: http://…

  Treehouse

  1 replies

  14 years ago

  By: GSquared

• End Date Issue

  Hi Professional, I need your help for solving below issue, CREATE TABLE tmp_end_date (ID INT, tgs_r…

  kiran.rajenimbalkar

  7 replies

  14 years ago

  By: kiran.rajenimbalkar

• Script run history

  Morning all Is there any way I can retrieve details about a script that was a run outside of a sche…

  MickyD

  2 replies

  14 years ago

  By: Grant Fritchey

• I had a Question Asked of Me today, that I Never Thought About Before

  A person came up to me today, and asked if SQL 2008 and SQL 2008R2 can reside on the same OS. I ask…

  AndrewSQLDBA

  4 replies

  14 years ago

  By: Grant Fritchey

• Restoring SQL2008 Enterprise Edition db into SQL2008 Standard edition question

  A vendor of ours is going to give us a database that is in SQL2008 Enterprise Edition for us to res…

  Anonymous

  11 replies

  14 years ago

  By: Anonymous

• Output who invoked a SQL Job

  Hi all, Is there a way I could output the username of whoever invoked a SQL job each time it runs? …

  mg_dba

  2 replies

  14 years ago

  By: mg_dba

• Columns not in key look up, why?

  Hey all, We came across a problem today, no solutions yet, here is the scene, we have a query which…

  yasubmj

  7 replies

  14 years ago

  By: yasubmj