SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• user mapping by default ?

  Is there a way to add a user mapping for a particular login so that the login gets read access to a…

  inevercheckthis2002

  1 replies

  11 years, 10 months ago

  By: Keith Tate

• Deadlock graph information with xml format.

  I am capturing deadlock graph by using extent events script and verified the resource and process l…

  SQL Galaxy

  2 replies

  11 years, 10 months ago

  By: SQL Galaxy

• Tracing user actions

  Hi all, Just wonder if there is a posibillity to trace all user actions which is done on a database…

  gkramer 23701

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• What's the fatest way to restore? SSIS

  Hi, Long story, but I'm restoring a remote SQL DB via SSIS. I'm using this inside a 'Execute SQL ta…

  krypto69

  1 replies

  11 years, 10 months ago

  By: free_mascot

• Can't connect to stand alone Server not in a Domain

  I have a Server named cdcd. I can remote into it by specifying the Computer name cdcd. I have an in…

  Welsh Corgi

  2 replies

  11 years, 10 months ago

  By: free_mascot

• Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan.

  Hi All, I am wondering why I got this error on Maintenance Plan Back up : Database 'BizTalkEDIDb' i…

  WhiteLotus

  1 replies

  11 years, 11 months ago

  By: free_mascot

• CPU USAGE IS 100%

  Hi All, I am using sql server 2008 r2 and windows server 2008r2. Management studio is taking time t…

  New persopn

  4 replies

  11 years, 11 months ago

  By: Henrico Bekker

• Dynamically managing SQL Memory

  Heres the scenario, I've recently come across involving a multi-instance SQL server server. The ser…

  Jason-299789

  1 replies

  11 years, 11 months ago

  By: graham.nolan-753599

• Script to restore backup with Full Text Search

  I have a backup script and it has been working fine but now I have a situation where there is a ful…

  Welsh Corgi

  1 replies

  11 years, 11 months ago

  By: Welsh Corgi

• DBCC CHECKDB Questions on general practice

  I'm going to set up DBCC CHECKDB to check all databases on a server with about 50 databases, the la…

  taseedorf

  9 replies

  11 years, 11 months ago

  By: Nadrek

• SQL Services are not showing in configuration manager

  Hi All, in my one of the server the sql server and sql sevrer agent service is not showing in confi…

  c.ajitkumar

  5 replies

  11 years, 11 months ago

  By: c.ajitkumar

• Administering a Data Warehouse sql server 2008R2

  Hi All, i hope i have posted this in the right place. I am looking for some advice on what better k…

  extremenovice

  4 replies

  11 years, 11 months ago

  By: extremenovice

• Large FT Catalogs and little lock icon by the file

  Question - we run Relativity by KCura and have hundreds of databases and in turn, hundreds of full …

  taseedorf

  1 replies

  11 years, 11 months ago

  By: EdVassie

• Locking error while populating a table

  Hi, I will explain my issue as below: Database 1: Table : myTable1 View : myView1 (referring myTabl…

  ssandeepksh

  2 replies

  11 years, 11 months ago

  By: ssandeepksh

• Task scheduler history showing dtsx process has run, log history does not

  I'm using SS 2008. I have a SSIS package that was running fine. Then, a server change out was made…

  nonghead-webspam

  3 replies

  11 years, 11 months ago

  By: nonghead-webspam