SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Release a large amount of free space from a data file.

  I have a Database that is currently 642 GB is size with 317 GB free (49%). I do not know how it got…

  Welsh Corgi

  11 replies

  11 years, 1 months ago

  By: Jeff Moden

• Merging of SQL Server databases into one??

  Hi, Hope you guys can help... We created an application that is using multiple dbs, one for each cl…

  dexdev

  3 replies

  11 years, 2 months ago

  By: quackhandle1975

• Unhandle Exception on SQL Management Stuio 2008 R2

  Hi Expert, I couldn't get any related topic regarding this in the forum. So, I hope that anyone out…

  Clement-404472

  2 replies

  11 years, 2 months ago

  By: ca·thar·tic

• Need to trigger mail for an event

  Hi I have a view which will fetch data from database and it contains mail ids also. When ever a new…

  n.subbuu

  3 replies

  11 years, 2 months ago

  By: Jack Corbett

• xp_regread remove public permissions

  Hi, We have been directed to remove all user permissions from all extended procedures containing '…

  delizat

  1 replies

  11 years, 2 months ago

  By: Jack Corbett

• Transaction log configured to auto-grow, didn't grow?

  This morning, I walked into a database that was unusable due to a full transaction log... (Strike 1…

  jasona.work

  4 replies

  11 years, 2 months ago

  By: SQLisAwe5oMe

• Server Information

  I want to know, if company is providing me server for ETL stuff. What stuff in the server or extra…

  rocky_498

  2 replies

  11 years, 2 months ago

  By: Ed Wagner

• How to restrict an user to do not take the Script of DB or table

  Dear All, How to restrict an user to do not take the Script of DB or table.etc... Actually i have c…

  Chowdary's

  10 replies

  11 years, 2 months ago

  By: Chowdary's

• View Definition?

  Hi Everyone, I have a Question i.e, I want to create a login with some restriction like the followi…

  Chowdary's

  9 replies

  11 years, 2 months ago

  By: Chowdary's

• Please advise if any white paper on true enterprise best practices for extensibility of environments with minimal reworking of dependent objects: sprocs, queries in SSRS reports, SSIS ETL packages, etc.

  Looking for material. --Quote me

  polkadot

  10 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Restoring Logs - Empty Logs

  I have a job that retrieves log files from an FTP site, then restores them into a local database. T…

  Carol Adams

  1 replies

  11 years, 2 months ago

  By: aahale

• Serivce Broker 31+ million Disconnected_Inbound conversations

  Hi, Running this query on one of our servers returned some scary numbers. SET TRANSACTION ISOLATION…

  DennisPost

  3 replies

  11 years, 2 months ago

  By: DennisPost

• Rebuild index and update statistics.

  I have rebuild index job setup every week. Questions: 1. Do I need to run update statistics? 2. If,…

  Dan121

  13 replies

  11 years, 2 months ago

  By: Dan121

• Kill All Spid(s) according to Database Name

  Hello Everyone I know there is a way, but I cannot seem to figure out the correct query. I would li…

  AndrewSQLDBA

  9 replies

  11 years, 2 months ago

  By: Bill Parrott

• Remote login timeout not working

  I am trying to test connection to linked servers using sp_testlinkedserver but, if the server is no…

  Don Urquhart

  4 replies

  11 years, 2 months ago

  By: Don Urquhart