See books online about shrinking databases

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_462b.asp

look in books online for

dbcc shrinkdatabase

or

dbcc shrinkfile

you have to formulate your if statement into something that returns a boolean true false

declare @ageYear varchar(10)

set @ageYear = '44'

if(isnumeric(@AgeYear) = 1)

select 'true'

else

select 'false'

A Text file is a connection. Use activex to name your connection "Your file" at runtime

http://www.sqldts.com/default.aspx?200

Other File management examples

http://www.sqldts.com/default.aspx?292

This is not the case for sql server. sql server can store many rows per page, so the relative position in the row of a column is irrelevant. sql server...

you cannot get domain group members by using t-sql that I aware of.

Wierd.

Just for giggles check the poll setting.

go to enterprise manager,

go to tools -->Options

is the poll box checked.

Other than that I don't know what the issue could be unless the...

The only way you can do it is if your table has a unique primary key for each duplicate.

delete mytable

Where PK in (select min(a.pk)

             From mytable a

             join mytable b...

I don't use mysql,

But I know that you cannot do that in sql server,

Thats not how relational databases work.

You can do it using dynamic sql.

http://www.sommarskog.se/dynamic_sql.html

A good technique is not to generate tables from within a stored procedure, to manually create all well formed/normalized tables and not to...

if the datatype is text, then you cannot use regular update table set column = 'Sometext'

Please read books online, it will give you the information you need to update this...

I said what you said,

Twice,

Touche`

of the two options you have tried, they both are wrapping a function around a table column, which FORCES sql server to do a table scan, it cannot/will not use...

Yep, you can at runtime change the filename

http://www.sqldts.com/default.aspx?200

http://www.sqldts.com/default.aspx?292

Instead of sp_addUser, Use sp_Grantdbaccess (sp_adduser is old)

for the user to do this he must be a member of the SecurityAdminisrators role, which you have. But also a member of...

well.

When good apps go bad. Thats tough.

Its likely that you would incurr some performance gain if you move webapp off of the sql server onto its own server. (Scale out).

and...