SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• SELECT from openrowset (exec stored procedure)

  Using a technique I found on the web in various forums: SELECT * FROMOPENROWSET('SQLOLEDB', 'Serve…

  gdudley

  7 replies

  15 years, 10 months ago

  By: gdudley

• SQL Server Profiler locks tables?

  Hi All, I ran SQL Server Profiler on SQL Server Management Studio while a client was running anothe…

  umayal5

  9 replies

  15 years, 10 months ago

  By: umayal5

• What are the command line argumnets for SSMS (SQL Server Management Studio)

  ..for 2008 and or 2005 (I have both although I prefer 2008). I have found the BOL Page on the basic…

  YSLGuru

  13 replies

  15 years, 10 months ago

  By: villersk

• Query tuning ONLY FOR THE BRAVE & BOLD

  :-D:-D I've tried the DTW (Database Tuning Wizard) and it has no recommendations for tuning this q…

  davidsalazar01

  12 replies

  15 years, 10 months ago

  By: Dave Ballantyne

• Can a Select statement with no lock still causes locks?

  We had an issue recently where a query caused a lock on a database. Looking at the query, its a sel…

  huston.dunlap

  3 replies

  15 years, 10 months ago

  By: Elliott Whitlow

• Inserting records for missing values

  create table projdetails(ID varchar(10),year numeric(4,0),det1 numeric(10,2),det2 numeric(10,2)) Ta…

  rekha_sara

  1 replies

  15 years, 10 months ago

  By: Lowell

• Automatically change the Owner on SQL Agent job

  We have a number of maintenance plans built in Management Studio. We change the owner on the Agen…

  FordMom

  2 replies

  15 years, 10 months ago

  By: FordMom

• Source Code Control for SQL Server

  I need to know how to Control Source Code of SQL Server 2005 with Team Foundation Server. VS 2008 D…

  Atif-ullah Sheikh

  4 replies

  15 years, 10 months ago

  By: Atif-ullah Sheikh

• Converting 01.12.2005 into 1-Dec 2009 while insert

  I have a date like 01.12.2005 in excel sheet. While i make a query and then run this in sql to inse…

  pramod_yg

  4 replies

  15 years, 10 months ago

  By: pramod_yg

• Basic trigger help?

  Hi all (sorry if this applies to the wrong section), I'm having some trouble with a basic insert tr…

  gillabong

  11 replies

  15 years, 10 months ago

  By: gillabong

• Some general questions about Locks

  Hey guys, I'm trying to get a better understanding of locks...especially revolving around update st…

  huston.dunlap

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• Sql erro help :/

  need help with a error 2009-11-02 23:39:58 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_L…

  lamin.mha

  9 replies

  15 years, 10 months ago

  By: Florian Reischl

• Providing 2 numbers as hour numbers and third input number as minute and getting result in third number's difference from start hour to end hour

  Hi All Suppose i provide 8 and 11 and 15 as inputs to stored procedure. First two values denote hou…

  dhruva

  9 replies

  15 years, 10 months ago

  By: nigel.

• sqlcmd returning data as if transaction just committed has not yet happened

  Hi All I am stumped to understand how what I am seeing can be true. I have a batch file that runs a…

  Take me Away From All This

  2 replies

  15 years, 10 months ago

  By: Take me Away From All This

• Creation of New Instance in SQL Server 2005

  .

  archanab

  4 replies

  15 years, 10 months ago

  By: Nabha