I have the following table:
CREATE TABLE [dbo].[sku_info](
    [idsku] [int] IDENTITY(1,1) NOT NULL,
    [model_full] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT

We are working on migrate an application to use a MS SQL Server 2000
database when it was running on a Sybase SQL Anywhere 5.05.
At some point of the execution of the application, a SELECT is issued and in
the SELECT LIST a String(intcolumn) is included.

I am running the stored procedure in query analyzer and I am expecting a
return output of 40 character long but I am getting only 30 character long,
So for example if the returned value should be
\\ServerName\DirName\FileName, I get  \\ServerName\DirName\F

Can you backup individual table in the database?.  I am using SQL Server 2005
and I need to backup only 3 tables because each one has about 40 - 45
million rows.
Any suggestions would greatly appreciate.

I'm busy working on trying to optimize a C# method that inserts, updates and
deletes data (in a transaction) when a new stock trade occurs. The method
touches 23 tables in the transaction, doing mostly updates, inserts and about
2 deletes. Probably about 3-5 selects also happen ...

What is the best way to move a table to a new filegroup.  I read that by
moving the tables clustered index to the new file group it will move the
table also.  Can this create fragmentation or if the table is already
fragmented will it persist to the new filegroup?

I would like to install the SQL Server Management Studio and other tools to
an existing installation of SQL Server Workgroup Edition on Small Business
Server 2003 R2 Premium.
Well, apparently the person who did the original install must have installed

i need to fire off several queries to different servers in parallel from
inside a CLR SP.
Seems like this is not permitted even with the assembly flagged as unsafe

I am trying to use modify to insert an element into an xml column.  The
syntaxt shows to specifically assign the node occurence.  Is there any way to
affect the entire column?  I am referencing BOL sample below.
USE AdventureWorks;

<sqlserver2000>.
TABLEA has 10 lines:
RowNum, myvar1 nvarchar(20), myvar2 nvarchar(20)
SET @maxRowNum = ( SELECT TOP 1 RowNum FROM TABLEA ORDER BY RowNum DESC )

Please find all the scripts to create the tables and populate at the bottom
of this message.
Here's a brief explanation of the issue:
tblProjects - Stores all project related info i.e. contract date, contract

We want our operators to be able to stop and restart services on a Sql Server
(2000).  And that's all we want them to be able to do.  We don't want them to
Terminal Serve into the box and we don't want to give them client tools or
anything similar.

I am trying to execute a sql script
using the sqlcmd utlity , taking in
parameters.
The script 'CreateDatabase.sql' is listed below:

hi...
I needed to create a table which has same records in a number of rows
and only one column (ID) has different datas on it. Like:
ID    CITY        STATE   COUNTRY

I am trying to use BULK Insert for our CSV file. The data is being imported
successfully however, i am getting problem with one column which has a Text
Qualifier, because it may contain comma as text for example a row could be
3973,Sample1,"Problem, Column",Sample2, 4449,2,1