SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Issue with Self Join

  Hi, This is my sample data with sample as ( select 1 as id, 20 as mark,0 as islabel union all …

  born2achieve

  6 replies

  12 years, 1 months ago

  By: Luis Cazares

• How to find out what the table relationship is

  Hi, I have started a new company and no one there is technical. They have advised me of a server an…

  SQL_Kills

  1 replies

  12 years, 1 months ago

  By: SQLRNNR

• DNS Aliasing issues for multiple instances on the same machine, same port

  Hey all, We recently migrated from a 3 instanced two node cluster to a single virtual machine. In o…

  Adam Bean

  6 replies

  12 years, 1 months ago

  By: Matt Crowley

• How To Capture ALL Data Retrieval Actions Regardless of Method

  How to construct a SQL Profiler Trace That Will Capture all Data Retrieval actions from a specified…

  YSLGuru

  3 replies

  12 years, 1 months ago

  By: YSLGuru

• Index structure comparison

  Is there any script to compare index structure inlcuding (Name , key cols and included cols ) among…

  SQL Severe DBA

  3 replies

  12 years, 1 months ago

  By: SQL Severe DBA

• Split a column into several columns by delimiter

  Hi, can anyone help me; I need a function/procedure where I can pass it a table name, column name a…

  nickwrenchster

  4 replies

  12 years, 1 months ago

  By: Luis Cazares

• a question about sys.server_principals and sys.server_permissions

  Hi guys I am testing users' rights in sql server. However; I would like to add another column to sy…

  Akayisi

  1 replies

  12 years, 1 months ago

  By: Ness

• Reset password for user with no login?

  Hi. I have a couple of database users that aren't mapped to any logins, and I've been asked to rese…

  Beatrix Kiddo

  4 replies

  12 years, 1 months ago

  By: Beatrix Kiddo

• Linked server query issues?

  Hi, Source - SQL server 2008 R2 64 bit (sp2 CU1) Destination - SQL server 2008 32 bit (sp3) I have…

  SQL Galaxy

  5 replies

  12 years, 1 months ago

  By: MyDoggieJessie

• How to define a server role that can see all that a sysadmin can see but cannot alter anything?

  Hi, In SQL Server 2008 is there a way a user can view everything (all databases, all logins, storag…

  Yusuf Bhiwandiwala

  4 replies

  12 years, 1 months ago

  By: Lowell

• Get number of rows successfully processed before executing a rollback

  Hi folks, is there any way to get the number of rows successfully processed before executing a roll…

  ghanshyam.kundu

  1 replies

  12 years, 1 months ago

  By: Eugene Elutin

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

  Hi, What I'm trying to achieve is a result set where each distinct dbpatid has a Paid column of 1 …

  mattech06

  3 replies

  12 years, 1 months ago

  By: mattech06

• Regarding Audits in sql server

  Hi All, I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:5…

  p.avinash689

  4 replies

  12 years, 1 months ago

  By: Jeff Moden

• Help with date in sQL

  I have date field named "[Latest Filled Date]" - format smalltimedate. I'm trying to do-If the "[L…

  dhananjay.nagarkar

  6 replies

  12 years, 1 months ago

  By: Jeff Moden

• restrict a specific login for a specific amount of time?

  Is there a way to restrict a specific login for a specific amount of time from connecting to a user…

  paulaalkz 9229

  6 replies

  12 years, 1 months ago

  By: SQLRNNR