I am using SQL Server 2005, and Management Studio.  When I try to set
a primary key using the UI on a sizable table (over 1 million
records), the Management studio reports:
Time out expired or the server is not responding.

I'm creating a client/server application and I'm new to SQL server.
I'll be using SQL Express 2005.  This same application will be used by
several different users, and each user should only have access to
their own data.  Each user will have a user ID and all data will be

I know there is technically no such thing as a dumb question but i
think i have one, please bear with me here.  I know how to install,
configure and use SQL server very well first and foremost.  However i
just bought 2005 developer edition and noticed that there are 8 disks

I found this code in Help file
Declare @ErrorMessage As ErrMsg /* nvarchar(4000) */
Declare @ErrorProcedure As ErrProc /* nvarchar(126) */
Declare @ErrorNumber As ErrNum /* int */

I am bulkloading client data using an xml format file.  The client
sends a flat file and each record is supposed to be fixed length (for
the example below, 35 characters), ending with a carriage return line
feed.  However, occasionally they have a record that is short (say, 25

Hey folks,
I want to insert records into a process logging table to keep track of
what's happening in a stored procedure.
The problem I'm running into is, the inserts to my log table are contained

I'd like to write a generic block of T-SQL at the end of a long stored proc
that I can "GoTo" whenever I want to log an event or an error.  This way, if
if I ever want to change/enhance the logging (right now I'm just inserting
info into a log table but I might want to insert to ...

Hi all, just a quick question, I've built the following recordset -
<%
Dim ClientsAdvertising
Dim ClientsAdvertising_cmd

I have a table partitioned in sql 2005 using partition function and
partition scheme using different file groups. The table is partitioned using
Tax year as partition column. Now, I want to add more data to the current
table let's say for tax year 2006. How can I do It?

I have a number of web services which deliver a tabular data stream I
would like to access this data from SQL within SQL Server. Ideally I
would like to dynamically query this to provide for real time access
to the data from the web service.

SQL Server can fetch (server HDD serial number or SQL Server unique Id (if
there is one) ) ?
For the licensing purposes
Thanks

I could use some help regarding converting an EPOCH datetime value, combined with getting the results greater than or equal to 4 days based on a normal SQL server datetime value.  
I'm able to convert the EPOCH datetime value such as:
DATEADD(s, DATE_OPENED, '19700101') AS ...

I have an IP-Location database with columns
FirstIP bigint
LastIP bigint
Country char(2)

I am a new user to SQL Server 2005.  Currently I have the task in producing
a report using Crystal Report and viewing data thru ODBC to get data from
AS/400.  It is a
cumbersome process, extracting the data Many times I do not need a report,

I have the query below that is throwing the error 'Msg 8115, Level 16,
State 2, Line 1 Arithmetic overflow error converting expression to
data type int.':
select l.heading_code, ROUND(LMIimp - YPCimp*LMIclicks/cast(YPCclicks