Deniz Dülec – IT Blog

PROBLEM:
How to set the DefaultValue of a SPFieldDateTime?

SOLUTION:
Dim DateField As SPFieldDateTime
DateField.DefaultValue = “2012-05-19T00:00:00Z”

REMARK:
In Wss 3.0 you have the SPUtility.CreateISO8601DateTimeFromSystemDateTime Method (Microsoft.SharePoint.Utilities)
to help you out

PROBLEM:
Working with a WSS 2.0 List I get this Exception when adding the formula:

System.Xml.XmlException: Name cannot begin with the '0' character, hexadecimal
value 0x30. Line 1, position 170.
 at System.Xml.XmlTextReaderImpl.Throw(Exception e)

Here a part of the code:

Dim DelayField As SPFieldCalculated = SP_Web.Lists(TimeList).Fields(Delay)
DelayField.Formula = "=INT([Column X]<0;2;0)"
DelayField.DisplayFormat = SPNumberFormatTypes.NoDecimal
DelayField.Update()

SOLUTION:
The Formula is a String but in Sharepoint it is read as XML. So the <0 is the Problem.
Changing the <0 to lt;0 write the formula like this:

DelayField.Formula = "=INT([Column X]lt;0;2;0)"

Check if a database or table exists using Sql Server 2005

http://hansengel.wordpress.com/2007/10/09/wordpress-unicode-and-s/ wrote this:

I previously had some problems when I mixed Unicode with WordPress. Every time I typed a Unicode character, (after posting) it would display as a ‘?’. This post will describe how to fix this.

Basically, the problem is that WordPress is not comprehending this, and instead of telling the database to store the Unicode characters, it just says, “Heck, just stick a bunch of question marks in there.”

Of course, this can be easily fixed in two steps. All you’ll need is FTP access to your server and a fair comprehension of how to type. So, let’s get started!

1. Open up ‘wp-config.php’ from the root directory of your WordPress installation.
2. Add ‘//’ at the very beginning of these two lines:
   define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

So that section should now look like this:
//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

You’re already finished. How easy was that?

Important notes:

1. The quotes surrounding // in step 2 should not be inserted. Those are just indicating that the // is the part you should insert.
2. If you’ve meddled with that part of ‘wp-config.php’ before, it may look a bit different. But pay no attention to the differences. Just be sure add // to the lines containing DB_CHARSET and DB_COLLATE.

Found on http://kuysal.blogspot.com/2008/03/turkish-unicode-characters.html

* ? – \u011f
* ? – \u011e
* ? – \u0131
* ? – \u0130
* ö – \u00f6
* Ö – \u00d6
* ü – \u00fc
* Ü – \u00dc
* ? – \u015f
* ? – \u015e
* ç – \u00e7
* Ç – \u00c7

After an installation of SQL Server 2005 a Software-Setup didn’t run because it demanded a case-insensitive collation. We had Latin1_General_CS_AI and wanted to change to Latin1_General_CI_AI.

This is not a trivial task and can make you a lot of pain, so maybe this helps. Many thanks to Tom Wisnowski.
This is his blog entry from http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx :

Step 1. Put SQL Server into Single User Mode

The first thing you will want to do is stop the SQL Sever Sevicer (sqlservr.exe) and the associated services (Agent, Full Text, Etc). There are a few ways to do this, but the easiest way would be to use the SQL Configuration Manager (Start->All Programs->Microsoft Sql Server 2005->Configuration Tools->Sql Server Configuration Manager). From this console you can manage the various SQL server services running on the machine. Right Click on each service listed and stop the service. The services are stopped, you can proceed to Step 2.

Step 2. Start the SQL server in Single User Mode

Open a command window and navigate to the folder where Sqlservr.exe resides (generally :\Program Files\Microsoft Sql Server\MSSQL.1\MSSQL\Binn). Run “sqlserver.exe -m” to start the sql server from single user mode.

Step 3. Rebuild the system databases

In SQL 2005, the rebuildm.exe program is nto supported. To rebuild the master database you need to use the setup.exe found on the SQL 2005 installation media. To rebuild, use the following command “start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=”. Please refere to Books on Line for compelete details on how to use Setup.exe.

Step 4. Restart the SQL Server Services in regular mode

End the command shell you started earlier. Ctrl-C to stop SQL server in single user mode, then close the command window. Go back to the Sql Server Configuration Manager and restart the SQL services.

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName
/SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ]
/SQLCOLLATION=CollationName

Use /SQLCOLLATION= with the name you need.
For a List of collations use: SELECT * FROM fn_helpcollations()

