SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Unable to open the physical file trying to attach AdvntrWrks2008 DB

  Hello SQL server colleagues, I'm trying to attach the Adventureworks2008 DB to my local instance an…

  jb_sql_geek

  9 replies

  14 years ago

  By: jb_sql_geek

• Weird SQl server reboots, what to look for?

  Hello all I have a mid size server with sql server 2008 R2, 42 gb of ram, an several midsize to lar…

  ricardo_chicas

  4 replies

  14 years ago

  By: ricardo_chicas

• Cannot rename the table because it is published for replication.

  Hello, I removed a table from Replication but the table setting is still set as flagged for replica…

  DanielP

  4 replies

  14 years ago

  By: DanielP

• help with date query

  i have a table which has a date in called "Date", the dataType is set to date in this table i have …

  Michael.bishop 92660

  2 replies

  14 years ago

  By: JeffRush

• Convert From Zone times in SQL Server 2008 R2

  Hello, I am trying to convert time between zones. i.e., when a transaction takes place in China...I…

  gsd1

  3 replies

  14 years ago

  By: Lowell

• restore failed

  Hello I have to automate backup-restore from production environment to Day behind server. I schedu…

  surma.sql

  4 replies

  14 years ago

  By: rraja

• need to shrink Log File

  Hi I need to shrink the log file due to space problem. but my concern is, is it ok to shink log fil…

  yogi123

  1 replies

  14 years ago

  By: Perry Whittle

• case statement in where clause

  Hello, I need to show products whose Status is NA and OnHand is greater than 0. But when I use belo…

  Shree-903371

  4 replies

  14 years ago

  By: Shree-903371

• WildCard Alternatives.

  Hi, I'm aware that using a wildcard on both sides of a search criteria will stop the index being us…

  brk5tr

  4 replies

  14 years ago

  By: Eugene Elutin

• why getting error :Arithmetic overflow error converting numeric to data type numeric.

  SELECT TradeId, Trade_SecurityId, SecurityType.*, Trade_ParAmount Quantity INTO #S…

  ashuthinks

  3 replies

  14 years ago

  By: Sean Lange

• Problem in Replication

  Hi Friends, I am trying to do a snap shot replication over cross servers....mine is 192.168.14.200 …

  Charmer

  4 replies

  14 years ago

  By: Charmer

• tlog backup way bigger than .ldf, not bulk-logged...

  I have a database with a 6GB transaction log, which at the time I attempted a tlog backup, was abou…

  NJ-DBA

  10 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Restore DB using Powershell

  I'm evaluating powershell for my use to restore SQL db. Backup is from SQL Server 2008R2 db and is …

  khushbu

  5 replies

  14 years ago

  By: Johan Bijnens

• Count Data in Large Seprated Text

  How to count part of data in a field contains large Separated text like that i have that table st…

  ahmedhussein787

  24 replies

  14 years ago

  By: ahmedhussein787

• Insert statement fails via Server link with DB2

  We have a server link through which we are inserting data, that fails with the following error: OLE…

  dragonfly

  2 replies

  14 years ago

  By: dragonfly