Administering

• Topics

  Started by

  Posts

  Last post

• The description for Event ID ( 18265 ) in Source ( MSSQLSERVER ) cannot be found

  Hi, We have SQL Server 2005 EE x64 with SP3 and configured log shipping to run the log backups ever…

  Mani-584606

  5 replies

  16 years, 1 months ago

  By: Matt Miller (4)

• How to remove / delete multiple logins

  I deleted the database, but now have 100+ logins left on the SQL Server. Is there some kind of scri…

  koln

  7 replies

  16 years, 1 months ago

  By: Ron McCullough

• The time stamp counter of CPU on scheduler id 5 is not synchronized with other CPUs.

  Hi, I received the following error. The time stamp counter of CPU on scheduler id 5 is not synchron…

  purushotham_vandamsetty

  1 replies

  16 years, 1 months ago

  By: DB_Newbie2007

• how to find out who dropped a database

  database droppped by script. has since been restored, any way I can find out which user done it? sq…

  Hughesie

  7 replies

  16 years, 1 months ago

  By: Hughesie

• Backup Restoration

  Hi Experts, Is it possible to restore latest differential backup after restoring an old full backup?

  VastSQL

  4 replies

  16 years, 1 months ago

  By: free_mascot

• Install SQL server 2005 developer edition

  Hi, I need to install SQL server 2005 on windows server 2003. While starting the installation proce…

  DBAsql-1046554

  3 replies

  16 years, 1 months ago

  By: Brandie Tarvin

• The definition of object '<stored_proc_name>' has changed since it was compiled.

  Running SQL 2005 Standard Edition, 64-bit, 28GB RAM assigned to SQL. We have 134 databases on this…

  owen983

  2 replies

  16 years, 1 months ago

  By: owen983

• alter a table using GUI without having db_owner access

  Hi All, Is it possible for a user to alter a table using GUI without having db_owner access to that…

  VRR

  2 replies

  16 years, 1 months ago

  By: matt stockham

• SQL Server is taking over 90% of RAM of the server

  Hello, I have a SQL Server 2005 Enterprise Edition with 8GB of RAM. The server is in database mirro…

  Satish-219904

  12 replies

  16 years, 1 months ago

  By: george sibbald

• After shrinking file it regrow again.

  I shrunk the file using following command but it regrow again. DBCC shrinkfile(file_capx1,1). It wa…

  balbirsinghsodhi

  6 replies

  16 years, 1 months ago

  By: balbirsinghsodhi

• Rebuild and Reorganize Indexes

  I have a Stored Procedure that is run after every full backup of my database. This Stored Procedure…

  MTY-1082557

  9 replies

  16 years, 1 months ago

  By: MTY-1082557

• Pros & Cons of setting the Initial Size of a Log File to its estimated Max growth

  PLATFORM: SQL Server 2005 (Ent Edit) For several months now I've been recording the changes in the …

  YSLGuru

  6 replies

  16 years, 1 months ago

  By: Brandie Tarvin

• Use multiple data files for large content database

  Hi, We have MOSS 2007 SP1 databases on sql server 2005 EE x64 with SP3. We have Separate drive for …

  gary1

  3 replies

  16 years, 1 months ago

  By: Brandie Tarvin

• SQL Server 2005 account running SQL Server services

  Hi, I need to make a script that deletes all the users (windows users) from a SQL Server 2005 in…

  river1

  5 replies

  16 years, 1 months ago

  By: river1

• C:\Programas\Microsoft SQL Server\MSSQL.1\MSSQL\Data .cert file

  Hi, every time i install a SQL Server 2005 instance, inside the C:\Programas\Microsoft SQL Server\…

  river1

  5 replies

  16 years, 1 months ago

  By: river1