Latin1_General_
CI = Case Insenstive
CS = Case Senstive
AI = accent-senstive
AS = accent-insensitive and so forth.

Thanks to Jeff

declare @y int;
declare @m int;
declare @d int;

– the date we wish to create is Nov 6, 2003:
set @y = 2003
set @m = 11
set @d = 6

select dateadd(mm,(@y-1900)* 12 + @m – 1,0) + (@d-1)

For my site-search: Convert Date, ConvertDate, DateConvert,Int,Integer,IntToDate,IntegerToDate,Datum

Error “File format not supported” when you import VOB files

Issue

When you try to import VOB files into Adobe Premiere Elements 1.0 or Premiere Pro 1.x, the application returns the error message, “File format not supported.”

Solutions

Premiere Elements 1.0 and Premiere Pro 1.x do not support importing and editing the VOB file format. If you must work with the contents of a DVD, the following suggestions may provide you with possible workflows for using this material in Premiere.

Solution 1: Change the .vob file extension to .mpg, and then import into Premiere.

Note: Premiere Elements and Premiere Pro do not import encrypted DVD MPEG files . The technique described below only works when used with VOB files that have not been encrypted.

1. Open My Computer, right-click the DVD drive, and choose Explore.
2. Navigate to the Video_TS folder.
3. Copy the VOB files to your hard drive.
4. Change the VOB file extensions (.vob) to the MPEG file extension (.mpg).
5. Import the MPEG files into Premiere Elements 1.0 or Premiere Pro 1.x.
6. Render the footage on the time line.

Solution 2: Convert the MPEG files to DV AVI

Use a third-party application (such as VirtualDub, DVD2AVI, or Mpeg2AVI) to convert the MPEG files from Solution 1 to Microsoft DV AVI, and then import the DV AVI files into Premiere.

Background information

For additional information on converting VOB files to DV AVI files as well as other format conversion, visit www.videohelp.com .

I thought I was all alone with this Problem. My font in Outlook was so big, even if I hat it in Arial 9!
A co-worker was able to help me out quick. Today I have seen the same problem at another’s co-worker screen and he told me: “I don’t know how to change it back!” … Damn the Mouse-Wheel.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TKC Supercheatpack 1.21 Final

This cheat is brought to you by TKC

The Teamkilling and Cheating community

Visit us at:   http://www.tkc-community.net

Programmers: [YENG]Hubertus & [TKC]Anothercheater

Thanks to all who helped beta-testing and giving new ideas
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~v1.21~

-DISCLAIMER-

This software is provided ‘as-is’, without any express or implied warranty.
You are not allowed to continue the  setup-process if it would result in
breaking legal laws, legal license agreements or patents of any government.
The files included in this release are meant for educational purposes only.
Neither the authors of this file nor the TKC-Community can be held
responsible for any damages this release may cause to you, your grandma
and/or your computer. In fact neither the authors of this file nor the TKC-
Community can be held responsible for anything you  do with the files
contributed in this release, like illegal activities.
USE AT YOUR OWN RISK ONLY! And remember to have fun

-INSTALL-
0. Do NOT copy the setup.exe to your OFP folder.
1. Doubleclick the Setup.exe and follow the instructions.
2. Select your existing Operation Flashpoint folder which MUST
contain the FlashpointResistance.exe.
3. Press Continue and your ofp is patched and ready for use.

-FEATURES-

+ Undetectable from any server through a smart patch engine
+ ESP Hack – See where your enemies are
+ Fog Hack – Remove fog and increase the viewdistance
+ Godmode – The easiest way to get unkillable
+ Manipulate Objects & Players (Move, Destroy, Repair, Put in Air, Copy,
Hide, Delete, …)
+ Spawn any Vehicles you want on any map – Choppers, Planes, Tanks,
Papercars, LST…
+ Special Effects – Spaceworld, Delete ALL Objects, Boats, Logos, Bombs,
Parachutes, Crazy CTF Flags, Walk on Water…
+ CTI Tools – Delete the MHQs, Teleport yourself to the enemie MHQ, Switch
the MHQs, Send out drones to the enemy MHQ…
+ SUPERWEAPONS – Get the big ass guns ready and kill the cornercamper
with a Maverick, Sabot, MG, 30mm, Bombs, etc.
+ Free Camera Scripts, Restore Fog, Anonymouse Killing, Flying Trucks,
Guba & Angelina, AI Flooding, Wallstreets, Churches, Towers, …
+ And many more, checkout www.tkc-community.net for more

-STARTUP-

1. Start a multiplayer game
2. After the game started you need to die once so you respawn, after that
you can access the === SUPERCHEATMENU ===.

