SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• CTE in sql server

  I have a general question about CTEs. We are using CTEs all over our SSIS packages and they are doi…

  ssismaddy

  2 replies

  14 years ago

  By: ssismaddy

• Created Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server Agent

  I created a Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server A…

  Welsh Corgi

  1 replies

  14 years ago

  By: Welsh Corgi

• How sincronize databases between two servers while the source server databases are in use

  Hi, I have my SERVER01 SQL Server 2008 server with many databases. Now we need migrate this server …

  ico-601891

  2 replies

  14 years ago

  By: ico-601891

• Some one devloper update a column in a table, how to I find out who updated?

  Hi All, Some one devloper update a column in a table, how to I find out who updated it is? Could yo…

  ARUN KUMAR AGUNURU

  4 replies

  14 years ago

  By: ARUN KUMAR AGUNURU

• Dedicated SSIS server - Allocating RAM

  We have a dedicated SSIS Server that is running on SS2008 SP1, W2008 Enterprise. It has total of 8…

  cbarus

  1 replies

  14 years ago

  By: Jo Pattyn

• Db in recovery after restoring

  I had a database of 2tb in size which went into recovery mode as the server was rebooted when there…

  Tara-1044200

  25 replies

  14 years ago

  By: Gail Shaw

• SQL 2008 Edition Upgrade Questions

  I'm performing SQL 2008 Standard Edition upgrade to SQL 2008 Enterprise Edition on an Active/Active…

  sqladdict

  4 replies

  14 years ago

  By: sqladdict

• Test PC is faster than Server Meachine

  Hi, We moved the database to new server and after move , we the server is slow. So i create a sam…

  Mathew M.Varghese

  13 replies

  14 years ago

  By: Mathew M.Varghese

• Running Windows batch script

  Can i know is there any way of calling/running a windows batch file using powershell script or SSIS…

  Dhruva_51

  4 replies

  14 years ago

  By: Orlando Colamatteo

• Restoring a network back-up failing

  I've already posted this in SQL 2008 General but didn't gut much of a response Hello I'm using SQL …

  mark.jones

  3 replies

  14 years ago

  By: Daxesh Patel

• Help with script, shrink multiple data files

  hi, What is wrong with my script below: i am trying to change multiple database to full recovery mo…

  FTdenali

  8 replies

  14 years ago

  By: FTdenali

• Replication

  I need to drop a table that is used in replication (from sqlserver 2005 to 2008). And recreate the …

  SQL_Surfer

  2 replies

  14 years ago

  By: Suresh B.

• extended stored procedure

  Hi everyone, I am working to migrate SQL Server 2000 databases to SQL Server 2008 R2. I restored al…

  B Raj Dhakal

  4 replies

  14 years ago

  By: B Raj Dhakal

• executing a windows batch file(.bat) from sql server job

  My batch file basically copies the txt files from Unix server to Windows directory. i use some cred…

  Dhruva_51

  4 replies

  14 years ago

  By: Dhruva_51

• permissions about start and stop service

  We have a sql server job set up to stop and start a windows service which is a service of a softwa…

  sqlfriend

  17 replies

  14 years ago

  By: Welsh Corgi