SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• PerfMon & SQL MPA

  Does anyone know of a PerfMon counter for the SQL MPA? I'm looking for a way to record the output o…

  tim.cloud

  6 replies

  13 years, 10 months ago

  By: tim.cloud

• Database Mail on server A is creating a profile on Server B

  Hi, I have a SQL 2005 server, call it OldProd, and a new production SQL 2008, call it NewProd. I…

  GeoffT

  2 replies

  13 years, 10 months ago

  By: chris.mcgowan

• Insert FK conflict

  Dear All The issue is following: select ddb.num_cue_s,count(*) from ddb_temp_DDB ddb group by ddb.…

  Igor Micev

  9 replies

  13 years, 10 months ago

  By: Gazareth

• SQL Backups cause user slowness

  I'm receiving complaints that users experience slowness when the sql backup runs. The database is 2…

  lulu_lutz

  12 replies

  13 years, 10 months ago

  By: lulu_lutz

• SSRS - How to search textbox for a specific value and change text color based on that value

  I have a Reporting Services report that has a textbox which contains the number of minutes a delive…

  kswiss1701

  1 replies

  13 years, 10 months ago

  By: HowardW

• SSIS task causes tempdb to grow uncontrolled

  I have a very strange problem where a execute SQL task in a SSIS package completely fills up my tem…

  romanoplescia

  15 replies

  13 years, 10 months ago

  By: paul.mcmillin

• sqlservr.exe utilizes very less memory comparitively as it did before a week

  My production DB's got a maximum of 300 GB in size and it has users more than 300... Operates in wi…

  SQLInspired

  5 replies

  13 years, 10 months ago

  By: SQLInspired

• SQL Server Snapshot Replication

  Hi, I have a table that needs to be exported to another server every night. I set up snapshot repli…

  ssismaddy

  2 replies

  13 years, 10 months ago

  By: ssismaddy

• run SSIS package in 2008 designed in 2005

  i just want to know, what changes has to make when i want to run a package in 2008 environment whic…

  Zeal-DBA

  2 replies

  13 years, 10 months ago

  By: Brandie Tarvin

• Error after Data loading , name can not start with '>' character hexadecimal 0x3e

  Hi I loaded the data suing an SSIS package in a SQL Server 2008 database. After the data load , I t…

  SJanki

  6 replies

  13 years, 10 months ago

  By: Jared

• Invalid attempt to enter duplicate records. The transaction ended in the trigger. The batch has been aborted.

  Hello All, I am trying to add the records from one table to other table. But getting the below erro…

  EasyBoy

  1 replies

  13 years, 10 months ago

  By: EasyBoy

• How to create slq to return the rows only from the first table with multiple table join?

  Have a 3 table Tabel A emplyee_ID, first_name, last_name 1 John Anderson…

  Seattlemsp

  7 replies

  13 years, 10 months ago

  By: Divine Flame

• Convert Job Duration Format

  The following script returns the run_duration as for example: 45028 43520 3007 40529 2509 I want 4…

  Welsh Corgi

  1 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Windows 7 + SQL Server 2K8 Expression edition

  Hi, Can i install Windows 7 32 bit and SQL Server 2K8 Expression edition. I tried intalling 2008 Ex…

  parthi-1705

  7 replies

  13 years, 10 months ago

  By: parthi-1705

• Powershell script to check if the db owner is 'sa'? Please help!!!!

  Hi Guys, I am looking for a powershell script to check if the db owner of the sqlserver database …

  Mithra

  1 replies

  13 years, 10 months ago

  By: derek.colley