-ADDITIONAL-

If you got problems running this cheat or for additional cheats (1.96 ID-
Changer, 1.96 Ammotrainer, etc) goto www.tkc-community.net/Forums
and read the existing topics in the OFP section.

Have fun and good luck!

Copyright © 2003-2005 by TKC-Community.net

Download

– Drop all Views, Functions and Stored Procedures in SQL

– See also http://www.duelec.de/blog/?p=430

declare @procName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE type = ‘P’ AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @procName

while @@FETCH_STATUS = 0

begin

exec(‘drop proc ‘ + @procName)

fetch next FROM someCursor INTO @procName

end

close someCursor

deallocate someCursor

go

declare @funcName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE (type = ‘FN‘ OR type = ‘TF’) AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @funcName

while @@FETCH_STATUS = 0

begin

exec(‘drop function ‘ + @funcName)

fetch next FROM someCursor INTO @funcName

end

close someCursor

deallocate someCursor

go

declare @viewName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE type = ‘V’ AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @viewName

while @@FETCH_STATUS = 0

begin

exec(‘drop View ‘ + @viewName)

fetch next FROM someCursor INTO @viewName

end

close someCursor

deallocate someCursor

go

PROBLEM:

How to compare to dates in t-sql without considering the time?

SOLUTION:
Compare if my variable @MyDateToCompare is equal or less to the current date (GetDate())

IF

CAST(CONVERT( CHAR(8), @MyDateToCompare, 112) AS SMALLDATETIME)

<=

CAST(CONVERT( CHAR(8), GetDate(), 112) AS SMALLDATETIME)

…

Youtube-Video an bestimmten Zeitpunkt starten – Stimmt, sollte ich auch mal bloggen, da ich jedes mal vergesse, wie es funktioniert.

Man kann bei Youtube-Videos via URL-Parameter einen Startzeitpunkt manuell festlegen. Dutzende Male habe ich diesen Parameter und vor allem seine Syntax schon gegoogelt und immer wieder vergessen. Damit ich das in Zukunft nicht mehr tun muss und weil es vielleicht der Eine oder die Andere noch nicht wusste bzw. sich auch nicht merken kann, hier die Syntax für diese Funktionalität:

URL des Videos + #t=(x)m(y)s

Wobei (x) für eine Zahl für die Minute und für (y) eine Zahl für die Sekunde steht.

Beispiel:

http://www.youtube.com/watch?v=3nwwKbM_vJc#t=4m12s

Here is a simple solution…

If you have locked yourself out your Mambo installation, (i.e.) lost your admin password, you should be able to reset it without issue as long as you have access to your database via phpMyAdmin, the MySQL command line utility, SQLYog or some other similar program.

Simply login to your database and run the following statement:

Replace ‘newpassword’ with the new password you would like and replace ‘admin’ with whatever your admin username is. The admin username is ‘admin’ by default so unless you changed it this is probably still the same. Replace mos_users with the name of your user table. The ‘_users’ part will always be the same, but if you selected a different database prefix during installation then ‘mos’ may differ. If you left the database prefix alone during installation then the table will in fact be ‘mos_users’.

PROBLEM:

Unable to rename [DatabaseName]. (ObjectExplorer)

Rename failed for Database[DatabaseName].  (Microsoft.SqlServer.Smo)

The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

SOLUTION:

ALTER DATABASE <DBNAME>  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
SP_RENAMEDB <oldname>,<Newname>
Go
ALTER DATABASE <NEWDBNAME>  SET MULTI_USER — set back to multi user
GO

Shortcuts for Notepad++

http://notepad-plus.sourceforge.net/uk/shortcuts.php

ALTER DATABASE [DBNAME]  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE [DBNAME] COLLATE  Latin1_General_CI_AS_KS_WS
ALTER DATABASE [DBNAME] SET MULTI_USER

Keep in mind that changing the collation of the database will NOT change the
collation of the columns that are already in the database, only the default
collation of any new columns you will create.

You can change your database collation from enterprise manager. But your columns in table did not change accordingly.

Here is show how to change all collation columns in database.

I updated the SQL 2000 Version from vbnetsample.blogspot.com

Note: The EXEC-Statment ist commented for protection. Uncomment to Execute the Printed Alter-Statemnts.

SQL 2000 Version:

Sample Script
DECLARE @@TableName Nvarchar(100)
DECLARE @@ColumnName Nvarchar(100)
DECLARE @@ColumnType NvarChar(100)
DECLARE @@ColumnLengh FLOAT
DECLARE @@SQL NvarChar(1000)
DECLARE @@IsNullAble NvarChar(50)

