Just added >> CF_jscalendar & FileUpload.cfc

Tue, 21 Oct 2008 00:13:00-0700

CF_jscalendar is a port of jscalendar from dynarch.com for CF 5 and above. FileUpload.cfc is a very simple File Upload component that uploads a file and sanitizes the file name for Windows servers. It was tested on on CF 7 and above and should work on Railo 2+ and (Open) BlueDragon 6.x and above. Update: Tuesday, 10/21/08 I added set_SQL_permissions.cfm. It is just a little throw away script that creates the SQL need to grants SELECT, INSERT, DELETE, UPDATE permissions to tables for MSSQL. Setting permissions using the SQL Server Management Studio, in a word, sucks.

Setting Permissions after importing data into MS SQL Server.

Fri, 13 Apr 2007 19:30:00-0700

At work we use MS SQL Server for our intranet. A lot of times we have to import data from the live server to development box do we can trouble shoot problems or need to copy tables from development to the live server for a launch. When you use the import/export function in SQL Server Enterprise Manager/ Management Studio you lose all your permissions and your Identity specifications. Setting permissions on Server Enterprise Manager/ Management Studio is a total pain in the ass. So I wrote this little script to help speed up the process

Notes:

These are all the permissions"

GRANT SELECT, INSERT, DELETE, REFERENCES, UPDATE, CONTROL, TAKE OWNERSHIP, ALTER, VIEW DEFINITION

I use EMS SQL Manager 2005 Lite for SQL Server to run to run the SQL. Enterprise Manager/ Management Studio doesn’t seem to want to execute the SQL statement for some reason.

              GRANT #tmp_Permissions# ON [dbo].[#indx2#] TO [#index1#] GO

Cozmo's Dev Blog - MS SQL SERVER

Just added >> CF_jscalendar & FileUpload.cfc

Setting Permissions after importing data into MS SQL Server.