I've just setup SQL Express 2005 SP2 on my fresh SBS 2003 R2 system. I never
had anything to do with and have no idea about SQL, the only reason for
updating from MSDE was the annoying and ugly event id 1000 relating to
sharepoint services in my application log. There seems to be ...

Just want to clarify the date from which a DB backup with DIFFERENTIAL
option includes its changes.
I have a db which I do a full backup on Saturday, and a differential the
other days (this is plenty in our case)

I am setting up a new SQL Server 2005 EE server with Reprting Services
installed. The log files have all been moved to a seperate drive. However, I
have never moved log files for Reporting Services and can find no
documentation for this procedure. Is there anything unique about ...

I'm using SET IDENTITY INSERT to be able to insert into an identity col.
I have explicitly named every col to be added & set identity Insert on then
off, as in the code below, but I still get the error that says:
"An explicit value for the identity column in table

Is there a way to open a webpage through SQL?

Hopefully someone is knowledgeable about this that can help me.  We
use SQL Server, and usually FTP our microsoft documents up to it.
Obviously, when different locations access these files through our
intranet, they are read only.  I wanted to see if there is a way to

I encountered a nasty bug in SQL Server 2000.
Symptoms:
When you try to create a query in the Query Builder of Enterprise
Manager, the selected tables are displayed without columns. Only *

We have a web app currently being hosted on a RAID 5 with four disks, 2 GB
RAM, Xenon 3.2 processor.  Also running Windows 2003 Server Standard Ed. and
SQL Server 2000 Standard Edition.  Our database is about 4GB and at most we
have 10 concurrent users hitting our server, with a ...

Our db server appeared to hang during a long running script last
night. Our windows guys rebooted the server. However my suspicion is
that the script was consuming all systems resources but was still
running.

We have two servers, one inside the firewall and one outside and need to
keep them synched up on a daily basis.  Short of doing full backup and
restore, what is best solution?
Thanks.

What is the maximum amount of RAM supported by SQL Server 2000 on Windows
2003 standard edition server?
Regards
Ram

Using the SQL Server 2005 Maintenance Wizard -- Where do you tell it
to delete files older than a certain date?  With SQL Server 2000 it is
a checkbox where you specify an age before it is deleted.  Any
suggestions appreciated!

Good afternoon!
I know that I have asked this question a while back but I can not find it so
I am asking again!  This time I will print it out!
First off, I am not a database guy!  At all!  This is something that will

I get access denied or server doesn't exists error message when try to
connect to a SQL Server 2005 named instance remotely. I have sysadmin
permissions on SQL Server. I checked in SQL Server Surface Area Configuration
tool to make sure Local and Remote connections are allowed. I ...

I'm starting to build a database that will contain English and Welsh
text. Up until now I have just used the default collation settings, and
everything has been fine - but I've only ever needed to use English.
There is also the possibility that, at some point in the future, the