SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Interview Question

  Dear Experts, Is it possible to check whether table has index,stored procedure,views,triggers,prima…

  venktsrinivas.gv

  7 replies

  15 years, 8 months ago

  By: chandan_kumar_sahu-987370

• Zip Code search - Msg 3623 "A domain error occurred" (code inside)

  Hi, DECLARE @start_lat float DECLARE @MaxNorthLat float DECLARE @MaxSouthLat float SELECT @start_la…

  matt6749

  1 replies

  15 years, 8 months ago

  By: SQLRNNR

• Issue with attaching SAN snapshot replicated database files

  We house our database files on SAN disks in production. Our BCP server is also attached to SAN disk…

  nman47

  1 replies

  15 years, 8 months ago

  By: SQLRNNR

• problem with iis7 and SQL

  hi i build a web application with local sql database and linq to sql in visual studio 2008. i conf…

  amon 68987

  9 replies

  15 years, 8 months ago

  By: Gift Peddie

• Linkserevr Sqlserver 2005 with Ingres ODBC Dsn

  Hi All, In my server machine I have SQL-Server 2000 and SQL-Server 2005. I created Linkserever for …

  mf.gadagin

  2 replies

  15 years, 8 months ago

  By: kenneth.phillips

• Running Totals in SQL

  I have a stored Procedure that calculates savings, i need these savings to be grouped by month and …

  nialltuohy

  5 replies

  15 years, 8 months ago

  By: LutzM

• "Buffer provided to read column value is too small." error after moving to SQL2k5

  Hi, We just installed 64-bit SQL Server 2005 on our new Server having Windows Server 2003 x64 Enter…

  RSingh-135921

  7 replies

  15 years, 8 months ago

  By: jszhong

• How to encrypt database objects

  Hi... Is there any way by which I can encrypt restrict to view definition of my database objects a…

  ManoharV

  2 replies

  15 years, 8 months ago

  By: ManoharV

• Repairing problem

  Hi everyone I have a very strange problem. In a big database one of the NDF files is corrupted. Dat…

  Renis Cerga.

  3 replies

  15 years, 8 months ago

  By: Gail Shaw

• linked server problem

  I use a trigger which I update a linked server and this is working very good in SQL 2000. But after…

  Supernova Hakeem

  1 replies

  15 years, 8 months ago

  By: Lisa Ward-361516

• Can TSQL 2005 do this : ToBase64string

  I have this code in vb.net, I use it to convert info in my query string to code like ID = 1000, the…

  Digs

  5 replies

  15 years, 8 months ago

  By: Digs

• Translating SQL 2005 script to SQL 2000

  I have a customer who is down that I'm working with that needed adjustments to their SQL tables for…

  Jayded

  9 replies

  15 years, 8 months ago

  By: Jeff Moden

• Creating Stored Procs for all tables

  I have been working on a new ecommerce database schema template and i have nearly finished setting …

  bkirk

  9 replies

  15 years, 8 months ago

  By: SQLRNNR

• Delay in record appearing in table - why and how to prevent?

  I'm experiencing a weird issue where there is a 30-60 second delay in records being added to a tabl…

  WayneS

  3 replies

  15 years, 8 months ago

  By: Jeff Moden

• Duplicate record insertion check

  I have 3 tables Adviser , adviserbranch and customer. adviser has branches under him and customers …

  ndixit

  3 replies

  15 years, 8 months ago

  By: Jack Corbett