you will need to install either SQL2005 express or developer. Enterprise and standard are for server systems only

install a new instance with the correct collation and transfer any objects across, then remove the original instance. Pay close attention to the installer and select the right collation, check...

you may or may not need to configure the /3GB switch in the boot.ini (i assume you meant this file and not...

Simon

not so much bad indexing, but yes they are related. The fill factor is defined as a default at server level which is usually 0 and means 100%. When rebuilding...

what is your MDAC version

to make the trace easier to read\sort dump the output to a sql table

SELECT * INTO tablename

FROM ::fn_trace_gettable('d:\path to trace\tracename.trc', default)

the compound key has to be unique, you can have the same value in single columns as long as the combined values are unique

col1 ...

Jeff, send it over PM

begs the question, if you find yourself having to store the same data in a column should it really be a primary key??

this is very important, if...

i'll send you my resume which contains my name, address, date of birth ,etc. I dont think so

anupamabr (11/13/2008)

I am new to Sql

I created asp.net web project.I need to connect this website to my locally installed database

.For that I need to modify the connection string of...

samalex (11/21/2008)

In our maintenance plan for each database, we're doing a nightly full backup, but I've noticed this isn't truncating the transaction logs. I thought this was how it...

if you have removed builtin admins group i would add that back first before switching domain memberships then remove when finished. If all the logins are SQL and you're not...

manually install the sql client first by using the msi package