SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• permissions to sp / table

  Hi, If I grant execute permissions to a procedure, do I also need to grant permissions to any under…

  Al Cook

  3 replies

  14 years, 5 months ago

  By: Lowell

• Querying XML - Quick help required and material recommendations

  Apologies for this i realize its not the best practice, but i dont have time to learn the in's and …

  winston Smith

  3 replies

  14 years, 5 months ago

  By: GSquared

• script some insert statements from some of the rows in an existing table

  I would like to generate multiple insert statements like below that l need to run later. insert ta…

  sqlfriend

  7 replies

  14 years, 5 months ago

  By: sqlfriend

• Using views in Report Builder 2.0 - relationships not detected?

  Hey all, I'm working with SQL Server Report Builder 2.0 for the first time, and so far I'm enjoying…

  Tim Mitchell

  5 replies

  14 years, 5 months ago

  By: Krishna-400391

• Bit Tricky

  Hi, I am working with my friend on his vb project regarding schedule task assignment. Managers wil…

  gksharmaajmer

  11 replies

  14 years, 5 months ago

  By: gksharmaajmer

• Need nudge with logic to use in dynamic SQL statement to delete duplicate FKs

  Can someone give me a nudge with the logic to use to identify only the FKs with trailing numbers? I…

  KoldCoffee

  13 replies

  14 years, 5 months ago

  By: Jeff Moden

• Error 9002: The Transaction Log for MSDB database is full.

  Error 9002 The Transaction Log for MSDB database is full. log_reuse_wait =1 log_reuse_wait_desc= CH…

  forsqlserver

  42 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• Audit access to column on a table

  Has anyone implemented a process to audit users/logins accessing a column on a table -- or access t…

  Express12

  1 replies

  14 years, 5 months ago

  By: Express12

• Unable to drag and drop components in SSIS

  [font="Tahoma"] Hello Friends, I am unable to drag and drop components from Tool Box into Control F…

  MuraliKrishnan1980

  3 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• sql server agent jobs(scheduler)

  i want to know usage of sql agent jobs how the functionality work pls priovide the direction

  kond.mohan

  2 replies

  14 years, 5 months ago

  By: Iulian -207023

• Soft numa, is this MS article incorrect

  http://msdn.microsoft.com/en-us/library/ms345357.aspx Im trying to get a grip on soft numa with the…

  winston Smith

  2 replies

  14 years, 5 months ago

  By: Gail Shaw

• error in excel source

  hi when i try to open my excel source> name of the sheet its show "unspecified error" how to sol…

  sql Anand

  1 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• Need Query

  Hi Friends, How can i get all the user defined stored procedures, views, and indexes..? what would…

  Charmer

  1 replies

  14 years, 5 months ago

  By: danielfountain

• Trim sql 2008 Analysis Service Memory use....

  We have a single server with Sql 2008 installed. We have trimmed its memeory to free up RAM for the…

  Barkingdog

  3 replies

  14 years, 5 months ago

  By: Devendrakumar

• SQL Server 2012 CTP

  Download link for SQL Server 2012 CTP3 is gone from microsoft.com/sqlserver. Does this mean a new v…

  PHXHoward

  7 replies

  14 years, 5 months ago

  By: Devendrakumar