SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• where can I query the 'Enable Mail Profile' value from the Agent properties

  Hi All, I'm looking to query (via SQL) the 'Enable Mail Profile' value from the Agent properties, …

  simon.dobner 32307

  4 replies

  11 years, 10 months ago

  By: simon.dobner 32307

• Error installing MS SQL Server R2 Enterprise (x64)

  Hi Everyone, Recently I attempted to upgrade from MS SQL Server to MS SQL Server R2. However I have…

  david.dartnell

  12 replies

  11 years, 10 months ago

  By: david.dartnell

• Perfomance due to foreign key

  I have a table with primari key. which is refrenced across 63 columns in 40 + tables Now when i tri…

  jagat.patel

  5 replies

  11 years, 10 months ago

  By: MMartin1

• Get the hierarchy orders(top to bottom) of the table

  Can we get the hierarchy orders of table Eg: 10 tables Table1 is master to table2 and so on till ta…

  yuvipoy

  12 replies

  11 years, 10 months ago

  By: pmadhavapeddi22

• How can I delete a duplicated table

  I created a new table but accidentally called a foreign key AgentsMasterID when it should have been…

  Doug Simmons

  6 replies

  11 years, 10 months ago

  By: Doug Simmons

• All CLR Objects - Unrestricted access?

  Hi, I verified one of the vendor database which was hosted 2 months back. There are total 96 CLR_SC…

  SQL Galaxy

  2 replies

  11 years, 10 months ago

  By: SQL Galaxy

• Changing server/db collation

  Hi all, We have a Dev server whose Collation Sequence must match that of our (soon to be ex) produc…

  Jake Shelton

  2 replies

  11 years, 10 months ago

  By: mosaic-287947

• Data Warehouse

  How easy is it configure and install a Data Warehouse in SQL Server 2008 R2?

  wak_no1

  2 replies

  11 years, 10 months ago

  By: a4apple

• Export to text file with quotes and pipes

  i have this script 'Exec Master..xp_Cmdshell ''bcp "Select column1, column2, column3 from table1" …

  M-Hol

  1 replies

  11 years, 10 months ago

  By: spaghettidba

• Running Totals Problem

  I need to calculate the running total for each individual in a dataset similar to the one below. cr…

  Neil Burton

  5 replies

  11 years, 10 months ago

  By: David Burrows

• Unable to sum column values

  Hi, I am using this below query to sum my column values. Query: select '$ ' + REPLACE( CONVERT(VARC…

  vigneshkumart50

  7 replies

  11 years, 10 months ago

  By: J Livingston SQL

• Linked server error

  I get an error as below on SQL server 2008. The linked server tests successfully: Msg 7391, Level 1…

  Aatish Patel

  4 replies

  11 years, 10 months ago

  By: Aatish Patel

• Can I convert a string to a time field ?

  Hi I have a field that is a string, but stores a time value as "09:45 AM" I need to do calculatio…

  jbalbo

  3 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Calling stored procedures in query

  Hi, Is it possible to use Stored Procedures inside query? I have SP with some results and is it pos…

  vigneshkumart50

  2 replies

  11 years, 10 months ago

  By: gbritton1

• In-Line Function to split string

  Good afternoon gents, I'm having a slight issue with a function i have created and the way it work…

  waxb18

  8 replies

  11 years, 10 months ago

  By: Jack Corbett