i'm trying to restore a log via trn files.
Now I get the message:
The log in this backup set begins at LSN xxx, which is too late to apply to
the database. An earlier log backup that includes LSN yyy can be restored.

Im looking at my server task manager and im seeing the SQLSERVR.exe procees
spike up to 90% every min for a few seconds. Connection to my DB freeze
during this time. I run the profiler looking for queries that take more than
5 seconds to run but not much appears (i.e i can see ...

I am trying to setup a new job in SQL Server 2005 Database Engine. One of the
Steps is to run a .bat file, but when I select 'Operating system (CmdExec)',
it doesn't give me the option to select 'WinCMD' as the 'Run as:'. The only
option is SQL Agent Service Account. Please help.

I keep getting a instruction at "0xyyyyyyyy" referenced memory at
"0x00f900a2". This memory address is constant and never changes.
I checked the event log and followed the CLID, which leads to iexplorer. I
checked the permissions - all is well. All updates are on and current - ...

I am trying to figure out how to change column type using script (it works
through studio interface).
The column type is currently integer with a check constraint which has no
name:

I am just wondering if there is any problems if we install Servicepack 3 on
a  Windows XP Pro box that is running SQL server 2000. is there any known
problems with the SQL server in this case?
Is there anyone that has tried this? its on a production computer, so im not

In a named instance in Sql Server 2008 i need to choose a static tcp port
number. Are there some rules? Some days ago i read a document that stated
the suggested port range, but i can't find it anymore. I have choosen 51319
port number. Is it ok?

I ordered MS Sql Server 2005 (x32) Single Processor  (MPN 228-04026) the
other day.
Today I received MS Sql Server 2005 (x64) Single Processor (MPN 228-04019)
plus Microsoft SQL server 2005 (x32) Media Kit. (MPN 228-05236).

We have a document management system made by some vendor.  It relies
on a SQL database for storage.  One table contains profile fields to
categorize the document, andother table contains the full text of the
document.  this way people can search for documents by profile or by

Currently, in the maintenance plan, there is a step of reorganise index for
the production database every week.
However, someone says that reorganise index is different from rebuild index
in SQL Server 2005 and we have to run "Update Statistics" as well.

I've read (briefly) regarding enhanced ordering capabilities in this new
version of SQL server.  For that matter, even in SQL Server 2005.  I'm
currently using an SQL Server 2000 that contains a table of part information.
If the new enhanced ordering capabilities can achieve the ...

We are looking at changing our database structure, which predominantly
uses char to use varchar, if this is deemed appropriate.
char stores 'extra' data to the tune of the trailing spaces in the
fields, is this correct?

Hello every one,
i have table named "item" with a column "item_name".
they are item_name starting wiht the char '#'.
i would like to update all those item_name where the item_name are not

I'm using SQL 2005, sp2.
I have inherited a table that has aprox 300 million records, and is very
wide.  We started running out of disk space, so I started deleting data from
the table.  I've noticed that the database doesn't seem to reuse the space

I have 2 questions regarding multiple files in the same filgroup:
1. How to check actual space usage in a file, not to confuse with space in a
database.
2. Does sql distributes data to multiple files in a filegroup proportionaly