SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Agent Service runs fine, but keeps logging this error [165] ODBC Error: 0, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

  Hi All I need some help here, I have looked and googled to no avail. I have an installation of SQL …

  Matthew Lang

  11 replies

  11 years, 8 months ago

  By: david.abram

• Internal Checkpoint Issue

  One of the Background spid is showing as a CHECKPOINT status and never clears out. Due to this,i ca…

  Bhuvnesh

  1 replies

  11 years, 8 months ago

  By: Beatrix Kiddo

• Restoring backup from network location

  Hi, I am having difficulty restoring my database backup from a network location. So far I have trie…

  navtec

  5 replies

  11 years, 8 months ago

  By: navtec

• The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value.

  hi All, My below proc gives me this error.. "The conversion of a nvarchar data type to a smallda…

  BokBob

  6 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• SQL Agent Job not firing when scheduled

  So, had an odd problem today. We have a job that runs quarterly to generate some reports. The job …

  thisted

  1 replies

  11 years, 8 months ago

  By: Rudyx - the Doctor

• Deadlock seems to involve only one object.

  I've done a search of the forum for articles on this subject and in one about 2 or 3 years ago, Gai…

  Willem Tilstra-440027

  13 replies

  11 years, 8 months ago

  By: Gail Shaw

• Need help on priorty to run query (urgent)

  HI, my table size is very big,i am loading data into the table using SSIS.same table some one ran …

  jeyaprakash84

  12 replies

  11 years, 8 months ago

  By: Grant Fritchey

• PRIMARY AND FOREIGN KEY CREATION

  i have migrated a database from ms access to sql server and application developer is not available…

  SQL learner22

  6 replies

  11 years, 8 months ago

  By: Michael L John

• updating records with BEGIN TRAN

  Hello All, I had a need to execute a query. As a standard practice, I issued a BEGIN TRAN statement…

  SQLJay

  7 replies

  11 years, 8 months ago

  By: Andrew Kernodle

• SQL 2008 and 2012 auditing at application layer

  I'm creating an audit specification in SQL 2008 R2 and I can't find the list of available predicate…

  smitty-1088185

  1 replies

  11 years, 8 months ago

  By: Jack Corbett

• Help with setting up Differential backups please (SQL2008)

  Hi - I currently have a maintenance plan setup which runs a full backup nightly and then trn logs f…

  dax.latchford

  6 replies

  11 years, 8 months ago

  By: ScottPletcher

• Converting output from 2 Access databases into 1 SQL query

  Hi, I’ve created 2 Access Databases that query our Oracle Database. They both work fine, however, i…

  clifford.sweeney

  7 replies

  11 years, 8 months ago

  By: Sean Lange

• exporting data

  Hi guys, I need to export millions of data from a database going to another server/database. I read…

  Sylar

  1 replies

  11 years, 8 months ago

  By: Luis Cazares

• Reduce size of TRN log & backup DB to UNC path (SQL2008) - Help please

  Hi - I have a couple of DB's that have trn logs that are far bigger than the data files. MDF file a…

  dax.latchford

  11 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Maintenance Plan Error - File in Use by Another Process

  We just moved to Server 2008 (from 2000) and after setting up the maintenance plans, everything see…

  brian.stewart

  7 replies

  11 years, 8 months ago

  By: webtomte