Administering

• Topics

  Started by

  Posts

  Last post

• The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

  HI All, I am getting the below error when i am running one application , The Microsoft Distribute…

  Lavanyasri

  13 replies

  14 years, 3 months ago

  By: Lavanyasri

• how different could it be joining a #temp_table Vs @table_variable?

  I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs w…

  curious_sqldba

  23 replies

  14 years, 3 months ago

  By: curious_sqldba

• Install 2008 R2, but not on C drive ?

  I started installing SQL 2008 R2, and when I get to the "Instance Configuration" screen, I can poin…

  homebrew01

  1 replies

  14 years, 3 months ago

  By: SQLRNNR

• SQL 2005 STD on WIN2003R2 STD 4GB RAM

  Hello all, (dont' kill the newbie) This server has only one instance to take care Allowing for fine…

  email-827037

  2 replies

  14 years, 3 months ago

  By: email-827037

• full text service

  I am using MSSQL 2005 My s/w is giving an error msg :- Full-Text Search is not installed, or a full…

  pallavi.unde

  6 replies

  14 years, 3 months ago

  By: Devendrakumar

• Error: 18456, Severity: 14, State: 6

  I came to this new company, and found a server's log file keeps giving me "Error: 18456, Severity: …

  yan-160997

  4 replies

  14 years, 3 months ago

  By: yan-160997

• empty sql server database

  Hi, I want to empty the database (only data). Is there any script/SP available to that. SQL Server …

  HBK_4700

  3 replies

  14 years, 3 months ago

  By: Lowell

• Bulk Login Creation Script

  Please Let me know if anyone have Bulk Login Creation Script. Requirement: Create SQL and Windows L…

  loken.bhatt

  1 replies

  14 years, 3 months ago

  By: Lowell

• Transaction Log File Will not Shrink

  I ran shrink DB command after that index rebuild against database, it caused the transaction log to…

  Admingod

  11 replies

  14 years, 3 months ago

  By: MasterDB

• hi job maintanance

  hi all I want set my job should run every 90 in sql server 2005 .how to set it and whether it is d…

  vivekinmadar

  4 replies

  14 years, 3 months ago

  By: John Mitchell-245523

• Encryption - DECRYPTBYKEYAUTOCERT

  Hi, I have 2 encrypted database DB1 and DB2. USE DB1 CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P…

  moorthy.jy

  2 replies

  14 years, 3 months ago

  By: moorthy.jy

• Can we have multiple Secondary servers in Mirroring?

  Hi ! Can we Configure Multiple secondary servers in Database Mirroring ?

  Steve Dell

  6 replies

  14 years, 3 months ago

  By: MasterDB

• VBS script to find out database details in SQL Server 2005

  Hi All, I have attached two files one is txt file and one is error file. I am executing the txt fi…

  beejug1983

  1 replies

  14 years, 3 months ago

  By: dick.baker

• Event ID:18053

  Hi All, In DB Server i am getting below error. Event Id : 18053 Error: 17066, Severity: 16, State:…

  Minto Minto(quendans)

  2 replies

  14 years, 3 months ago

  By: dick.baker

• Revoke Create, Alter and Drop privileges to a user

  Hi All, I am new to SQL Server DBA responsibilities. I would like to restrict users to ALTER , CREA…

  ramji543210

  5 replies

  14 years, 3 months ago

  By: Suresh B.