SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• cursor inside a cursor

  I have declared a cursor inside another cursor. And for all set of outside cursor ID i want to chec…

  sachinrshetty

  3 replies

  15 years, 5 months ago

  By: ColdCoffee

• Are "SELECT Statements" cached?

  I know that a stored proc is cached after it is executed and one can neutralize the impact of that …

  Barkingdog

  2 replies

  15 years, 5 months ago

  By: Barkingdog

• SQL 2005 Service Pack 3 client

  I am planning a SQL Server 2005 SP3 upgrade from SP2. What is the impact of not upgrading the clie…

  Bill "Bojangles" Robinson

  3 replies

  15 years, 5 months ago

  By: Bill "Bojangles" Robinson

• Service Broker

  Any good links or books on Service Broker. There is a neeed in our company to do the datawarehousel…

  SqlSavvy

  3 replies

  15 years, 5 months ago

  By: LutzM

• To find the user who shut down the SQL Server

  Hi All, I am having a very urgent issue. Someone have shut down the SQL Server database and I ne…

  Venkatesan Prabu

  1 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• what is the difference between Implicit, Explicit, Ref Cursors?

  Hi, I came across a question about the different type of cursors (Implicit, explicit, ref curosors)…

  Suresh Arumugam

  10 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• How to Re-Use a computed column in SQL View?

  Hello Experts, Is there a way we can reuse the computed column in a view... For example, I have a c…

  heyzain

  2 replies

  15 years, 5 months ago

  By: heyzain

• Unable to change the File Growth Option in SQL 2005

  Hi, We have tried to change the TLog file growth option in SQL 2005 from Restricted to UnRestricted…

  sbvenkatesh77

  1 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• Product Level is insufficient while using Import Export Wizard

  Hi there, I am trying to export a table to a (txt) file using the Import Export wizard in Sql Serve…

  bladerunner148

  3 replies

  15 years, 5 months ago

  By: bladerunner148

• Tempdb Log Question

  One of my Job was failing couple of times on its defined schedule and the reason for its failure ac…

  srawant

  4 replies

  15 years, 5 months ago

  By: Dragoberto INN

• How to Pass an array from the front end (say .NET) into a Stored Procedure?

  How is it possible? is there any way that we can make this happen? Pramod

  pramod_yg

  5 replies

  15 years, 5 months ago

  By: WayneS

• Validate column - by Column value while Import data from CSV File?

  Hi, I have a requirement that imports CSV file data to Sql server tables. Steps need to do: …

  srisagar_p

  3 replies

  15 years, 5 months ago

  By: Ron McCullough

• Creating a Letter Style e-mail in HTML format using sp_send_dbmail

  Hi All, I've been using sp_send_dbmail succesfully within an update trigger to send simple t…

  jfc-582176

  7 replies

  15 years, 5 months ago

  By: rmanjunath_cse

• BOL - Where to find Details on info returned by SYS.DM_DB_INDEX_USAGE_STATS

  Does anyone know where in BOL or somehwre else like MSDN, one can find detailed explinations on the…

  YSLGuru

  6 replies

  15 years, 5 months ago

  By: dmoldovan

• Calling a website...

  I am trying to create a job that will determine the round trip time from SQL to a website and back …

  Ray Laubert

  7 replies

  15 years, 5 months ago

  By: Lowell