SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Salesforce attachments stored as binary data needed to be rendered viewable.

  Hello Everyone, When we extract attachments using Salesforce's (Cloud) data loader and store the at…

  GaMusicMan

  3 replies

  14 years, 11 months ago

  By: Sean Lange

• sp_executesql issue

  I am trying to make a search query that I can pass a search phrase and the order field and order ty…

  lleemon13

  7 replies

  14 years, 11 months ago

  By: Orlando Colamatteo

• How to get threshold information for monitor and rules in SCOM Server SQL Server DB?

  Hi Guys, I want to know how to get threshold information for monitor and rules from SCOM Server…

  ramesh.chandrasekaran

  1 replies

  14 years, 11 months ago

  By: Grant Fritchey

• Requirements/Configurations in SQL 2005 to be able to use MSDTC

  I've got a requirement from our developers to make sure that MSDTC has been setup correctly. What s…

  smile_netz

  3 replies

  14 years, 11 months ago

  By: MikaS

• Reseed Identitity column

  First of all Hello to all my experts, I am having a table 'TB_Bill' in that i have taken an identit…

  shubham.saxena67

  3 replies

  14 years, 11 months ago

  By: Steve Jones - SSC Editor

• server hangs on osql called from stored Procedure

  This series of commands worked on another clients SQL '05 installation but at this site the output …

  paul.vanhouse

  5 replies

  14 years, 11 months ago

  By: Orlando Colamatteo

• Stored Procedure

  Hi I am trying to do a Login stored procedure with using email address and password Would it be lik…

  borgexvw

  3 replies

  14 years, 11 months ago

  By: LutzM

• Javacript interface with SQL

  Is there any way to pass variables from javascript in a web page to an SQL routine? I am using a na…

  borgexvw

  3 replies

  14 years, 11 months ago

  By: Sean Lange

• Unified LOB Programming Model

  Has anyone ever heard of the Unified LOB Programming Model? I'm reading a SQL 2005 MS Press book a…

  Brandie Tarvin

  5 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• Command timeout from .net application

  I get a timeout exception when running a query that takes almost 33 seconds on management studio. E…

  thulani.moyana 79207

  7 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• Query Help

  I am struggling to get my head around what I think should be straight forward. Can someone point ou…

  steve.walls

  2 replies

  14 years, 11 months ago

  By: steve.walls

• Binary Checksum

  Can someone please explain why the checksum stays the same when I just move the decimal point of a …

  shirley.fernandez

  2 replies

  14 years, 11 months ago

  By: shirley.fernandez

• Convert varchar field to time

  Hi I am inserting records from one table to another. In Table 1 Create table abc (id int not null, …

  aqsluck

  3 replies

  14 years, 11 months ago

  By: scrape

• sql script with local variables and

  Dear @all, I've tried to backup a list of tables to a backup database. But how I can use the curser…

  rene.schulz@implico.com

  1 replies

  14 years, 11 months ago

  By: rene.schulz@implico.com

• SUSER_NAME() vs SUSER_SNAME()

  Any reason to use one of the following over the other to return the user currently modifying data? …

  Mikey01

  1 replies

  14 years, 11 months ago

  By: Lowell