SQL Server: Changing from Single User Mode to Multiple User Mode

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = 'databasename'
go


kill 64
go


EXEC sp_dboption 'databasename', 'single user', 'false'

CRM: Popup Issue

Internet Options > Security Tab

Disable (uncheck) “Enable Protected Mode” for Local intranet

SQL : Trasition State, Please Try Later

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go SQL!

Sharepoint: Max Character Limit

How to set the maximum field length in InfoPath
by S.Y.M. Wong-A-Ton
Learn how you can use a data validation condition to check the maximum field length in InfoPath and display an error message to the user if the maximum field length is exceeded.
If you’re used to programming in Visual Studio, you’ll be disappointed to know that there is no MaxLength property that you can set on fields in InfoPath that can hold multiple lines of text with line breaks.
So if you want to set the maximum field length on a multi-line InfoPath Text Box (that allows line breaks) or Rich Text Box, you must use data validation.
Note: You can limit the amount of characters on a single-line text box by going to the Properties dialog box of the text box, clicking on the Display tab, and selecting the Limit text box to checkbox.
When using data validation to restrict the maximum field length in InfoPath, you can use the string-length function in a The expression data validation condition to check whether the amount of characters entered in a field is greater than the maximum characters allowed, and then display an error message.
For example, in Figure 1, I’ve created a data validation condition to check whether the maximum length of a piece of text in a multi-line text box (field1) exceeds 10 characters. This technique also works for rich text boxes in InfoPath.
Caveat: Spaces and line breaks are counted as characters.

Sharepoint: Individual File Size

Central Admin --> Application Management --> Web application general settings --> Maximum Upload Size

Sharepoint : "Value does not fall within the expected range"

This definitely happens when some field is missing. Compare your code and the list of fields that all the fields exist and if exist then they have same name. Make sure about the spelling checks.

Sharepoint : Multiline Text Field Size Limit

Error : " This field can have no more than 255 characters"

Go to form Library Settings. Open the properties of the desired field. set "Yes" to "Allow unlimited length in document libraries" settings