Administering

• Topics

  Started by

  Posts

  Last post

• Scheduling VB script job in SQL server agent

  Hi All, I have a windows scheduling VB script job(.bat file) in another windows server where SQL is…

  Gangadhara MS

  2 replies

  14 years, 5 months ago

  By: cindyaz

• Advice on sensitive data

  Hello all, I am seeking advice on how to handle a sensitive data field, specifically PIN's (Persona…

  SteveBell

  2 replies

  14 years, 5 months ago

  By: SteveBell

• Error in stored procedure

  Hello, When I test my stored procedure get this error: Transaction count after EXECUTE indicates a …

  Krasavita

  5 replies

  14 years, 5 months ago

  By: Krasavita

• Delete unnecessary data and log files

  how to delete unnecessary data and log file in a database use abc sp_helpfile team_Data team_Log a…

  jamessdba

  1 replies

  14 years, 5 months ago

  By: jamessdba

• LDF file size issue

  Hi all, one of our production SQlserver 2005 EE MDF : 6780224 KB LDF sizes : 13246208 KB we are …

  jamessdba

  2 replies

  14 years, 5 months ago

  By: jamessdba

• Restoring users for DB afetr restoring backup

  Good afternoon: In the enterprise I work for we have production and staging environments for our Da…

  Jportelas

  16 replies

  14 years, 5 months ago

  By: george sibbald

• Linked Server

  I have to create linked server on my SQL server. Both server that will be linked r SQL servers I ha…

  mandavli

  8 replies

  14 years, 5 months ago

  By: MyDoggieJessie

• Can't connect; Login failed.

  Hi, I am trying to enter an application on a client PC, (application is MS Dynamics GP which u…

  Skybvi

  5 replies

  14 years, 5 months ago

  By: SQLRNNR

• ALTER COLUMN & Indexes

  Hello, Can someone explain why, once there is a nonclustered index on a column, I cannot reduce t…

  SwedishOrr

  4 replies

  14 years, 5 months ago

  By: Gail Shaw

• Unable to install Windows Installer MSP fileExit Code Returned: 11032

  Hi I am trying to apply SP4 on sql server 2005 (Database Services (MSSQLSERVER) ENU …

  shanila_minnu

  4 replies

  14 years, 5 months ago

  By: RWebster-632853

• analyzing SQL memory

  Hi all, How to analyze below query output? Top 10 consumers of memory from Buffer Pool: SELECT TOP…

  SqlSavy

  12 replies

  14 years, 5 months ago

  By: SqlSavy

• Maintenance Plan rebuild Index online option

  Hi all, I'm just wondering that If I use online option while doing ReBuild Index under Maintenance …

  Davekahn

  2 replies

  14 years, 5 months ago

  By: Davekahn

• ERRORLOG filled with Logon entries - what is the source?

  I have a vendor system where I see the ERRORLOG flooded with successful Logon events. Close to a h…

  Randy Doub

  1 replies

  14 years, 5 months ago

  By: Randy Doub

• Dead lock issue

  HI All, I enabled dbcc traceon(1222,-1) on my server and i run a profiler with Deadlock: graph f…

  Lavanyasri

  18 replies

  14 years, 5 months ago

  By: SpringTownDBA

• What other alternatives are out there for Read-Only Reporting Database

  Hi Everybody, We are currently using log shipping to create a standby database that we use for repo…

  Isabelle2378

  5 replies

  14 years, 5 months ago

  By: Isabelle2378