SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Grant select, exec permission to SP, inline, scalar & table-values functions

  I need to grant a user to select & exec permissions to SP, inline, scalar & table-values …

  SQLisAwe5oMe

  5 replies

  13 years ago

  By: SQLisAwe5oMe

• Unique Constraint Across More Than One Column

  Hi, I have a table that contains, among other columns, 4 columns that contain the same type of data…

  dec_obrien

  1 replies

  13 years ago

  By: Sean Lange

• Database Mail

  I am trying to get my database to send emails but I can not get it to work. From everything I have …

  edward_hall76

  12 replies

  13 years ago

  By: tppromoter

• Suspended Commands on master db

  Hi I'm hoping someone will be able to cast some light on my current server issue. There are a numbe…

  ProofOfLife

  5 replies

  13 years ago

  By: harikasomireddy

• Search for partial text in text field

  There is a table Order in which one filed [Notes] as text data type. How to search a partial text s…

  adonetok

  2 replies

  13 years ago

  By: DiverKas

• How to delete the duplicate row without any unique value? please help

  I have a table of contacts that has no unique key on it. The users have entered multiple copies of…

  hydbadrose

  3 replies

  13 years ago

  By: ChrisM@home

• SQLPS vs SSMS

  Ran into a SNAFU. I have a simple script that will "create" creation scripts for any object in an …

  fundpc

  1 replies

  13 years ago

  By: Lowell

• Forgot sysadmin user password

  In a SQL server instance I have only SQL logins with sysadmin permission. Windows authentication ha…

  IT researcher

  5 replies

  13 years ago

  By: Lowell

• Backup taking too long after migration to SQL 2008 R2

  Hello, We recently migrated databases from SQL 2005 to SQL 2008 R2. It's a nice shiny hardware, muc…

  apat

  25 replies

  13 years ago

  By: Geoff A

• Sql server start as single user mode

  I started sql server instance using single user mode by changing start up parameters in sql server …

  IT researcher

  8 replies

  13 years ago

  By: SQL Show

• wich OS is better for slq server 2008 R2

  Iam creating a new windows server in the cloud (Dediserve), this will be a database server and I sh…

  webmaster 51012

  1 replies

  13 years ago

  By: Geoff A

• Pivot and grouping question

  I have a table with structure Education(edu_id, emp_id, school, degree) where an employee can have …

  emiranda 59653

  2 replies

  13 years ago

  By: emiranda 59653

• Which one is better?

  Here is sample code below: Both queries will retun same result. But I want to know which one better…

  kapil_kk

  4 replies

  13 years ago

  By: Ed Wagner

• Colulmn Reference

  CREATE TABLE [dbo].[GV_ReceivedOffice]( [ReceivedOfficeID] [int] IDENTITY(1,1) NOT NULL, [VoucherNo…

  kapil_kk

  6 replies

  13 years ago

  By: kapil_kk

• problem with stored procedure

  I have a table Create table SINHVIEN ( MASVnvarchar(20) not null, HOTENnvarchar(100) not nul…

  yennhi2812

  2 replies

  13 years ago

  By: yennhi2812