SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• sql cluster install windows cluster offline

  I was trying to install a named SQL CLuster 2008 R2 instance on Windows 2008 R2 cluster. I found wa…

  didier41

  4 replies

  15 years ago

  By: Warren Peace

• Sending batches of SPs at one time from Application

  The developers I am working with are taking to the idea of stored procedures which is great. Probl…

  JKSQL

  15 replies

  15 years ago

  By: Orlando Colamatteo

• Questions about User-Defined Function which return Table-Value

  I have a table Customer like: id Name Surname ------------------------…

  thinknight

  1 replies

  15 years ago

  By: Sean Lange

• Trouble with Linked Server

  I added a linked server (both servers are in my domain) and the connection tests successfully. I c…

  janderson0306

  3 replies

  15 years ago

  By: janderson0306

• How to delete an offline datafile

  Hello all I really need to remove some data files, but they are offline and the commands that I kno…

  ricardo_chicas

  9 replies

  15 years ago

  By: Orlando Colamatteo

• Help EXEC inside SP not working

  Please take a look at this: ALTER PROCEDURE [dbo].[P_SENDEMAILNOTIFICATION] @Days INT = 0 AS BEGIN…

  euroray

  13 replies

  15 years ago

  By: Welsh Corgi

• INSERT INTO Question

  Hi: I am trying to insert data in to a database. Most is static, but some is data driven. I canno…

  steve.anderson 7639

  15 replies

  15 years ago

  By: steve.anderson 7639

• SqlCacheDependency - which version of SQL Server supports it?

  I have been trying to get SqlCacheDependency to work in SQL Server Express 2008 and now SQL Server …

  ca44

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Index creation on lookup table

  Our lookup table contains only 10 records. But the transaction table, which has referenced the look…

  Pothiraj R

  5 replies

  15 years ago

  By: Ninja's_RGR'us

• SQL Agent Job failing mysteriously

  Hi Guys, I have an issue where my scheduled job just seems to fail sometimes for no reason. Here is…

  stormsentinelcammy

  9 replies

  15 years ago

  By: stormsentinelcammy

• manually do windows update patching.

  Hello every , i know some of you might say that its a sql server forum not windows.. but i am a sq…

  BoobyB

  2 replies

  15 years ago

  By: BoobyB

• Killed a PID, in rollback now but.....

  OK, I had a user that needed me to kill their PID/session. The table is pretty big, 1.5million reco…

  Warren Peace

  1 replies

  15 years ago

  By: Welsh Corgi

• Can we increase @query_result_width (size) when using MSDB.DBO.SP_SEND_DBMAIL (stored procedure)

  Hello All, I am getting problem when i am getting result of my user defined stored procedure I am u…

  vishal_mca2005

  1 replies

  15 years ago

  By: Orlando Colamatteo

• SQL Newbie in Need of Help!!!

  I am in the process of creating a DB in SQL Server 2008 R2 and am having a couple of problems. I h…

  Aaron.Kelly 14475

  2 replies

  15 years ago

  By: Aaron.Kelly 14475

• Scalar Functions (UDF's) compile at runtime causing locks

  It appears that scalar functions compile at runtime and require a exclusive lock. We have stored p…

  SMAAG

  6 replies

  15 years ago

  By: TheSQLGuru