SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• xp_create_subdir() returned error 161, 'The specified path is invalid'

  Hello! I created a new job that keeps on failing with the following message: "xp_create_subdir() re…

  BallaKet

  2 replies

  10 years, 10 months ago

  By: Alvin Ramard

• Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user

  Hello Experts, Good Morning I want to grant a SQL USer Full Privilege to a folder in a path using x…

  SQL_Hunt

  5 replies

  10 years, 10 months ago

  By: Jeff Moden

• troubleshoot connection issue - what is issuing the login request?

  So I've removed db X, and I get periodic login failures in the SQL error log because db X does not …

  snomadj

  5 replies

  10 years, 10 months ago

  By: snomadj

• I have 3 tables and I want a specific type of join. Can anyone help

  Hi, I have 3 tables as per following: orddet OrderProductQtyOrd 1 Item1 20 2 …

  james.lyons

  2 replies

  10 years, 10 months ago

  By: james.lyons

• SQL timeout expire

  Hi Expert, We are getting sql timeout expire error from Microsoft Dynamic CRM application. I am not…

  shahnawaz052

  2 replies

  10 years, 10 months ago

  By: mssqlsrv

• SQL Mail Problem

  Hi Team, I have strange issue. Not able to understand it. One of my sql job "report job" from serv…

  mssqlsrv

  1 replies

  10 years, 10 months ago

  By: mssqlsrv

• Same database with two different machines at different times

  I have a customer with an odd request and try as I might, I just can't talk him out of what he want…

  ratherbeflying

  16 replies

  10 years, 10 months ago

  By: ratherbeflying

• Project suggestion for a noob

  Hi everyone, I am teaching myself MS SQL Server 2008 for work purposes. I have a background in pro…

  dick.vanderweed

  14 replies

  10 years, 10 months ago

  By: Jeff Moden

• Archieving Data

  Hi, We have one large table with 6880875 records. It has created date. The min created date is a ye…

  ramana3327

  28 replies

  10 years, 10 months ago

  By: Jeff Moden

• Domain access on SQL Database

  Hi Team, We have an .net desktop application which connects to the sql server 2008 database. We con…

  GonnaCatchIT

  1 replies

  10 years, 10 months ago

  By: John Mitchell-245523

• Violation Of primary key constraints, Cannot insert a duplicate key in object

  Hi All, Please I need help on how to solve this problem. I have table variable in which I am insert…

  eobiki10

  10 replies

  10 years, 10 months ago

  By: schleep

• If SPN is manually registered, will SQL Server try to re register every time it is started ?

  Hi All, If SPN is manually registered, will SQL Server try to re register every time it is started …

  Joy Smith San

  11 replies

  10 years, 10 months ago

  By: JimmyJones

• Help Needed

  Please let me know the benefit of breaking large transaction into multiple small transactions(means…

  mandirkumar 18293

  2 replies

  10 years, 10 months ago

  By: Gail Shaw

• Does Change Data Capture require a table have a primary key

  or can it record before and after column changes based on the LSN only? An extract from a file base…

  drew.georgopulos

  11 replies

  10 years, 10 months ago

  By: inspi

• MAXDOP and cost threshold for parallelism settings ?

  Hello All, Referencing an article regarding MAXDOP and cost threshold for parallelism from Brent Oz…

  SQLJay

  2 replies

  10 years, 10 months ago

  By: Gail Shaw