SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Retrieve specific flagged fields into select statement

  CREATE TABLE #tblProjects ( ProjectID int, Project varchar(50) ) GO INSERT INTO #tblProjects(Projec…

  webskater

  1 replies

  11 years, 2 months ago

  By: Sean Lange

• SSAS Role not working for all memberships

  I have an SSAS environment that has only one role with 8 people as members, the role is to limit a…

  BI_Baracus

  2 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Ideas for creating QA and Test environments with very limited DBA support.

  I’m looking for some ideas to try in order to provide our small department (about 35 to 40 people) …

  Vic Rauch-303403

  3 replies

  11 years, 2 months ago

  By: Vic Rauch-303403

• Sending attachment using Database Mail

  Currently, I am getting this error message when I try attaching a file at the location stated in th…

  Bridget Elise Nelson

  2 replies

  11 years, 2 months ago

  By: HanShi

• Unable to pass the select statement to cursor to get details across each databases.

  Hi, Unable to pass the select statement to cursor to get details across each databases. DECLARE @DB…

  SQL_Hunt

  3 replies

  11 years, 2 months ago

  By: SumLasty

• Recursive replace Japanese to English characters

  Hi there, I have a table with Employeename, companyname, companyaddress all in Japanese in a table …

  rash3554

  3 replies

  11 years, 2 months ago

  By: adaddio

• Add dollar to the result of floor value

  Hi, I am using this query to get the nearest value and rounding it. floor(Price*DollarPrice) as Do…

  vigneshkumart50

  2 replies

  11 years, 2 months ago

  By: Neil Burton

• Login Trigger Causing Deadlocks

  Background: In my environment historically people have obtained elevated user ID information and us…

  Stamey

  11 replies

  11 years, 2 months ago

  By: Stamey

• db created in sql server 2005 to Attach in sql server 2008?

  Hi I created a database in sqlserver 2005 . now I wants to attach it in sqlserver 2008. But I would…

  armm1388

  5 replies

  11 years, 2 months ago

  By: enriquemallon

• Populate a new table column using internal value

  Hi, I have a requirement to create a new table - MG_EDI_CONVERSION. The issue I am stuck on is to p…

  pwalter83

  3 replies

  11 years, 2 months ago

  By: ChrisM@Work

• Restore Transaction Log after RESTORE DATABASE [Cadence] WITH RECOVERY

  We have a database to which we want to restore a full back and then restore several logs. But betwe…

  ross.mason 49698

  13 replies

  11 years, 2 months ago

  By: enriquemallon

• Cascading data from one returned row to the next

  Hi, Can anyone one suggest an easy way of cascading certain fields from one returned record to the …

  itwhiz

  1 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Ho wto grant and revoke 'CREATE LOGIN' to a user?

  I need to temporary grant a permission to a user so he can CREATE LOGIN. And then revoke it. How to…

  SQL Guy 1

  3 replies

  11 years, 2 months ago

  By: SQLDCH

• DEADLOCKS on SELECT statements with UPDLOCK hint

  I'm getting deadlocks on the following Select statements which use an UPDLOCK hint, this is a third…

  bugg

  2 replies

  11 years, 2 months ago

  By: Ville-Pekka Vahteala

• OUTPUT in Stored Proc

  Hello, I Want to have an output from a stored proc. The output must be displayed in a msgbox in vb.…

  johndewitte

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson