SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• @@Servername and Serverproperty('servername') do not match

  I used the script listed below to rename a 2005 SQL Server. However serverproperty('servername') s…

  Aneyshia

  3 replies

  13 years, 7 months ago

  By: Steve Jones - SSC Editor

• How to get text output from a scheduled sp on 2005 to a file

  We don't have SSIS installed so is there any way a Job can be run to direct the output from an exec…

  Random Visitor

  4 replies

  13 years, 8 months ago

  By: Random Visitor

• Almost a Delimited Split kind of Join?

  Wow I'm having a lot of trouble with this one today. I'm working with existing DDL, so I cannot cha…

  Lowell

  4 replies

  13 years, 8 months ago

  By: ChrisM@home

• copy the select results into text file

  🙂

  purushotham.k9

  10 replies

  13 years, 8 months ago

  By: savethytrees

• SQL Server Collation vs ASCII Table sort

  Hi everybody , I have an issue about SQL Server Collations. Our owned programmed database use Case…

  diallonina

  1 replies

  13 years, 8 months ago

  By: SQLRNNR

• Extreme wait-time when taking a SQL Server database online

  Hello, I don't understand something. I have a database (about 5 Go) on SQL Server 2005 SP3 Enterpri…

  ERIC CRUDELI

  11 replies

  13 years, 8 months ago

  By: george sibbald

• The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

  Can someone please help me. I executed these Commands EXEC sp_configure 'show advanced options', 1;…

  raym

  12 replies

  13 years, 8 months ago

  By: Syamjith

• Error:5184 When creating db specyfying another loations for log file

  SQL Server 2005 SP2 on a cluster node with two members. OS is Windows 2003 Server SP2. This the pro…

  j mangual

  4 replies

  13 years, 8 months ago

  By: siva_krishnan

• Corrupt T-Sql Script

  Hi All, I've wrote a T-Sql script last week, that this morning has decided to corrupt. I know that …

  ldorian81

  2 replies

  13 years, 8 months ago

  By: Grant Fritchey

• Data Collection Questionnaires

  Greetings Super Experts, I need your expertise assistance, please. We are tasked with coming up wit…

  simflex-897410

  5 replies

  13 years, 8 months ago

  By: simflex-897410

• Database update statistics job overrunning....

  Hi, Hopefully someone can advise and make things a bit clearer for me. I have a database with three…

  rarara

  6 replies

  13 years, 8 months ago

  By: Jack Corbett

• Partitions, SANS and Logical Drives Setup

  Database: SQL Server 2008 or 2005 The database will only be used for reporting Data will be impo…

  SQLH

  6 replies

  13 years, 8 months ago

  By: Gail Shaw

• Run an Excel Macro from SQL Server 2005

  I need to export some data to Excel and then run 1 or more Excel macros. Export to Excel is easy en…

  paragdalal

  3 replies

  13 years, 8 months ago

  By: skpanuganti

• DR Solution

  We have a production server which is 2 node cluster. DR is proposed to have stand alone machine, wi…

  csuresh79

  5 replies

  13 years, 8 months ago

  By: george sibbald

• Kill procceses

  I am trying to detach a database. I have killed all processes, but it still gives me an error sayi…

  djustice 20821

  11 replies

  13 years, 8 months ago

  By: rmcmanus05