0x80070005 Access is Denied

I was creating a scheduled task in Windows XP SP3 and I was getting 0x80070005 Access is Denied error. I looked and tried all I could find in the net. I finally tried the following and it worked!

I made the user local administrator of the machine.

Everything went fine then after.

astu...

Alternating Color for GROUP HEADERS

I am hiding detail row and just showing group header in SSRS and needed alternating color, this is what i used

=IIf (RunningValue (Fields!SomeField.Value, CountDistinct, Nothing) Mod 2 = 0,
"Silver", "White")

it worked !

astu...

Reducing size of MS SQL Server Log File

Couple of days back I realized that my log file has grown out of control. Usually backing up transactions logs and then shrinking the log file should have taken care but I had to take one more step.

I changed the recovery model of the dB from 'Full' to 'Simple' then shrunk the log file and changed the recovery model back to 'Full'. I was able to reduce my .ldf file size from almost 100GB to about 500KB! Quite a resize.

NOTE: Take all cautions while dealing with backend dB. Backups, no users, front end program considerations.

astu. . .

GP Note Index

I have collected this for my reference from following two references and I thank you both for putting this out.

Ref:
	from msdn blog
	From mbsguru, blogspot

The Note Index (NOTEINDX) field in each record of SY_Company_MSTR (SY1500) table store the next Note Index to be used for that company. Every Master and Transaction record is assigned a Note Index when created. This Note Index is used as a foreign key when looking note against SY_Record_Notes_MSTR (SY03900).

To get Note Index use the following:
For Dexterity: call Get_Next_Note_Index, 'Note Index';
For SQL Scripting, call procedure: smGetNextNoteIndex

Yous SQL script as following:
declare @companyId smallint,
@noteIndex numeric (19, 5)
@errorState int;

-- get company id
select @companyId = CMPANYID
from DYNAMICS..SY01500
where INTERID = DB_Name()

--get and increment the next note index
exec DYNAMICS..smGetNextNoteIndex @companyId, 1, @noteIndex output, @errorState output


print @noteIndex
print @errorState

Displaying PPT in SharePoint

Follow this link. Follow the instructions, they are straight forward, but make sure that you choose MULTPLE UPLOAD when uploading the file, the web version of ppt has more than one file so, SP informs you that you are uploading xx files even when you just selected 1 web version of PPT file. Thanks Sherri!

SQL Server login character length

Run sp_server_info procedure to find the limitation of the server with other information.

e.g. EXEC sp_server_info

Ref:
http://awesomesql.wordpress.com/2009/08/21/maximum-length-of-loginuser-name-and-password-in-sql-server-2005/
http://msdn.microsoft.com/en-us/library/ms176094.aspx
http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/7b28762b-5e7e-40c7-b765-3eb6c2681ba5

Other limitations:
http://weblogs.sqlteam.com/mladenp/archive/2007/07/24/60267.aspx

SQL Server Error: 10061

Check if the SQL Server (MSSQLSERVER) Service is running. This can throw that error.
(Ref)