SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• problem with Database mail:All mails have Unsent status

  We have setup Database Mail on SQL SERVER 2008 R2 (RTM).Since yesterday,Database Mail stopped worki…

  Aspet Golestanian Namagerdi

  10 replies

  9 years, 1 months ago

  By: Lowell

• The database XXXX is not accessible (ObjectExplorer)

  Hello Experts, First of all I am not a DBA guy and have only limited knowledge on SQL server DB. 🙂W…

  Phanit86

  16 replies

  9 years, 1 months ago

  By: Jeff Moden

• High CPU for "System" Process

  Never really come across this issue, i have a query when i execute overall server CPU gets to 80%.W…

  curious_sqldba

  1 replies

  9 years, 1 months ago

  By: Jeff Moden

• SQL2008R2: Cannot open the required dialog box. Possibly AD/Firewall issue ?

  Hi, I'm new so apologies if there's a better place to post this but basically my problem is such: I…

  squaffle

  2 replies

  9 years, 1 months ago

  By: squaffle

• SSIS job completion

  hi i have an ssis job that picks up .csv files and posts them into various tables. when i manually …

  dopydb

  16 replies

  9 years, 1 months ago

  By: dopydb

• Length specified in network packet payload did not match number of bytes read

  Length specified in network packet payload did not match number of bytes read; the connection has b…

  smoham22

  8 replies

  9 years, 1 months ago

  By: Frank.Ferlise

• OS error 665 - Not CHECKDB

  Hi, SQL Server 2008 R2 Enterprise Edition - 10.50.6220 on a 2 node Windows 2008 R2 cluster.  I…

  adb2303

  9 replies

  9 years, 1 months ago

  By: adb2303

• Function Left and IsNull together

  Hello, How can I combine function Left and IsNull together? I am getting "Argument data type text i…

  datsun

  2 replies

  9 years, 1 months ago

  By: datsun

• How to decompress internal tables?

  Hi All, I use tfs, and there was necessity to downgrade tfs' sql server Enterprise edition to stand…

  Thinky Night

  2 replies

  9 years, 1 months ago

  By: Steve Jones - SSC Editor

• Clustered scan vs Non-clustered Seek with lookup

  Hi I think the answer to this question will be "it depends" but i'm interested to know what the var…

  alex.palmer

  9 replies

  9 years, 1 months ago

  By: ScottPletcher

• List of ODBC connections

  Dear All, I'm trying to find out list of ODBC connections on SQL SERVER but I'm not sure which scri…

  tt-615680

  1 replies

  9 years, 1 months ago

  By: Eirikur Eiriksson

• VSTA component error during setup

  Hello, I've installed SQL SERVER EXPRESS 2008 R2 With Advanced services on my fresh new HP server (…

  Birby1974

  2 replies

  9 years, 1 months ago

  By: Birby1974

• How to parse this, 'F0-B20170225131636437{A^CM.INIT}'

  What is the best way to parse out 'CM.INIT' from 'F0-B20170225131636437{A^CM.INIT}'?

  NineIron

  8 replies

  9 years, 1 months ago

  By: NineIron

• Create table partition function on range of values

  Can i create a partition function for set of range values, like can i say values between 1 - 100 ge…

  curious_sqldba

  1 replies

  9 years, 1 months ago

  By: Joe Torre

• How to change the CLR permission_set value from 3(unsafe) to 1(safe)

  SELECT name, is_user_defined, permission_set, permission_set_desc from sys.assemblies; How can I …

  SQLisAwe5oMe

  4 replies

  9 years, 1 months ago

  By: Lowell