SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Group by column text in one row

  create table test ( ID int , textID int , Typetext varchar(100) ) insert into test values (1,…

  vikrantkale18

  4 replies

  15 years, 10 months ago

  By: LutzM

• How do i get restore succeed according to the code below?

  How could i know just restore succeeded? According to this code: declare @qStr varchar(512), @i int…

  thinknight

  4 replies

  15 years, 10 months ago

  By: thinknight

• identifying resources used by a server side trace

  I need to run a server side trace on a production server. I need to gather info on the resources us…

  winston Smith

  5 replies

  15 years, 10 months ago

  By: Grant Fritchey

• How to get SQL2008 db to another machine running SQL2005?

  Alcon: I am a LAN/WAN/desktop network engineer. The company I presently work for seems to think tha…

  phil.cooper.2

  10 replies

  15 years, 10 months ago

  By: Grant Fritchey

• Openrowset don't show all columns

  Hi, I use a OpenRowset Query to create a table in SQL Server from .txt file. The command don't sh…

  leonardo.castillo

  11 replies

  15 years, 10 months ago

  By: leonardo.castillo

• How to import excel file into a table SQL server without using DTS,...

  Anyone help to provide me a SQL query b/c I want to import an excel file into a table Thanks

  steven_nguyenhuy

  2 replies

  15 years, 10 months ago

  By: Ashwani Malik

• errors and how to resolve

  Hi all am new to sql server i need logshipping issues and how resolve the issues plz help me

  kjplreddy

  1 replies

  15 years, 10 months ago

  By: Dan.Humphries

• Empty Table from Stored Procedure

  Hi All, I have a Procedure which should return only 1 Record on selecting record according to Prior…

  Vinay Theethira

  1 replies

  15 years, 10 months ago

  By: Grant Fritchey

• Prolem with IF ELSE Statement

  Hi All, I have a Procedure which should return only 1 Record on selecting record according to Prior…

  Vinay Theethira

  4 replies

  15 years, 10 months ago

  By: Lynn Pettis

• windows running Process Info

  I need to start pssdiag utility(.exe) through SQL agent job when ever my CPU reaches over 95% ,but …

  sqlquery-101401

  2 replies

  15 years, 10 months ago

  By: crazy4sql

• update transaction

  Dear all, We are in the process of doing data conversion. Hence, we prepare a lot of update queries…

  golden-1131024

  7 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• Can SSIS be installed without SQL Server?

  Greetings. Is installing SQL Server (database engine) required, in order to install and use SSIS, …

  randy.witt

  5 replies

  15 years, 10 months ago

  By: SQLRNNR

• Query to use for CPU Utilization

  I need a query that checks my overall CPU utilization on server and kick of one SQL Agent Job if ov…

  sqlquery-101401

  3 replies

  15 years, 10 months ago

  By: sqlquery-101401

• About login SQL Server Management Studio

  Hi folks, Windows server 2008 R2 Enterprise 64 bit SQL server 2008 64 bit This is a newly installed…

  satimis

  2 replies

  15 years, 10 months ago

  By: satimis

• Next Version of Sql Server ???

  Does anyone know what is going to be the next version of sql server ? After 2008 R2 ,are they plann…

  SqlServerLover

  3 replies

  15 years, 10 months ago

  By: SQLRNNR