SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• adding specific port + default

  Hi all: I have been reading some docs over at MS and I am a bit confused. We have an MSSQL 2008 R…

  cmosentine

  4 replies

  11 years, 3 months ago

  By: cmosentine

• Sql View to display code descriptions

  Hi Team, I have Table with two columns id | codes ------------ 001 | a,b,c 002 | e,g,t 003 | r,t,y…

  Minnu

  8 replies

  11 years, 3 months ago

  By: ChrisM@Work

• Stored procedure to load two different tables based on a condition

  Hi All, I am new to SQL and Stored Procedure. Please help on the below scenario. An abstract exampl…

  Jackson89

  15 replies

  11 years, 3 months ago

  By: Jackson89

• Conditional Case in WHERE

  -- Can anyone help me conditional based search in where clause I am getting error Not able to post…

  ramrajan

  2 replies

  11 years, 3 months ago

  By: ChrisM@Work

• How to Import Data from Excel sheet to Sql server 2008

  Hi , i have an Excel sheet , that i need to import directly to sql server 2008. how can i do that…

  navbingo20

  13 replies

  11 years, 3 months ago

  By: Jeff Moden

• How to check for duplicate records by comparing columns from three tablespaces

  Hi All, I am trying to check for duplicate records in a particular table, I successfully wrote sql …

  Jackson89

  7 replies

  11 years, 3 months ago

  By: Jackson89

• Need help in refreshing some tables in a database from one server to another server

  Hi, I need some help in refreshing process some of the tables in a database from a sql server (runn…

  Agnii

  7 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Restore database error - The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'J:\Mssql2008R2\FTData\Product_FT\MssearchCatalogDir\0001000C.ci'.

  Using SQL 2008 R2 Enterprise. I've got a job that restores a database every night that fails on oc…

  Steve-443559

  13 replies

  11 years, 3 months ago

  By: Super Cat

• Remote development database

  Hi, I'm new to SQL server. I'm programming in vb.net and want to use SQL Server on my PC for develo…

  ma701ss

  3 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Possible to check if table not exist, select top(0) * into newtable else do nothing

  I need, as part of a sql agent job, to create a check for the existence of a table. If it doesn't …

  KoldCoffee

  1 replies

  11 years, 3 months ago

  By: KoldCoffee

• OPENROWSET export problem

  When I export numeric data to excel file from sql server 2008 using Openrowset, it is pasted in str…

  abhijay.singh

  6 replies

  11 years, 3 months ago

  By: anuraj.anoop

• Tempdb full issue

  Hi all, I restarted SQL server services to free Tempdb but after restart also Tempdb not released d…

  Shivrudra

  2 replies

  11 years, 3 months ago

  By: Jeffrey Williams

• SQL 2008R2 just keeled over

  Hi. Our production server which has been up since Sept 8 2011 suddenly just keeled over with the fo…

  C3PO's twin

  11 replies

  11 years, 3 months ago

  By: vishe.dinesh

• Find Appropriate Event After An Incident

  I have a table of about 1.8 million violations that I need to associate with a sanction. The sanct…

  Neil Burton

  16 replies

  11 years, 3 months ago

  By: ChrisM@Work

• Need to Export the results to Excel

  Hi!, Help is appreciated, I am pulling a data for 1 year bit turns to be very huge, just want to ex…

  bubby

  7 replies

  11 years, 3 months ago

  By: MMartin1