SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Modified User

  I want to track whenever a change is made to a record, or a new record inserted. I have the followi…

  Paul_Harvey

  9 replies

  15 years, 7 months ago

  By: Gail Shaw

• Access 97 Linked Server

  2 days research. No solution. Have seen this in many forums. I create a linked server to MS Access.…

  Michael Moore-262193

  6 replies

  15 years, 7 months ago

  By: Michael Moore-262193

• Week start and end date in a month

  Hi, I need Week Start date and week End date for particular Week and year . eg. if weeknumber=1 an…

  KpSQL123

  3 replies

  15 years, 7 months ago

  By: Dave Ballantyne

• Connecting SQL 2005 64 bit to an Access 2007 Database

  I know that this is a known issue, but my question is more about asking for a work around. I have s…

  Hyabusact

  1 replies

  15 years, 7 months ago

  By: Gift Peddie

• How to i do update/insert to certain fields in a certain order

  I have 5 Db's...DB1, DB2, DB3, DB4, and DB5. Now when an account is created in the front end, I wan…

  mohaminho10

  4 replies

  15 years, 7 months ago

  By: mohaminho10

• Problem with automatic updates for SP3

  I have XP on my laptop. There is an automatic update that keep failing and I have tried everything …

  simonpgillham

  1 replies

  15 years, 7 months ago

  By: SQLRNNR

• Will a trigger work

  Hello - I need some help with triggers. I have a table for inventory that includes the employee na…

  Charlie-120533

  5 replies

  15 years, 7 months ago

  By: SQLRNNR

• to get acctual used tables

  Hello all; I am a new member and I have problem. for my software , I have to know witch table is op…

  salih.duzel

  1 replies

  15 years, 7 months ago

  By: SQLRNNR

• How and Where is profiler trace file scheduled/coming from?

  Hi, There are over 1000 .trc files on our drive. The files are named audittrace20091211104655_1516…

  debbie_jacob

  5 replies

  15 years, 7 months ago

  By: debbie_jacob

• Round SQL Price to Nearest .05 or .09

  I'm trying to create a script to set all of the items in my IM_PRC table to round to the nearest .0…

  jadonr

  13 replies

  15 years, 7 months ago

  By: jadonr

• max limit of varchar(max) in sql server 2005

  What is the maximum limit (in terms of characters) of varchar(max) in SQL server 2005? I mean if I …

  anjali.vishwakarma

  5 replies

  15 years, 7 months ago

  By: LutzM

• SQL Server 2005 Performance Dashboard Failure - How To Resolve Without Restarting SQL Server?

  I've received this error before, when I attempted to start SQL Server 2005 Performance Dashboard: "…

  Gail Wanabee

  3 replies

  15 years, 7 months ago

  By: SQLRNNR

• how to create a login with only read rights?

  I want to create a SQL login with only read rights..that is the user should be able to only view th…

  anjali.vishwakarma

  6 replies

  15 years, 7 months ago

  By: SQLRNNR

• VARCHAR(MAX)

  Hi There, Please help me with the below issue. I have a table with so may columns (200 in f…

  naresh1253

  3 replies

  15 years, 7 months ago

  By: naresh1253

• Help whit Query Distinct

  Hi, I have a query thats brings me: dsCallId Piloto ---------- -…

  EIAnd

  4 replies

  15 years, 7 months ago

  By: EIAnd