SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Hierarchy Query

  I have a hierarchy setup to store product categories as below : ID int ParentID int CategoryName va…

  cdh-727733

  29 replies

  14 years, 7 months ago

  By: fahey.jonathan

• SQL Parse Function always returning the same data - why?

  I have the following SQL parse Function: USE [JobPortalIAN] GO /****** Object: UserDefinedFunctio…

  isuckatsql

  7 replies

  14 years, 7 months ago

  By: Ron McCullough

• Upgrade SS2K5 to 2K8R2 for default and named instances

  I'm tasked with upgrading the two instances of SQL Server 2005 on the same Windows server to 2008R2…

  SQLDCH

  6 replies

  14 years, 7 months ago

  By: Revenant

• Manangement Studio 2000

  Is the 2000 version of Management Studio bundle in SQL?

  neal 38916

  1 replies

  14 years, 7 months ago

  By: spaghettidba

• Cursorfetch error message - SQL Newbie - PLS advise

  I have the following - and I cannot understand why I receive the error message: Cursorfetch: The nu…

  2prowler

  3 replies

  14 years, 7 months ago

  By: 2prowler

• Exec sp in response to data changes (w/o triggers)?

  Without the use of triggers, is there a way to execute a stored procedure any time data change in u…

  peter 82125

  5 replies

  14 years, 7 months ago

  By: Matt Miller (4)

• PERFORMANCE Tuning

  Hi All, I am trying to tune the code in the sp here, which I uses around 10 times daily.. CREATE TA…

  bvsc

  14 replies

  14 years, 7 months ago

  By: bvsc

• Switching partitions

  Is there a way around this restriction "Destination table cannot reference the source table using F…

  Lexa

  2 replies

  14 years, 7 months ago

  By: Lexa

• Change logins causing system reboot

  I've got a server with the following @@version return: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2…

  graymer

  2 replies

  14 years, 7 months ago

  By: graymer

• sql query execution time & rowcount, without results

  there is a complex SELECT query, that takes long to run, and returns lot of rows. i want to find th…

  sqld-_-ba

  3 replies

  14 years, 7 months ago

  By: LutzM

• Improve select from really large table

  Hello all I have a very large table ( 338782585 rows, 552 gb ) , usually it is "fast" to retrieve d…

  ricardo_chicas

  5 replies

  14 years, 7 months ago

  By: Evil Kraig F

• Why could I not disable a windows account in SQL Server

  I have sa on a server. When I tried to disable a Windows account, I came acroos the following error…

  SQL ORACLE

  3 replies

  14 years, 7 months ago

  By: Nicholas Cain

• SQL takes longer time in I/O request

  I came across the following errors in SQL logs. SQL Server has encountered 3 occurrence(s) of I/O r…

  SQL ORACLE

  3 replies

  14 years, 7 months ago

  By: Nicholas Cain

• SQL Server Agent Not sending notification emails

  I have setup a database mail profile and account. I am able to send test emails to my work email by…

  Siva Ramasamy

  3 replies

  14 years, 7 months ago

  By: Siva Ramasamy

• sp_addsrvrolemember to add an account to sysadmin role of an instance.

  I have written a T-SQL code which outputs the below lines of codes. DECLARE @ServiceaccountName1 va…

  Chandu-212374

  1 replies

  14 years, 7 months ago

  By: spaghettidba