This is what I thought you are looking for then I saw the previous replies so I left it alone, to apply equality in SQL...

Try the link below for a walk through.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_5gvt.asp

Kind regards,

Gift Peddie

Yes you can install it without VS2003 but don't answer any question Windows ask you during the installation, only answer relevant questions.  Hope this helps.

Kind regards,

Gift Peddie

Try the thread below and read the post from the other forum I posted because it depends on your write users.  Hope this helps.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=223444#bm223994

Kind regards,

Gift Peddie

You have two problems when you import text SQL Server sees null values because of the nature of text so if you import into a table with primary key your import...

There is install SQL Server Agent with a service account with Admin permissions because when XP_CMDSHELL is running in the context of SQL Server Agent the Agent needs the same...

Try the link below read it before you plan your DDL (data definition langauge) because there are two time intervals in ANSI SQL Day/Time and Month/Year.  If your end time...

RPC(remote procedure call) I don't know why you need it in a stored proc is outside your network so you need XP_CMDSHELL with SQL Server Agent installed with service account running...

In Enterprise Manager right click at the top and go to Server properties, then Network configurations and make sure you have enabled both Named Pipes and TCP/IP.  Then go back...

Drop the statistics  'AssessorAbbr' before altering the table and recreate the statistics after the alter. Hope this helps.

Kind regards,

Gift Peddie

I guess we have to disagree because I gave you those solutions for schema change, long resource using code is usually not needed just get the create table statement and...

All information about indexes are in the sysindex table in every database, so you have some options Index tuning wizard, DBCC SHOW_STATISTICS (table_name , index_name), or just plain UPDATE STATISTICS...

ANSI SQL expert Peter Gulutzan says when you create a Cursor a query processor says you have asked me to perform a task I am not equipped to do so...

I don't think the From clause is the reason for the error, it may be the where clause because technically a JOIN with a where clause is obsolete since...

I am not a novice, Database schema changes one word ALTER and save as .sql.    If database  diagramming is simple DDL (data definition langauge) writers will not earn very good living...