Select * from YourTable

Where len(Description) > 35

You won't have to install VS2005.

As far as licensing goes, i think that if you have the correct CAL/process license for your server then you can install Client tools...

You should schedule transaction log back-ups this will truncate the log and mark the space for re-use.

Your database needs to be on full-reovery mode to allow this.

Vnc'ing into the server is not ideal, the client tools are on the same disk that has SQL server just go through the install process on...

try

select id, count(*) as RowAmount, color

from tableX

Group By id, color

No worries, thanks for the feedback..

The DBA should be able to give you specific permisson to view the definition of the View, and then Deny modify/alter permissons.

As far as i am aware sp_droptype is to drop alias data types, ones that have been user created, as Date is a system datatype in 2008.,...

I dont think it is a permission error, as you have said you checked, it looks like you are passing in the string 'Date' and using this as...

Have you installed SQL server on a server or on your local machine?

If this is a application running on a server or a local machine then you may consider downloading...

Scout7 (3/11/2009)

---

I still current have everything set to the database default, which is as follows;

Windows Collation - Latin1_General

Dictionary Sort - Accent Sensitive.

This is working fine for most of main languages...

Krishna (3/11/2009)

---

The fastest operation is to detach it and...

I have to agree with the comment above about normalistation, you will be in for a lot of issues down the track with this sort of design

The CPU time is cummulative so it is normal for it to keep increasing

for opening large text files i use textpad

http://www.textpad.com

I am not sure if it has a rowcount option, but i have opened large 500mb+ text files without any problems