In that case I would probably put the varchar column in a separate table.

SELECT [id], [name], OBJECTPROPERTY([id], 'TableHasIdentity') AS HasIdentity

FROM sysobjects

WHERE xtype = 'U'

Please do not cross-post, we monitor all boards.

Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=195074

Look in Task Manager. The column PID shows the process id for each running application and you can match it to the one in Profiler.

For the definition of the column, you can look in syscomments:

SELECT [text] FROM syscomments WHERE id = OBJECT_ID('TABLENAME') AND number = @columnIdInTable

Add the new account to the local administrator group on SQL Server to be converted

In general, the domain user account does not need to be a local administrator, and should...

I would definitely not store it in a single column. DOB and YOB does not represent the same information and are not even the same datatype. If there are requirements...

Should you only use the text data type in situations where you need to store more than 8000 characters?

Yes. You should always use the most fitting datatype for any data...

If you are using Windows XP or Windows Server 2003 you can create a counter log that logs to any data source. Otherwise you can log perfmon counters to a...

Take a look at my checklist for moving system databases. How to do this is mentioned in the end of the article.

sp_adduser and sp_dropuser exists only for backward compatibility, so it is recommended to use sp_grantdbaccess and sp_revokedbaccess respectively instead. Both sets are used for managing existing login accounts access to...

The answers in the other thread described this I think. Anyway, here is an example that adds a description for a column foo in table bar which can be seen...

Until I looked it up I had no idea what WebMarshal (I assume you mean NetIQ WebMarshal?) was, so I can not give any specific advice. However, it sounds strange...

Take a look at Gert Draapers' xp_smtp_sendmail. It is an extended stored procedure that uses SMTP to send mail. In SQL Server 2005 there is a new component called...

Does something like this not work?

SELECT * FROM foo WHERE bar IS NOT NULL

If not, could you provide DDL and some sample data, along with a description of the desired...