SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Failed to Notify Operator via Email

  1.Database mail is enabled 2.SQL Server Agent's alert system is configured 3.Database mail is enabl…

  manju.ccc

  2 replies

  13 years ago

  By: manju.ccc

• Ideas about Error 266 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0."

  I had to deal with this whilst writing a unit test framework for my TSQL Create simple procedure th…

  DataDog

  4 replies

  13 years ago

  By: adavtyan

• Uninstalling a SQL 2005 Cluster on Windows 2008

  I have successfully uninstalled SQL 2005 on both nodes of a two node Windows 2008 cluster and am at…

  Stu20

  1 replies

  13 years ago

  By: Stu20

• Is UPDATE FROM only available in SQL 2005?

  I rarely have to write an UPDATE query that uses more than 1 table. Today I did, and I came across…

  Rod at work

  18 replies

  13 years ago

  By: Mark Cowne

• Error 7320 while executing a MDX through Linked Server on SQl server 2005

  while executing a MDX through the Linked Server on a 64 bit SQL server 2005 it's throwing Error 732…

  kasisriharsharao

  1 replies

  13 years ago

  By: ojha.binayak

• Background process and SINGLE_USER

  Hi, we have a critical heavy loaded task which is running through all user databases of our SQL-Ser…

  PatrickSimons

  2 replies

  13 years ago

  By: walidkilani

• Process ID was killed by host process ID

  We have one job that job was killed by hostname SVR1, host process ID 30416 this job was configured…

  sri2015

  1 replies

  13 years ago

  By: RBarryYoung

• Help With Foreign Keys

  Hello, I wondered if someone could explain to me how to setup foreign keys that cascade on update f…

  david_a_wallace

  11 replies

  13 years ago

  By: Sean Lange

• Database Data not saving to the correct MDF Files

  Hi I was wondering if anyone has come across the following issue before. We recently moved locatio…

  Andrew Dove

  3 replies

  13 years ago

  By: Gail Shaw

• Linked server query column needed

  Hello all, Pardon my ignorance ... but i'm trying to add a column in my linked server query which i…

  johnnyrmtl

  3 replies

  13 years ago

  By: johnnyrmtl

• Database Size

  In My Production server i am facing following problem. Totally my database size showing 134 GB.But …

  vs.satheesh

  2 replies

  13 years ago

  By: Gail Shaw

• Not able to view standard reports in management studio

  Able to view standard reports when do right click on server name or database name in one box but no…

  Ganeshkumar005

  2 replies

  13 years ago

  By: Ganeshkumar005

• Insufficient permissions to access Reporting in Management Studio & web reports

  Hi all, I've just added SQL Reporting Services to our SQL 2005 server, but cannot access the web in…

  chris.howard 22022

  9 replies

  13 years ago

  By: chris.howard 22022

• Single sql column defined as 2 separate indexes-unique and non unique?

  HI, I have a database that was set up by a vendor application. I have discovered at least 10 occur…

  Juanita

  16 replies

  13 years ago

  By: Orlando Colamatteo

• Error in ship transactional log

  I'm trying to implement a ship transactional log between two servers. when the "copy" job run in my…

  manju.ccc

  1 replies

  13 years ago

  By: Ant-Green