SQL Server 2000 - SP4 2187.
I am getting the warning that is in the bottom after executing the following
query in Query Analyzer. Why am I getting this warning since I am not
creating a column that is more than 8000 byte or altering to make it more

I have a huge table to be partitoned and I hope some can answer my questions.
We have a 1TB table on a filegroup with multiple files over seperate disk
arrays.
The PK is an identity column and the partition key will be JobID (bigint,

SQL Server 2005
Item inventory tracking & invoicing database.
Lets say there is an item table and a transaction table.
Item contains the definition of the item and transaction contains a record

Hope someone could shed some light on this.
I have 2 boxes running win 2k3/sql 2k5. For sql server, agent and fulltext
search services  I set startup type to manual, however after
a reboot all three services start automatically.

I have just started a new assignment as a database developer with a financial
company that has a db that exceeds 500 GB – it’s a VLDB!  It has in excess of
1500 tables and over 95% of the sql calls are dynamic from code.  No need to
tell me how bad that practice is!  They hired ...

I have upgraded a MSDE 1 database to MSDE SP3A.
The system in question currently connects remotely to a SQL Server 7 server
(this is being upgraded to SQL Server 2005 in the near future)
The upgrade appears to work but once the application starts we get the

I have migrated a SQL server to a Win 2003 server environment..
It concerns SQL 2000, SP4.
We have a DB setup for our production machines,
We have some 3rd party application which reads dat files from certains pc's (located on another network / subnet) and imports this data into ...

I am trying to install SP2 on an existing 32 bit SQL Server 2005 SP1
installation.  I am trying to do this at our client installation.
Before starting the installation, I checked in the add remove programs to
see whether 'reporting services' is installed.  I did not see the ...

I used to run the stored procedure below against SQL 2000 32bit
without any issues.  Recently we migrated to SQL 2005 64bit and now
this stored procedure that runs from SQL 2000 32bit and references the
new SQL 2005 64 bit server fails with the following error message:

Weird problem on a site in Russia. MSDE 2000 with SP3a is installed on
XP. The system is generally working OK, including a small extended
stored procedure to communicate from SQL Server to a service app.
Occasionally (3 times a few days apart so far) during operation, we

I want to change status of my database to SUSPect in SQL 2005. How can i do
this?
best regards,
Thor

i have a database backup of broken server and want to restore it to another
server so i can work with the old database too.
i have a new empty database and when i want to restore, a take the error
message:

Hello i hjave to realize a simple query, but icannot do it
maybe its not simple as i thtink :
WHAT I HAVE:  3 tables :
Incident (incident_id,incident_ref,incident_rmk)

I'm in Management Studio Express, and I have two databases, Apple and
Banana. If I choose "Apple" from the Available Databases dropdown, and
run this query:
SELECT Id FROM Banana.dbo.Location

I have this complicated CREATE VIEW query below, but to make it
simpler I'll just lift out the one LEFT JOIN  I'm looking at.
I think the Left join is joining this manufacturer part of the query
to the part right below it, which is the Car_owner table and would be