SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Moving SQL 2005 Cluster with 2 Cluster Groups to standalone

  We currently have a SQL 2005 active/passive Cluster with two cluster groups (I'll call them sql1 an…

  duane.rezac

  2 replies

  13 years, 7 months ago

  By: duane.rezac

• Does Sql Server clustering increasing data access performance?

  Clustering allowing one physical server to take over tasks and responsibilities of another physical…

  Jagz W

  2 replies

  13 years, 7 months ago

  By: Jeff Moden

• Foreign key constraints

  Hi there, I am currently in the process of checking all the indexes (in particular primary keys) a…

  Manie Verster

  8 replies

  13 years, 7 months ago

  By: Johan Bijnens

• send sms from sql server 2005 using smpp

  hi all. i need to configure our application to send an sms through sql server 2005.Is it possible t…

  hemanth T

  15 replies

  13 years, 7 months ago

  By: lozis6947

• Using Oracle's DECODE in SQL Server 2005

  Hi all, I have a decode statement in Oracle which takes the first character of the middle names to …

  jat1n

  1 replies

  13 years, 7 months ago

  By: spaghettidba

• Unary Plus -- Does BOL Lie about promoting tinyInt to smallInt?

  Microsoft documentation for the unary plus operator seems to me to be blindly cloned from the doc f…

  john.arnott

  5 replies

  13 years, 7 months ago

  By: Gail Shaw

• sp_send_dbmail

  I  have a trigger on a table that belongs to a non-dbo schema. The trigger is an after insert …

  Tenny-133977

  7 replies

  13 years, 7 months ago

  By: belgarion

• Split String question

  I have a table with two fields. IDValue 12345kais#2323232#def#323# THe requirement is to sh…

  SQL_Surfer

  2 replies

  13 years, 7 months ago

  By: Sean Lange

• I have installed sqlserver 2008 r2 in mixed mode now while going to login with sa and password with sql authetication i got the error

  A network-related or instance-specific error occurred while establishing a connection to SQL Server…

  dharmendra.israni

  5 replies

  13 years, 7 months ago

  By: dharmendra.israni

• 99 Bananas

  This one is driving me bananas. I am using SQL Server 2005. I have an oracle linked server throug…

  BC-353997

  3 replies

  13 years, 7 months ago

  By: pete.coales

• Is it possible to reduce retrieval time when using select * from [table]

  Apart from using NOLOCK

  Wicked

  6 replies

  13 years, 7 months ago

  By: Gail Shaw

• Sql server restarted or fail overed??

  Hi Guys, How can we conclude it was a "restart or failover" tat happend in sqlserver?Is there any…

  Mithra

  5 replies

  13 years, 7 months ago

  By: Mithra

• msdb is 45g sys.sysobjvalues is the issue

  What can I do about a 35g sys.sysobjvalues table? My msdb database is 45g and I have cleared backup…

  elizabeth.murray 24129

  9 replies

  13 years, 7 months ago

  By: elizabeth.murray 24129

• Really need help in writing data to a text file

  Hi Guys I have used oracle to create a flat txt file using UTL. I am now really struggling to unde…

  ram_kamboz2k7

  1 replies

  13 years, 7 months ago

  By: george sibbald

• Create an object

  Guys how do i create an object? It is called dbo.tm_dbs_get_directory. thanks

  ram_kamboz2k7

  1 replies

  13 years, 7 months ago

  By: Ron McCullough