SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Identify SQL Licensing Configuration

  I am trying to see if there is a programmatical way through SQL or Windows to identify the type of …

  gbargsley

  3 replies

  14 years, 10 months ago

  By: Meet George Jetson

• Help --User going dormant instead of disconnecting

  On a database on a SQL Server 2005 server we have some synonyms that are for tables in a database t…

  Ellen-477471

  4 replies

  14 years, 10 months ago

  By: bridgt01

• complex query

  wht will be the query to find all the menu available in menu id 1?... any help? -- master table --…

  BeginnerBug

  2 replies

  14 years, 10 months ago

  By: Andreas Goldman

• Service Broker

  Hi, I'm looking good artice / good video about Service Broker. Can anyone help?

  Little Nick

  3 replies

  14 years, 10 months ago

  By: Little Nick

• SQL on Cluster Self-restarts and communication link failure error in event log

  This is a question and answer post, as I have spent about week searching for answers on and off lin…

  TrailRunner

  1 replies

  14 years, 10 months ago

  By: TrailRunner

• Need Calculation Performed Without Modifying Base Table(s)

  Hello, Problem: We have a database that splits records based on UnitCost and rounding. What occurs…

  btodd 61953

  9 replies

  14 years, 10 months ago

  By: btodd 61953

• DATEFIRST setting oddity

  Alright, Specs time: Using SQL Server 2k5 version: 9.00.3042.00 I was messing around with DATEFIRST…

  Evil Kraig F

  8 replies

  14 years, 10 months ago

  By: Evil Kraig F

• No option available to create subplan SQL Server 2005

  SQL Server 2005, Windows Server 2003, Standard Edition, Service Pack 2 While in Management Studio I…

  JohnWSmith

  15 replies

  14 years, 10 months ago

  By: Meet George Jetson

• Scheduled Backup and Restore to a different server

  Hi all, I was after some free advice. I'm fairly new to SQL and have been tasked to solve a little …

  andy3660

  2 replies

  14 years, 10 months ago

  By: andy3660

• Extracting time from string

  I have a varchar field with strings of numbers and letters. Somewhere in the string is a 24 hour t…

  chrismat

  3 replies

  14 years, 10 months ago

  By: Scott Coleman

• SQL Server 2008 Login Error

  Hi All, Below error coming during SQL Server 2008 Login ["A network related or instance specific er…

  Sanjay Thakur-488205

  4 replies

  14 years, 10 months ago

  By: Meet George Jetson

• student --marks query---sql

  Hi Everyone , This is a general query about sql. how to find the 3 rd highest marks in a MARKS col…

  hemanth T

  1 replies

  14 years, 10 months ago

  By: steveb.

• getting rows in alphabetic order because of char(39)

  Hi, This is my table.When u run the stored procedure we will get first row as AgentsScheduled as pe…

  naresh0407 93367

  5 replies

  14 years, 10 months ago

  By: GSquared

• SQL 2005 SP4 Release Date

  Good morning all, Is there any update on exactly when SP4 will be released? It's Q4 now. Thanks, L…

  lorisj33

  1 replies

  14 years, 10 months ago

  By: Meet George Jetson

• Error Performing SQL Shrink Log File

  Hi my name is Ryan, I have a database let's just called Data_All_DB. In a glance my size descriptio…

  ryan.reinaldi

  15 replies

  14 years, 10 months ago

  By: ryan.reinaldi