Recent content by andyoye

I want to pull user login, home directory... etc from AD using VB.NET Someone told me to use System.DirectoryServices, but I am new to VB.NET I can get the result by using dsquery.. dsquery * OU=Users,OU=xxx,OU=xxxx,DC=xxxx,DC=xxxx,DC=xxxx,DC=com -filter...

how about this check constraint SSN like '___-___-___' Looks like its working for me

I have a column (varchar 25) The values it should store should look like 1111-111111 like 2006-123456 Is there a way I can make sure users cant enter mismatched data? thanks

I am not a programmer, I am DBA just created a webpages to connect to database. so using span tab will fix it?

If I use medium text size for IE, my web site looks ok but if I change to large or largest text size, all the text get messed up. Is there a way for fix the font/text size in html so even if users changes their browser setting, page stays the same? thx

I am getting this error while using Outlook 2003 with Exchange 5.5. ox8004010F: The operation failed. The object could not be found." I am able to send and recieve emails.

I just mentioned fname, lname, address for ease. In reality my form has 10 questions, so actuall table looks like ques1 varchar(2000) ques2 varchar(2000) . . . ques10 varchar(2000) ques1 varchar(2000) Q: Does "text" acts like varchar for storage? I mean its variable in lenght like varchar?

Q1:What will be the impact on performace after converting to text? Q2:How would I be able to see the text entered into those fields? I guess QA is not going to work with that long strings. thanks in advance

Like I said, current table description is fname varchar(2000) lname varchar(2000) address varchar(2000) I want to store more then 8000 bytes in EACH field

Thanks all, but what should I do with my existing table? Can I change varchar to text with Alter table command?

So what should I do now?? Create a new table, drop the old table and change name of the new table to old table's name? Kindly provide more detail.... How can I store 20,000 characters in a table with 4 columns. currently my table stucture is xyz varchar(2000) abc varchar(2000) pqr...

On my production sql server(sql server 2000, SP4), I have a table with column like xyz varchar(2000) Q1: I guess the max size a varchar data-type can have is 8000 ?? Q2: How can I increase the size of the column that has data in it? Q3: Can I change it to CHAR type? as the column is going...

I have done Masters in comp sci but my main focus is always on Databases, I am on OCP, currently a DBA for Sql server. I had couple of classes in C++ while i was in university( 6 yrs back).

Thanks but which book/s I should start with?? I checked amazon, there are plenty of vb.net books by WROX

Kindly let me know, what book/s should I refer to learn Vb.Net For example: I liked the C++, how to program by Deitel & deitel. I need something step by step kindda book. Thanks