SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• how do i allow only specific ip address to connect to my sql server

  recently i saw many login attacks on my sql server, it eat uped resources like anything for the tim…

  sukhoi971

  24 replies

  11 years, 1 months ago

  By: Ville-Pekka Vahteala

• SQL Agent Job cannot run scripted Profiler Trace (2008 r2 RTM)

  Can anyone help with this SQL Agent running a Trace issue: I have scripted out a SQL Profiler Trace…

  SQL Swerver

  4 replies

  11 years, 1 months ago

  By: Grant Fritchey

• View Name defaults to the name of the login user

  Hello I have a user that has db_owner on a database. When the user creates a view the name of the v…

  jdbrown239

  4 replies

  11 years, 1 months ago

  By: arnipetursson

• replication or restores?

  Hi, i have a production sql server, and i have a production report server. I need to ensure that th…

  jenny 12957

  4 replies

  11 years, 1 months ago

  By: arnipetursson

• Drop Temp Tables from INFORMATION_SCHEMA.TABLES

  I am trying to remove some temp tables our application created from the INFORMATION_SCHEMA.TABLES. …

  bpowers

  4 replies

  11 years, 1 months ago

  By: bpowers

• Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

  Dear All! I have this problem in our one of module, Please let me know your suggestion to overcome …

  Saravanan_tvr

  2 replies

  11 years, 1 months ago

  By: mias.louw

• Ola's SQL Server Maintenance solution - commandlog cleanup

  I have searched up and down and can't find anything regarding this topic. Am I missing something if…

  lawson2305

  1 replies

  11 years, 1 months ago

  By: lawson2305

• very large log file due to mysterious replication configuration

  Log reuse wait for database is replication. But no replication has ever been setup?? This means th…

  DavidB 36561

  7 replies

  11 years, 1 months ago

  By: Gail Shaw

• Page still marked corrupt after DBCC check returns no errors

  Noticed this on a tucked-away server going through things today. Ran DBCC a couple different ways b…

  sqldriver

  3 replies

  11 years, 1 months ago

  By: Gail Shaw

• Restricting access

  Hi, A few questions. 1. Is it possible to grant select on all tables in a schema but also restrict…

  davidgray

  7 replies

  11 years, 1 months ago

  By: Sean Lange

• how to install N no of Sql server at a time

  HI, I would like to know how to install N no of SQL server at a single go is there any process by I…

  santoshkal

  3 replies

  11 years, 1 months ago

  By: Jeff Moden

• syspolicy_purge_history job failed at step 3

  Hello, In one of my sql 2008 sp1 standalone instance, syspolicy_purge_history job is fails at step …

  Robin35

  1 replies

  11 years, 1 months ago

  By: bpowers

• Can we restrict windows authentication or SA login to only selected databases?

  Hi Experts, Can we restrict windows authentication or SA Login to only selected databases? We want …

  Chowdary's

  3 replies

  11 years, 1 months ago

  By: Gail Shaw

• Memory page fault/sec - too high value?

  1.Memory\Page Faults/sec Min value = 1865.610193 Max value = 7440.700727 captured system perfmon t…

  SQL Galaxy

  4 replies

  11 years, 1 months ago

  By: karthik babu

• unable to connect to a default instance without using port number

  Hello folks I have a server with a default instance, but outside this server I cannot connect to th…

  hiram.osiris

  10 replies

  11 years, 1 months ago

  By: hiram.osiris