Administering

• Topics

  Started by

  Posts

  Last post

• Data collection

  Hi, I need to collect tempdb object creation rate and size of temp db every half hour… Collect the …

  khushbu

  4 replies

  15 years, 4 months ago

  By: khushbu

• can't delete old back up file created by sql server 20005.

  Hi, I have encountred strange error on sql server 2005. I have big sql server database, that i…

  Sagar-636902

  15 replies

  15 years, 4 months ago

  By: Perry Whittle

• Running SQL Server 2008 with Local Admin or Domain user

  Hi, Last week we upgraded our system Sql server 2005 to Sql server 2008 Windows 2003 to Windows 200…

  ocolakoglu

  8 replies

  15 years, 4 months ago

  By: Carl Federl

• need to capture each and every error

  I need to capture each and every error when i run the job. Currently i am using error_message() par…

  curious_sqldba

  2 replies

  15 years, 4 months ago

  By: curious_sqldba

• he request failed or the service did not respond in a timely fashion.

  I am using MSSQL2005 when I restart the machine and trying to restart the SQl agent I get following…

  patilharshalv

  8 replies

  15 years, 5 months ago

  By: ozzy_rkr

• SQL Server Scheduler Performance

  Hi I am new to SQL server Scheduler. I would like to know if there is any benchmark or data on the …

  Mukunth-444251

  4 replies

  15 years, 5 months ago

  By: Mukunth-444251

• Adding SQL Server Agent Operators w/o GUI

  We recently decided to start using DBMail on our SQL servers mostly to notify for failed SQL Agent …

  SQLMD

  4 replies

  15 years, 5 months ago

  By: JohnnyDBA

• Stored Proc that creates excel business / financial reports

  Hi, Does anyone know of a good sproc that can formulate query results into an excel business report…

  MostInterestingMan

  6 replies

  15 years, 5 months ago

  By: keith.gerritsen

• CnstIsNotTrusted Returns True on Key Set with ON UPDATE

  I am experiencing a problem where I am adding a FK to a table and every time it is added with the O…

  JohnnyDBA

  5 replies

  15 years, 5 months ago

  By: JohnnyDBA

• Is it possible to supress certain types of errors?

  ie. log shipping errors. when 1 of my dr servers is taken down, 1000's of errors are generated. i…

  baby_cheeses

  2 replies

  15 years, 5 months ago

  By: baby_cheeses

• TempDB dedication.

  On one of my client's server. I have 3 databases A, B and C. A ---> Highly transactional B ---&g…

  Bhuvnesh

  5 replies

  15 years, 5 months ago

  By: magasvs

• Replication setup

  Hi All, We are setting up replication between 2 systems whose IP addresses are like 3.183.x.x and 3…

  Raghavender Chavva

  1 replies

  15 years, 5 months ago

  By: magasvs

• SET QUOTED IDENTIFIER in JDBC connection string

  I have an app that connects to a SQL 2005 database with JDBC. I have added some indexed views in t…

  Ken Davis

  2 replies

  15 years, 5 months ago

  By: Ken Davis

• Using aliases

  Hello all, The databases on my old server are going to be moved to a new server. In order to minimi…

  H-122523

  11 replies

  15 years, 5 months ago

  By: Anonymous

• Best method to add logins

  Hi, There was some problem going on the server and we had to reinstall the OS, after that we se…

  Skybvi

  9 replies

  15 years, 5 months ago

  By: Skybvi