SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How get Alerts when Database Mirroring Fails

  Hi All, I have configured Database Mirroring. Only Principal server and Mirror Server.With out Witn…

  vamshi.sql

  3 replies

  14 years, 11 months ago

  By: shaun.stuart

• Any concerns where I put transaction logs and tempdb?

  Before you give me the best practices, hear me out: I realize most of the time the goal is to give …

  shifty1981

  9 replies

  14 years, 11 months ago

  By: shifty1981

• Exporting Fixed width files

  Hello, I am trying to export data with over 200 columns to fixed width and output seems to be witho…

  herladygeekedness

  3 replies

  14 years, 11 months ago

  By: GSquared

• Log shipping and execution plans

  Hi, I have a situation where we log audit data to a live database and periodically (twice a day) lo…

  dave.farmer

  4 replies

  14 years, 11 months ago

  By: sturner

• SQL Server 2008 no me permite modifcar una tabla

  Hola a todos, espero que alguien me pueda ayudar, no se escribir en ingles. Tengo una instalacion d…

  weaseludo

  4 replies

  14 years, 11 months ago

  By: fed_olivera

• using conditional split how to load from source to destination table where the condition is null or blank to a particular column

  using conditional split how to load from source to destination table where the condition is null or…

  jyothi_siri2000

  4 replies

  14 years, 11 months ago

  By: parthi-1705

• Using BIDS 2008, export to flat file, can we give unique name for the file?

  I am using BIDS 2008 to export to flat file(CSV) it will be automatically exported at 11.00 am in t…

  wewe_halim

  1 replies

  14 years, 11 months ago

  By: Lynn Pettis

• PREEMPTIVE_OLEDBOPS cause of slow down remote query

  I've got two machines: Server A: SQL 2008: contains the database on which the query is executed. Se…

  spidey73

  2 replies

  14 years, 11 months ago

  By: tfifield

• Semaphore

  I recently was asked on interview what is semaphore, I could not answer it. Can someone explain it …

  SQL Guy 1

  8 replies

  14 years, 11 months ago

  By: Gail Shaw

• Insert takes long

  Hello, I have a simple INSERT in a stored procedure. I do this from a .NET Client, which calls the …

  Schuttberg

  5 replies

  14 years, 11 months ago

  By: Surii

• Change password at first logon for SQL Login

  Hi, We are using SQL Authentication for SQL Server 2008. I have created users with sqllogins and pr…

  gary1

  1 replies

  14 years, 11 months ago

  By: Surii

• Problems shrinking logfile

  I have an log file that I try to shrink, but it doesn't seem to work. The file is currently 5gb, an…

  andy.l

  10 replies

  14 years, 11 months ago

  By: soj2008

• SSIS 2008 Sybase Data source Error

  I have created a sybase connection using ASE driver and I can preview the data successfully in the …

  Stringzz

  1 replies

  14 years, 11 months ago

  By: Stringzz

• Stump on why this statement ever performs well 1 day 5 minutes next day a second.

  The following statement has been causing some odd behavior. I can not modify it because it is in a…

  eccentricDBA

  17 replies

  14 years, 11 months ago

  By: LutzM

• sqlserver 2008 mnmt studio issue. f5 doesn't execute query.

  I have my default destination for results set to result to grid. yet for whatever reason when i hit…

  BaldingLoopMan

  2 replies

  14 years, 11 months ago

  By: Brett Phipps