I am running GSitecrawler (it is a crawler that helps to create
sitemap) on my site which has over 1 million urls (but could be over 2
millions since I never got the chance to finish due to resource
limitation).  Currently, there are only 440,000 url records stored in

OPENQUERY ISSUE
Hi,
I have SQL 2005 Enterprise set up with Linked Server using ODBC Driver
(System DSN) to access an AS/400.

I am using SQL Server 2005 Enterprise edition in one of my product. This is
running live in one of my customer's place. They are feeling a severe hit in
the performance of the application/database.
The database size is 3.6 GB. Can you please suggest on how to improve the

installed reporting services on SQL 2005 instance but no REPORTS option
appears on management studio. should be able to right click DATABASES from
management studio to see this option :(
thanks for any help

I can't seem to find the T-SQL command to display the database names and guid
(Global Unique Identifier).  Does anyone know of any command or gui path.  
Thank you in advance.
-Napone

I am implementing table partititoning on table with an identity column as
PK/Clustered Index.
Part.Key is another non-unique bigint column.
I know that partkey must be included in the clustered index.

Hi,
I am experiencing some performance issues.
I am testing a system in a load environment which means the server was
running for around 20 days and loading data into the SQL Server.

I am getting the following error message when I try to run the code
below.
Server: Msg 156, Level 15, State 1, Line 17
Incorrect syntax near the keyword 'OPEN'.

Periodically we are taking backup and restore in two machines.
Full Backup every Saturday and every hour transcation log backup.
One day we last one transcation backup which is deleted by mistake.
Now my question is.

What is the new feature in SQL 2005 that allows you to perform a backup of a database without breaking the log chain?
Thank-you,
Rubens

I was trying to write a code to go through each database and remove
all users except two.  I tried to do it with two cursors.  If I run
the inner cursor on each individual database it works fine and it
removes all users from that particular database.  When I try to run

Trying to go a different route from my previous post regarding drop
users for each database.
this is what i got:
declare @sq1 varchar (1000)

SQL Server 2005
In the new shop I am in I have seen a format for Select statements that I
have not run across before, joins with no explicit Join or ON clauses.
Select c.CustId, c.CustName, h.OrderDateId, h.Orderdate

Anyone help with this SQLserver 2000.
I have recently tried to shrink the database in our production server
(currently 17G) I notice when using sp_spaceused in a stored proc that
iterates through all tables that some tables (about 30) have large

I setup a maintenance plan that was given to us by the vendor which includes
the following steps.
1. History Cleanup
2. Delete old bak files