SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to i find out the user when stored procedure last modified

  Hi All, how to i find out the user when stored procedure last modified i am able to get the list of…

  cooljagadeesh

  5 replies

  13 years, 5 months ago

  By: Grant Fritchey

• Steps to verify database diagram

  In one of our project, where i recently joined , team leader gave me database diagram to verify whe…

  Bhuvnesh

  4 replies

  13 years, 5 months ago

  By: Grant Fritchey

• is there any difference between query run time and execution time

  hi, is there any difference between query run time and execution time Thanks, Dastagiri

  dastagiri16

  1 replies

  13 years, 5 months ago

  By: Grant Fritchey

• cluster upgrade

  iam new to cluster environment can any one send me the approach how to upgrade SQL 2005 cluster to …

  ramyours2003

  3 replies

  13 years, 5 months ago

  By: Arun Yadav

• IF EXISTS Logic

  Hi Team, I am having a temp Table "@Temp_Table" and a physical Table "St_Value" @Temp_Table Contain…

  Minnu

  1 replies

  13 years, 5 months ago

  By: Eugene Elutin

• SQL STACK DUMP FILE

  SQL has created a stack dump file of 2.5 GB I have copied the file elsewhere is it OK for it to be …

  Bobby Glover

  2 replies

  13 years, 5 months ago

  By: emile.milne

• Mirroring Endpoint Port Number

  Dear, I want to configure database mirroring with automatic failover option. That is why I want to …

  shohelr2003

  8 replies

  13 years, 5 months ago

  By: shohelr2003

• Read data from Excel and while inserting getting data type error

  Hi, I am reading data from excel sheet and inserting in to temp table something like this SELECT * …

  subramani.rudrappa 78855

  9 replies

  13 years, 5 months ago

  By: Koen Verbeeck

• sql query implementaion

  hi friend i have a small doubt in sql server plz tell me how to solve table data contins like i…

  asranantha

  6 replies

  13 years, 5 months ago

  By: asranantha

• locking in DML statement

  Hi what is the difference between IX and X lock on a table?(Totally I plus s,x,u,etc.) according to…

  mah_j

  6 replies

  13 years, 5 months ago

  By: Paul White

• pages

  HOW MANY datapages in sql ?

  ramyours2003

  14 replies

  13 years, 5 months ago

  By: sanket kokane

• Running SSIS packages

  I have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the sec…

  sagar0838

  1 replies

  13 years, 5 months ago

  By: robert.gerald.taylor

• Replace a substring using Powershell

  Hi, I've got a job, one step of which adds some articles into a publication: $DBScriptFile = "C:\Sc…

  Roust_m

  1 replies

  13 years, 5 months ago

  By: Roust_m

• why i can't grant any permission to current server?

  hi i create a user in sql server 2008,i login with it .(it has sysadmin and public server role) wit…

  pooya1072

  1 replies

  13 years, 5 months ago

  By: Lynn Pettis

• Linked Server Insert truncates string

  Hello, when I try to insert data through linked server the data is truncated to 24 chars, INSERT […

  sporoy

  7 replies

  13 years, 5 months ago

  By: Richard Reukema