Administering

• Topics

  Started by

  Posts

  Last post

• sp_addartcle fails

  Hi, I am trying to automate replication creation. I am running the below code to add two articles …

  Roust_m

  4 replies

  5 years, 9 months ago

  By: Daniel Adeniji-180202

• SSIS - How to Set Output column width to varchar(max)

  I have an SSIS project that works fine on files smaller than 8k. When i use a file larger than 8k, …

  isuckatsql

  5 replies

  5 years, 9 months ago

  By: theobellash

• How can I export all table names plus column names from sql?

  Hi, I have to list all the tables in my database, plus the column names in each, and how they all l…

  Jules

  13 replies

  5 years, 9 months ago

  By: Sue_H

• sql express 2005 database has dissapeared after restore.

  This is live, old I know, but I really need advice. So I had a corrupt db.  Backups all screwe…

  snomadj

  6 replies

  5 years, 9 months ago

  By: Steve Jones - SSC Editor

• how to connect mssql with php

  Hii friends i am getting an error Warning: mssql_connect() [function.mssql-connect]: message: Login…

  nafeeza

  3 replies

  5 years, 10 months ago

  By: nima1234

• Transaction Log File size not reducing after transaction log backups

  Hi all, I've seen this topic discussed a million times in various blog posts and forum posts, but I…

  kramaswamy

  6 replies

  5 years, 10 months ago

  By: Lynn Pettis

• Types of DBA's ???

  Can any of you gentlemen tell me totally how many types of DBA's exists for an organization or over…

  vamsi056

  22 replies

  5 years, 11 months ago

  By: jliu 81028

• I can't figure out how a user is logging in!

  I have a 2005 server with several Windows individuals and group logins. One user in particular who …

  C-M-A

  3 replies

  5 years, 11 months ago

  By: Chris Harshman

• Error on Performance Counters disabled after adjusting Service accts permissions

  Our SQL service account was incorrectly a Domain admin account. As per best practices and give onl…

  jsheldon

  7 replies

  5 years, 11 months ago

  By: Jamie-2229

• Linked server for Oracle

  Hi, I am having this weird problem with Oracle linked server on SQL 2005 x64. I have installed Orac…

  Bhavana-251907

  19 replies

  5 years, 12 months ago

  By: mohanbabu.s

• The client was unable to reuse a session with SPID XX, which had been reset for connection pooling.

  Hi Guys, Need your help! We are receiving the below errors more frequently now. When ever we get th…

  gurbirrataul

  4 replies

  5 years, 12 months ago

  By: SQL ADMIN 79

• Auditing failed login attempts

  For reading audit files for reporting Failed login attempts . Need the connection event info includ…

  shannu_anand

  3 replies

  6 years ago

  By: Steve Jones - SSC Editor

• Manually Manage Service Master Key possible?

  Hi All,Is it possible to manually Manage the Service Master Key rather than use an expensive HSM? W…

  tane461

  2 replies

  6 years ago

  By: almendarez13

• How to Schedule a SQL Trace ?

  All, I need to schedule a sql trace on Profiler.I see a stop time but no start time.Accordin to msd…

  LOOKUP_BI-756009

  23 replies

  6 years ago

  By: rcf64

• how to validate if an Index has been disabled?

  while looking over my indexes... (after which i have already disabled) i couldn't find a way to see…

  neotokyo

  4 replies

  6 years ago

  By: Lynn Pettis