SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Detach database

  Can we rename .ldf file which it's corresponding database is detached? Thanks..

  Achilies

  2 replies

  14 years, 7 months ago

  By: SQLRNNR

• LOg files Growth - Out of Control

  Log files for my database are growing fast and un-expectedly and i am left with no space available …

  aby_dvd

  13 replies

  14 years, 7 months ago

  By: Jeffrey Williams

• i got fixed with file ..... i trying to ..plz help....plz...plz

  NUM FNAME LNAME COUNTRY CITY centuries special wickets runs highe…

  sqlmaverick

  10 replies

  14 years, 7 months ago

  By: sid@nostalgia

• Insert into SQL Tables using SSRS or Access

  Hi Guys, I need suggestion on what is the best approach to do something like this: We have some exc…

  Ghanta

  2 replies

  14 years, 7 months ago

  By: Ghanta

• Why I can't shrink the log file?

  Hello all I noticed that in 2008 the Tempdb log file is not recreated when I restart the service, I…

  ricardo_chicas

  5 replies

  14 years, 7 months ago

  By: ricardo_chicas

• Guidelines for tuning CPU bound SQL Server System

  Are there any general guidelines for performance tuning of a CPU bound SQL Server system? We have a…

  praveen_vejandla

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• How to construct a Select query from INFORMATION_SCHEMA.COLUMNS

  I would like to pull the column names from INFORMATION_SCHEMA.COLUMNS for any one table, however I …

  bob mazzo

  7 replies

  14 years, 7 months ago

  By: R.P.Rozema

• silently unzipping Patches & Cumulative updates.

  Im writing a script to silently install Cumulative updates. ive downloaded an update ( CU6 ) and am…

  winston Smith

  1 replies

  14 years, 7 months ago

  By: winston Smith

• What is a deferred txn?

  Hi All, Can anyone give me an example of a defferred transaction to understand it better? http://ms…

  Oracle_91

  1 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• clean up maintenance plan failing because it can't access log file

  Much like the subject says, my cleanup job is failing because it can't access the log file it gener…

  jshurak

  5 replies

  14 years, 7 months ago

  By: Jack Corbett

• use REPLACE with like

  Hi, can i use the REPLACE function with like to accomplish this syntax?(i want to replace all non a…

  Mad-Dog

  1 replies

  14 years, 7 months ago

  By: R.P.Rozema

• DATABASE MAIL Error

  we have installed SQL Server 2005 (standard edition) with SP3 on a SQL cluster. after the installat…

  pujain

  1 replies

  14 years, 7 months ago

  By: Jim Murphy

• compare two database?

  i get abackup from a database and restor on another pc . how can compare main database with restore…

  zsafakhah

  5 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Exporting table column type 'Long Text' to Excel

  Hi, I am using the standard table export within SQL Server 2008 R2 to send my data to Excel. Howeve…

  Essex

  1 replies

  14 years, 7 months ago

  By: Essex

• What is the language of SQL server installation files

  How to find the language of SQL server installation files? I have SQL server 2008R2 media file. I n…

  Ryan007

  2 replies

  14 years, 7 months ago

  By: Ryan007