You would need to check the application that is inserting/updating the table.

this blog post (http://dpatrickcaldwell.blogspot.com/2009/05/converting-decimal-to-hexadecimal-with.html) describe a function that will convert a decimal number to any base specified.

I had posted a script in this forum post (http://www.sqlservercentral.com/Forums/Topic745531-359-1.aspx#bm746408) that retrieves all the data you are looking for. It does not do it all in one query but you...

I am unable to edit your provided sql because I have no idea about table structure or data contained within. Read the link in my signature on how to post...

the correct syntax to disable a login is:

alter login [domain\username] disable;

you just cannot disable windows group logins, only individual users.

you should be able to get what you want using the dateadd function(http://msdn.microsoft.com/en-us/library/ms186819.aspx)

this should get you started

select DATEADD(qq,-2,getdate()),DATEADD(qq,-1,getdate()),GETDATE(),DATEADD(qq,1,getdate()),DATEADD(qq,2,getdate())

this should work for you

update tableA

set column_A = column_B

from tableA

inner join tableB

on tableA.codigo = tableB.codigo

checkout this link for info about using update..from. there are some best practices...

Unfortunately I do not see anywhere to stop those table option from being scripted out.

Look under tools-> options->SQL Server Object Explorer->Scripting

For any fixed database roles(db_ddladmin), this script will not give you which objects they have access to because they are unchangeable. If you want to read up on fixed...

The script provided only collects information. How the information is used is really up to you.

What kind of data are you looking for?

here is a simple query that...

The final result is really up to you.

If you let me know exactly what result you are looking for I may be able to point you in the right...

For question 1, by running a profiler trace while executing sp_spaceused or looking at the code in sys.sp_spaceused you should be able to find the statements executed and modify them...

Thanks Seth. First for providing the code with the CASE statement, it does run successfully with it. But more importantly, based on you comment about the optimizer choosing when to...

I have run across this as well and the only solutions I have found is to either change the column to datetime or move to access 2010 which recognizes the...