SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Restore master db from sql 2000 to sql 2008 R2

  I restored few databases from sql 2000 to sql 2008 R2. All but master db could be restored. I chang…

  puskal.adhikari

  7 replies

  14 years ago

  By: puskal.adhikari

• Reporting Solution

  So I am looking for some opinions on how to determine a reporting solution. Here is our current se…

  pamozer

  10 replies

  14 years ago

  By: MWise

• Log Shipping - Index Maintenance

  Hi All A question regarding Log Shipping and Index maintenance Server A - Log Shipping Primary Serv…

  SQLSACT

  13 replies

  14 years ago

  By: Orlando Colamatteo

• Find obsolete User Defined Functions SQL2008R2

  I have been asked to identify which of the 250 or so User Defined Functions in a database are now o…

  brian.keyworth

  4 replies

  14 years ago

  By: Grant Fritchey

• What is the Query?

  Hi Friends, I have SQL statement like insert into table1 (column1, column2,column3) select colum…

  Charmer

  6 replies

  14 years ago

  By: Daxesh Patel

• Edition upgradation and licence Keys

  Hi All, I'm having some doubts on Edition upgrade. 1) We have SQLServer 2008 R2 Enterprise Evaluati…

  ravisamigo

  10 replies

  14 years ago

  By: Lynn Pettis

• Instance Service Won't Start

  Hi there, SQL 2008 install. I have a default instance and a named instance. I wanted to move the …

  TSQL Tryer

  5 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Clone a Login; SQL Server 2008 R2

  Hi All, I have an existing SQL server account and I would like to create a windows user with the sa…

  Chrissy321

  4 replies

  14 years ago

  By: Chrissy321

• Migration of data from old server to new server

  Hi, I have a requirement,i have a code which was written in Vb.net for migration of data,so my…

  atlancharlo

  3 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Creating an SP for MDX using openquery

  I've been tasked with writing an SP for some MDX currently residing in SSRS. Have come across a fe…

  jahayes

  1 replies

  14 years ago

  By: HowardW

• Send Mail

  Hi, I got a job to run a script at a fixed time and the result should send to the recipient .Please…

  ravimir

  5 replies

  14 years ago

  By: GSquared

• Creating new user on local machine

  I created a local User Test1 on my local machine just to test some schema settings. Then I added th…

  hp_dba_uk

  1 replies

  14 years ago

  By: SQLRNNR

• Convertion Error, DateTime to Int

  Hi All, I have a table like this, while I am altering the column, datetime to Int , it is throwing …

  PRAMANA.DBA

  5 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• SSIS Package - strange issue

  We have a job to execute SSIS packages. if we initiate a second request following the initial one …

  vkundar

  1 replies

  14 years ago

  By: HowardW

• clustered indexes

  Hi I have always been under the impression that in tables where there are a lot of inserts a cluste…

  erics44

  10 replies

  14 years ago

  By: Gail Shaw