SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Expand DB in SQL Server 2005

  Hi All, Just joined so hello to everyone.. I have just been asked to increase the size of our DB on…

  ken.nessworthy

  3 replies

  15 years, 9 months ago

  By: ken.nessworthy

• Can't attach db, file is corrupted.

  Hi, I can't attach db file, Customer send me db from recovery disk, I tryed attach to SQL Server 20…

  simegh

  5 replies

  15 years, 9 months ago

  By: Gail Shaw

• SQL Server 2005 and Windows 7

  Since installing Windows 7 the only way we can open a .sql file is to go through the management stu…

  bpowers

  5 replies

  15 years, 9 months ago

  By: bpowers

• Is there a free (legal) download of SQL Server 2005 for home use?

  I'm looking for a legally free copy of Microsoft SQL Server 2005 (i.e., "Lite," "Personal Edition,"…

  shew

  2 replies

  15 years, 9 months ago

  By: Lynn Pettis

• collation conflict between "SQL_Latin1_General_CP1_CI_AS"

  Hi, I am trying to run the following query but keep getting this error below, i have tried various …

  sc-w

  4 replies

  15 years, 9 months ago

  By: sc-w

• change owner to dbo

  Cannot find the principal 'ima-ind_dbuser', because it does not exist or you do not have permission.

  bmw110001

  3 replies

  15 years, 9 months ago

  By: bmw110001

• How to find out the source computer name if the hostname is blank

  Hi all. One of our large SQL applications is pre-.Net (i am told "probably" written in C++) and us…

  Jimmy M

  4 replies

  15 years, 9 months ago

  By: Jimmy M

• sql validating constraint violation

  I need to disable and enable constraint to update a primary key. I was successfully able to disable…

  caesarkim

  2 replies

  15 years, 10 months ago

  By: caesarkim

• LEFT OUTER JOIN - Return a constant value instead of NULL for mismatches

  LEFT OUTER JOIN returns each row that satisfies the join of the first table with the second table. …

  maneesh_menon

  6 replies

  15 years, 10 months ago

  By: vliet

• ALTER the columns data type as varbinary

  Hi, How to ALTER the varchar data type column into varbinary data type. For ex, i have a column (fl…

  sqlusers

  3 replies

  15 years, 10 months ago

  By: Gail Shaw

• using 'OR CLAUSE' in LEFT OUTER JOIN

  I have written a left outer join and in the ON CLAUSE I have used an OR CONDITION also select * fro…

  maneesh_menon

  1 replies

  15 years, 10 months ago

  By: Jack Corbett

• Capturing query texts used by an application

  Hello I have an application that uses embedded sql and I don't have the source code. This applicati…

  EMoscosoCam-602582

  3 replies

  15 years, 10 months ago

  By: Jack Corbett

• Trace file names

  HI, I know in sql 2005 the default trace file names are in the form of log_##.trc. I am seeing some…

  Juanita

  2 replies

  15 years, 10 months ago

  By: Jack Corbett

• Recovery model, etc. (inquiry)

  Hi, Can I ask if what's the impact if i change the recovery model of my ms sql server 2005 and 200…

  dominicgurat

  4 replies

  15 years, 10 months ago

  By: Bru Medishetty

• Which is normalization is best when we performing database design?

  Hi Friends, I need some help to understand normalization. Could anybody please tell me which no…

  ps_prakash02

  2 replies

  15 years, 10 months ago

  By: ps_prakash02