DECLARE my_cursor CURSOR FOR
Select sysobjects.name From sysobjects Where xtype=’u’ OPEN my_cursor

FETCH NEXT FROM my_cursor INTO @@TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE my_column CURSOR FOR
select syscolumns.name,systypes.name as Type, syscolumns.length ,syscolumns.isnullable
From syscolumns inner join sysobjects on sysobjects.id=syscolumns.id
left outer join sysproperties on sysproperties.smallid=syscolumns.colid and sysproperties.id = syscolumns.id
inner join systypes on syscolumns.xtype = systypes.xtype
where sysobjects.xtype=’u’ And sysobjects.name=@@TableName And (systypes.name=’nvarchar’ or systypes.name=’varchar’)

OPEN my_column
FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble

WHILE @@FETCH_STATUS = 0
BEGIN
IF (@@IsNullAble=1)
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ + @@ColumnType + ‘(’ + CAST(@@ColumnLengh as
NVARCHAR) + ‘) COLLATE ‘ + ‘ Thai_CI_AS NULL’)
END
ELSE
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ +
@@ColumnType + ‘(’ + CAST(@@ColumnLengh as NVARCHAR) + ‘) COLLATE ‘ + ‘ Thai_CI_AS NOT NULL’)
END

PRIN(@@SQL)
–EXEC(@@SQL)

FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble
END
CLOSE my_column
DEALLOCATE my_column

FETCH NEXT FROM my_cursor INTO @@TableName
END
CLOSE my_cursor
DEALLOCATE my_cursor
GO

SQL 2005 Version:

DECLARE @@TableName Nvarchar(100)
DECLARE @@ColumnName Nvarchar(100)
DECLARE @@ColumnType NvarChar(100)
DECLARE @@ColumnLengh FLOAT
DECLARE @@SQL NvarChar(1000)
DECLARE @@IsNullAble NvarChar(50)

DECLARE my_cursor CURSOR FOR
Select sys.objects.name From sys.objects Where [type]=’u’ OPEN my_cursor

Select object_id FROM sys.objects
Select *  FROM sys.syscolumns
Select * FROM sys.extended_properties

FETCH NEXT FROM my_cursor INTO @@TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE my_column CURSOR FOR
select sys.syscolumns.name,systypes.name as Type, sys.syscolumns.length ,sys.syscolumns.isnullable
From sys.syscolumns inner join sys.objects on sys.objects.object_id=sys.syscolumns.id
left outer join sys.extended_properties on sys.extended_properties.minor_id=sys.syscolumns.colid
and sys.extended_properties.minor_id = sys.syscolumns.id
inner join systypes on sys.syscolumns.xtype = systypes.xtype
where sys.objects.type=’u’ And sys.objects.name=@@TableName And (systypes.name=’nvarchar’ or systypes.name=’varchar’)

OPEN my_column
FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble

WHILE @@FETCH_STATUS = 0
BEGIN
IF (@@IsNullAble=1)
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ + @@ColumnType + ‘(’ + CAST(@@ColumnLengh as
NVARCHAR) + ‘) COLLATE ‘ + ‘ Latin1_General_CI_AS_KS_WS NULL’)
END
ELSE
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ +
@@ColumnType + ‘(’ + CAST(@@ColumnLengh as NVARCHAR) + ‘) COLLATE ‘ + ‘ Latin1_General_CI_AS_KS_WS NOT NULL’)
END

PRINT(@@SQL)
–EXEC(@@SQL)

FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble
END
CLOSE my_column
DEALLOCATE my_column

FETCH NEXT FROM my_cursor INTO @@TableName
END
CLOSE my_cursor
DEALLOCATE my_cursor

PROBLEM:

You want to visit a Website but you cannot reach it and you are not sure if it is a problem with the  provider or if it is down!

SOLUTION:

Go to http://www.downornot.com and check.

Example:

http://www.downornot.com/duelec.de

PROBLEM:

When dropping/deleting a Data Soure View from a SSAS-Database you geht this Error:

“Fehler im Metadaten-Manager. Das Objekt (dimension) mit der ID ‘Identifier’ und dem Namen ‘Identifier’ wurde durchVorgänge in der Transaktion für ungültig erklärt.”

Translates to something like: Error in Metadata-Manager. Object (Dimenions) with ID XY … are invalid / not valid!

SOLUTION:

You can only drop/delete the DataSourceView if no Cubes and Dimensions exist that references the View!

So delete all Cubes and Dimensions first and then get rid of the DSV (Data Source View)