Administering

• Topics

  Started by

  Posts

  Last post

• Getting error while installing SQL Server 2005 on Windows Server 2003 SP1

  TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup failed to mo…

  shahm10

  1 replies

  17 years ago

  By: Gift Peddie

• Way to delete/add entries to Microsoft® SQL Server™ log file

  Hi All, Is there is any way to add/delete entries from SQL Server log files? This information helps…

  ankur_libra

  12 replies

  17 years ago

  By: Matt Miller (4)

• Database Mirroring Problem

  Hi all, I have a problem where synchronous mirroring without witness is causing a lot of system ove…

  SQLbee

  3 replies

  17 years ago

  By: Jeffrey Williams

• insert data

  how can we insert rows from a table XYZ of one database to another database table XYZ

  shanila_minnu

  5 replies

  17 years ago

  By: Russel Bell

• Include select as a parameter in Stored proc

  I am not sure how to explain this,, but i'll give it a go. I have a stored procedure ee_updatestatu…

  ss-457805

  7 replies

  17 years ago

  By: Buxton69-502449

• backup table

  how can we take a backup of table in a database

  shanila_minnu

  7 replies

  17 years ago

  By: Russel Bell

• Configure a SQL Server alias via VBScript

  Can I setup a SQL Server alias via VBScript or similar? We have a large number of aliases in use a…

  Ian_McCann

  2 replies

  17 years ago

  By: Ian_McCann

• Query Difference

  Does following query returns the first record from the table? SELECT TOP 1* FROM TicketActivity I t…

  MichaelJasson

  9 replies

  17 years ago

  By: Adi Cohn-120898

• Not able to start sqlserver default instance in sqlserver 2005

  Hi i Not able to start (automatically) sqlserver default instance in sqlserver 2005 every day man…

  sivark1

  6 replies

  17 years ago

  By: Brandie Tarvin

• I updated couple of rows in a table wrongly

  I updated couple of rows in a table wrongly. How to rollback the table without using retore db opti…

  SQL Dev-938873

  2 replies

  17 years ago

  By: Brandie Tarvin

• Primary Filegroup Full

  Hi, For one of my databases, I am getting a message the following message: Could not allocate spac…

  Sandhya-371593

  3 replies

  17 years ago

  By: Brandie Tarvin

• How to handle Collation errors when joining 2 tables of different databases

  Hi All, I have 2 databases with different collations, when i try to join them it shows me the colla…

  akash.suryan

  7 replies

  17 years ago

  By: wfagg

• What to look for to find indexes not used

  I have this query which i got by googling: select iv.table_name, i.name as index_name, iv.seeks + i…

  ss-457805

  4 replies

  17 years ago

  By: hi_abhay78

• how to convert mysql database in mac os to mssql in windows

  Hi i want to know the process how to convert mysql database in mac os to mssql in windows is it…

  sivark1

  2 replies

  17 years ago

  By: John H Marsh

• How to convert column names to upper case in all tables

  Hi All, I want to convert all the column names to upper case in all the tables and i have a lot of …

  anilpinnamaneni

  6 replies

  17 years ago

  By: anilpinnamaneni