SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Real Time Project

  Hi, Can anybody provide me the actual real time project example. for example,in company how many da…

  daveriya

  2 replies

  15 years ago

  By: Bhuvnesh

• Using "Use" in stored procedure

  Hii all, my requirement is in a stored procedure I have to create a database dynamically and add so…

  Chow's

  4 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Trigger xml message when particular row value changes

  Hi I am trying to write trigger when particular row value changes say i have table ABC of 10 rows. …

  techlady

  1 replies

  15 years ago

  By: Sean Lange

• Database / Table Permissions

  Hi, What is the best method for restricting user access to a SQL database, we provide reporting in …

  gregorym

  11 replies

  15 years ago

  By: gregorym

• replication error converting date and/or time from character string

  hi, we are using transactional replication on an sql 2008 server. we try now to add a table to the …

  christoph schwarz

  6 replies

  15 years ago

  By: DavidBridgeTechnology.com

• Create a hierarchy drilldown

  Good afternoon, I would create a hierarchy dorilldown. I have a table, the father and son that I wo…

  tpm

  2 replies

  15 years ago

  By: tpm

• SQL 2000 connectivety to SQL 2008 database

  A vendor of ours, who supplies no SQL support, other than creating their databases, has most of th…

  Katherine Mitchell

  5 replies

  15 years ago

  By: Stegzy

• Drop all temp tables one time

  I used code below to drop temp table: IF OBJECT_ID(N'tempdb..[#temp1]', N'U') IS NOT NULL DROP TABL…

  adonetok

  6 replies

  15 years ago

  By: GSquared

• Probably very simple query

  This looks pretty simple on the face of it but I can't get my head around it. I have two tables tha…

  garethdyson

  4 replies

  15 years ago

  By: GSquared

• looking for an application that will monitor and alert on lack of data received by querying SQL DB ?

  For example i use a system that collects packets of information on socket 10001. 09:00 - 17:00 i wo…

  scott_lotus

  3 replies

  15 years ago

  By: scott_lotus

• Select Same row X number of times

  I am trying to do a monte carlo simulation within SQL I have a table containing unique product nu…

  Chancus Speare

  2 replies

  15 years ago

  By: Chancus Speare

• Versioning

  I am just wondering, is there any best practice in controlling the version of the stored procedure …

  sukino.li

  1 replies

  15 years ago

  By: spaghettidba

• Database size on disk jumped overnight

  We are running SQL Server 2008 Stnd 64-bit. The production database was about 100mb, but overnight…

  mxhxr

  3 replies

  15 years ago

  By: Bhuvnesh

• DTS ERROR

  Hi All, Below is the error that we are receiving while executing the sql server agent job from sql …

  balaji.ganga

  4 replies

  15 years ago

  By: Ali Bajwa

• convert(varchar(max),xmltypevariable) works only for 8000 chars

  Hi, print(convert(varchar(max),xmltypevariable)) works only for 8000 chars Is there any oher way to…

  kuppurajm

  2 replies

  15 years ago

  By: kuppurajm