...it's me...eRiCk

Format specifier Name Description C or c Currency The number is converted to a string that represents a currency amount. The conversion is controlled by the currency format information of the NumberFormatInfo object used to format the number. The precision specifier indicates the desired number of decimal places. If the precision specifier is omitted, the default currency precision given by the NumberFormatInfo is used. D or d Decimal This format is supported for integral types only. The number is converted to a string of decimal digits (0-9), prefixed by a minus sign if the number is negative. The precision specifier indicates the minimum number of digits desired in the resulting string. If required, the number is padded with zeros to its left to produce the number of digits given by the precision specifier. E or e Scientific (exponential) The number is converted to a string of the form "-d.ddd...E+ddd" or "-d.ddd...e+ddd", where each '

if u want to using SSO in Sharepoint Designer where it only has parameter for username and password, don't forget to uncheck "Windows Authentication" when u created new Account Information then u can use it in SPD

run this under SQL Management Studio USE master; GO EXEC sp_configure 'show advanced option', '1'; RECONFIGURE; EXEC sp_configure 'Ad Hoc Distributed Queries', '1'; RECONFIGURE; and also :D u need to use Windows Auth, the SQL Auth won't work

u need to go this folder C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 and run aspnet_regiis -i, it will installed current version of ASP.NET.. u can verify it on IIS Manager under Web Server Extension until then

If just in case u found an error something like this The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications then u must enable it it's effected SQL SERVER 2005 and above ALTER DATABASE DB_NAME_HERE SET NEW_BROKER WITH ROLLBACK IMMEDIATE ALTER DATABASE DB_NAME_HERE SET ENABLE_BROKER -- to check whether the broker already enabled or not (1 = enabled, 0 = disabled) SELECT is_broker_enabled FROM sys.databases WHERE name = 'DB_NAME_HERE '